E0302002d: Cannot find and create the object ID counter in the database for table

Products

• CA Harvest Software Change Manager

Issue/Introduction

When performed a delete version action, got error

E0302002d: Cannot find and create the object ID counter in the database for table HARVERSIONS

in the Hserver.log, we saw

[Microsoft][SQL Server Native Client 11.0][Sql Server][The EXECUTE permission was denied on the object 'GetNewSqlVal_HARAUDITEVENTSQL', database '<harvest-database-name>', schema 'dbo'. SQLSTATE=42000

Environment

CA Harvest Software Change Manager all versions

Resolution

Please engage your DBA to grant the EXECUTE permission for Harvest database procedures to the SCM database user(default is "harvest") and try again. If after EXECUTE permission grant you still face the issue please contact Broadcom Support.

Additional Information

DBA should grant the EXECUTE permission to the SCM database user(default is "harvest") for the SCM database(the default database name is "harvest") procedures

that is, all procedures. This step should be checked and performed when the SCM database is moved.