topic Table activation Error in Application Development and Automation Discussions

Table activation Error

Former Member — Wed, 18 Apr 2007 08:37:20 GMT

Dear Experts,

I have created a secondary index for table EKPO with the following fields

EBELN LOEKZ WERKS MATKL PSTYP KNTTP WEPOS EVERS

When I activated index in developement sytem it is active.then I went to utilities activate/adjust with save option.then I have done the same to table EKPO activation it gave me warning occured during activation I checked the log 'The name MMPUR_BEKPO is already reserved for a type group' along with other warnings .I moved ahead and transported it quality ,in Quality table is partially active.Please help me in resolving the issue.

Regards,

Imtiaz

Re: Table activation Error

Laxmana_Appana_ — Wed, 18 Apr 2007 08:43:52 GMT

Hi,

Go to SE14 transaction : enter table name and select 'Activate and adjust database'.this tool will adjust the partly active database tables.

then run the program 'RSDDCHECK' with table name.it will do the consistency check.

Regards

L Appana

Re: Table activation Error

Former Member — Wed, 18 Apr 2007 08:46:21 GMT

Hi imtiaz,

1. This can happen sometimes.

2. In such case, we have to manually

do SE14 (Activate and Adjust)

in QA Server

as well as PRD Server.

regards,

amit m.

Re: Table activation Error

Former Member — Wed, 04 Jul 2007 05:10:25 GMT

Dear friends,

EKPO is the heart of the business table .What precautions to take if some thing goes wrong in this exercise.How I can take the back up of the data and how to restore the same.If for example there are 350 million records.

I am really in tricky and difficult position to explain this situaltion .

Please advice.

Regards,

Imtiaz

Re: Table activation Error

former_member219399 — Wed, 04 Jul 2007 06:38:10 GMT

Hi,

select the radio button save data and then press activate and adjust table.

with regards,

Vamsi

Re: Table activation Error

Former Member — Wed, 04 Jul 2007 10:03:19 GMT

just now i had creaqted the index for your table EKPO with your fields and it got activated without any error .

see the index id is SEA i had given

short text ,

Non-unique index first option ,

then all fields ....

activated no warining ....

and started activating the table ..... it was activated ...

see in your case as you said it is big table with large no of data so .... do the activate of the table in the prodction it will take some time ... because it will start creating an new index and sorts the full(large no of data ) as per the new index sort in the database level ......

i think you would have came out in the middle of the activation of the table ...thatiswhy it shows Partly ativated

reward points if it isusefull ....

Girish

Re: Table activation Error

Former Member — Wed, 04 Jul 2007 11:48:27 GMT

Hi,

Plz go to se11,give ur table name...Go to utilities..there will be data base utility will bethere..click tht and there will be a push button...adjust and activate database...either click keep the data and adjust or delete it and adjust...

REWARD if USEFUl

Re: Table activation Error

Former Member — Mon, 09 Jun 2008 11:38:23 GMT

Thanks Amit ,

I feel your answer is the perfect solution. But apprciate

the thread member answers also.

But what happend is recetly we had upgrade and this issue got resolved automatically in Upgrade most probably some other developer would have done your solution.