SAP Knowledge Base Article - Public

3003712 - WFA on HANA Incremental Load fails on a weekend or during a maintenance window

Symptom

  • WFA on HANA Incrementa Load fails with the following error: 
    • dd-mm-yyyy hh:mm:ss PackageRunner error. System.Exception: Failed to build SSIS package in memory. XML has been saved to the job record. Job: 9feb9cb6-1af6-4f09-b203-f06cfc72b7e9. CurrentTask: Set Component Hana Source property: HANA Query -> SELECT (IF...
  • The automatic Incremental Load was triggered during a weekend and coincided with a maintenance window

Environment

SAP SuccessFactors Workforce Analytics

Cause

When Incremental Load happens to run on a Sunday or during a maintenance window, an interrupted connection to HANA DB is likely there reason for the failure.
If the process coincides during the time that the HANA database is being rebooted, it will fail.

Resolution

The load should can be triggered manually by the WFA on HANA admin.  It should succeed when re-run.

Keywords

wfa on hana, incremental load fails, error reason not clear, initial load, automatic load, wfa data not updated, wfa load failed, workforce analytics data load , KBA , LOD-SF-WFA-REP , Reports, Data, Insight , Problem

Product

SAP SuccessFactors HXM Core 2005