Print and Delivery Error: Form - Reserved / Illegal form Unique ID [66000-2]

Answered

Hannes Jordaan

July 25, 2017 15:26

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

0

Comments

6 comments

Official comment
Yaremi Miranda Lopez

July 26, 2017 14:37
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
Wendy Tranter

July 26, 2017 13:02
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.
Hannes Jordaan

July 26, 2017 14:51
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
Hannes Jordaan

July 26, 2017 14:52
Hi Wendy,

Thanks for your response and suggestion.

Regards,

Hannes
Hannes Jordaan

July 26, 2017 15:03
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
Yaremi Miranda Lopez

July 27, 2017 16:34
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.