Database table error

[Former Member]

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

[Former Member]

Hi,

Use continue adjusment in development then transport it.

Regards

Debarshi

[Former Member]

Hi Roy,

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

Thanks & Regards

[Former Member]

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

[Former Member]

Hi

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

[Former Member]

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@

[Former Member]

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

[pole_li]

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

[Former Member]

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