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.

Upgrade to Version 8.00A or 9.0 fails with Oracle error ORA-01031

book

Article ID: 88837

calendar_today

Updated On:

Products

CA Automic Workload Automation - Automation Engine

Issue/Introduction

Upgrade to Version 8.00A or 9.0 fails with Oracle error ORA-01031

Environment

Release: AOATAM99000-9.0-Automic-One Automation Tools-Application Manager
Component:

Resolution

Detailed Description and Symptoms

?The error appears during the Upgrade process, mostly on the Loadutility while UC_UPD.txt is loaded to the database:

the error appearing looks as followings like below:

U0003590 DB error: 'OCIstmtExecute', 'ERROR ', '', 'ORA-01031: insufficient privileges

ORA-06512: at "UC4_OWNER.UC_GET_LAST_AGENT_LOG", line 9

ORA-06512: at line 4'
 
(the "line" messages can vary)


Investigation

The Error is happening during the upgrade process from earlier Version (6.00A) to  8.00A or Automation Engine 9.00A.

The error can only occur if you use ORACLE for your UC4 Database environment

To investigate the issue do steps below:

1.) check the logfile of the dbload process this can be find in \temp\ directory of the utilities and its called UCYBDBLD_LOGG_00.TXT which is the most recent one

2.) open the logfile, and scroll down below of the .ini file, search for the line

U0003590 DB error: 'OCIstmtExecute', 'ERROR ', '', 'ORA-01031: insufficient privileges

if this line appears, you can be sure that you have described issue, and below provided solution will work:


Solution

These errors indicate the user is missing a privilege. Here is the information from the documentation. Please pass this onto your DBA and check that the user has these:
 
We recommend creating an extra database user for UC4 who has the following authorizations:

CREATE SESSION
CREATE TABLE
CREATE SEQUENCE
CREATE PROCEDURE (loading initial data)
ALTER SESSION
(UNLIMITED TABLESPACE)
Read access to the view user_tab_columns
Execute procedures whose names start with "UC_"
The right to run the function GET_SCHEMA_NAME
The right EXECUTE for the DBMS package (command to set this right: GRANT execute ON dbms_lock TO <schema_name>)