Five New Optimizely Certifications are Here! Validate your expertise and advance your career with our latest certification exams. Click here to find out more
AI OnAI Off
Five New Optimizely Certifications are Here! Validate your expertise and advance your career with our latest certification exams. Click here to find out more
Try posting your question on the commerce forum instead, you will get a response much quicker.
Hi,
I suspect this might be related to a recent fixed bug:
http://world.episerver.com/support/Bug-list/bug/128798
I would suggest you to upgrade to 8.16.1 to see if it fixes the issue for you.
Regards,
/Q
Hi,
Thank you for replays.
We will update our version and then we will check this issue.
Best Regards.
Hi,
I need help.
Sometimes we have these errors on prod machine.
But we can not reproduce on other environments.
System.NullReferenceException: Object reference not set to an instance of an object. at Mediachase.BusinessFoundation.Data.Sql.SqlHelper.PrepareCommand(SqlCommand command, SqlConnection connection, SqlTransaction transaction, CommandType commandType, String commandText, SqlParameter[] commandParameters) at Mediachase.BusinessFoundation.Data.Sql.SqlHelper.ExecuteReader(SqlConnection connection, SqlTransaction transaction, CommandType commandType, String commandText, SqlParameter[] commandParameters, SqlConnectionOwnership connectionOwnership) at Mediachase.BusinessFoundation.Data.Sql.SqlHelper.ExecuteReader(SqlContext context, CommandType commandType, String commandText, SqlParameter[] commandParameters) at Mediachase.BusinessFoundation.Data.Meta.Management.SqlSerialization.SqlSerializer.GetVersionId() at Mediachase.BusinessFoundation.Data.Meta.Management.SqlSerialization.SqlSerializer.Deserialize() at Mediachase.BusinessFoundation.Data.DataContext.get_MetaModel() at Project.Commerce.Business.ProductAvailability.Foundation.AutoInstallMetaDataPlugin.Execute(BusinessContext context) at Mediachase.BusinessFoundation.Data.Business.BusinessManager.ExecutePlugins(EventPipeLineStage eventPipeLineStage) at Mediachase.BusinessFoundation.Data.Business.BusinessManager.Execute(Request request) at Project.Commerce.Business.BusinessFoundation.EntityContext`1.InnerListDBRetrieve(FilterElement[] filters, SortingElement[] sortings)
System.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.Commit() at System.Data.SqlClient.SqlTransaction.Commit() at Mediachase.BusinessFoundation.Data.Sql.SqlContext.InnerCommit() at Mediachase.BusinessFoundation.Data.Sql.SqlTransactionScope.Commit() at Project.Commerce.Business.BusinessFoundation.EntityContext`1.Save(T entity, Boolean cacheData, Boolean refreshCache)
Save -> var tran = DataContext.Current.BeginTransaction(), BusinessManager.Create\Update(entity), tran.Commit().
...
System.Data.SqlClient.SqlException (0x80131904): Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding. ---> System.ComponentModel.Win32Exception (0x80004005): The wait operation timed out at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(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.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.TdsExecuteTransactionManagerRequest(Byte[] buffer, TransactionManagerRequestType request, String transactionName, TransactionManagerIsolationLevel isoLevel, Int32 timeout, SqlInternalTransaction transaction, TdsParserStateObject stateObj, Boolean isDelegateControlRequest) at System.Data.SqlClient.SqlInternalConnectionTds.ExecuteTransactionYukon(TransactionRequest transactionRequest, String transactionName, IsolationLevel iso, SqlInternalTransaction internalTransaction, Boolean isDelegateControlRequest) at System.Data.SqlClient.SqlInternalConnection.BeginSqlTransaction(IsolationLevel iso, String transactionName, Boolean shouldReconnect) at System.Data.SqlClient.SqlConnection.BeginTransaction(IsolationLevel iso, String transactionName) at Mediachase.BusinessFoundation.Data.Sql.SqlContext.BeginTransaction() at Mediachase.BusinessFoundation.Data.DataContext.BeginTransaction() at Mediachase.BusinessFoundation.Data.Business.BusinessManager.Execute(Request request) at Project.Commerce.Business.BusinessFoundation.EntityContext`1.InnerListDBRetrieve(FilterElement[] filters, SortingElement[] sortings)
May be we do wrong something? Can somebody help?
Version:
EPiServer.Commerce.Core.8.9.0