Report saving failed: Report queries should not create, modify or delete persistent objects in the database.

Products

• IT Management Suite

Issue/Introduction

Creating a report based on an SQL query fails to save the message:  "Report saving failed: Report queries should not create, modify or delete persistent objects in the database."

Environment

ITMS 8.x

 

Cause

The product is looking for keywords in the SQL, if the word CREATE is located anywhere in the code it will cause it to fail to save.

Resolution

Do not use the word "Create" or put it in square brackets.  For example instead of just Create it could be [Create] or Created.