XML exports of JOBS_SQL object contain inconsistent data in SQLConnection element

[Michael A. Lowry]

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:

1^st export: <SQLConnection>3906-735</SQLConnection>
2^nd export: <SQLConnection>x86_64/4</SQLConnection>
3^rd 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?

[Michael A. Lowry]

I discovered another element that can differ between subsequent exports of the same (unmodified) object:
/uc-export/JOBS_SQL/ATTR_SQL_FORM/sql1/password