Adding Autosys PostgreSQL environment to iXp gives "org.postgresql.util.PSQLException: ERROR: relation "aedbadmin.ujo_job" does not exist" in ixpDaemon.log

Products

• CA Workload Automation iXP

Issue/Introduction

When adding an Autosys instance in iXp AdminTool which uses a PostgreSQL database, the following error message might be noticed into $IXP_HOME/log/ixpDaemon.log file

07-28 09:58:39:   db-PRD:connecting:jdbc:postgresql://###.###.###.###:<portnumber>/aedb?currentSchema=AEDBSCHEMA
07-28 09:58:39:   db-PRD:connected:jdbc:postgresql://###.###.###.###:<portnumber>/aedb?currentSchema=AEDBSCHEMA:22ms
07-28 09:58:39:   db-PRD:dci:open=2:closed=2:IXP_SITE_HOLD_DB_CONNECTIONS=false
07-28 09:58:39:      PRD:org.postgresql.util.PSQLException: ERROR: relation "aedbadmin.ujo_job" does not exist
  Position: 64

Environment

iXp
Autosys v24.x using PostgreSQL database

Cause

PostgreSQL does not require the schema owner to be specified

Resolution

Login into iXp AdminTool

1. Select "Instance" tab
2. Select the instance
3. On left pane, select "Database"

Blank out the field for "Schema Owner"