Oracle bursting syntax error in Fusion

Question

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

Sanjay Kumar Yadav · Answer

Hi, thanks for the response.

The issue was wrong selection of data source while creating the data set.

I was supposed to selet ApplicationDB_FSCM but hadselectedthe default source Oracle BI EE (Default)

Gianni Ceresa · Answer

@User_KAST0 , no need to post again (which would be double posting, against the forum rules), it has been moved to the right category already.

Shantaram-Oracle · Answer

Thank you for your question on Oracle Analytics community. Please Take a moment to update your profile with a display name and an image representing you. Let's create a vibrant and engaging community together!

Also please note that  this is a BI Publisher question and should be posted under BI publisher discussions for a quicker reply.

https://community.oracle.com/products/oracleanalytics/discussions/tagged/bi-publisher