OAC: Report Based Of Remote Data Connector(RDC) Gives ORA-0933 Error In Oracle Analytics Cloud
(Doc ID 2496038.1)
Last updated on NOVEMBER 30, 2020
Applies to:Oracle Analytics Cloud - Version 18.2.1 and later
Information in this document applies to any platform.
Certain reports in a dashboard page were failing with ORA-0933 error message with NQSError description "Task Cancelled". However the same reports ran successfully when run on database query inside answers in OAAC. These reports were both English and Non English reports.These reports failing on the dashboard would run or spin unusually long time. It was found that Comments are not recognized by the sql while running the Initblocks. Analyzing the diagnostic log > OBIS1.log show the following error:
[nQSError: 77031] Error occurs while calling
remote service DatasourceService. Details: [JDSError : 77] 933 : ORA-00933:
SQL command not properly ended [
[2019-01-15T19:52:10.511+00:00] [OBIS] [ERROR:1]   [ecid: 005VsHzD^suAXN^5xVl3iW0007vR000Wmz,0] [sik: bootstrap] [tid: bb1ca700] [nQSError: 77031] Error occurs while calling remote service DatasourceService. Details: [JDSError : 77] 928 : ORA-00928: missing SELECT keyword [[
- Cause: SQLException is thrown from the datasource
Initblock sql for the failing reports had sql statements comments ";" or special character
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document