SAP Knowledge Base Article - Public

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

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 statsu 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.

To run an initial load:

  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-ANA , Analytics & Reporting (Ad Hoc, ORD) , Problem

Product

SAP SuccessFactors HCM Core all versions