XML Export via AWI adds CR LF which leads to inconsistence if imported via :IMPORT script.

book

Article ID: 205504

calendar_today

Updated On:

Products

CA Automic Workload Automation - Automation Engine CA Automic One Automation CA Automic Operations Manager CA Automic Oracle

Issue/Introduction

The following script of an include object is exported via AWI.

!set global variables based on contents of GLOBAL VARA object
:set &GVarsObj# = "P8LP.LPI.GLOBAL.SSIS_VARS"

:set &DTExecPath64# = get_var(&GVarsObj#,"PATH_DTEXEC_X64")
:set &DTExecPath32# = get_var(&GVarsObj#,"PATH_DTEXEC_X86")
:SET &POWER_SHELL# = GET_VAR(&GVarsObj#, "POWER_SHELL")

:SET &BASE_API_URL# = get_var(&GVarsObj#,"BASE_API_URL")
:SET &Config_API# = get_var(&GVarsObj#,"Config_API")
:SET &ENV# = get_var(&GVarsObj#,"ENV")
:SET &ID_Server# = get_var(&GVarsObj#,"ID_Server")
:SET &HOST# = get_var(&GVarsObj#,"HOST")
:SET &SQLSERVER# = GET_VAR(&GVarsObj#, "SQLSERVER")
:SET &SSIS_SQL_SERVER# = GET_VAR(&GVarsObj#, "SSIS_SQL_SERVER")
:SET &TKA_DB_LOCATION# = GET_VAR(&GVarsObj#, "TKA_DB_LOCATION")

:SET &ElasicSearch_Password# = GET_VAR(&GVarsObj#, "ElasicSearch_Password")
:SET &ElasicSearch_UserName# = GET_VAR(&GVarsObj#, "ElasicSearch_UserName")

!:SET &HND# = PREP_PROCESS_AGENTGROUP("P8LP.HOSTGROUP",,BY_RULE)
!:PROCESS &HND#
!: PSET &HOST# = GET_PROCESS_LINE(&HND#,1)
!:ENDPROCESS

If this script is imported via script utilizing :IMPORT 

:SET &FILE#  = "C:\temp\export.xml"
:SET &FOLDER# = "\CASES\ALEXANDER\2020\12_DECEMBER\32417915"
:SET &RET#    = IMPORT(&FILE#,&FOLDER#,"1")

The include object looks like this:

            !set global variables based on contents of GLOBAL VARA object
:set &GVarsObj# = "P8LP.LPI.GLOBAL.SSIS_VARS"

:set &DTExecPath64# = get_var(&GVarsObj#,"PATH_DTEXEC_X64")
:set &DTExecPath32# = get_var(&GVarsObj#,"PATH_DTEXEC_X86")
:SET &POWER_SHELL# = GET_VAR(&GVarsObj#, "POWER_SHELL")

:SET &BASE_API_URL# = get_var(&GVarsObj#,"BASE_API_URL")
:SET &Config_API# = get_var(&GVarsObj#,"Config_API")
:SET &ENV# = get_var(&GVarsObj#,"ENV")
:SET &ID_Server# = get_var(&GVarsObj#,"ID_Server")
:SET &HOST# = get_var(&GVarsObj#,"HOST")
:SET &SQLSERVER# = GET_VAR(&GVarsObj#, "SQLSERVER")
:SET &SSIS_SQL_SERVER# = GET_VAR(&GVarsObj#, "SSIS_SQL_SERVER")
:SET &TKA_DB_LOCATION# = GET_VAR(&GVarsObj#, "TKA_DB_LOCATION")

:SET &ElasicSearch_Password# = GET_VAR(&GVarsObj#, "ElasicSearch_Password")
:SET &ElasicSearch_UserName# = GET_VAR(&GVarsObj#, "ElasicSearch_UserName")

!:SET &HND# = PREP_PROCESS_AGENTGROUP("P8LP.HOSTGROUP",,BY_RULE)
!:PROCESS &HND#
!: PSET &HOST# = GET_PROCESS_LINE(&HND#,1)
!:ENDPROCESS

Cause

Defect.

Environment

Release : 12.3

Component : AUTOMATION ENGINE

Resolution

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

Article title: How to register to Broadcom Software Product updates and Critical Alerts

https://knowledge.broadcom.com/external/article?articleId=133819

Additional Information

Workaround: Modify the export.xml and remove the CR LF before importing it with :IMPORT:

To:

Attachments