topic Database table locked.. in Application Development and Automation Discussions

Database table locked..

Former Member — Tue, 11 Nov 2014 07:54:14 GMT

Hello everyone, i have a database table with structure. I have changed some fields in structure and tried to activate database table. Its giving error that database table does not exist refer error log. Please help me out I went to se14 and its showing only two options there -- Continue adjustment and -- Unlock table.. So can i unlock.. or will i loose data.

Re: Database table locked..

Former Member — Tue, 11 Nov 2014 08:00:34 GMT

Hi,

please contact the basis team and try to solve the issue. Sometimes database table changes can't be completed because of missing space

in the file system of the OS
in the database tablespace of the database table

For this you have to check the job logs from SE14 actions.

Regards,

Klaus

Re: Database table locked..

Former Member — Tue, 11 Nov 2014 08:04:58 GMT

I am having a option to Continue adjustment and Unlock table. Can I go with any one of that.

Re: Database table locked..

rthoodi — Tue, 11 Nov 2014 08:07:07 GMT

Hi,

If table is locked, please unlock it and further "Activate and Adjust Data base" with "Save Data" option, which ensures no deletion of data.

BR Ramakrishna Thoodi

Re: Database table locked..

Former Member — Tue, 11 Nov 2014 08:10:15 GMT

Hi,

do not unlock the table, Maybe It is locked because a database conversion job is running or an error has occured.

You have to check the reason for the lock first.

Regards,

Klaus

Re: Database table locked..

Former Member — Tue, 11 Nov 2014 08:18:50 GMT

Actually table is showing status : partially activated and saved.

and I have only two options Continue adjustment and Unlock table . No save data option.

Re: Database table locked..

rthoodi — Tue, 11 Nov 2014 08:22:24 GMT

Hi,

Then try with adjustment, as I said earlier, "Activate and Adjust Data base" with "Save Data" option

Re: Database table locked..

Former Member — Tue, 11 Nov 2014 08:27:51 GMT

Activate and adjustment option is not there . I have only two options Continue adjustment and Unlock table . No save data option.If I do unlock then what about data.

Re: Database table locked..

rthoodi — Tue, 11 Nov 2014 08:32:02 GMT

I mean to say that, Continue adjustment, and then check option "Activate and Adjust Data base" with "Save Data" is avilable?, if avilable, then please do it.

Re: Database table locked..

matt — Tue, 11 Nov 2014 08:40:01 GMT

Do not unlock. Talk to Basis as Klaus has already said. If you continue blindly without knowing what you are doing, you risk corrupting your data.

Re: Database table locked..

Former Member — Tue, 11 Nov 2014 09:32:04 GMT

Have you included/appended any structure? if yes please activate then try to activate table using SE14.

Regards,

Vadamalai A

Re: Database table locked..

nagarjun_kalletla — Tue, 11 Nov 2014 09:45:30 GMT

Don't Simply unlock table you might end up in risk.

Better to find the reason for Lock and then do continue...

I think you have added , non key fields and facing this issue .... So seams to be some space missing for Table space of the Data Base ....

Revert back if this is helpful ....