WebReport/Livereport combo gives puzzling "DB update error"

Shirley_Kow

I have a webreport which uses a livereport as a source. When the webreport is run it gives message: The SQL included syntax for modifying the DB but the option: "Allow Database Modification:" was not checked so all changes have been rolled backThe livereport and both the "Use Cursor Fetch mode" and the "Use Transaction Mode" is unchecked.The SQL statement in the livereport (see attachment) does not contain any db update statements - so why is it complaining that the SQL statement is trying to modify the database?

Darren_Hodder

Hi Shirly,If you have LiveReport Extensions installed, there is a check to see if any banned terms are present in your SQL - the list of banned terms is specified in the opentext.ini configuration file. Usually the terms that would be in this list would be terms that are used for database modification, such as "drop" as an example.We have tried running your SQL through one of our Livelink instances using LiveReport Extensions, and we didn't receive any error, so it may be possible that if you are using LiveReport Extensions your admin may have added additional terms to this banned list.Can you confirm for us that you are using LiveReport Extensions, and if possible attach your opentext.ini config file, or at least the [reportext] section of it?Thanks,Darren.