7 Replies Latest reply: Sep 13, 2016 2:50 PM by Clever Anjos RSS

    SQL Error in Qlik Only

    John Hillock

      I have a part of my load script that calls a stored procedure:

       

      Hours:

      SQL

      EXECUTE Finance_Budgeting_2.dbo.spNewFY17Rollup 2, NULL, NULL;

      Store Hours INTO Hours.qvd

      ;

      When I reload the script, I get the following error:

      SQL##f - SqlState: 22005, ErrorCode: 245, ErrorMsg: [Microsoft][ODBC SQL Server Driver][SQL Server]Conversion failed when converting the nvarchar value 'Org Level 1 Code' to data type int.

      Hours:

      SQL

      EXECUTE Finance_Budgeting_2.dbo.spNewFY17Rollup 2, NULL, NULL

      However, when I execute the stored procedure outside of Qlik, I get no error at all. Has anyone else ran into this issue?