Sage 100

Upgrading from 2013 Premium to 2015 Premium. Migration went smoothly, but in conversion process we get stuck on the following (tried a few times, same results each time). Hellllp! ""The following conversion record failed while converting XXX: 05.10.00.00:DATA:IM_Item_TransactionHistory:000000:000 - Create Table failed for MAS_XXX..IM_ItemTransactionHistory 08S01:[Microsoft][SQL Server Native Client 11.0]The connection is no longer usable because the server failed to respond to a command cancellation for a previously executed statement in a timely manner. Possible causes include application deadlocks or the server being overloaded. Open a new connection and re-try the operation.

Logged into SQL Server management Studio so we could see what happened when the Sage Error popped up and got the following: ""Lock request time out period exceeded. (Microsoft SQL Server, Error 1222) googling now

Are you using the sa logon? I have had issues converting even when using a logon with sys admin privileges.

Yep, using the SA.

IT at the client seems to think there is a lock file stuck somewhere. Anyone know how to check SQL for files that are locked?

Saw this on the internet: http://dba.stackexchange.com/questions/1214/help-solving-a-clustering-issue-sqsrvres-odbc-sqldriverconnect-failed One of the error messages returned is exactly the one you are getting.

Forwarded that to the IT guy and he applied the suggested fixes, but still no luck. We are reindexing the file in SQL to see if maybe it's just a bad record. Still open to suggestions though :) I would love to be done with this before midnight! *fingers crossed*

Turns out it was lock files! https://amitchandnz.wordpress.com/2010/08/29/kill-process-sp_who2/ sp_lock sp_who2 kill (SPID# to be killed) - no ticks '

Glad you resolved the issue and this is good to know.