SAP Knowledge Base Article - Preview

3571707 - Query execution results in error with reference to DATE0

Symptom

Upon executing a query with 0DATE in the drilldown the below errors are received:

  • Error 303 has occurred in the BWA/SAP HANA server
  • value is not a date or wrong syntax;[here]daydate("DATE0"), DATE0 = '00000120'[string]
  • invalid DATE, TIME or TIMESTAMP value: search table error: [6931] attribute value is not a date or wrong syntax;exception 70006931
  • CL_RSDR_AT_QUERY >> Row:  Inc: 54 Prog: WRITE_MESSAGES


Read more...

Environment

  • SAP NetWeaver
  • SAP BW/4HANA

Product

SAP BW/4HANA all versions ; SAP NetWeaver all versions

Keywords

to_date, 0date, date0, daydate, invalid date, timestamp, time, not a date, error, exception 70006931, /BI0/SDATE, date, syntax, , KBA , BW-BEX-OT-DBIF , Interface to Database , HAN-DB-ENG-BW , SAP HANA BW Engine , Known Error

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.