Issue while doing checkout from shoppingcat.

Hello Experts,

I am getting below error while doing check out from shoppingcart.

Monday, October 19, 2020 10:22 AM Error WebLog te1r5ja3adpoh4vtuscra5gj VI.Base.ViException: Beim Ausführen der Formularmethode F0_ctl00_ControlRef8_ControlRef15_ControlRef15_ControlRef8b_Main_Main_Container6_Container7_Button4_Method ist ein Fehler aufgetreten. ---> System.AggregateException: One or more errors occurred. ---> System.AggregateException: One or more errors occurred. ---> VI.Base.ViException: Fehler beim Anwenden der Änderungen in der Datenbank. ---> VI.DB.ChangedByAnotherUserException: Fachliche Rolle (FR) wurde inzwischen von einem anderen Benutzer geändert.
at VI.DB.Entities.DbOperations.ClusteringDbOperationsQueue.<_RunSingleAsync>d__41.MoveNext()

I did checked all logs and also no other user is doig check out.

Could you please tell me what could be reason for this error.

Thank you.

Kind Regards,

0 Rene.Obermueller over 3 years ago

Hi,

the error message means that the whereclause of the update statement did not find any rows to update. This could be a genuine parallel change by another user to the row, or a different error situation, e.g. incorrect data conversion or a double update.

Suggest to provide the exact version, and have a look at the SqlLog output including some amount of context. And it would be good to know if this is a permanent or intermittent error.

-René
Cancel
Up 0 Down

Reply

Verify Answer

Cancel
0 dnyandev garad over 3 years ago in reply to Rene.Obermueller

Hi Rene,

Thank you for quick response.

We are using version 8.1.3.

This error mesage is ot permanent but getting some time only.

Kind Regards,

DG
Cancel
Up 0 Down

Reply

Verify Answer

Cancel
0 Rene.Obermueller over 3 years ago in reply to dnyandev garad

For 8.1.3 at first glance this doesn't look like a known defect. Suggest to look at Sqllog and compare to row in ShoppingCartItem to see if there is anything obvious why the update statement failed.

-René
Cancel
Up 0 Down

Reply

Verify Answer

Cancel

Endpoint Privilege Management

Issue while doing checkout from shoppingcat.