ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.

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

book

Article ID: 84478

calendar_today

Updated On:

Products

CA Automic Workload Automation - Automation Engine

Issue/Introduction

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!

 

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.

Environment

OS Version: N/a

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