SAP Knowledge Base Article - Preview

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

Symptom

You run a query which is based on a DSO or ADSO(Advanced DataStore Object). When characteristic 0CALDAY is in the drilldown, the query terminates or does not display the expected result (e.g. rows are missing).

This problem only occurs when the underliying 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


Read more...

Environment

  • SAP NetWeaver 7.3
  • SAP NetWeaver 7.4
  • SAP NetWeaver 7.5
  • SAP BW/4HANA All versions

Product

SAP BW/4HANA all versions ; SAP NetWeaver 7.3 ; SAP NetWeaver 7.4 ; SAP NetWeaver 7.5

Keywords

wrong data, incorrect values in query, transformation, routine, data base error 339, checkNull false, Advanced DataStore Object , 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 ONE Support launchpad (Login required).

Search for additional results

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