My Oracle Support Banner

OAC: Report Based Of Remote Data Connector(RDC) Gives ORA-0933 Error In Oracle Analytics Cloud (Doc ID 2496038.1)

Last updated on FEBRUARY 20, 2019

Applies to:

Oracle Analytics Cloud - Version 18.2.1 and later
Information in this document applies to any platform.

Symptoms

 

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

Changes

Initblock sql for the failing reports had sql statements comments ";" or special character 

Cause

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
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.