Hi,
Lately we’ve been getting a lot of errors when migrating insurances that my data is locked by another record and to rerun the transaction. Is there a way to figure out what process is locking my record (besides a trace)?
That way maybe we can figure out the timing issue of why newly imported data can be locked already.
Thanks in advance!
@Mila_Sparreboom, hi! My first though was about M10693 – Novulo Event Logging: to configure logs.
Hi, thanks for your response.
Quick question: how configurable is that? I opened the component quickly and it looks like you do need an existing datasource to look into. And that’s not included in the Novulo migereren van verzekeringen component. Could we still use that to figure out my deadlock error of is there another way?
@Mila_Sparreboom, what you can try first then (it is quicker): kendoopenlockslog tabel. So you can create an export definition for the data type = kendoopenlockslog ([kendoopenlockslog]), filter it like this:
boolean:and([
boolean:not(this.lockedrecorddata.equals("[]")),
this.kendoprocesslog.datetime.isgreater(datetime:load("xxxx-xx-xxTxx:xx:xx")),
this.kendoprocesslog.datetime.islower(datetime:load("xxxx-xx-xxTxx:xx:xx"))
])
And add fields, for example:
Then you should be able to see locked records. @Redmer, correct me if I am wrong.
