SAP Knowledge Base Article - Public

2924463 - Incremental OLAP process is failing due to "Invalid number" error - WFA on HANA

Symptom

Incremental OLAP process is failing due to the following error:

"com.sap.db.jdbc.exceptions.JDBCDriverException: [339]: invalid number"

Environment

  • 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

Cause

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)

Resolution

How to resolve the issue?

  1. Remove the lookup related to data type differences.
  2. Complete again a full initial load
  3. Incremental load will then be successful. 

Keywords

invalid number, WFA on HANA, Initial fail, Incremental fail, OLAP Process, error, com.sap.db.jdbc.exceptions.JDBCDriverException: [339] , KBA , LOD-SF-WFA-ADM , Admin Tools , Problem

Product

SAP SuccessFactors HXM Core 1911

Attachments

fail.jpg