Email can't delivery ?!!

Faisal Alsugair asked on August 1, 2015 12:04

Hello,

I have upgrade from Kentico 8.1 to 8.2 successfully but I note one problem when I try to send email by use Contact us page on my website: http://www.namerah.com/Contact-us.aspx the email message don't arrive to inbox and it saved in FORM app and Email queue app under waiting... I'm sure the setting of SMTP and password is correct and it was working fin in v8.1.

Also After check the Event Log I see the error as below:

CMS version: 8.2 Build: 8.2.31 OS version: Microsoft Windows NT 6.3.9600.0 License info: namerah.com, Base, 1/1/0001 12:00:00 AM, 08 EventID: 57635

EventType: E

EventTime: 8/1/2015 2:56:56 AM

Source: SchedulingExecutorParameters

EventCode: RUN

UserID: 53

UserName: admin

IPAddress: 77.64.10.172

EventDescription: Message:

Proc_CMS_ScheduledTask_FetchTasksToRun

Caused exception: Invalid object name 'CMS_ScheduledTask'. Transaction count after EXECUTE indicates a mismatching number of BEGIN and COMMIT statements. Previous count = 0, current count = 1.

Exception type: System.Exception Stack Trace: at CMS.DataEngine.AbstractDataConnection.HandleError(String queryText, Exception ex) at CMS.DataEngine.AbstractDataConnection.ExecuteQuery(String queryText, QueryDataParameters queryParams, QueryTypeEnum queryType, Boolean requiresTransaction) at CMS.DataEngine.AbstractDataConnection.CMS.DataEngine.IDataConnection.ExecuteQuery(String queryText, QueryDataParameters queryParams, QueryTypeEnum queryType, Boolean requiresTransaction) at CMS.DataEngine.GeneralConnection.RunQuery(QueryParameters query) at CMS.DataEngine.GeneralConnection.ExecuteQuery(QueryParameters query) at CMS.DataEngine.GeneralConnection.ExecuteQuery(QueryParameters query, Int32& totalRecords) at CMS.DataEngine.DataQueryBase1.GetDataFromDB() at CMS.DataEngine.DataQueryBase1.GetData() at CMS.DataEngine.DataQueryBase1.get_Result() at CMS.DataEngine.ConnectionHelper.ExecuteQuery(String queryName, QueryDataParameters parameters, String where, String orderBy, Int32 topN, String columns, Int32 offset, Int32 maxRecords, Int32& totalRecords) at CMS.DataEngine.AbstractInfoProvider2.ExecuteQuery(String queryName, QueryDataParameters parameters, String where, String orderBy, Int32 topN, String columns, Int32 offset, Int32 maxRecords, Int32& totalRecords) at CMS.Scheduler.TaskInfoProvider.FetchTasksToRunInternal(String siteName, String serverName, Nullable`1 useExternalService) at CMS.Scheduler.TaskInfoProvider.FetchAllTasksToRun(String siteName, String serverName) at CMS.Scheduler.SchedulingExecutor.ExecuteScheduledTasks(String siteName, String serverName) at CMS.Scheduler.SchedulingExecutorParameters.ExecuteScheduledTasks() at CMS.Base.CMSThread.RunThread() at CMS.Base.CMSThread.Run()

Message: Invalid object name 'CMS_ScheduledTask'. Transaction count after EXECUTE indicates a mismatching number of BEGIN and COMMIT statements. Previous count = 0, current count = 1.

Exception type: System.Data.SqlClient.SqlException Stack Trace: at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action1 wrapCloseInAction) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action1 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, 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(CommandBehavior behavior, String method) at System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior) at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior) at System.Data.Common.DbDataAdapter.FillInternal(DataSet 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 CMS.DataEngine.AbstractDataConnection.ExecuteQuery(String queryText, QueryDataParameters queryParams, QueryTypeEnum queryType, Boolean requiresTransaction)

Message:

Proc_CMS_ScheduledTask_FetchTasksToRun

Caused exception: Invalid object name 'CMS_ScheduledTask'. Transaction count after EXECUTE indicates a mismatching number of BEGIN and COMMIT statements. Previous count = 0, current count = 1.

Exception type: System.Exception Stack Trace: at CMS.DataEngine.AbstractDataConnection.HandleError(String queryText, Exception ex) at CMS.DataEngine.AbstractDataConnection.ExecuteQuery(String queryText, QueryDataParameters queryParams, QueryTypeEnum queryType, Boolean requiresTransaction) at CMS.DataEngine.AbstractDataConnection.CMS.DataEngine.IDataConnection.ExecuteQuery(String queryText, QueryDataParameters queryParams, QueryTypeEnum queryType, Boolean requiresTransaction) at CMS.DataEngine.GeneralConnection.RunQuery(QueryParameters query) at CMS.DataEngine.GeneralConnection.ExecuteQuery(QueryParameters query) at CMS.DataEngine.GeneralConnection.ExecuteQuery(QueryParameters query, Int32& totalRecords) at CMS.DataEngine.DataQueryBase1.GetDataFromDB() at CMS.DataEngine.DataQueryBase1.GetData() at CMS.DataEngine.DataQueryBase1.get_Result() at CMS.DataEngine.ConnectionHelper.ExecuteQuery(String queryName, QueryDataParameters parameters, String where, String orderBy, Int32 topN, String columns, Int32 offset, Int32 maxRecords, Int32& totalRecords) at CMS.DataEngine.AbstractInfoProvider2.ExecuteQuery(String queryName, QueryDataParameters parameters, String where, String orderBy, Int32 topN, String columns, Int32 offset, Int32 maxRecords, Int32& totalRecords) at CMS.Scheduler.TaskInfoProvider.FetchTasksToRunInternal(String siteName, String serverName, Nullable`1 useExternalService) at CMS.Scheduler.TaskInfoProvider.FetchAllTasksToRun(String siteName, String serverName) at CMS.Scheduler.SchedulingExecutor.ExecuteScheduledTasks(String siteName, String serverName) at CMS.Scheduler.SchedulingExecutorParameters.ExecuteScheduledTasks() at CMS.Base.CMSThread.RunThread() at CMS.Base.CMSThread.Run()

