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

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)

Comments

  • Duong Nguyen-NhatDuong Nguyen-Nhat Team Automic Posts: 156 Specialist ✭✭✭✭
    I am not sure if you can give the direct ID like that. Please check the following document:

    https://docs.automic.com/documentation/webhelp/english/ALL/components/DOCU//ARA Guides//Default.htm#ARA/CLI/cli_cleanup_parameter.htm?TocPath=Administration%20Guide|Administration%20via%20Command%20Line%20Interface|Clean-up%20Utility|_____1

    You can enter the application's name, workflow's type and different options. However I didn't see the Id option.
  • karthikeayankarthikeayan Posts: 66 Explorer ✭✭
    @Duong Nguyen Nhat

    When I do "--help", I can see --id option. However even if I didn't pass any parameters also, am getting the same exception.

    DBCleanup>DB-Cleanup.exe --help
    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 =
    DBCleanup 7.0.1.0
    Copyright c Automic Software GmbH

      --connectionString    Connection string to the ARA database.

      --olderThan           Only executions having an end-date older than the
                            specified number of days are considered. Default is 90.

      --keepAtLeast         Defines how many executions must remain per workflow
                            independent from their end date. Default value is 5.

      --applications        Comma-separated list of application names. If set, only
                            executions of the specified applications are considered.

      --workflows           Comma-separated list of workflow names. For application
                            workflows this parameters has to be set in conjunction
                            with the applications parameter. If the applications
                            parameter is not set, only general workflows are
                            considered.

      --archivedOnly        Flag whether only archived executions should be
                            deleted. Default value is False.

      --force               Flag whether the utility should also delete executions
                            that belong to a current installation. Default value is
                            False

      --verbose             Level of textual output to screen or log file. Possible
                            values: min, med, and max. Default is min.

      --fi                  Optionally mirror screen output to a log file. Messages
                            will have timestamp appended before it.

      --id                  Comma-separated id of executions to be deleted. At
                            most, you can specify 100 executions id using this
                            switch.

      --ignorestatus

      --help                Display this help screen.

Sign In or Register to comment.