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."
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
Run an initial load for the customer, and the issue should stop happening for them after that. See below:
- Log into the Data Factory (WFA Admin -> WFA on HANA Data factory)
- 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.
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