2194542 - "internal error: numeric value out of ranng" occurs for HANA

Symptom

In DS4.2, Optimized SQL is created as procedure, but it is failed to be called in HANA.

Environment

• SAP BusinessObjects Data Services XI4.2
• HANA 1.0 SP9 Revision 92
  

Reproducing the Issue

1. Create a job which use 2 HANA table sas Source table  and one HANA table as Target table.In dataflow,Add a Query B.
2. For the 2 Source tables, join them together and transfer to Target table.
3. Execute the job, it may cause error "DBS-070404:... SQL submitted to ODBC data source <XXX> resulted in error <[SAP AG][LIBODBCHDB DLL][HDBODBC] General error;129 transaction rolled back by an internal error:  [129] <Procedure Name> ......: [129] (range3): transaction rolled back by an internal error: numeric value out of range: Failed in "XXX" column with the value-57037036703703380494060>. The SQL submitted is <CALL <Procedure Name>>."

Cause

This is HANA's issue that such procedure could not be executed in HANA92, and the error not occurs since HANA95.

Resolution

Upgrade HANA to laster version since Rev 95.

Keywords

HANA,roll back,DBS-070404