Ogone error: UpdateCommand is not supported

Martijn van Tongeren

Posted on 20/05/2016 22:55:03

We getting an error with a ogone payment. Ogone does a callback (see log with status 9, success status) . We getting the following error: Dynamicweb.eCommerce.Cart.CheckoutHandlers.Ogone An error with the message 'Unhandled exception with message: Dynamic SQL generation for the UpdateCommand is not supported against a SelectCommand that does not return any key column information.' occurred.

Someone any idea?

vr, 20 mei 2016 22:37:20	CheckoutHandler Redirecting to checkout handler: Dynamicweb.eCommerce.Cart.CheckoutHandlers.Ogone
vr, 20 mei 2016 22:37:20	Dynamicweb.eCommerce.Cart.CheckoutHandlers.Ogone Callback started. Payment status: 9 (Total:99, orderline total: €99.00; Orderlines:1 - Products:1, Discounts:0, Taxes:0, BOM:0.)
vr, 20 mei 2016 22:37:20	Dynamicweb.eCommerce.Cart.CheckoutHandlers.Ogone Payment ORDER8606 succeeded with transaction number 3003635501 (Total:99, orderline total: €99.00; Orderlines:1 - Products:1, Discounts:0, Taxes:0, BOM:0.)
vr, 20 mei 2016 22:37:20	Dynamicweb.eCommerce.Cart.CheckoutHandlers.Ogone An error with the message 'Unhandled exception with message: Dynamic SQL generation for the UpdateCommand is not supported against a SelectCommand that does not return any key column information.' occurred. See the error log for details. (Total:99, orderline total: €99.00; Orderlines:1 - Products:1, Discounts:0, Taxes:0, BOM:0.)

log.txt

Replies

Martijn van Tongeren

Posted on 21/05/2016 12:23:46

I tried to rebuild the index and run the magic pixel without succes. The problems start when we update to 8.8.1.1 so we switch back to 8.8.0.6.

Martijn van Tongeren

Posted on 21/05/2016 17:46:38

I found the problem. In version 8.8.1.1 there is a new column OrderAutoId this will also create an index: DW_IX_EcomOrders_AutoId. Because we think the problem is the new core, we downgrade to 8.6.0.6.

I removed this index and the payment status of ogone is succesfull set in DW. But there is still an issue in version 8.8.1.1 with setting the payment status from Ogone. Does anyone else also have this problem with this version?

Nicolai Høeg Pedersen

Posted on 24/05/2016 10:58:47

Hi Martijn

I've send this to QA for investigation and fixing.

BR Nicolai

Oleg Rodionov

Posted on 25/05/2016 04:59:58

Hi all,

New TFS 23273 has been created against the bug, thanks.

BR, Oleg QA

You must be logged in to post in the forum

Developer forum

Ogone error: UpdateCommand is not supported

Replies