My Oracle Support Banner

OBIEE 12c: Columns are not imported From SAP IQ when table/view name contains an underscore (Doc ID 2353476.1)

Last updated on OCTOBER 02, 2018

Applies to:

Business Intelligence Suite Enterprise Edition - Version 11.1.1.9.0 and later
Information in this document applies to any platform.

Symptoms

You have created a connection pool to SAP Sybase IQ16 by using an correct ODBC driver.

You can import columns normally when you don't have underscore in tables/views name.

but if the tables/views contain an underscore character "_" in the name, the result is that the table has no columns.

If you create a column manually you can view data normally.

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.