Sales Header Archive Table locked ?

julkifli33

hi all
i want to create sales invoice from job
but the process is very slow, and in the end it cant be created
there is an error message that said Sales Header Archive locked

for your information, user who use this database only one user

and when i try to back up and restore to my local pc
i can create sales invoice

kindly help
thanks

Srivas

I think its the code issue.
check code where it is applying filter to a record variable with no or incorrect keys ( this takes lot of time).
And I think the same table is updated down the line.

julkifli33

Srivas wrote:

I think its the code issue.
check code where it is applying filter to a record variable with no or incorrect keys ( this takes lot of time).
And I think the same table is updated down the line.

i didnt add any code for this object
still use standard nav
but the weird thing is ... in server have problem, but in my local it's okay

kriki

julkifli33 wrote:

still use standard nav

What do you mean with standard NAV? classic client or native database? (there are differences between behaviour on SQL and native DB).