• Ask a question
    • Topics
    • Questions
    • Users
  • Sign in
  • Home /
avatar image
Question by Coleslaw · Aug 30, 2016 at 08:30 PM · requirementstestsversion control

Version control opens the original version of the test or requirement instead of the latest version

We just recently upgraded to version 12.50 and when we enabled versioning on our projects and when we check out a test or requirement, it opens the original version of the test or requirement instead of the most recent. Have you heard of this happening before?

Comment

People who like this

0 Show 0
10 |600 characters needed characters left characters exceeded
▼
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Viewable by all users

2 Replies

· Add your reply
  • Sort: 
avatar image

Answer by jameslcoleman · Aug 30, 2016 at 08:36 PM

This is a known issue with HP, and I have posted the link below to the KM article that contains a solution for the issue.
The KM article states the following:

Problem ALM is checking out first version of VC entities like tests, reqs, test resources, etc. instead of latest one. td.test set TS_VC_VERSION_NUMBER sdfasdfadsBy using a query like the following we are able to determine what is the latest check-in version of an entity: i.e. test plan tests.

SELECT TS_TEST_ID, TS_VC_VERSION_NUMBER, TS_VC_STATUS FROM TEST For example: If wrong value is shown under TS_VC_VERSION_NUMBER (i.e. 1 instead of 5) ALM will check-out version number '1' which is not the latest one! VC entities like Reqs, Test Resources, etc might also be affected by this so the query should be modified to accomodate to specific entity table.

Cause max(TS_VC_VERSION_NUMBER) from td.HIST_TEST table is not matching TS_VC_VERSION_NUMBER as set on td.TEST table.

Fix For Tests: UPDATE td.TEST SET TS_VC_VERSION_NUMBER = (SELECT MAX(TS_VC_VERSION_NUMBER) FROM td.HIST_TEST WHERE test.TS_TEST_ID=HIST_TEST.TS_TEST_ID) WHERE TS_VC_STATUS = 'Checked_In'

Fix For Requirements: UPDATE td.REQ SET RQ_VC_VERSION_NUMBER = (SELECT MAX(RQ_VC_VERSION_NUMBER) FROM td.HIST_REQ WHERE REQ.RQ_REQ_ID=HIST_REQ.RQ_REQ_ID) WHERE RQ_VC_STATUS = 'Checked_In'  

For any other affected entity/table make use of the above queries as template and modify accordingly.

The link to the KM article:

[https://softwaresupport.hpe.com/group/softwaresupport/search-result/-/facetsearch/document/KM01246311][1]

Note: The query will only update the tests, requirements, etc. where the VC_STATUS = 'Checked_In'. If you have any items checked by your users, you will need to contact them and let them know that all tests, requirements, etc. need to be checked in. If for some reason not all items are checked in, you can undo the checkout to ensure all items are checked back in. The TDAdmin user can undo a checkout, but you need to be aware that the changes that were created during that check out will be lost and the entity will be reverted back to the previous state before the check out.

If you have the userid for the user who has a checked out entity, and you are using QC Authentication (and not LDAP) and need to keep the changes, then you can change the password for the user within the Site Admin>Site Users tab and then log in as that user and "check in" the entity to preserve the changes. This only works with QC Authentication. [1]: https://softwaresupport.hpe.com/group/softwaresupport/search-result/-/facetsearch/document/KM01246311

Comment

People who like this

0 Show 0 · Share
10 |600 characters needed characters left characters exceeded
▼
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Viewable by all users
avatar image

Answer by Dan · Sep 01, 2016 at 02:55 PM

Disabling versions control clears the version number and when re-enabled the version number gets set back to the default count of 1 as well.

Dan

Comment

People who like this

0 Show 0 · Share
10 |600 characters needed characters left characters exceeded
▼
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Viewable by all users

Your answer

Hint: You can notify a user about this post by typing @username

Up to 5 attachments (including images) can be used with a maximum of 4.2 MB each and 22.0 MB total.


Stuff we like

Orasi Software
AppDynamics

Follow this Question

Answers Answers and Comments

2 People are following this question.

avatar image avatar image

Related Questions

How do I remove linked tests from a requirement in the database? 1 Answer

Can't check in some requirements on copied project 1 Answer

Does Quality Center 9.2 support Microsoft SQL Server 2005 SP3? 1 Answer

QC/ALM freezes when I click the Requirements Detail link 1 Answer

ALM Analysis Report for Number of Tests Executed per Month 1 Answer

(c) 2015 Orasi Software, Inc.


Enterprise
Social Q&A

  • Anonymous
  • Sign in
  • Create
  • Ask a question
  • Explore
  • Topics
  • Questions
  • Users