hamed_night
June 6th, 2015, 22:31
سلام
دوستان کسی با این خطا برخورد نکرده؟
فکر میکنم در مورد collation دیتابیس هستش ولی اصلا نمیشه collation رو تغییر داد
وارد صفحه auditlog که میشیم این پیغم رو میده
متن کامل خطا این هستش
************************************************** ************
Page URL: http://***********/Default.aspx?pid=AuditLog&UserID=1
Logged User: serveradmin
Work on Behalf: serveradmin
Hosting Space: 0
Stack Trace: System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. ---> System.Web.Services.Protocols.SoapException: System.Web.Services.Protocols.SoapException: Server was unable to process request. ---> System.Data.SqlClient.SqlException: Cannot resolve the collation conflict between "Latin1_General_CI_AS" and "Arabic_CI_AS" in the equal to operation.
at System.Data.SqlClient.SqlConnection.OnError(SqlExc eption exception, Boolean breakConnection, Action`1 wrapCloseInAction)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndW arning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
at System.Data.SqlClient.SqlDataReader.TryConsumeMeta Data()
at System.Data.SqlClient.SqlDataReader.get_MetaData()
at System.Data.SqlClient.SqlCommand.FinishExecuteRead er(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
at System.Data.SqlClient.SqlCommand.RunExecuteReaderT ds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, SqlDataReader ds)
at System.Data.SqlClient.SqlCommand.RunExecuteReader( CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean asyncWrite)
at System.Data.SqlClient.SqlCommand.RunExecuteReader( CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
at System.Data.SqlClient.SqlCommand.ExecuteReader(Com mandBehavior behavior, String method)
at System.Data.SqlClient.SqlCommand.ExecuteDbDataRead er(CommandBehavior behavior)
at System.Data.Common.DbCommand.System.Data.IDbComman d.ExecuteReader(CommandBehavior behavior)
at System.Data.Common.DbDataAdapter.FillInternal(Data Set dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet)
at Microsoft.ApplicationBlocks.Data.SqlHelper.Execute Dataset(SqlConnection connection, CommandType commandType, String commandText, SqlParameter[] commandParameters)
at Microsoft.ApplicationBlocks.Data.SqlHelper.Execute Dataset(String connectionString, CommandType commandType, String commandText, SqlParameter[] commandParameters)
at WebsitePanel.EnterpriseServer.DataProvider.GetAudi tLogRecordsPaged(Int32 actorId, Int32 userId, Int32 packageId, Int32 itemId, String itemName, DateTime startDate, DateTime endDate, Int32 severityId, String sourceName, String taskName, String sortColumn, Int32 startRow, Int32 maximumRows)
at WebsitePanel.EnterpriseServer.AuditLog.GetAuditLog RecordsPaged(Int32 userId, Int32 packageId, Int32 itemId, String itemName, DateTime startDate, DateTime endDate, Int32 severityId, String sourceName, String taskName, String sortColumn, Int32 startRow, Int32 maximumRows)
at WebsitePanel.EnterpriseServer.esAuditLog.GetAuditL ogRecordsPaged(Int32 userId, Int32 packageId, Int32 itemId, String itemName, DateTime startDate, DateTime endDate, Int32 severityId, String sourceName, String taskName, String sortColumn, Int32 startRow, Int32 maximumRows)
--- End of inner exception stack trace ---
at System.Web.Services.Protocols.SoapHttpClientProtoc ol.ReadResponse(SoapClientMessage message, WebResponse response, Stream responseStream, Boolean asyncCall)
at System.Web.Services.Protocols.SoapHttpClientProtoc ol.Invoke(String methodName, Object[] parameters)
at WebsitePanel.EnterpriseServer.esAuditLog.GetAuditL ogRecordsPaged(Int32 userId, Int32 packageId, Int32 itemId, String itemName, DateTime startDate, DateTime endDate, Int32 severityId, String sourceName, String taskName, String sortColumn, Int32 startRow, Int32 maximumRows)
at WebsitePanel.Portal.AuditLogHelper.GetAuditLogReco rdsPaged(Int32 maximumRows, Int32 startRowIndex, String sortColumn, String sStartDate, String sEndDate, Int32 packageId, Int32 itemId, String itemName, Int32 severityId, String sourceName, String taskName)
--- End of inner exception stack trace ---
at System.RuntimeMethodHandle.InvokeMethod(Object target, Object[] arguments, Signature sig, Boolean constructor)
at System.Reflection.RuntimeMethodInfo.UnsafeInvokeIn ternal(Object obj, Object[] parameters, Object[] arguments)
at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture)
at System.Web.UI.WebControls.ObjectDataSourceView.Inv okeMethod(ObjectDataSourceMethod method, Boolean disposeInstance, Object& instance)
************************************************** **************************
دوستان کسی با این خطا برخورد نکرده؟
فکر میکنم در مورد collation دیتابیس هستش ولی اصلا نمیشه collation رو تغییر داد
وارد صفحه auditlog که میشیم این پیغم رو میده
متن کامل خطا این هستش
************************************************** ************
Page URL: http://***********/Default.aspx?pid=AuditLog&UserID=1
Logged User: serveradmin
Work on Behalf: serveradmin
Hosting Space: 0
Stack Trace: System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. ---> System.Web.Services.Protocols.SoapException: System.Web.Services.Protocols.SoapException: Server was unable to process request. ---> System.Data.SqlClient.SqlException: Cannot resolve the collation conflict between "Latin1_General_CI_AS" and "Arabic_CI_AS" in the equal to operation.
at System.Data.SqlClient.SqlConnection.OnError(SqlExc eption exception, Boolean breakConnection, Action`1 wrapCloseInAction)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndW arning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
at System.Data.SqlClient.SqlDataReader.TryConsumeMeta Data()
at System.Data.SqlClient.SqlDataReader.get_MetaData()
at System.Data.SqlClient.SqlCommand.FinishExecuteRead er(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
at System.Data.SqlClient.SqlCommand.RunExecuteReaderT ds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, SqlDataReader ds)
at System.Data.SqlClient.SqlCommand.RunExecuteReader( CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean asyncWrite)
at System.Data.SqlClient.SqlCommand.RunExecuteReader( CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
at System.Data.SqlClient.SqlCommand.ExecuteReader(Com mandBehavior behavior, String method)
at System.Data.SqlClient.SqlCommand.ExecuteDbDataRead er(CommandBehavior behavior)
at System.Data.Common.DbCommand.System.Data.IDbComman d.ExecuteReader(CommandBehavior behavior)
at System.Data.Common.DbDataAdapter.FillInternal(Data Set dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet)
at Microsoft.ApplicationBlocks.Data.SqlHelper.Execute Dataset(SqlConnection connection, CommandType commandType, String commandText, SqlParameter[] commandParameters)
at Microsoft.ApplicationBlocks.Data.SqlHelper.Execute Dataset(String connectionString, CommandType commandType, String commandText, SqlParameter[] commandParameters)
at WebsitePanel.EnterpriseServer.DataProvider.GetAudi tLogRecordsPaged(Int32 actorId, Int32 userId, Int32 packageId, Int32 itemId, String itemName, DateTime startDate, DateTime endDate, Int32 severityId, String sourceName, String taskName, String sortColumn, Int32 startRow, Int32 maximumRows)
at WebsitePanel.EnterpriseServer.AuditLog.GetAuditLog RecordsPaged(Int32 userId, Int32 packageId, Int32 itemId, String itemName, DateTime startDate, DateTime endDate, Int32 severityId, String sourceName, String taskName, String sortColumn, Int32 startRow, Int32 maximumRows)
at WebsitePanel.EnterpriseServer.esAuditLog.GetAuditL ogRecordsPaged(Int32 userId, Int32 packageId, Int32 itemId, String itemName, DateTime startDate, DateTime endDate, Int32 severityId, String sourceName, String taskName, String sortColumn, Int32 startRow, Int32 maximumRows)
--- End of inner exception stack trace ---
at System.Web.Services.Protocols.SoapHttpClientProtoc ol.ReadResponse(SoapClientMessage message, WebResponse response, Stream responseStream, Boolean asyncCall)
at System.Web.Services.Protocols.SoapHttpClientProtoc ol.Invoke(String methodName, Object[] parameters)
at WebsitePanel.EnterpriseServer.esAuditLog.GetAuditL ogRecordsPaged(Int32 userId, Int32 packageId, Int32 itemId, String itemName, DateTime startDate, DateTime endDate, Int32 severityId, String sourceName, String taskName, String sortColumn, Int32 startRow, Int32 maximumRows)
at WebsitePanel.Portal.AuditLogHelper.GetAuditLogReco rdsPaged(Int32 maximumRows, Int32 startRowIndex, String sortColumn, String sStartDate, String sEndDate, Int32 packageId, Int32 itemId, String itemName, Int32 severityId, String sourceName, String taskName)
--- End of inner exception stack trace ---
at System.RuntimeMethodHandle.InvokeMethod(Object target, Object[] arguments, Signature sig, Boolean constructor)
at System.Reflection.RuntimeMethodInfo.UnsafeInvokeIn ternal(Object obj, Object[] parameters, Object[] arguments)
at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture)
at System.Web.UI.WebControls.ObjectDataSourceView.Inv okeMethod(ObjectDataSourceMethod method, Boolean disposeInstance, Object& instance)
************************************************** **************************