2023 Feb 09 12:40 PM
Hi All!
A colleague is trying to increase the size of a key field in a Z-table by switching to another data-element. Because a foreign key relationship to another Z-table exists, he is prototyping this in a sandbox system and doing it in steps. In the final step he is getting an error during activation related to the field length which we don't quite understand and could use some help with. Here are some screenshots:
Initial state of table "FEES" where field OWN_ID should be 13 instead of 10 characters in length:
Table DOCS for foreign key:
Current state in sandbox-system for table DOCS which could be activated "standalone" (after first disabling the foreign key dependeny temporarily via a copied Z-table) with OWN_ID now having 13 Chars.:
Table FEES is still inactive:
And even though the key-fields are - from what we can tell - identically defined as in table DOCS, we get this activation error:
What we don't understand at all, is why field "FILE_ID makes an appearance in the error message although that wasn't touched at all during the change. And the field OWN_ID should be of equal length unless the system is doing the comparison based on some not yet active/available table information for table FEES - possibly a catch-22 situation.
Has anybody run into a similar situation and can point us towards a solution?
We are on a NW 7.50 system with EHP8 and SP25
Thanks much and cheers
Bärbel
2023 Feb 10 8:12 AM
We noticed a difference between the DDIC and DB-information for the FEES-table (sorry, didn't save a screenshot of that yesterday), but here is how to get there - Utilities --> Database Object --> Check:
That still showed the 10 Char data element associated with field OWN_ID and only had MANDT and FILE_ID in the list of key fields, so was clearly the interim state for the table.
When forcing the activation and adjusting of the table via SE14 (database utility) it worked and the table definition could be activated successfully.
Cheers
Bärbel
2023 Feb 10 8:12 AM
We noticed a difference between the DDIC and DB-information for the FEES-table (sorry, didn't save a screenshot of that yesterday), but here is how to get there - Utilities --> Database Object --> Check:
That still showed the 10 Char data element associated with field OWN_ID and only had MANDT and FILE_ID in the list of key fields, so was clearly the interim state for the table.
When forcing the activation and adjusting of the table via SE14 (database utility) it worked and the table definition could be activated successfully.
Cheers
Bärbel