Qlikview 12 Store Procedure Error

QlikView2019 — Thu, 05 Sep 2019 19:41:46 GMT

Hi Team

Recently we migrated from QV11 to QV12.3

One of my store Procedure is getting failed in the New Environment QV12.3 , it works good in Qv11

Nothing Difference same access,same odbc drivers.. i don't see any changes in the Environments expect the version

The Error:

QVX_UNEXPECTED_END_OF_DATA: SQL##f - SqlState: 21000, ErrorCode: 512, ErrorMsg: [Sybase][ODBC Driver][Adaptive Server Enterprise]Subquery returned more than 1 value. This is illegal when the subquery follows =, !=, <, <= , >, >=, or when the subquery is used as an expression.

Please help me

Re: Qlikview 12 Store Procedure Error

Brett_Bleess — Thu, 19 Sep 2019 12:45:35 GMT

Anusha, just an FYI here, this is NOT a Qlik issue, it is a problem with the DB Connector/Driver and the DB, we are simply returning the error provided by the Connector/Driver in this case. I did a quick Google search and found the following links that may help:

http://infocenter.sybase.com/help/index.jsp?topic=/com.sybase.infocenter.dc00729.1500/html/errMessageAdvRes/BABDFIFB.htm

https://stackoverflow.com/questions/40093999/why-am-i-getting-a-subquery-returned-more-than-1-value-error-on-sql-server-whe

Hopefully these may help you get things resolved, I am not able to explain why things are working in 11 track though, there must be something different in the Connector configuration or something in the new environment is all I can figure at the moment.

Regards,
Brett

topic Re: Qlikview 12 Store Procedure Error in QlikView

Qlikview 12 Store Procedure Error

Re: Qlikview 12 Store Procedure Error