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