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

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

book

Article ID: 164188

calendar_today

Updated On:

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.