Skip to Content
0
Former Member
Jan 16, 2012 at 09:12 AM

Table Partially Active

3690 Views

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