Close

An error occured while running the CustomerRemindersTask

Prokey
5 years ago
#4448 Quote
Avatar
  • 3
In the system log, many errors are generated with the following exception:
System.Data.EntityCommandExecutionException: An error occurred while executing the command definition. See the inner exception for details. ---> System.Data.SqlClient.SqlException: Invalid column name 'StoreId'. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.SqlInternalConnection.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.SqlDataReader.TryConsumeMetaData() at System.Data.SqlClient.SqlDataReader.get_MetaData() at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite) 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(CommandBehavior behavior, String method) at System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior) at System.Data.Common.DbCommand.ExecuteReader(CommandBehavior behavior) at System.Data.EntityClient.EntityCommandDefinition.ExecuteStoreCommands(EntityCommand entityCommand, CommandBehavior behavior) --- End of inner exception stack trace --- at System.Data.EntityClient.EntityCommandDefinition.ExecuteStoreCommands(EntityCommand entityCommand, CommandBehavior behavior) at System.Data.Objects.Internal.ObjectQueryExecutionPlan.Execute[TResultType](ObjectContext context, ObjectParameterCollection parameterValues) at System.Data.Objects.ObjectQuery`1.GetResults(Nullable`1 forMergeOption) at System.Data.Objects.ObjectQuery`1.System.Collections.Generic.IEnumerable<T>.GetEnumerator() at System.Data.Entity.Internal.Linq.InternalQuery`1.GetEnumerator() at System.Data.Entity.Infrastructure.DbQuery`1.System.Collections.Generic.IEnumerable<TResult>.GetEnumerator() at System.Collections.Generic.List`1..ctor(IEnumerable`1 collection) at System.Linq.Enumerable.ToList[TSource](IEnumerable`1 source) at SevenSpikes.Nop.Plugins.CustomerReminders.Services.ReminderService.GetAllEnabledReminders(Boolean showDeleted) at SevenSpikes.Nop.Plugins.CustomerReminders.Services.RemindersProcessor.() at SevenSpikes.Nop.Plugins.CustomerReminders.Services.RemindersProcessor.ProcessReminders() at SevenSpikes.Nop.Plugins.CustomerReminders.Tasks.CustomerRemindersTask.Execute()

Please, help.

Thanks.
hristian.dimov
5 years ago
#4449 Quote
Avatar
  • Moderator
  • 386
Prokey wrote:
In the system log, many errors are generated with the following exception:

...

Please, help.

Thanks.


Hi Prokey,

Can you tell me what version of nopCommerce & plugin version you are using?

Thanks.
Regards,
Hristian Dimov
Nop-Templates.com
Prokey
5 years ago
#4450 Quote
Avatar
  • 3
NopCommerce version: 3.10

Group: 7Spikes
FriendlyName: Nop Shop All Theme
SystemName: SevenSpikes.Theme.ShopAll
Version: 3.10
SupportedVersions: 3.10
Author: Seven Spikes
DisplayOrder: 2
FileName: SevenSpikes.Theme.ShopAll.dll
Boyko
5 years ago
#4459 Quote
Avatar
  • Moderator
  • 1437
Prokey wrote:
NopCommerce version: 3.10

Group: 7Spikes
FriendlyName: Nop Shop All Theme
SystemName: SevenSpikes.Theme.ShopAll
Version: 3.10
SupportedVersions: 3.10
Author: Seven Spikes
DisplayOrder: 2
FileName: SevenSpikes.Theme.ShopAll.dll


Hi Prokey,

You need to check the zip package number that you have downloaded.
When did you start to get this error? Can you clear your Log and see if this error appears? Have you upgraded your nopCommerce installation from previous nopCommerce version i.e 3.0?

Thanks
Regards,
Boyko Stanev
Nop-Templates.com
joster
5 years ago
#4540 Quote
Avatar
  • 127
I have also been having these errors for the same amount of time..about 2 weeks now.
It doesn't seem to be JUST the CustomerReminders task, but all scheduled tasks.

I started this topic here:
http://www.nop-templates.com/boards/topic/929/errors-in-log


I also posted a topic at nopcommerce.com forums:
http://www.nopcommerce.com/boards/t/29170/scheduled-tasks-throwing-errors.aspx

Anyone?

Steve
Boyko
5 years ago
#4565 Quote
Avatar
  • Moderator
  • 1437
joster wrote:
I have also been having these errors for the same amount of time..about 2 weeks now.
It doesn't seem to be JUST the CustomerReminders task, but all scheduled tasks.

I started this topic here:
http://www.nop-templates.com/boards/topic/929/errors-in-log


I also posted a topic at nopcommerce.com forums:
http://www.nopcommerce.com/boards/t/29170/scheduled-tasks-throwing-errors.aspx

Anyone?

Steve


Hi Steve,

We received your email with your web site credentials and the we will investigate what the reason for these errors could be. We will send you an email with an update.

Thanks
Regards,
Boyko Stanev
Nop-Templates.com