
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
The conversion of the nvarchar value '523825279709' overflowed an int column.
Hi All,
im facing below issue while running a task
could you please help us to resolve this
Error: SQL##f - SqlState: 22003, ErrorCode: 248, ErrorMsg:
[Microsoft][ODBC SQL Server Driver][SQL Server]The conversion of the nvarchar value '523825279709' overflowed an int column.
General Script Error
The conversion of the nvarchar value '523825279709' overflowed an int column.
Thanks In Advance

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi, that looks like an issue in the SQL query, maybe at some point of the query it's trying to convert an string to int type, try with bigint type that will cover that range.
.png)
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Ruben is spot on with his diagnosis, see the following post I found:
http://www.sql-server-helper.com/error-messages/msg-248.aspx
The key thing to understand is just because an error is returned on our side of things, does not always mean the error is ours. In the case of data connectors, we often are just returning the error sent to us from the Connector, which is the case here, so the issue is in the SQL query itself, not Qlik. Hopefully this will help you get things resolved.
Regards,
Brett
I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.
