topic Re: Reason for Table Partially Active in Application Development and Automation Discussions

Reason for Table Partially Active

Former Member — Mon, 06 Feb 2012 10:01:43 GMT

HI experts,

I am working with table FKKVK with APPEND structures.This table become partially active after sometime.

I dont know the resons that why this table become partially active.

I have checked that :-

1) All the append structures are also active.

2) all check tables are also ACTIVE.

3) all the domains all also ACTIVE.

Please suggest the reason that why FKKVK table become PARTIALLY ACTIVE.

Thanks,

Sampat Tandon

Re: Reason for Table Partially Active

Former Member — Mon, 06 Feb 2012 10:16:03 GMT

Hi Sampat,

You have to adjust the database.

Goto Utilitiies~~>Database Object~~>Database Utility--> Activate and adjust database.

It will activate and adjust the datase.

You can do this directly from se14 also.

Regards,

Supriya.

Re: Reason for Table Partially Active

Former Member — Mon, 06 Feb 2012 10:23:04 GMT

hi Supriya.

Thanks for ur response. I am already able to activate the table.

But I need the reason that why this table become partially inactive.

Thank,

Sampat

Re: Reason for Table Partially Active

Former Member — Mon, 06 Feb 2012 10:43:44 GMT

Hi ,

Since the table structure was changed from the standard. Yet you have checked independently all are active. But when you check all the combined changes it will show partially inactive to make the table to behave normally we use database table utility to adjust the structure accordingly.

Regards,

Rajan.

Edited by: Rajan.Dexter9 on Feb 6, 2012 11:44 AM

Re: Reason for Table Partially Active

Former Member — Mon, 06 Feb 2012 11:23:32 GMT

Hi Rajan.

Do you mean to say that inorder to activate the table we have to active it both at se11 as well as se14...??

& we need to adjust the structure from se14 to make it fully active..??

Thanks,

Sampat

Re: Reason for Table Partially Active

Former Member — Tue, 07 Feb 2012 07:20:00 GMT

Hi,

Tough you have activated all the objects separately, your table is changed now by a append structure which means that you will have to adjust the table accordingly to activate it. So to activate your table follow the below process,

Goto your table -? Utilities -> database utility -> Adjust & activate. this will make sure that your table is completely active and all the changes are in effect.

Please let me know if you need further details.

Thanks!

Praveenkumar T.

Re: Reason for Table Partially Active

former_member727086 — Tue, 06 Sep 2022 14:48:38 GMT

I tried to follow the same steps but Adjust & activate is enable