Navision error

Tatoshka

What can do such thing, is this a Navision error or SQL error?

The following SQL Server error(s) occurred while accessing the Sales Header Archive table:

601, “42000”,[Microsoft][ODBC SQL Server Driver][SQL Server] could not continue scan with NOLOCK due to data movement.

SQL:

SELECT COUNT(*)FROM”MVAPDB”,”dbo”.”MVAP Live$Sales Header Archive” WITH (READUNCOMMITTED) WHERE ((“Sell-to Customer No_”=’2763))



Is there a stuck job?

any idea?
thanks

geordie

Could be a SQL problem, probably regarding SIFT-tables...maybe did you insert any data directly in SQL, with some stored procedures or DTS?

Which NAV version are you using?