Skip to main content

Qlik

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Navneet07
Contributor
Contributor
‎2019-11-11 03:51 AM

SQL OLEDB CONNECTION ERROR: Arithmetic overflow error converting float to data type numeric.

Hi ,

 

While  fetching one qlikview table i am facing the below issue 
Error: Connector reply error: ErrorSource: Microsoft OLE DB Provider for SQL Server, ErrorMsg: Arithmetic overflow error converting float to data type numeric.

how to solve this issue

1,192 Views
0 Likes
2 Replies
Anil_Babu_Samineni
MVP
MVP
‎2019-11-12 02:41 AM

Is that error while creating the connection?

While fetching the data?

Can you please provide sample data how it is there in SQL side?

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
1,162 Views
0 Likes
Brett_Bleess
Former Employee
Former Employee
‎2019-11-14 08:42 AM

Here are a few Google posts I found, believe this is going to be something you need to solve on the SQL Server side of things, not QlikView.

https://blogs.msdn.microsoft.com/sqlforum/2011/04/19/forum-faq-why-do-i-get-a-arithmetic-overflow-er...

https://stackoverflow.com/questions/19326520/arithmetic-overflow-error-converting-float-error-in-sql

About the best I have in addition to Anil's comment.  If you did figure things out, consider posting what the issue was and then use the Accept as Solution button on that post to mark it as the solution to let others know that was the issue and the fix.

Regards,
Brett

To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question.
I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.
1,150 Views
0 Likes