SAP Knowledge Base Article - Preview

3390221 - Incremental Export ExportTarget must be a unique constant

Symptom

The Incremental Export API needs an ExportTarget defined when developing an export. This ExportTarget is used to identify records in the export that are exported so that running subsequent exports are not exporting the same data that was already exported. When this is not unique this can cause issues as incremental exports can clobber other exports. And if this is not a constant string it can cause issues as well with large DB growth issues.


User-added image

Here is a query that helps at looking for any incremental exports where the export target is set to a non-constant value. This will cause "change detection" problems and the export will not function properly.

select scheduled_script_id from scheduled_script where REGEXP_LIKE(SCRIPT_TEXT, 'INCREMENTAL_EXPORT_API', 'mi')

FOR SQL DATABASE:
In the Policy Editor, do a Find (search) of "INCREMENTAL_EXPORT_API';"


Read more...

Environment

SAP WorkForce Time and Attendance (All versions)

Keywords

Constant, String, Value, Timesheet, Incremental , KBA , XX-PART-WFR-TAM , SAP Time and Attendance Management by Workforce Software , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.