search cancel

AWA: JSON_GET_VALUE fails with "sync-call failed!

book

Article ID: 203058

calendar_today

Updated On:

Products

CA Automic Workload Automation - Automation Engine

Issue/Introduction

Using Automation Engine Scripts, the JSON_GET_VALUE fails with "sync-call failed! ret-code: 0000020647" if CREATE_OBJECT is performed before on the same Script.

The prerequisite is that the VARA OBJECT created in CREATE_OBJECT does not exist beforehand.

Example to reproduce 

---- execute script ---

:SET &JSON_DOC# = '{"test": 12}'
:SET &TEST1# = JSON_GET_VALUE(&JSON_DOC#, "$.test")
:P "json parsing before create vara: &TEST1#"
:SET &RET# = CREATE_OBJECT("VARA","test.VCS-PAU.V")
:SET &TEST2# = JSON_GET_VALUE(&JSON_DOC#, "$.test")
:P "json parsing after create vara: &TEST2#"

--- actual report

2020-11-05 10:11:22 - U00020408 json parsing before create vara: 12
2020-11-05 10:11:24 - U00020647 Object 'TEST.VCS-PAU.V' was created by script from user: ('MSLEBODN')
2020-11-05 10:11:24 - U00020408 json parsing after create vara: sync-call failed! ret-code: 0000020647

---- expected output 

2020-11-05 10:11:22 - U00020408 json parsing before create vara: 12
2020-11-05 10:11:24 - U00020647 Object 'TEST.VCS-PAU.V' was created by script from user: ('MSLEBODN').
2020-11-05 10:11:24 - U00020408 json parsing after create vara: 12
 

Environment

Release : 12.3.x

Component : AUTOMATION ENGINE

Cause

This is a bug affecting current version of Automation Engine 12.3.x

Resolution

Workaround:

In order to avoid the error, you should add the following statement

:WAIT 0

in the script after the call to CREATE_OBJECT and before the call to JSON_GET_VALUE

Solution:

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

Fix version:
Component(s): Automation.Engine 

Automation.Engine 12.3.5 - Available