Forums (Obsolete)

Member

sc0ttkclark - 11/17/2008 3:41:18 PM

Upgrade from 3.0 => 3.1 => 3.1a THEN from Server 2000 => Server 2008

We just upgraded a Kentico site from 3.0 to 3.1 to 3.1a, and then migrated it from Windows Server 2000 to 2008.

We performed the upgrade as documented in the upgrade guide.

Here is the error we keep getting when pulling up the site (replaced the actual directories with ROOT_SITE for privacy purposes):

Server Error in '/' Application.
[QueryProvider.GetQuery]: Query newsletter.emails.clearsendingstatus not found!
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Exception: [QueryProvider.GetQuery]: Query newsletter.emails.clearsendingstatus not found!

Source Error:

Line 154: // Re-initialize tasks which were stopped by application end
Line 155: SchedulingExecutor.ReInitCorruptedTasks();
Line 156: EmailQueueManager.ClearEmailsSendingStatus();
Line 157: }
Line 158:

Source File: ROOT_SITE\App_Code\Global.asax.cs Line: 156

Stack Trace:

[Exception: [QueryProvider.GetQuery]: Query newsletter.emails.clearsendingstatus not found!]
CMS.SettingsProvider.QueryProvider.GetQuery(String queryName, Boolean throwException) +184
CMS.SettingsProvider.QueryProvider.GetQuery(String queryName) +10
CMS.DataEngine.GeneralConnection.RunQuery(String queryName, Object[,] parameters, String where, String orderBy, Int32 topN) +19
CMS.DataEngine.GeneralConnection.RunQuery(String queryName, Object[,] parameters) +14
CMS.DataEngine.GeneralConnection.ExecuteQuery(String queryName, Object[,] parameters) +8
CMS.Newsletter.EmailQueueManager.ClearEmailsSendingStatus() +19
Global.FirstRequestInitialization(Object sender, EventArgs e) in ROOT_SITE\App_Code\Global.asax.cs:156
Global.Application_BeginRequest(Object sender, EventArgs e) in ROOT_SITE\App_Code\Global.asax.cs:348
System.Web.SyncEventExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() +92
System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) +64

Version Information: Microsoft .NET Framework Version:2.0.50727.1434; ASP.NET Version:2.0.50727.1434


Kentico Developer	kentico_helenag - 11/18/2008 9:52:23 AM RE:Upgrade from 3.0 => 3.1 => 3.1a THEN from Server 2000 => Server 2008 Hi, could you please try this query in your Kentico CMS database? SELECT * FROM CMS_Query WHERE QueryName like '%clearsendingstatus%' Does it find a result or not? Thank you. Best regards, Helena Grulichova

Member

sc0ttkclark - 12/11/2008 12:48:23 PM

RE:Upgrade from 3.0 => 3.1 => 3.1a THEN from Server 2000 => Server 2008

It seems we either got past that issue or created a new one!

Server Error in '/' Application.

Exception of type 'System.OutOfMemoryException' was thrown.

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.OutOfMemoryException: Exception of type 'System.OutOfMemoryException' was thrown.

Source Error:

Line 153:
Line 154: // Re-initialize tasks which were stopped by application end
Line 155: SchedulingExecutor.ReInitCorruptedTasks();
Line 156: EmailQueueManager.ClearEmailsSendingStatus();
Line 157: }

Source File: e:\wwwroot\serviceexperts.com\App_Code\Global.asax.cs Line: 155

Stack Trace:

[OutOfMemoryException: Exception of type 'System.OutOfMemoryException' was thrown.]
System.Data.SqlClient.TdsParserStateObject.ReadString(Int32 length) +56
System.Data.SqlClient.TdsParser.ReadSqlStringValue(SqlBuffer value, Byte type, Int32 length, Encoding encoding, Boolean isPlp, TdsParserStateObject stateObj) +170
System.Data.SqlClient.TdsParser.ReadSqlValue(SqlBuffer value, SqlMetaDataPriv md, Int32 length, TdsParserStateObject stateObj) +174
System.Data.SqlClient.SqlDataReader.ReadColumnData() +88
System.Data.SqlClient.SqlDataReader.ReadColumn(Int32 i, Boolean setTimeout) +223
System.Data.SqlClient.SqlDataReader.GetValueInternal(Int32 i) +17
System.Data.SqlClient.SqlDataReader.GetValues(Object[] values) +181
System.Data.ProviderBase.CommonLanguageSubsetDataReader.GetValues(Object[] values) +10
System.Data.ProviderBase.SchemaMapping.LoadDataRow() +30
System.Data.Common.DataAdapter.FillLoadDataRow(SchemaMapping mapping) +137
System.Data.Common.DataAdapter.FillFromReader(DataSet dataset, DataTable datatable, String srcTable, DataReaderContainer dataReader, Int32 startRecord, Int32 maxRecords, DataColumn parentChapterColumn, Object parentChapterValue) +153
System.Data.Common.DataAdapter.Fill(DataSet dataSet, String srcTable, IDataReader dataReader, Int32 startRecord, Int32 maxRecords) +170
System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +175
System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +137
System.Data.Common.DbDataAdapter.Fill(DataSet dataSet) +86
CMS.DataProviderSQL.DataConnection.ExecuteQuery(String queryText, Object[,] queryParams, QueryTypeEnum queryType) +702
CMS.DataProviderSQL.DataConnection.CMS.IDataConnectionLibrary.IDataConnection.ExecuteQuery(String queryText, Object[,] queryParams, QueryTypeEnum queryType) +12
CMS.SettingsProvider.SqlHelperClass.ExecuteQuery(String queryText, Object[,] queryParams, QueryTypeEnum queryType, IDataConnection conn) +68
CMS.SettingsProvider.QueryProvider.LoadQueries() +117
CMS.SettingsProvider.QueryProvider.GetQuery(String queryName, Boolean throwException) +12
CMS.SettingsProvider.QueryProvider.GetQuery(String queryName) +10
CMS.DataEngine.GeneralConnection.RunQuery(String queryName, Object[,] parameters, String where, String orderBy, Int32 topN) +19
CMS.DataEngine.GeneralConnection.RunQuery(String queryName, Object[,] parameters, String where, String orderBy) +18
CMS.DataEngine.GeneralConnection.ExecuteQuery(String queryName, Object[,] parameters, String where) +18
CMS.Scheduler.SchedulingExecutor.ReInitCorruptedTasks() +45
Global.FirstRequestInitialization(Object sender, EventArgs e) in e:\wwwroot\serviceexperts.com\App_Code\Global.asax.cs:155
Global.Application_BeginRequest(Object sender, EventArgs e) in e:\wwwroot\serviceexperts.com\App_Code\Global.asax.cs:348
System.Web.SyncEventExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() +92
System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) +64

Version Information: Microsoft .NET Framework Version:2.0.50727.1434; ASP.NET Version:2.0.50727.1434

Kentico Support

kentico_jurajo - 12/15/2008 2:54:28 AM

RE:Upgrade from 3.0 => 3.1 => 3.1a THEN from Server 2000 => Server 2008

Hi,

Could you please check the windows event log and also check what is consuming the memory so it throws exception?
Could you please also check the IIS settings and also application pool settings?
When is this exception thrown? I mean, what is leading to this issue?

Thank you in advance.

Best Regards,
Juraj Ondrus