SAP Knowledge Base Article - Preview

2556862 - Table Function in SQL editor fails with ' invalid number: [6930] attribute value not a number'

Symptom

  • When you execute a a table function, which uses a date variable whose value is initialized to NULL, from the SQL editor as follows:

--------------------------------------------------------------------

DO BEGIN
DECLARE AS_OF_DATE DATE = NULL;
SELECT *
FROM <table function  qualified name>;
END;

-----------------------------------------------------

  • This gives an error as follows:

---------------------------------

Could not execute 'DO BEGIN DECLARE AS_OF_DATE DATE = NULL= ...' in 6.157 seconds .
SAP DBTech JDBC: [339]: invalid number: "SAPSUPPORT"."DO": line 7 col 1 (at pos 233), line 2 col 9 (at pos 18), line 3 col 9 (at pos 68), line 5 col 9 (at pos 174): [339] (range 3) invalid number exception: invalid number: search table error: <table function>: line 39................................... line 31 col 5 (at pos 1718): [339] (range 3) invalid number exception: invalid number: [6930] attribute value is not a number (please check lines: 31, 52, 72, 91, 114) (please check lines: 39, 78, 124, 141, 147, 153, 168, 298)
Could not execute 'SELECT * FROM ...'

---------------------------------------------


Read more...

Environment

SAP HANA PLATFORM 1.0

Product

SAP HANA 1.0, platform edition

Keywords

NULL date value, empty date , KBA , HAN-DB-SCR , SAP HANA SQL Script , Problem

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.