Error when loading JDE solution to DB - U00003590 UCUDB - DB error: 'OCIStmtExecute', 'ERROR ', '', 'ORA-00904: "VERSI_PATCH": invalid identifier'

Document ID : KB000084478
Last Modified Date : 14/04/2018
Show Technical Document Details
Issue:
Error Message :
20171116/220713.085 - U00003591 UCUDB - DB error info: OPC: 'OCIStmtExecute' Return code: 'ERROR'
20171116/220713.085 - U00003592 UCUDB - Status: '' Native error: '904' Msg: 'ORA-00904: "VERSI_PATCH": invalid identifier'
20171116/220713.085 - U00003594 UCUDB Ret: '3590' opcode: 'SLUC' SQL Stmnt: 'select VERSI_DBVersion from UC_VERSI order by VERSI_Major desc, VERSI_Minor desc, VERSI_Patch desc'
20171116/220713.085 - U00003590 UCUDB - DB error: 'OCIStmtExecute', 'ERROR ', '', 'ORA-00904: "VERSI_PATCH": invalid identifier'

Utility Load aborts when loading JDE solution to the database (DB), but actually the solution does load successfully to the DB.
This issue can be encountered when running other Utilities.

Messages similar to these can be seen in the utility log:
20171116/220713.085 - U00003591 UCUDB - DB error info: OPC: 'OCIStmtExecute' Return code: 'ERROR'
20171116/220713.085 - U00003592 UCUDB - Status: '' Native error: '904' Msg: 'ORA-00904: "VERSI_PATCH": invalid identifier'
20171116/220713.085 - U00003594 UCUDB Ret: '3590' opcode: 'SLUC' SQL Stmnt: 'select VERSI_DBVersion from UC_VERSI order by VERSI_Major desc, VERSI_Minor desc, VERSI_Patch desc'
20171116/220713.085 - U00003590 UCUDB - DB error: 'OCIStmtExecute', 'ERROR ', '', 'ORA-00904: "VERSI_PATCH": invalid identifier'
20171116/220713.088 - U00038257 Version check result:
Version of the RA Solution: '2.0.0'.
Version of database objects: '11.2.4+build.675'.
...
20171116/221433.638 - U00038165 RA Solution loaded successfully.
20171116/221433.679 - U00038273 RA Plugins loaded successfully.
...
20171116/221433.700 - U00038067 ABORTING due to error!

 
Environment:
OS Version: N/a
Cause:
Cause type:
By design
Root Cause: These DB errors concerning VERSI_Patch can be ignored.
The DB schema changed in this area and UCUDB/DBLoad tries one methods and retries with another one if this fails.
The solution will be loaded correctly to the database.
Resolution:
These DB errors concerning VERSI_Patch can be ignored.

The solution will be loaded correctly to the database.


Fix Status: No Fix

Fix Version(s):
N/A
Additional Information:
Workaround :
N/A