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

Oracle Business Intelligence Applications

Home› Oracle Analytics› Oracle Analytics Forums› More Solutions› Oracle Business Intelligence Applications

Categories

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
BenS
BenS Rank 3 - Community Apprentice
in Oracle Business Intelligence Applications

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.