After some testing the migration should be done from Testing environment to the production environment.The same data was needed in both environment so database was created from a backup testing database to a new database for production.Migration was done, new broker was set in Administrator Tab and Workbench.

If a new package was created the following error occured in the logs:. ---------- Begin Process ---------------E03020570: Database contraint violation [CA Harvest SCM][ODBC 20101 driver][Oracle]ORA-00001: unique constraint (HARVEST.HARPACKAGE_PK) violated SQLSTATE=43.---------- End Process ---------------

Environment:

Ca Harvest Software Change Manager R13.0SQL Database

Instructions:

Substaining Engineering provided reset_sequences.sql to clean up the database problem.Before customer send us some analysis which was leaded by SE too.So please contact CA Support for help in this Case