DB load error: U00021161 ... processed object '' table 'OVW'
Article ID: 381241
Updated On:
Products
Issue/Introduction
When attempting to load a transport case, the DB Load utility fails with the following error:
20241104/223108.445 - U00021126 Client '0100': Importing object 'VARA.EXAMPLE.NAME' of type 'VARA'.
U00021161 ERROR: Transport case is inconsistent (processed object '' table 'OVW' ), loading to Database is not possible. Please contact Automic Support !
This can occur especially when a transport case is taking from older versions like 12.3 and imported into new versions like V24
Environment
Version: Any
Cause
Duplicate entries in a variable that are in different case (upper vs lower vs mixed case)
Resolution
This is caused by the variables in the older version having multiple lines that, if changed to all upper or lower case characters, would be the same. The database throws this error when the database is case sensitive and cannot allow for duplicates. For example, if there is a variable called VARA.EXAMPLE.NAME that has two entries with the same key, but different case characters:
Key: Example_one
Key: example_one
If these are both fully set to lower or upper case, they will be the same: EXAMPLE_ONE and EXAMPLE_ONE
If this is the case, the following will show in the log file:
20241104/223108.445 - U00021126 Client '0100': Importing object 'VARA.EXAMPLE.NAME' of type 'VARA'.
U00021161 ERROR: Transport case is inconsistent (processed object '' table 'OVW' ), loading to Database is not possible. Please contact Automic Support !
Looking at the error message, look at the U00021126 message right above it. This points to variable object, VARA.EXAMPLE.NAME.
At this point, you know that the client is 100 and the object name is VARA.EXAMPLE.NAME. In the old system, go to the VARA.EXAMPLE.NAME variable in client 100 and update the lines to be different from each other or remove one of them. Then unload a new transport case.
Feedback
