topic Re: Adjusting Database in Quality server in Application Development and Automation Discussions

Adjusting Database in Quality server

Former Member — Fri, 01 Jun 2007 12:14:16 GMT

Hi All,

I have changed the datatype of an existing database from NUM4 to INT4 and adjusted the database utility before activating in a development server. When I moved the transport request to quality server, the transport request got terminated in quality server giving the return code 12. The error is:

Table conversion 06/01/2007 06:16:31 (12) Canceled

The database table contains data before this transport moved and I am not having authorization to adjust the database in quality server.

Please provide me any pointers for this problem.

Regards,

Lavanya.

Re: Adjusting Database in Quality server

suresh_datti — Fri, 01 Jun 2007 12:22:29 GMT

>>I am not having authorization to adjust the database in quality server.

You either have to get the SE14 Authn in your QA system or request the BASIS resource to run it for you, with the option 'save entries'..

~Suresh

Re: Adjusting Database in Quality server

Former Member — Fri, 01 Jun 2007 12:38:11 GMT

Hi,

Actually the the transport got terminated during the adjusting phase which should not happen.

The steps 5 and 6 failed in the below mentioned steps:

1 Initialization

2 Dropping of indexes, renaming of original table

3 No action

4 Activation of transparent table

5 Conversion of data to new table, deletion of renamed table

6 Creation of sec. indexes

Regards,

Lavanya.