karthikeayan_9058

Sql Exception whlie clearing ARA Executions, invalid object name 'execution'

Discussion created by karthikeayan_9058 on May 5, 2017
Latest reply on May 8, 2017 by karthikeayan_9058
Hello,

My ARA filled up with too many executions and I have to delete one of the package.
For both I have to delete my executions I believe. I used DB_CLEANUP Utility to delete the executions, but got this exception.

Can anyone help me on solving this. Am on ARA 12.

UtilitiesPath\DBCleanup>DB-Cleanup.exe --id 1048241
INFO : Parsing options from application config file
INFO : Parameters from configuration file:
INFO :     olderThan =
INFO :     keepAtLeast =
INFO :     applications =
INFO :     workflows =
INFO :     archivedOnly =
INFO :     force = false
INFO :     verbose = max
INFO :     fi =
INFO :     id =
INFO : Parameters after addition from command line:
INFO :     olderThan =
INFO :     keepAtLeast =
INFO :     applications =
INFO :     workflows =
INFO :     archivedOnly =
INFO :     force = false
INFO :     verbose = max
INFO :     fi =
INFO :     id = 1048241
INFO : Execution id specified. All other option will be ignored
INFO : Executing DetectDatabaseVersion
DEBUG: Execution report NOT presented.
DEBUG: IsCurrentInstallation NOT available in InstalledPkgComp table.
INFO : DetectDatabaseVersion executed successfully
INFO : Executing TemporaryTable
DEBUG: Temporary table name: T_pFlzPhP98UWCYv2oPGgASg
DEBUG: Executing query: create table T_pFlzPhP98UWCYv2oPGgASg (Id BIGINT)
INFO : TemporaryTable executed successfully
INFO : Executing PopulateTemporaryTable
INFO : Removing temporary table...
DEBUG: Executing query: if exists (select * from dbo.sysobjects where id = object_id(N'T_pFlzPhP98UWCYv2oPGgASg') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table T_pFlzPhP98UWCYv2oPGgASg
INFO : Temporary table removed
ERROR: Unknown error
NHibernate.Exceptions.GenericADOException: could not execute query
[ SELECT Id FROM Execution e where e.Id in (@p0) AND  e.Status in (5, 6, 7, 8, 9)  ]
  Name:id - Value:1048241
[SQL: SELECT Id FROM Execution e where e.Id in (@p0) AND  e.Status in (5, 6, 7, 8, 9) ] ---> System.Data.SqlClient.SqlException: Invalid object name 'Execution'.
   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
   at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean&
dataReady)

Outcomes