Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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:
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