Skip to main content
Announcements
See why Qlik is a Leader in the 2024 Gartner® Magic Quadrant™ for Analytics & BI Platforms. Download Now
cancel
Showing results for 
Search instead for 
Did you mean: 
QlikView2019
Contributor
Contributor

Qlikview 12 Store Procedure Error

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

1 Reply
Brett_Bleess
Former Employee
Former Employee

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/errMessag...

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

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

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.