[Help] API DataReader Problem
Code:
001070.730| WO_API: failed with error code 5 SQL Select Failed: Transaction (Process ID 53) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
001070.730| !!!! UpdateCharThread failed, code: 5, ans: SQL Select Failed: Transaction (Process ID 53) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction. , Rerun
001070.731| !!!! CAsyncApiWorker 1 job CJobUpdateChar[1167240] 104A0408 failed
001070.741| WOApi: Connect to 112.121.150.131
001070.741| WOApi: api_GetProfile1.aspx NETWORK time: 0.0100
001070.742| CAsyncApiWorker 1 job CJobUpdateChar[1167240] 104A0408 failed
Code:
015923.880| WO_API: failed with error code 6 alter item failedWO_5System.InvalidOperationException: There is already an open DataReader associated with this Command which must be closed first.
at System.Data.SqlClient.SqlInternalConnectionTds.ValidateConnectionForExecute(SqlCommand command)
at System.Data.SqlClient.SqlInternalTransaction.Rollback()
at System.Data.SqlClient.SqlTransaction.Dispose(Boolean disposing)
at api_SrvCharUpdate.UpdateCharBackpack()
at api_SrvCharUpdate.Execute()
at WOApiWebPage.Page_Load(Object sender, EventArgs _e)
015923.880| !!!! UpdateCharThread failed, code: 6, ans: alter item failedWO_5System.InvalidOperationException: There is already an open DataReader associated with this Command which must be closed first.
at System.Data.SqlClient.SqlInternalConnectionTds.ValidateConnectionForExecute(SqlCommand command)
at System.Data.SqlClient.SqlInternalTransaction.Rollback()
at System.Data.SqlClient.SqlTransaction.Dispose(Boolean disposing)
at api_SrvCharUpdate.UpdateCharBackpack()
at api_SrvCharUpdate.Execute()
at WOApiWebPage.Page_Load(Object sender, EventArgs _e) , Rerun
015923.880| !!!! CAsyncApiWorker 0 job CJobUpdateChar[1167689] 10265710 failed
Re: [Help] API DataReader Problem
what os ?
and sql version
Re: [Help] API DataReader Problem
Quote:
Originally Posted by
javaz97
what os ?
and sql version
windows server 2008 r2 enterprise 64-bit (x64)
Microsoft SQL Server 2008 R2 Express 64-bit (x64)
- - - Updated - - -
can you help me pls
how to fix
Re: [Help] API DataReader Problem
remove >> Microsoft SQL Server 2008 R2 Express 64-bit (x64)
and new install Microsoft SQL Server 2008 R2 Datacenter x64 + SP 1
Re: [Help] API DataReader Problem
