Getting error while creating report

Question

Hello All,

We are recently migrating from OBIEE 12c to OAS 6.4. But we are facing one problem after migration. One of our connection pool contains connection for vertica DB. While pulling any varchar column in criteria, we are facing error like HSTMT binding can not be used when cursor is open.

State hy000 code 16001. [nqserror:16001] odbc error state sl012 code 0 message [datadirect] [odbccur lib] hstmt bindings May not be changed while a cursor is open. (Hy000)

Can you please let me know if I am doing anything wrong.

Thanks

Anirban

JohnW-Oracle · Answer

Hi Anirban,

It looks like its been a while since you asked this question and not sure if you got your answer.  This issue could be JDBC driver specific and OAS / OAC comes with there own specific JDBC driver as documented here: https://docs.oracle.com/en/cloud/paas/analytics-cloud/acsds/set-jdbc-connection-data-source.html#GUID-6AA9E1D3-9C10-42ED-B839-A65C6EB4FDAA

You may want to log a SR on this if the issue is continuing with the latest driver.

Regards,

John Whitaker