SQL Statement Execution Failed XQuery Not Supported Use XMLQuery — Oracle Analytics

Oracle Business Intelligence Applications

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

SQL Statement Execution Failed XQuery Not Supported Use XMLQuery

Received Response
1
Views
1
Comments

We are in the process of implementing NetSuite and in order to synchronize the data we are using an ODBC tool called Data Virtuality.  I have been able to connect OBIEE (12c) to the Data Virtuality as an ODBC source (Import Metadata) to get the structure of the tables for modeling.  However, when I go to access the data in the tables through OBIEE (in this case simple test of "view data" in the Physical Layer I get an error message.  Here is the message that I get:

pastedImage_0.pngpastedImage_4.png

I have not been able to find any information on Oracle site or just searching in regards to how to setup/change OBIEE to access this data.  Any help would be appreciated.

Thanks...

Answers

  • [Deleted User]
    [Deleted User] Rank 2 - Community Beginner

    So you are trying to use an outside/third-party tool to read the OBIEE metadata?

    I'd say the only answer you will get is this: That's the tools problem. OBI works as designed. If that tool hsa ODBC issues then its drivers are out of date or inappropriate - as the error seems to confirm by the wy.