PostgreSQL uc_ddl.sql throws syntax error.

book

Article ID: 193957

calendar_today

Updated On:

Products

CA Automic Workload Automation - Automation Engine CA Automic One Automation CA Automic Operations Manager CA Automic Oracle

Issue/Introduction

Creating a new database schema for PostgreSQL throws a syntax error using the uc_ddl.sql.

psql:uc_ddl.sql:6279: ERROR:  syntax error at or near "!"

LINE 1: !

        ^

psql:uc_ddl.sql:6286: ERROR:  syntax error at or near "!"

LINE 1: !

        ^

psql:uc_ddl.sql:6293: ERROR:  syntax error at or near "!"

LINE 1: !

        ^

psql:uc_ddl.sql:6298: ERROR:  syntax error at or near "!"

LINE 1: !

        ^

 

Cause

Configuration.

Environment

Release : 12.3

Component : AUTOMATION ENGINE

Resolution

The "!" is a separator symbol for the utility DB.LOAD.

If the database schema is created manually, please remove the "!" symbol from the uc_ddl.sql.