Register today for Oracle CloudWorld. October 17th - 20th, Las Vegas

Register now

Hillel Cooperman, Senior VP of User Experience Design, has a message for you on Oracle CloudWorld

Watch now
Non Standard SQL restrictions on DML/DDL in BIP 12c — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Non Standard SQL restrictions on DML/DDL in BIP 12c

Received Response
21
Views
3
Comments
edited Sep 11, 2019 5:18AM in Oracle Analytics 3 comments

Summary

Non Standard SQL restrictions on DML/DDL in BIP 12c

Content

I am working to migrate a set of custom BI reports that were developed by a 3rd party for one of our clients

We are moving from BIP 11g (11.1.1.7.160119) to BIP 12c (12.2.1.2.0) on WIndows x64, with a SQL Server back end

 

I have copied all the reports and associated data models, have set up the data source, roles and folder permssions, and can get most of the reports to run. There is however a set of reports which all have a similar structure and are failing with the error "SQLInjection Error: DML / DDL Operations not allowed". I have attached the engine log with the stack dump.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!