Error while Converting Nav 2009 Sp1 into Nav 2013(Nav 2013 Upgradation)

Business Central/NAV Technical Forum
1

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.

2

This error occurred while opening the SP1 database in Nav 2013 Development Environment(Altering Database).

3

Hi,

Please check if any of your key groups are disabled or enable for some reason… if the key have maintain sql index yes… this could cause the problem…i suppose

if maintainsql index is Yes… the please don’t disable those keys… in this case please check the key in the value entry table.

Anil.