2391741 - Query based on DSO/ADSO delivers incorrect results when 0CALDAY is in the drilldown

When running a query that involves reading from an (A)DSO and drilling down characteristic 0CALDAY (or a characteristic referencing the same), the query terminates or does not display the expected result (e.g. rows are missing).

This problem only occurs when the underlying provider contains data records where 0CALDAY is initial.

Possible error messages are:

• BW based on HANA: "invalid number [6930] attribute value is not a number..."
• BW based on ORACLE: "ORA-01722: invalid number"
• invalid number: exception 71000339: SQL Error
• invalid number: attribute value is not a number;decfloat [here]decfloat(string "COL$8$"),COL$8$ = ''[string]; checkNull false: .
  ld_Decimal__()
  Error reading the data of InfoProvider ZXXXXXX

• SAP NetWeaver - All Versions
• SAP BW/4HANA - All Versions

wrong data, incorrect values in query, transformation, routine, data base error 339, checkNull false, Advanced DataStore Object, no data after drilldown, NULL, Missing/Unexpected data caused by master data inconsistency , KBA , BW-BEX-OT-DBIF , Interface to Database , BW-BEX-OT-OLAP , Analyzing Data , BW-WHM-DST-TRF , Transformation , BW4-DM-ADSO , DataStore Object (Advanced) , BW4-AE , Analytic Engine , How To