Rank: Newbie
Groups: Registered
Joined: 4/23/2020(UTC)
Posts: 3
|
After installing SR, I defined a data source which interfacing to an Oracle instance. I've checked the connection (ODBC) and everything works. When I'm trying to create a report and add tables (either straight forward or from the catalog), but then I'm getting an error "Arithmetic operation resulted in an overflow". This error repeats and I can't actually proceed. Any idea what is the reason?
|
|
|
|
|
|
Rank: Administration
Groups: Administrators
Joined: 12/20/2013(UTC) Posts: 1,209  Thanks: 14 times
Was thanked: 206 time(s) in 199 post(s)
|
Hi, are you using the 5.5 RC ? I just check and I had no problem to create a table and build a model using Oracle ODBC.
If so, perhaps your tables have weird Data Types, can you check first with a simple table, then understand what is causing the error...we may fix this in the incoming 5.5.
|
|
|
|
|
|
Rank: Newbie
Groups: Registered
Joined: 4/23/2020(UTC)
Posts: 3
|
Yes - I'm using 5.5.
The table is very simple. I've tried with several and all gave the same result.
From another desktop, where I'm using exactly the same DB, everything work as expected.
|
|
|
|
|
|
Rank: Administration
Groups: Administrators
Joined: 12/20/2013(UTC) Posts: 1,209 Thanks: 14 times
Was thanked: 206 time(s) in 199 post(s)
|
Yes, after investigations, it seems related to you Oracle ODBC driver installation, I recommend to use the ODAC Oracle Native Drivers( check https://www.oracle.com/d...es/odac-downloads.html).After configuring your TNS Names file, your OleDb connection string will look like: Code:Provider=OraOLEDB.Oracle.1;Persist Security Info=True;Data Source=tnssource;
|
|
|
|
|
|
Forum Jump
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.
