Transaction resolve with error “Lock request timeout” 10k + records

[jet2050]

Hello dear Kim

Please, I request your help to resolve the “Lock request timeout” error when saving a document with more than 10,000 detail records on the server.
The database is SQL Server
DevArt SDAC
Delphi Enterprise 10.2.3
kbmMW Enterprise 5.21

I have already tried changing the DefaultLockTimeOut parameter from 2000 to 6000 in the TMSConnection without success.
Also, change the Provider option from prAuto to prSQL.

Is there an alternative to applying the transaction in smaller blocks without being affected by the lock timeout?

Thanks in advance for your time and help.

Greetings

Job Espejel

• This topic was modified 2 years, 11 months ago by jet2050.

[kimbomadsen]

Hi,

I do not know why MSSQL or DevArt do not respect your setting, or if it really takes that long to process the records that the timeout happens anyway. You could try to set it to -1 as that should make it default to MSSQLs default setting which is infinite.
However I have added a BatchSize property (default 0) to the resolver. It will autocommit every n records. It will however work against the allornothing=true setting, as that will only be related on the latest batch, and not on all previous already committed batches.

/Kim

[jet2050]

Thanks Kim

[Author]

Posts