Categories
Oracle bursting syntax error in Fusion

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
Answers
-
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
0 -
@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.
0 -
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)
1