REST JSON export of objects returns wrong path as the link instead of the object

Products

• CA Automic Workload Automation - Automation Engine

Issue/Introduction

For lots of objects when we export them in JSON (or from Rest API), it takes the wrong path.

Instead of providing the correct object path, it provides the link path ( from table OFS where ofs_link=1).

 

See, for example for this object VARA.36681776, I create it in a given path:

Then I create a link in a totally different folder (see the link in the object icon):

If we do a query on the table OFS using as ofs_oh_idnr_o the oh_idnr that corresponds to oh_name='VARA.366817760  we can see that we'll find two results:

1. In green: with ofs_link=0 - this is the correct path for the object
2. In red: with ofs_link=1 - this is the link path so not a correct path for the object

Depending on the database, whenever we export the objects, sometimes the path provided in the json will be the one of the link (wrong) instead of the one of the object.

Environment

Automation Engine 21.x and 24.x

Area: export of objects in JSON format

Cause

DE177888: the query on table OFS did not have the clause where ofs_link=0 (to exclude links)

Resolution

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

Fix version:
Component(s): Automation Engine
Automation.Engine 24.4.3 - Planned release December 2025

Additional Information

Public Title: Object path wrong in the REST  JSON export

Public Description: A bug was fixed where, in the REST JSON export, the object path was wrongly returned as the path of a link to the object.