SAP Knowledge Base Article - Preview

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: .
    Error reading the data of InfoProvider ZXXXXXX



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


SAP BW/4HANA all versions ; SAP NetWeaver 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

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.