KNOWLEDGE BASE

Error "303 invalid DATE, TIME or TIMESTAMP value: search table error: [6931]" Changing Filter Values with SAP HANA


Published: 09 Jul 2016
Last Modified Date: 09 Aug 2017

Issue

When changing filter values while connected to SAP HANA, the following error occurs:
[SAP AG][LIBODBCHDB DLL][HDBODBC] General error;303 invalid DATE, TIME, or TIMESTAMP value: search table error: [6931] attribute value is not a date or wrong syntax;BwPopSearch pop4(SAPHDB:/BI0/SFISCPERen)

Environment

  • Tableau Desktop
  • SAP HANA

Resolution

Confirm that all the values in the underlying data source are in a date format that is valid in SAP HANA.

Cause

This error is passed from SAP BW and indicates that some entries in a date field are in an incorrect format. 
Did this article resolve the issue?