cancel
Showing results for 
Search instead for 
Did you mean: 

Could not commit transaction: Error -1 detected during transaction in the HANA approval query

0 Kudos

Hi,

The $[$38.10002037] is distribution rule, when i provide the dist rule then query works correctly means and when i dont provide the dist rule norrmally it should allow to create the Purchase order. But it throwing the error as "Could not commit transaction: Error -1 detected during transaction" . i used the converter to convert my sql query to the below HANA query. is there any error in the query ?

SELECT DISTINCT 'TRUE' FROM DUMMY WHERE $[$38.10002037] IN ('100','110') AND NOT EXISTS (SELECT "CardCode" FROM "OCRD" WHERE "CardCode" = $[$4.0] AND "QryGroup13" = 'Y');

Dwarakanath

Accepted Solutions (0)

Answers (0)