Oracle bursting syntax error in Fusion

User_KAST0

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

Shantaram-Oracle

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

Gianni Ceresa

@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.

Sanjay Kumar Yadav

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)