SQL Error when attempting to run the Rejected Items Summary analytic in a CRM environment

(Doc ID 2062884.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Fusion Product Hub Cloud Service - Version and later
Information in this document applies to any platform.


In Fuse/Simplified UI, when clicking on "Analytics" and finding any item related analytic, on clicking on these get ODBC errors such as :

Error in Rejected Items summary -
Odbc driver returned an error (SQLExecDirectW).
Error Details
State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred. [nQSError: 43113] Message returned from OBIS. [nQSError: 27047] Nonexistent table: "PIM - Item". (HY000)
SQL Issued: {call NQSGetQueryColumnInfo('SELECT "Time"."Quarter" FROM "PIM - Item"')}
SQL Issued: SELECT "Time"."Quarter" FROM "PIM - Item"

Steps to Duplicate
1)Log into CRM environment FUSE UI
2)Click on Analytics
3)Find any item related analytics (such as Rejected Items summary)
4)select it and get error

Expected Behaviour
Not to get errors


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 hundreds of Community platforms