Time-out occurred while waiting for buffer latch type 2 for

ara3n

When importing an fob into sql 2k5 sp3 with 5.0 sp1 exe I get the following error.
The table has 1.2 million records. And based on sql statement it errors while creating the VIEW for SIFT
Has anybody seen this and a solution?
The workaround I've found is export the data through dataport. Delete the records. Import the fob and import the data.
This is time consuming and every time I have to change the table, I have follow the steps again. Thanks.

---

Microsoft Dynamics NAV

---

The following SQL Server error(s) occurred while accessing the Value Entry table:

845,"42000",[Microsoft][ODBC SQL Server Driver][SQL Server]
Time-out occurred while waiting for buffer latch type 2 for page (3:527372), database ID 36.
3621,"01000",[Microsoft][ODBC SQL Server Driver][SQL Server]The statement has been terminated.

SQL:
CREATE UNIQUE CLUSTERED INDEX "VSIFTIDX" ON dbo."PROD-LA-COLOMBIA$Value Entry$VSIFT$3" ("Item No_","Posting Date","Item Ledger Entry Type","Entry Type","Variance Type","Item Charge No_","Location Code","Variant Code")

---

OK

---

kine

May be that Update 1.3 will help you, see KB957733.

garak

Is it the original 5.00 SP1 exe or with some hotfixes :?:

here the link to the KB that kine post

https://mbs.microsoft.com/knowledgebase ... wsignin1.0