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.

AWA: WP / CP / DB Load utility fails with 'ORA-00922: missing or invalid option'

book

Article ID: 187503

calendar_today

Updated On:

Products

CA Automic Workload Automation - Automation Engine

Issue/Introduction

When starting the DB Load Utility to load a license file or any .jar file, DB Load utility fails with the following errors:

U00003594 UCUDB Ret: '3590' opcode: 'OPEN' SQL Stmnt: 'ALTER SESSION SET NLS_LENGTH_SEMA'
U00003590 UCUDB - DB error: 'OCIStmtExecute', 'ERROR   ', '', 'ORA-00922: missing or invalid option'

OR

When starting the WP / CP the following error is displayed in the log file:

20211126/090625.802 - U00003591 UCUDB - DB error info: OPC: 'OCIStmtExecute' Return code: 'ERROR'
20211126/090625.802 - U00003592 UCUDB - Status: '' Native error: '922' Msg: 'ORA-00922: missing or invalid option'
20211126/090625.802 - U00003590 UCUDB - DB error: 'OCIStmtExecute', 'ERROR   ', '', 'ORA-00922: missing or invalid option'
20211126/090625.802 - U00003594 UCUDB Ret: '3590' opcode: 'OPEN' SQL Stmnt: 'ALTER SESSION SET NLS__TERRITORY=AMERICA'

Cause

Configuration error in the DB string.

'ORA-00922: missing or invalid option is an Oracle error that is being reported by Automic Workload Automation DB Load Utility, WP or CP.

To fix the issue, verify that your DB connection string is correct and check for any extra or missing characters

For example, in the example above you see the following line in the log:

'U00003594 UCUDB Ret: '3590' opcode: 'OPEN' SQL Stmnt: 'ALTER SESSION SET NLS_LENGTH_SEMA'''

In the uctbdbld.ini file you have the following connection string:

SQLDRIVERCONNECT=ODBCVAR=NNJNIORO,DSN=AUTOMIC;UID=AUTOMIC;PWD=AUTOMIC;SP=NLS_LANGUAGE=AMERICAN,NLS_TERRITORY=AMERICA,CODESET=WE8ISO8859P15,NLS_LENGTH_SEMA;NTICS=CHAR

There is an additional semicolon in 'NLS_LENGTH_SEMA;NTICS=CHAR' that should be removed.

 

In the second example NLS__TERRITORY contains an additional underscore.

Environment

Release : 12.0, 12.1, 12.2, 12.3

Component : AUTOMATION ENGINE, DB Load Utilities

Resolution

Correct the DB connection string and restart the process.