SAP Knowledge Base Article - Public

2679757 - Incremental fails after successful full load - WFA on HANA

Symptom

Incremental load fails (even though the full load appears to be OK).

"Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental." 

Environment

WFA on Hana DATA Factory

Reproducing the Issue

When accessing OLAP load status the following errors is observed:

Stage Processor Pre-process OLAP data failed. Exception: OlapLib.OlapException: Pre process stage failed for OLAP incremental load. ---> com.sap.db.jdbc.exceptions

error1.PNG

Resolution

Run an initial load for the customer, and the issue should stop happening for them after that. See below:

  1. Log into the Data Factory (WFA Admin -> WFA on HANA Data factory)
  2. Run “Build Fact Table and Cube”

Ideally this would be done outside business hours for the customer, as it may take some time to build, and Analytics will be unavailable during that time.

Keywords

WFA on HANA, Incremental Load Fails, Error loading Olap tables , KBA , LOD-SF-WFA , Workforce Analytics & Planning , LOD-SF-WFA-WA , Workforce Anaytics , LOD-SF-ANA , Analytics & Reporting (Ad Hoc, ORD) , Problem

Product

SAP SuccessFactors HCM Core all versions ; SAP SuccessFactors Workforce Analytics all versions