Highlighted
Absent Member.. Absent Member..
Absent Member..
1263 views

Version Control prevents project upgrade

Hello there,

 

I'm in the middle of HPQC11 to HPQC 11.5 and even after sending emails to the different users asking them to check in all their objects, I have found that some objects were left checked out and by the upgrade time, the Site Admin would verify the project and would provide this error:

2014-01-10 11:36:57.697     ALM-V10067: Projects with checked out entities cannot be upgraded.

 

As once the upgrade has happened there is no way to connect to the project to check the objects in, the alternative I have found is sending an email to all the user who left their objects checked out and run the following script to check everything in - note that we are not using BP or models so I didn't bother to write the script to check these objects in:

 

/*TEST CASES*/

Update

TEST Set

TS_VC_STATUS

='Checked_In',

TS_VC_CHECKIN_TIME

='00:00:00',

TS_VC_CHECKIN_DATE

='2014-01-10 00:00:00',

TS_BPTA_CHANGE_DETECTED

=NULL,

TS_VC_CHECKIN_USER_NAME

='admin',

TS_VC_CHECKIN_COMMENTS

='Forced for Upgrade'

Where

TS_VC_STATUS ='Checked_Out'

 

/*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

 

I hope this thing helps someone outher.

Good luck and happy 2014!!

Tags (1)
1 Reply
Highlighted
Absent Member.
Absent Member.

Thanks for that.

You can of course proactively identify checked out items and get users to check them in...

 

USE [HPALM_default_pluto]

GO

/*TEST CASES*/

select * from TEST

Where TS_VC_STATUS = 'Checked_Out';

 

/*RESOURCES*/

select * from RESOURCES

Where RSC_VC_STATUS ='Checked_Out'

 

 

/*REQUIREMENTS*/

select * from REQ

Where RQ_VC_STATUS ='Checked_Out'

 

GO

 

0 Likes
The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.