Hi All,
Below error i got while converting the Nav 2009 Sp1 into Nav 2013 database:
The following SQL Server error or errors occurred when accessing the Value Entry table:
845,“42000”,[Microsoft][SQL Server Native Client 10.0][SQL Server]Time-out occurred while waiting for buffer latch type 2 for page (3:18277597), database ID 7.
3621,“01000”,[Microsoft][SQL Server Native Client 10.0][SQL Server]The statement has been terminated.
SQL:
CREATE UNIQUE CLUSTERED INDEX [VSIFTIDX] ON dbo.[Efftronics Systems Pvt Ltd_,$Value Entry$VSIFT$13] ([Item No_],[Global Dimension 1 Code],[Global Dimension 2 Code],[Source Type],[Source No_],[Item Ledger Entry Type],[Entry Type],[Posting Date])
Current my server has 32 GB RAM for 280 GB Database(Single user mode)…I am using SQL server Enterprise Edition…
Kindly tell me the solution.
Thanks & Regards,
Baba Guru.