Test case Id lost when migrationg from 1.7.4 to 1.8 B3

[Pierre]

Hello,

I've migrated successfully the data base from TL 1.7.4 to 1.8 B3.

But during the migration, test cases Ids are re-computed. Thus I lost the previous Id.

Question : is it possible to keep during the migration the old test case Id, and to start the mumbering from a defined value for new test cases?

Thanks,
Pierre

[havlatm]

Thanks for report. It could be compatibility problem ... I'll ask.

[fman]

was just a design decision.
we can see if we can fix it, but due to existence of EXTERNAL ID on 1.8
i think is better to use EXTERNAL ID

[fman]

Pierre:
I've tested migration from 1.7 to 1.8, and review code.
No change is done on test case internal ID, but on 1.8 test case internal ID are not showed on user interface anymore, we have choose to display External Testcase ID.

please re-check your migration and explain in details what has happened

[sfunk]

To fix this I usually copy the testcase and delete the old version.

[pgartner]

After upgrading to RC2 from 1.7.4 all my existing test id's are now "0" on the UI. After adding a prefix option I created a new test case. This new test case is now TC-1. Is there any way to display the old test cases with their original id's and have the new test case id's start after them?

[fman]

>>After upgrading to RC2 from 1.7.4 all my existing test id's are now "0" >>on the UI.
is not clear what is happing, please explain better.

>> After adding a prefix option I created a new test case. This new test >>case is now TC-1.
>> Is there any way to display the old test cases with their original id's >> and have the new test case id's start after them?
What you can do if write yourself a sql statement to update tcversions table
field that holds external id with internal id (you have this on nodes_hierarchy table, of type testcase)

[pgartner]

CALMS-0:Add a User

Above is one of the testcase ID's with the title of one of the test cases displayed on the archiveData.php.

The problem is that all preexisting test cases have the CALMS-0 id showing.

[tanweernoor]

Hello fman,

>> Is there any way to display the old test cases with their original id's >> and have the new test case id's start after them?
What you can do if write yourself a sql statement to update tcversions table
field that holds external id with internal id (you have this on nodes_hierarchy table, of type testcase)

i checked the test case id's in both tables and I believe it can be fixed as suggested by fman, just a little doubt......
will it impact somewhere else also??
what query did u use to fix this??

[pgartner]

I reran the install and data migration and all the external ids are now populated. Something must have happened during the data migration process.

It is all fixed now. Thanks for all your help!

Paul

[tanweernoor]

pgartner,
could you please explain in detail..... when i reran migration script, i got the numbers but those are different from the one what i had with 1.7.
I have around 20,000 test cases and it took me around 8 hrs to run the migration script..

[ivan karpov]

I opened the DB tcversions and external id contains correct info, though in GUI it's displayed as "DISCO (ID=1)-48"
Where DISCO is the part of project name. ID=1 - something unknown.
and 48 - is a real external id that is stored in tcversions table.

How to remove this prefix from all test cases ?

[fman]

very easy edit testproject and change prefix

[ivan karpov]

Great,
it helped.
thanks.

[rinmar]

My RC3 don´t accept empty Prefix.
Our automat. run tool accept only testcase numbers.

How could i disable Prefix?
How could i enable view of old testcase id? (i don´t understand solution above)