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

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.

Additional Information

Datetime Data Types at SAP Help
Data Services Job Error "DLL][HDB] General error;303 invalid DATE, TIME or TIMESTAMP value: not a valid month: 25>" at SAP Q&A
Troubleshooting SAP HANA Error Codes From Error 284 to 303 at SQLServerF1

Click here to return to our Support page.

Open a new case

Click here to go to our Support page.

Get detailed answers and how-to step-by-step instructions for your issues and technical questions.

Find and share solutions with our active community through forums, user groups and ideas.

Browse a complete list of product manuals and guides. Available online, offline and PDF formats.

Learn how to master Tableau’s products with our on-demand, live or class room training.