Incremental OLAP process is failing due to the following error:
"com.sap.db.jdbc.exceptions.JDBCDriverException: : invalid number"
- SAP SuccessFactors HCM CORE
- WFA on Hana DATA Factory
Reproducing the Issue
1, Navigate to WFA Admin page
2, Select WFA on HANA Data Factory
3, Check the Load Status page
4, Incremental OLAP Processig is in isFailed status
Issue is due to the look-up that return null value in some case due to mismatch of data type e.g Decimal (Job req ID) vs VCHAR (FACT table Primary Person ID).
(OLAP home page - Go to Configuration - LookUps)
How to resolve the issue?
- Remove the lookup related to data type differences.
- Complete again a full initial load
- Incremental load will then be successful.
invalid number, WFA on HANA, Initial fail, Incremental fail, OLAP Process, error, com.sap.db.jdbc.exceptions.JDBCDriverException:  , KBA , LOD-SF-WFA-ADM , Admin Tools , Problem