A CPM save point already exists with a different CPM context.

Products

• CA Harvest Software Change Manager
• CA Harvest Software Change Manager - OpenMake Meister

Issue/Introduction

I am trying to do the cross project merge from one project to another and got the following error message. But I am the only user who was working on these packages. 

I00090001: A CPM save point already exists with a different CPM context.

Another user has initiated the process.

Environment

Harvest Software Change Mangager v14.x and up

Cause

The error message indicates there is a record in the Harvest database created by another Cross Project Merge that has already been started between the same source and target projects and packages. It is possible another user has initiated this and is working on it, or that something happened and the process was abandoned before it could finish.

Resolution

Here is SQL you can run to try and find out who initiated the previous Cross Project Merge.  It will make it easier to diagnose the root cause of the message and correct it.

for SQL Server:
SELECT HARUSER.USERNAME, 
     TGTENV.ENVIRONMENTNAME AS TARGET_PROJECT, 
     TGTPKG.PACKAGENAME AS TARGET_PACKAGE, 
     SRCENV.ENVIRONMENTNAME AS SOURCE_PROJECT, 
     CAST(CAST(HARCPMSTATE.SRCPKGLIST AS VARBINARY(MAX)) AS VARCHAR(MAX)) AS SOURCE_PACKAGE_OBJIDS
FROM HARCPMSTATE 
     INNER JOIN HARENVIRONMENT AS SRCENV ON HARCPMSTATE.SRCENVOBJID = SRCENV.ENVOBJID
     INNER JOIN HARENVIRONMENT AS TGTENV ON HARCPMSTATE.TGTENVOBJID = TGTENV.ENVOBJID
     INNER JOIN HARUSER ON HARCPMSTATE.USROBJID = HARUSER.USROBJID
     INNER JOIN HARPACKAGE AS TGTPKG ON HARCPMSTATE.TGTPKGOBJID = TGTPKG.PACKAGEOBJID

for Oracle
SELECT HARUSER.USERNAME, 
     TGTENV.ENVIRONMENTNAME AS TARGET_PROJECT, 
     TGTPKG.PACKAGENAME AS TARGET_PACKAGE, 
     SRCENV.ENVIRONMENTNAME AS SOURCE_PROJECT, 
     TO_CHAR(HARCPMSTATE.SRCPKGLIST)
FROM HARCPMSTATE 
     INNER JOIN HARENVIRONMENT SRCENV ON HARCPMSTATE.SRCENVOBJID = SRCENV.ENVOBJID 
     INNER JOIN HARENVIRONMENT TGTENV ON HARCPMSTATE.TGTENVOBJID = TGTENV.ENVOBJID 
     INNER JOIN HARUSER ON HARCPMSTATE.USROBJID = HARUSER.USROBJID 
     INNER JOIN HARPACKAGE TGTPKG ON HARCPMSTATE.TGTPKGOBJID = TGTPKG.PACKAGEOBJID;