topic Re: Database table error in Application Development and Automation Discussions

Database table error

Former Member — Mon, 17 Nov 2008 04:36:06 GMT

Hi experts,

I have created a ZTable and trasported to production server and it was working fine.

Now i have changed the data type of one field from char to decimal. Then i transported it to production

Now in production server whenever i open that table it gives a message table doesnot exist in database and

displays that table . When i Execute the table it displays no database table exists for table .

But when i go to SE14 for adjusting database table it shows two options

1) Unlock Table

2) Continue Adjustment.

what should i do.

waiting for reply

Thanks and regards

Re: Database table error

Former Member — Mon, 17 Nov 2008 04:38:21 GMT

Hi,

Use continue adjusment in development then transport it.

Regards

Debarshi

Re: Database table error

pole_li — Mon, 17 Nov 2008 04:42:50 GMT

Hi,

When table field of data type "char" changed to "decimal", some values will lost.

So , you'd better backup your table at database level(ask your basis guy for help),

Then you can Continue Adjustment.

Regards,

Pole

Re: Database table error

Former Member — Mon, 17 Nov 2008 04:43:14 GMT

Hi Roy,

Thanks for the reply. If i do this continue adjustment will it delete the existing record .

Thanks & Regards

Re: Database table error

Former Member — Mon, 17 Nov 2008 04:52:30 GMT

Hi Neelesh,

In Se14 there are 2 main options with adjustment

Activate and adjust database with 2 radio buttons

(a) Save data

(b) Delete data

Use the save data option with the "Activate and adjust database"

Then there will be no problem ....although ....if the length of the data type changed varies, there may be a case of truncation or additional spaces for existing records but from fresh records there will be no problems....

Hope it helps

Regards

Byju

Re: Database table error

Former Member — Mon, 17 Nov 2008 04:54:44 GMT

U can do just revart u changes in DEV and then transport to PRD then take backup of table OR download into excel .

then again make desired changes into table on DEV then transport .

Regards

Sachin

Re: Database table error

Former Member — Mon, 17 Nov 2008 04:57:49 GMT

Hi,

First when you change the table field technicalities especially data type then it has to be adjusted from the DEV and then it has to be transported.

If you have any field entities in this case that will changed to decimals but the characters will not be transported. Better option will be delete the entries and adjust the table by SE14 and then you transport to PRO server will resolve your issue.

Cheers!!

VEnk@

Re: Database table error

Former Member — Mon, 17 Nov 2008 05:05:38 GMT

Hi,

Suppose your field has value say aa122 then converting it to decimals will give you dump and your table will get locked.

So the option i gave you wont work in that case...

You have to Unlock Table , then enter the values in it from scratch...

Regards

Debarshi

Re: Database table error

Former Member — Mon, 17 Nov 2008 05:06:05 GMT

u just do one thing delete that field then update then transport . and find ther result

then add the filed aand update table then transport

what comparison that u get u see.

ajay