Applies to:

HP ALM, HP QC

 

Issue Summary:

How to upgrade project when Entities are checked out but site admin has already been upgraded. 


Error Message from SiteAdmin Upgrade Log below:


2015-02-20 13:24:16.04 Checking if Project has Checked Out entities ...

2015-02-20 13:24:16.073 ALM-V10067: Projects with checked out entities cannot be upgraded.


Versioning Enabled Project Requires Checkin
Found checkouts in project

Note: All of the checked out entities in the project must be checked in. 



Resolution:

If you have already upgraded your SiteAdmin/ALM to a newer version and can no longer check in the entities through Quality Center then you need to run the following query against the project's database in SiteAdmin to force check in all the entities. This can be run from SiteAdmin or from SQL. Some data loss may occur for non-checked in entities.


/*RESOURCES*/
UPDATE
RESOURCES SET
RSC_VC_STATUS = 'Checked_In',
RSC_VC_CHECKIN_USER_NAME = 'admin',
RSC_VC_CHECKIN_DATE = '2014-01-10 00:00:00',
RSC_VC_CHECKIN_TIME = '00:00:00',
RSC_VC_CHECKIN_COMMENTS = 'Forced for Upgrade',
RSC_VC_CHECKOUT_DATE = NULL,
RSC_VC_CHECKOUT_COMMENTS = NULL
WHERE RSC_VC_STATUS ='Checked_Out'

/*REQUIREMENTS*/
UPDATE
REQ SET
RQ_VC_CHECKIN_COMMENTS ='Forced for Upgrade',
RQ_VC_CHECKIN_DATE ='2014-01-10 00:00:00',
RQ_VC_CHECKIN_TIME ='00:00:00',
RQ_VC_CHECKIN_USER_NAME ='admin',
RQ_VC_CHECKOUT_COMMENTS = NULL,
RQ_VC_CHECKOUT_DATE = NULL,
RQ_VC_CHECKOUT_TIME = NULL,
RQ_VC_CHECKOUT_USER_NAME = NULL,
RQ_VC_STATUS = 'Checked_In'
WHERE RQ_VC_STATUS ='Checked_Out'

/*Remove FROM VC Tables*/
DELETE
FROM VC_ASSET_RELATIONS
DELETE
FROM VC_ASSET_REPOSITORY_ITEMS
DELETE
FROM VC_BP_ITER_PARAM
DELETE
FROM VC_BP_ITERATION
DELETE
FROM VC_BP_PARAM
DELETE
FROM VC_BPM_ELEMENTS
DELETE
FROM VC_BPM_MODELS
DELETE
FROM VC_BPM_PATHS
DELETE
FROM VC_BPM_PATHS
DELETE
FROM VC_BPTEST_TO_COMPONENTS
DELETE
FROM VC_COMPONENT
DELETE
FROM VC_COMPONENT_MULTIVALUE
DELETE
FROM VC_COMPONENT_STEP
DELETE
FROM VC_COMPONENT_STEP_PARAMS
DELETE
FROM VC_CROS_REF
DELETE
FROM VC_DELETED_ASSETS_INFO
DELETE
FROM VC_DESSTEPS
DELETE
FROM VC_FRAMEWORK_PARAM
DELETE
FROM VC_REQ
DELETE
FROM VC_REQ_MULTIVALUE
DELETE
FROM VC_RESOURCES
DELETE
FROM VC_RUNTIME_PARAM
DELETE
FROM VC_STEP_PARAMS
DELETE
FROM VC_TEST
DELETE
FROM VC_TEST_CONFIGS
DELETE
FROM VC_TEST_CRITERIA
DELETE
FROM VC_TEST_MULTIVALUE
DELETE
FROM VC_TEST_PARAMS
DELETE
FROM VC_USER_ASSETS