Oracle Service Cloud data preparation failure in Oracle Analytics Cloud
Hi Community.
I'm trying to bring data from an Oracle Service Cloud instance to Oracle Analytics Cloud. But when I ask for a data preview it brings me the following error:
| ODBC driver returned an error (SQLExecDirectW). |
| State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occured. |
| (HY000) |
| State: HY000. Code: 43113. [nQSError: 43113] Message returned from OBIS. |
| (HY000) |
| State: HY000. Code: 43119. [nQSError: 43119] Query failed: |
| (HY000) |
| State: HY000. Code: 46078. [nQSError: 46078] Cannot open file /bi/domain/fmw/user_projects/domains/bi/bidata/components/OBIS/DynamicDBFeatures.INI. (HY000) |
| SQL Issued: SET VARIABLE DISABLE_CACHE_SEED=1,DISABLE_XSA_CACHE_SEED=1,ENABLE_DIMENSIONALITY=1;SELECT |
| 0 s_0, |
| XSA('manuel.rubio@imaginecx.co'.'d4f75753-27bd-4287-8804-ee4dc7615b3a')."input"."Data"."CATEGORY_NAME" s_1, |
| XSA('manuel.rubio@imaginecx.co'.'d4f75753-27bd-4287-8804-ee4dc7615b3a')."input"."Data"."ID" s_2 |
| FROM XSA('manuel.rubio@imaginecx.co'.'d4f75753-27bd-4287-8804-ee4dc7615b3a').input."Data" |
| FETCH FIRST 21 ROWS ONLY |
I want to get data from Incidents. How can I solve this issue?
Thanks in advance for your help.
Tagged:
0