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. When characteristic 0CALDAY is in the drilldown, the query terminated 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

Product

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 , KBA , BW-BEX-OT-DBIF , Interface to Database , BW-BEX-OT-OLAP , Analyzing Data , BW-WHM-DST-TRF , Transformation , 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.