Oracle Analytics Publisher

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

Oracle bursting syntax error in Fusion

Received Response
314
Views
3
Comments
Rank 1 - Community Starter
edited Jan 8, 2024 9:27PM in Oracle Analytics Publisher

Error while compiling bursting query: java.io.IOException: prepare query failed[nQSError: 43113] Message returned from OBIS. [nQSError: 27002] Near : Syntax error [nQSError: 26012] .

But, the bursting query is working fine when testing separately.


When scheduled, getting below error.

Waiting Time: 0.9 seconds

Data Fetch Time: 0.2 seconds

Total Execution Time: 0.8 seconds

Job Priority: Normal


Job processor caused exception

[INSTANCE_ID=bip.bi_server1] [INSTANCE_JOB_ID=5145]


Error getting report data

[INSTANCE_ID=bip.bi_server1] INSTANCE_JOB_ID=[5145] oracle.xdo.XDOException: oracle.xdo.XDOException: java.sql.SQLException: java.io.IOException: prepare query failed[nQSError: 43113] Message returned from OBIS.

[nQSError: 27002] Near <->: Syntax error [nQSError: 26012] .

oracle.xdo.servlet.data.DataException: oracle.xdo.XDOException: oracle.xdo.XDOException: java.sql.SQLException: java.io.IOException: prepare query failed[nQSError: 43113] Message


Appreciated quick solution.

Thanks,

Anil

Welcome!

It looks like you're new here. Sign in or register to get started.

Answers

Welcome!

It looks like you're new here. Sign in or register to get started.