My Oracle Support Banner

RSP: Daily Innovation Workbench Grant to Data Visualizer Not Working (Doc ID 2780141.1)

Last updated on JUNE 07, 2021

Applies to:

Oracle Retail Science Platform Cloud Service - Version NA and later
Information in this document applies to any platform.


After creating a new data source in DV, the user should be able to click on RAFEDM* and see the RTLWSP* schema with tables populated in it.

Try the following:

1. Login to Data Visualizer (has /dv at end of URL).
2. Click Create in the upper right hand corner.
3. Click Data Set.
4. Click RAFEDM.
5. Click Enter SQL.
6. Run the following to generate the error that shows the batch is not running:  select * from rtlwsp01.guest_profile ;

Create Data Set Failed
Cause: execute query failed[nQSError: 43113] Message returned from OBIS. [nQSError: 17001] Oracle Error code: 1031, message: ORA-01031: insufficient privileges at OCI call OCIStmtExecute. [nQSError: 17010] SQL statement preparation failed. Action: Please refer to logs for more details.

A power user may encounter this issue when building reports in Data Visualizer (DV) for Oracle Retail Science Platform (RSP) / Retail Insights (RI).




To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

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