AAI SQL script for the database schema upgrade fails: ORA-00907

Products

• Automation Analytics & Intelligence

Issue/Introduction

Upgrading the AAI database schema to v6.4.6 using the upgradeJawsDbTo6.4.6.sql is failing with the following error message:

ORA-00907: missing right parenthesis

 

 

Environment

Component: Automic Automation Intelligence

Release : 6.4.6

Resolution

It is possible that the some special character included when copying the SQL script and running from the SQL Developer. Please run the SQL update script file using SQLplus  or SQL Developer as explained below.

Option 1: Using SQLplus 

-Go to <AAI_Installation directory>\scripts directory

-Log in to the database using Sqlplus with user who owns the AAI database

-Once logged in, execute the upgradeJawsDbTo6.4.6.sql as shown below

SQL> @upgradeJawsDbTo6.4.6.sql

 

Option 2: Using SQL Developer Client

-Log in to the database using SQL Developer Client

-Execute the upgrade script within the SQL Developer Client

@<AAI_Installation directory>\scripts\upgradeJawsDbTo6.4.6.sql