Automic Workload Automation

Expand all | Collapse all

XML exports of JOBS_SQL object contain inconsistent data in SQLConnection element

  • 1.  XML exports of JOBS_SQL object contain inconsistent data in SQLConnection element

    Posted 18 days ago
    We use XML to move AE objects from one system to another (i.e., from DEV to TEST and then PROD). We have noticed that subsequent exports of the same folder of AE objects can differ slightly. This causes problems because we use a checksum of the XML file to ensure that no changes have been made since the last export.

    We have isolated the difference (at least in this instance of the problem) to a single element in the XML file. The Xpath of the element is /uc-export/JOBS_SQL/ATTR_SQL/SQLConnection. In three subsequent exports of the same folder, this element of a particular SQL job three different values:

    1st export: <SQLConnection>3906-735</SQLConnection>
    2nd export: <SQLConnection>x86_64/4</SQLConnection>
    3rd export: <SQLConnection>SQLMSSQL</SQLConnection>

    In the JUI and AWI, there is no connection object specified on the SQL tab of this job.

    This seems like a bug in the AE's XML export component. Has anyone see this problem before?


  • 2.  RE: XML exports of JOBS_SQL object contain inconsistent data in SQLConnection element

    Posted 13 days ago
    Edited by Michael Lowry 13 days ago
    I discovered another element that can differ between subsequent exports of the same (unmodified) object:
    /uc-export/JOBS_SQL/ATTR_SQL_FORM/sql1/password