Warning message "•Query Validation 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 with the message

"Query Validation failed. Report queries should not create, modify or delete persistent objects in the database."

 An error occurred on the page. Please check the log for more details. 

Query Validation failed. Report queries should not create, modify or delete persistent objects in the database.
This DataSource is not in a runnable state.

Environment

Notification Server 8.0

 

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.