topic Re: error in table mofification in Application Development and Automation Discussions

error in table mofification

Former Member — Fri, 27 Jul 2007 07:01:37 GMT

Dear All,

I created one table with 7 fields with three key fields say A,B,C.and activated .It was working fine.

Due to changes in the requirement i added two fields say X,Y and made them as key fields and also made the fields A,B,C as non key fields.

Now when i try to activate it is showing error as

ERROR OCCURED DURING ACTIVATION

TABLE WAS NOT ACTIVATED AND STRUCTURE CHANGED AT FIELD LEVEL.

Please let me know how to correct this.

Former Member — Fri, 27 Jul 2007 07:03:47 GMT

do this way to avoid that error GOTO -- UTILITIES->DATABASE UTILITY and press button adjust and activate button ...

Else goto SE14 transaction give the table name and press button activate and adjust database...

Regards,

Santosh

Message was edited by:

Santosh Kumar Patha

Former Member — Fri, 27 Jul 2007 07:05:17 GMT

you have to do active and adjustment through se14 tcode.Then you have to come se11 and activate again.

Former Member — Fri, 27 Jul 2007 07:05:57 GMT

goto <b>SE14</b> tcode

select tables

enter table name

press ACTIVATE and ADJUST TABLE

it will be adjusted for the changes

<b>Reward points for useful Answers</b>

Regards

Anji

Former Member — Fri, 27 Jul 2007 07:06:13 GMT

GOTO -> UTILITIES -> DATABASE UTILITY

and then press ADJUST and ACTIVATE DATABASE.

Regards,

Pavan