PostgreSQL uc_ddl.sql throws syntax error.

Products

• CA Automic Workload Automation - Automation Engine

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: !

        ^

 

Environment

Release : 12.3

Component : AUTOMATION ENGINE

Cause

Configuration.

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.