SELECT LENGTH("Messages"), "ID", "ModifiedDate", "GeneratedApp_ID" FROM "OdagRequests" ORDER BY LENGTH("Messages") DESC
Delete specific records:
DELETE FROM "OdagRequests" WHERE "ID" = 'xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx'
Note: Modification to the Qlik Sense Repository database are done at your own risk. Prior to making changes, backup the database in case of a rollback being necessary. Qlik Support will require the system to be restored to the previous state, should an issue occur after modifications were done.
To avoid the likelihood of this problem from occurring again.
In On-demand app settings in QMC, change the default settings "Number of days before purging historical data" from 90 to 1.
The template app script has trace messages, it logs where clause which can be huge because of large number of selections. You can comment that if not needed
// TRACE Generated WHERE clause: ;
// TRACE $(WHERE_PART);
Issue 2: ADMIN, INTERNAL\SA_API does not have access
To verify this issue, review the following two log files: