logo

Warning: The forum is now for consultation only. Please use GitHub Discussions to post any questions or comments.


Welcome Guest ! To enable all features please Login or Register.

Notification

Icon
Error

Options
Go to last post Go to first unread
bcg008  
#1 Posted : Thursday, April 23, 2020 11:30:32 AM(UTC)
bcg008

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?
epf  
#2 Posted : Thursday, April 23, 2020 12:12:25 PM(UTC)
epf

Rank: Administration

Groups: Administrators
Joined: 12/20/2013(UTC)
Posts: 1,209
Switzerland

Thanks: 14 times
Was thanked: 205 time(s) in 198 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.
bcg008  
#3 Posted : Thursday, April 23, 2020 8:38:57 PM(UTC)
bcg008

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.
epf  
#4 Posted : Friday, April 24, 2020 7:10:37 AM(UTC)
epf

Rank: Administration

Groups: Administrators
Joined: 12/20/2013(UTC)
Posts: 1,209
Switzerland

Thanks: 14 times
Was thanked: 205 time(s) in 198 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;



Users browsing this topic
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.