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
Component: Automic Automation Intelligence
Release : 6.4.6
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