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  attribute value is not a number..."
- BW based on ORACLE: "ORA-01722: invalid number"
- invalid number: exception 71000339: SQL Error
- SAP NetWeaver 7.3
- SAP NetWeaver 7.4
- SAP NetWeaver 7.5
- SAP BW/4HANA All versions
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 pageThis 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.