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'
Article ID: 84478
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'
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!
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.
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
The solution will be loaded correctly to the database.
Fix Status: No Fix
Fix Version(s):
N/A
Additional Information
Workaround :
N/A
N/A
Feedback
Yes
No
Powered by
