Print and Delivery Error: Form - Reserved / Illegal form Unique ID [66000-2] Answered
Hi,
We are looking to use the 'Conditional Action - Report Action' on HANA and keep getting the error.
We also moved the UDF to the header section of the Sales Order.
Can someone please have a look at our syntax and advise if something needs changing?
SELECT CASE WHEN ($[$BOYX_1.0.0]) = 'Y' THEN 'Email' END FROM DUMMY
Thanks
Hannes
Comments
6 comments
Hello,
In this case is a HANA syntax error, what I did is that I created this condition with SQL syntax and use the HANA SQL Conversion tool to obtain the correct one:
SELECT CASE
WHEN ($[$BOYX_1.0.0] = 'Y')
THEN
(
SELECT 'EMAIL' FROM DUMMY
)
END FROM Dummy
Hi Hannes
From what I can see, it seems like your query is not quite in the proper HANA query format.
HANA is very fuzzy in regard to where you put the brackets.
I would suggest that you search for some HANA query samples in CASE statement and then modify your query accordingly.
Hi Yaremi,
Thanks for the HANA code,
I will update the configuration on the customer server, run a new test and log an update on here.
Regards,
Hannes
Hi Wendy,
Thanks for your response and suggestion.
Regards,
Hannes
Hi Yaremi,
I just changed the code and now we get the following message. Any ideas?
Error performing action: [RA-001 - Email SO - Del Approved - SMTP] (Could not execute SQL: SELECT CASE
WHEN (N = 'Y')
THEN
(
SELECT 'EMAIL' FROM DUMMY
)
END FROM Dummy (1). [SAP AG][LIBODBCHDB32 DLL][HDBODBC32] General error;260 invalid column name: N: line 2 col 7 (at pos 19)
))
Thanks
Hannes
Hello James,
I think the '' are missing in the syntax. But again, this is caused by HANA not by the add-on.
Please sign in to leave a comment.