Message: Invalid object name 'CMS_ScheduledTask'. Transaction count after EXECUTE indicates a mismatching number of BEGIN and COMMIT statements. Previous count = 0, current count = 1.

Exception type: System.Data.SqlClient.SqlException Stack Trace: at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action1 wrapCloseInAction) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action1 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, 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(CommandBehavior behavior, String method) at System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior) at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior) at System.Data.Common.DbDataAdapter.FillInternal(DataSet 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 CMS.DataEngine.AbstractDataConnection.ExecuteQuery(String queryText, QueryDataParameters queryParams, QueryTypeEnum queryType, Boolean requiresTransaction)

EventUrl: /CMSModules/EventLog/EventLog_Details.aspx?params=1f7ec324-2616-4f92-9e79-e3d49d5006a0&hash=723fb8793b1c2a31792afbe8b21f8ffdd8b65247bdb99b878e812b18e213c987&eventid=57634

EventMachineName: SPIRAEA

EventUserAgent: Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/44.0.2403.125 Safari/537.36

EventUrlReferrer: http://www.namerah.com/Admin/cmsadministration.aspx

Recent Answers

Roman Hutnyk answered on August 1, 2015 19:51 (last edited on August 1, 2015 19:53)

First of all you might visit System application, Email tab and test sending of emails from there.

Also I'd recommend you to restart Kentico from System application and, if it does not help, restars site at the IIS.

Sometimes Kentico behavior after upgrade is really weird...

If restart of the app will not help I'd start investigation from the scheduled task, which sends out all queued email, as I can see system fails to execute it.

0 votesVote for this answer Mark as a Correct answer

Faisal Alsugair answered on August 1, 2015 21:14

Hello,

I have restart app and website but still not help. From the system application I can send email test correctly but the error when I try to send from the form in contact us.

Please let me know what can I do for scheduled task exactly because I don't change any setting in scheduled task.

Please advise. Thanks.

0 votesVote for this answer Mark as a Correct answer

Roman Hutnyk answered on August 2, 2015 04:10

I don't have exact answer, as I can't investigate your issue, just suggestions.

Try to run a task manually.

0 votesVote for this answer Mark as a Correct answer

Faisal Alsugair answered on August 2, 2015 15:17

Hello Roman,

You are right the scheduled task not working and when I clcik to refresh the date and time can't change for all tasks!! I have restart application from system and restart website but still not working.

What can I do to fix this issue.. please advise. Thanks.

0 votesVote for this answer Mark as a Correct answer

Faisal Alsugair answered on August 16, 2015 01:03

Can I allow to send email from form in contact us page out of scheduler tasks??

0 votesVote for this answer Mark as a Correct answer

   Please, sign in to be able to submit a new answer.