An error occured while running the CustomerRemindersTask

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.

Hi Prokey,

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

Thanks.

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

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