Can't add field to table - Table is not activated

[Former Member]

Hello,

I'm facing an issue that i cannot understand. It happens everytime i need to make changes to some tables we've created.

Example:

I'm trying to add a field to a table SAFTPT_IMAT, i add the field, but when i try to activate the table, the system responds with an error. Navigating to the log i get a red message "TABL SAFTPT_IMAT was not activated". Navigating further i get the following:

Table SAFTPT_IMAT could not be activated

(E- Table SAFTPT_IMAT (Error adjusting the database) )

I navigate into the log and get:

Activate table SAFTPT_IMAT

Field name VAT_RELEVANT can be provided in this system. Please do not use.

No data exists (structure change caused by DROP / CREATE)

SAFTPT_IMAT: Structure change at field level (DB is adjusted)

Adjust table in DB >>>

sql:

DROP TABLE "SAFTPT_IMAT"

ORA-00604: error occurred at recursive SQL level 1 ORA-06553: PLS-801:

internal error [56319]

DDL time(___1): .......108 milliseconds

SAFTPT_IMAT could not be removed

Table SAFTPT_IMAT (Error adjusting the database)

Table SAFTPT_IMAT was not activated

When i enter in the error i get this:

Table SAFTPT_IMAT (Error adjusting the database)

Message no. DT007

Diagnosis

The definition of the table in the database could not be adjusted to its

definition in the ABAP Dictionary.

System Response

Procedure

Look for further information about the error in the log.

Using the analysis tool of the database utility, check the consistency

between the definition of the table in the database and its definition

in the ABAP Dictionary.

This happens also in another table, where i want to turn a regular field into a "Primary Key" field and change the order of the fields. I get the exact same error, without the warning about the field inside the sap namespace.

Can anyone please guide me through this error?

Thank you

[Former Member · Accepted solution]

Have you done any migration from 32 bit to 64 Bit or Vice versa or is this a fresh installed system?

Regards,

[Former Member · Accepted solution]

Hello Gagan,

Yes we migrated the system from 32 for 64Bits about two weeks ago.

Thanks

[Former Member · Accepted solution]

Hi,

I hope it is not production system , if yes then raise with SAP Support.

For first hand you have 2 options:

Run oracle scripts : catalog.sql and catproc.sql (Mentioned in Note 582427)

Or Run utlirp.sql in migration mode.

But we strongly recommend you to connect with SAP Support .

Regards,

[Former Member · Accepted solution]

Hi Gagan,

Thanks for the response. The mistake we're getting is in Development, but i think the upgrade to 64Bits was also in production.

Have you faced the same problem? It was another company that executed the migration, so i need to understand clearly what we're talking about, so i can raise the problem either to the people that did the migration or to raise it to SAP Support. If you please could tell me more about this issue i would be extremely gratefull.

Thank you very much

[Former Member · Accepted solution]

Hi Vitor,

Yes i have faces this issue in DB migration once (not with SAP) , so followed the solution i mentioned above .

You can raise this with Migration team as well, but for reliable soution its always better to take SAP's suggestion

Regards,

[Former Member]

Hi Vitor,

Try checking Note 582427.

Best Regards,

Matt

[Former Member]

Hi Matt,

I'm replying as Gagan sugested we raise this problem to SAP Support.

I've seen the noteyou've mentioned. Do you have any more information on this issue that can help me understand to do next, as we're not the ones responsible for the administration tasks.

Thank you very much