topic Re: se14- conversion error, unlock table in Application Development and Automation Discussions

se14- conversion error, unlock table

Former Member — Thu, 19 Mar 2009 13:26:00 GMT

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

Re: se14- conversion error, unlock table

Former Member — Thu, 19 Mar 2009 13:42:46 GMT

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

Re: se14- conversion error, unlock table

Former Member — Thu, 19 Mar 2009 14:36:15 GMT

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

Re: se14- conversion error, unlock table

Former Member — Thu, 19 Mar 2009 14:45:00 GMT

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?

Re: se14- conversion error, unlock table

Former Member — Thu, 19 Mar 2009 16:28:02 GMT

Create database table option creates the table succesfully

Re: se14- conversion error, unlock table

former_member194669 — Thu, 19 Mar 2009 16:32:58 GMT

What about the data ??

a®

Re: se14- conversion error, unlock table

Former Member — Fri, 20 Mar 2009 05:23:14 GMT

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.

Re: se14- conversion error, unlock table

Former Member — Fri, 20 Mar 2009 08:16:37 GMT

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.

Re: se14- conversion error, unlock table

Former Member — Fri, 20 Mar 2009 09:42:22 GMT

Thanx ,

Problem is solved.

Regards,

Archana W.

Re: se14- conversion error, unlock table

Former Member — Mon, 23 Sep 2013 16:07:49 GMT

did you loose data in production also after this conversion,