Version Control - Uncommitted Changes not working with PostgreSQL DB


Article ID: 145031


Updated On:


CA Automic Workload Automation - Automation Engine CA Automic One Automation


The screen Uncommitted Changes of the Version Control feature is not working with PostgreSQL as the AE DB 

After Creating New Branch and adding new Folders and Objects Uncommitted Changes should show the new or modified objects.
However, when choosing Uncommitted Changes AWI shows a popup with the following error:

com.uc4.ecc.backends.exceptions.AutomationEngineAPIException: [HTTP 500] (45110) An Automation Engine internal error occured.: No detail information available.
 at com.uc4.ecc.backends.impl.dataservice.request.RequestService.sendAndWait(
 at com.uc4.ecc.backends.dataservice.request.IRequestService$pbryglu.sendAndWait(Unknown Source)

The JCP log contains the following message:

20200205/223557.884 - 48 U00045014 Exception 'com.automic.database.api.DBException: "WITH changedobjects (oh_idnr, lev) AS (SELECT DISTINCT ofs_oh_idnr_o, 0 AS lev FROM ofs WHERE ofs_oh_idnr_f <> ofs_oh_idnr_o AND ofs_oh_idnr_f IN (1033003) UNION ALL SELECT f.ofs_oh_idnr_o, lev + 1 FROM ofs f, changedobjects o WHERE f.ofs_oh_idnr_f <> f.ofs_oh_idnr_o AND o.oh_idnr = f.ofs_oh_idnr_f) SELECT oh.OH_Client, changedobjects.oh_idnr, oh.OH_Name, oh.OH_OType, oh.OH_DeleteFlag, oh.OH_ModDate, oh.OH_CrDate, oh.OH_LastCommitDate, oh.OH_ModUserIdnr, b.OH_Name, oh.OH_Archive1, oh.OH_Archive2, oh.OH_VersioningId FROM changedobjects INNER JOIN oh ON changedobjects.oh_idnr = oh.oh_idnr LEFT JOIN oh b ON b.oh_idnr = oh.oh_moduseridnr"' at 'com.automic.database.impl.DBConnectionImpl.executeInternal():467'.
20200205/223557.886 - 48 U00045015 The previous error was caused by 'org.postgresql.util.PSQLException: "ERROR: relation "changedobjects" does not exist
20200205/223557.886 - 48 Detail: There is a WITH item named "changedobjects", but it cannot be referenced from this part of the query.
20200205/223557.886 - 48 Hint: Use WITH RECURSIVE, or re-order the WITH items to remove forward references.
20200205/223557.886 - 48 Position: 216"' at 'org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse():2422'.
20200205/223557.886 - 48 U00003620 Routine 'Repository : getUncommittedChanges failed.' forces trace because of error.
20200205/223557.888 - 48 U00003450 The TRACE file was opened with the switches '0000000000000000'.
20200205/223558.080 - 48 U00003449 Output to the TRACE file is finished.


We are investigating if this is a bug or a configuration issue.


Release : 12.3




Update to a fix version listed below or a newer version if available.

Fix version:

Component(s): Automation Engine

Automation.Engine 12.4.0 - Planned release in October 2020

Automation.Engine 12.2.6 - Planned release 2020-06-15
Automation.Engine 12.3.3 - Planned release 2020-06-29
Automation.Engine 12.3.2 HF1 - Available