Table Partially Active

[Former Member]

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

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,

RK

[Former Member]

Hi,

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

BR.

Tanmoy

[Former Member]

Hi ,

Thanks for replying.

The structure is still there.

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

Thanks,

RK

[lijisusan_mathews]

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

[Former Member]

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.

[Former Member]

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?

[Former Member]

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.

[Former Member]

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,

RK

[Former Member]

good to know

[Former Member]

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

[lijisusan_mathews]

take se80 and find your struture. Delete it.

Now delete your append structure form the table. and activate

[Former Member]

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

[Former Member]

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.