When a table contains a field with property 'SqlTimeStamp=True' it can't be use din teh function rec.AddLoadFields. This will result in the following error:
The field 'xxxxxxx' in the 'yyyyyyy' table is not valid for auto loading and cannot be passed to calls to AddLoadFields, SetLoadFields, or LoadFields."ADLSE Execute"(CodeUnit 82561).ExportTableUpdates line 20 - Azure Data Lake Storage Export by PUBLISHER\"ADLSE Execute"(CodeUnit 82561).TryExportTableData line 12 - Azure Data Lake Storage Export by PUBLISHER\"ADLSE Execute"(CodeUnit 82561).OnRun(Trigger) line 48 - Azure Data Lake Storage Export by PUBLISHER\
To solve this issue a condition If rec.AddLoadFields should be implemented. In case a fieldtype cant be used, the JIT loading fields of the platform will make sure all fields are loaded. Instead of throwing an error.
When a table contains a field with property 'SqlTimeStamp=True' it can't be use din teh function rec.AddLoadFields. This will result in the following error:
The field 'xxxxxxx' in the 'yyyyyyy' table is not valid for auto loading and cannot be passed to calls to AddLoadFields, SetLoadFields, or LoadFields."ADLSE Execute"(CodeUnit 82561).ExportTableUpdates line 20 - Azure Data Lake Storage Export by PUBLISHER\"ADLSE Execute"(CodeUnit 82561).TryExportTableData line 12 - Azure Data Lake Storage Export by PUBLISHER\"ADLSE Execute"(CodeUnit 82561).OnRun(Trigger) line 48 - Azure Data Lake Storage Export by PUBLISHER\
To solve this issue a condition If rec.AddLoadFields should be implemented. In case a fieldtype cant be used, the JIT loading fields of the platform will make sure all fields are loaded. Instead of throwing an error.