The conversion of the nvarchar value '523825279709' overflowed an int column.

[SNR1]

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

[rubenmarin]

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.

[Brett_Bleess]

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