se14- conversion error, unlock table

[Former Member]

Hi.

I have added a new append to MCHA. I modified this append and afterwards I went to se14 in order to adjust and activate the table.

But, I have a conversion error. Now, append structure is partially active and only temporary table for MCHA exists. I can not fix the conversion problem. Data on MCHA are not important, it is the development system and it contains few data. What happens if I select "Unloc Table" in se14?

Thanks

[Former Member]

If data in table is not important did you try activating it Using "Delete data" Option?

I hope this works.

Regards

Shital

Edited by: shital phadake on Mar 19, 2009 7:12 PM

[Former Member]

The problem is that I previously tried to activate the table and now I have only two options "continu adjustment" and "unlock table".

[Former Member]

Now, in se14 table se14 is partially active. However, it says that table does not exist in database, and I have only option "Create database table".

Any idea?

[Former Member]

Create database table option creates the table succesfully

[former_member194669]

What about the data ??

a®

[Former Member]

Hi,

Can u please tell how could u solve this error.

As I'm also having the same error

Its sayong in se14 - Adjustment terminated in step 6 and now have only 2 options Unlock Table and Continue Adjustment.

Please help

Regards,

Archana W.

[Former Member]

Hi all,

Regarding data, I lost them, but I did not mind since it is test development, and we are doing the first steps to implant MM module. So data was not revelant for us.

Archana,

Our problem was caused by a bad conversion data, in the end I unlock the table. Afterwards table mcha was at the dictionary but not in the database, and se14 only showed option "create database". We used this functionality to create it again, and it worked. It created the table, in inactive status, I fixed the append structure and activated the table. Then I went to db02 to perform consistency check, here I knew that indexes and table views were lost and I had to create them again.

On the other hand, if you want to maintain your data, I think you have several options:

- contact system team in order to restore them from backup or

- before unlocking the table, you can save temporary tables created for adjustment (tables like QCMMCHA ...) that contains data, or

- correct the conversion problem and continue adjustment (in my case I couldn't fix the problem, I tried to modify the append that caused the problem but I could not activate again)

Hope this helps you.

[Former Member]

did you loose data in production also after this conversion,

[Former Member]

Thanx ,

Problem is solved.

Regards,

Archana W.