The deletion of AAI scheduler is failing: Error while executing query: "delete from UnresolvedJobRunCausedBy

Products

• Automation Analytics & Intelligence

Issue/Introduction

The deletion of AAI scheduler is failing with the message below in the server.log.

2025-03-31 06:51:20,949 ERROR [DBMaintWorker] Error occurred
com.termalabs.common.datastore.DataAccessException: Error while executing query: "delete from UnresolvedJobRunCausedBy where jobRun in ( :jobRuns )"; jobRuns=[null; updated: null; null, null; updated: null; null, null; updated: null; null, null; updated: null; null, null; updated: null; null, null; updated: null; null, null;


Caused by: java.sql.SQLSyntaxErrorException: ORA-00904: "JOBRUNID": invalid identifier

 

Environment

Product: Automation Analytics & Intelligence v24.x

Cause

Permission of the user that started the AAI.

Resolution

Please make sure that the AAI is started with the user that owns the AAI schema.