Getting error while creating report

Anirban310

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

EzequielC-Oracle

Hi Anirban,

There may be an issue with the ODBC driver that works in the previous OBIEE 12c version but not in OAS. You may need a new version of the driver.

To verify that take the Presentation Server out of the picture and check the result by testing your query using nqcmd utility.

If the issue does not occur and you get a result for your query going to the database, then most likely you have a driver issue and you may need replace it for a newer one.

Here is the documentation and a MOS document (it mentions OBIEE 12c but it also applies to OAS) that explains how to use nqcmd:

Managing Metadata Repositories for Oracle Analytics Server

https://docs.oracle.com/en/middleware/bi/analytics-server/metadata-oas/use-nqcmd-test-and-refine-repository.html#GUID-F6E28CED-4FC4-42DA-B198-AC94F42CFC1B

When your repository is complete, you can run sample queries against it to test that it's created properly.

2121896.1 OBIEE 12C - How to invoke nqcmd client

Here is a MOS document that shows how to configure Vertica in case you need a new driver:

2778601.1 How To Configure Oracle Analytics Server To Use The HP Vertica Data Source In The Data Model Repository

Regards,

Ezequiel.