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

Table Partially Active

Former Member — Mon, 16 Jan 2012 09:12:05 GMT

Hi Experts,

I have created a append structure in Table CATSDB and tried activating it and it is ended with the error.

And the Table went to the status partially active.

So i have decided to revoke the changes, when i tried to delete the appended structure which i have created -i got thebelow error.

'Due to use in Dictionary objects the deletion cannot be performed.'

In SE14 i tried to Adjust and activate database - below is the log

Append structure ZCATS_REASONCODE_TXT no longer found

Index CATSDB-1 must be created in the database

Index CATSDB-2 must be created in the database

Index CATSDB-3 must be created in the database

Index CATSDB-4 must be created in the database

Index CATSDB-5 must be created in the database

Index CATSDB-Z01 must be created in the database

Index CATSDB-Z02 must be created in the database

Index CATSDB-Z99 must be created in the database

Test activation of Table CATSDB successful

Append structure ZCATS_REASONCODE_TXT no longer found

An SQL error occurred during a test access to the table

Cause: Database lock or inconsistency: Dictionary database

Compare module DD_DECIDE ended with error(s)

Request for CATSDB could not be executed

In SM21 it is showing that - Database error 207 at SEL access to table CATSDB

> Invalid column name 'ZZSHORTTXT'.

I am not getting a clear picture of what is being missed here.

Any heip is highly appreciated.

Thanks,

Re: Table Partially Active

Former Member — Mon, 16 Jan 2012 09:59:59 GMT

Hi,

Can you please let me know if your table still has the APPEND structure or not ?

BR.

Tanmoy

Re: Table Partially Active

Former Member — Mon, 16 Jan 2012 11:25:24 GMT

in sE11 open catsdb and click on append structure. can you see your append structure there? delete it from there. it will dy default try to activate CATSDB again. if you get any problem then goto Se14 and just use activate.

moreover, please remember to use CI_CATSDB for adding any fields to catsdb

Re: Table Partially Active

lijisusan_mathews — Mon, 16 Jan 2012 11:34:35 GMT

take se80 and find your struture. Delete it.

Now delete your append structure form the table. and activate

Re: Table Partially Active

Former Member — Mon, 16 Jan 2012 11:53:03 GMT

Hi ,

Thanks for replying.

The structure is still there.

I have tried the mentioned possibilities already. It is not working.

Thanks,

Re: Table Partially Active

lijisusan_mathews — Mon, 16 Jan 2012 12:19:09 GMT

in that case, try creating tht structure again first and then remove it properly.

Re: Table Partially Active

Former Member — Mon, 16 Jan 2012 14:22:37 GMT

Suzie,

The structure is already appened to the table. Currently both the structure and the table are in Partially active state.

Currently i am not able to delete the structure also through se11 - it is giving me error when i tried doing that.

Re: Table Partially Active

Former Member — Mon, 16 Jan 2012 19:03:40 GMT

when you stay on SE11 screen for catsdb, click append structure, it shows you your z structure. right? then you click delete.it says its going to activate the table again.. what happens next? you are getting error? what error?

Re: Table Partially Active

Former Member — Mon, 16 Jan 2012 19:33:58 GMT

This looks like runtime object being inconsistent with database object.

Here is what you can do. Goto SE14, input the table name and check database and runtime obects (Extras -> Database object -> Check and Extras -> Runtime object -> Check). If any of these show a discrepancy in the fields between runtime and database object then you need to adjust the table.

For adjusting the table follow these instructions carefully

1. Enter the table name in SE14 and press enter

2. Select Background radio button

3. Click on "Save data" and click "Activate and adjust database" (never click on "Delete data" or "Delete database table" !!)

This will start a background job that you can monitor in SM37.

Why I prescribed running in background is that depending on table size, some tables may take several minutes to adjust and it is better to schedule their adjustment in background.

Once the job finishes, try to reactivate the structure and table.

Re: Table Partially Active

Former Member — Tue, 17 Jan 2012 05:54:48 GMT

Hello Vishnu,

I did followed all the steps you have mentioned.

Still it was showing the same status.

Soumya - the error was ''Due to use in Dictionary objects the deletion cannot be performed.'

Anyway this issue closed now. We got in touch with basis and we have reconstructed the table.

Appreciate your help !!

Thanks,

Re: Table Partially Active

Former Member — Tue, 17 Jan 2012 06:18:56 GMT

good to know

Re: Table Partially Active

Former Member — Tue, 17 Jan 2012 06:33:15 GMT

DEAR,

AS U HAVE CREATED TRANS TABLE IN SE11 N NOW U HAVE TO ADD SOME MORE FIELDS....THEN SIMPLY CLICK ON APPEND STRUCTURE

1) A WINDOW WILL APPEAR -> GIVE APPEND NAME

AS U GIVE APPEND NAME ANOTHER WINDOW WILL APPEAR.

NOW GIVE SHORT DESCRIPTION N SELECT THE FIELDS OR TAKE THE FIELD ACCORDING TO UR CHOICE.

SAVE AND ACTIVATE IT.

NOW COME BACK IN DATA ELEMENT U WILL SEE UR APPEND STR NAME.

AS U DOUBLE CLICK ON APPEND IT WILL SHOW THE FIELDS.

SAVE , CHECK AND ACTIVATE AND PUT UR DATA IN DAT

I HOPE THESE WILL HELP U

Re: Table Partially Active

Former Member — Tue, 17 Jan 2012 06:41:44 GMT

AND FOR DELETING APPEND STRUCTURE.

FIRST GO TO SE 11

GIVE UR APPEND STRUCTURE NAME AND CLICK ON DELETE RADIO BUTTON

YOUR APPEND STRU WILL BE DELETED

NOW SAVE AND ACTIVATE UR TRANS TABLE.

THANK U.