Forums (Obsolete)

Member

quickpaw2000-hotmail - 6/2/2010 7:52:07 AM

Error in Site Manager after 5.0 > 5.5 upgrade

Hi all,

I just upgraded to 5.5 last night, and I am running into a few issues with Site Manager. Under the "Site" tab, I get this error:

[DataConnection.ExecuteQuery]: Query: WITH AllData AS (SELECT SiteID, SiteName, SiteDisplayName, SiteStatus, SiteDomainName,
(SELECT COUNT(*) FROM View_Node_Document WHERE (NodeSiteID = CMS_Site.SiteID)) AS Documents
FROM CMS_Site
WHERE 1=1 ) SELECT *, (SELECT COUNT(*) FROM AllData) AS CMS_TOT FROM AllData WHERE CMS_RN BETWEEN 1 AND 25: caused exception: Invalid column name 'CMS_RN'.
Invalid column name 'CMS_RN'.

I get a similar error if I go into the BizForms section in CMS Desk, and a few other sections as well. Any thoughts? Thanks!


Kentico Developer	kentico_helenag - 6/3/2010 8:40:41 AM RE:Error in Site Manager after 5.0 > 5.5 upgrade Hi, it seems you have some customization because there is no AllData table in our default configuration. Is it custom document type table? If so, please check if it contains CMS_RN column. Best regards, Helena Grulichova


Member	philippe.dodier-gmail - 6/17/2010 10:13:38 AM RE:Error in Site Manager after 5.0 > 5.5 upgrade Hi, We too have upgraded from 5.0 to 5.5 and we have the same problem. We haven't done any customization. Thanks

Kentico Support

kentico_jurajo - 6/21/2010 8:12:06 AM

RE:Error in Site Manager after 5.0 > 5.5 upgrade

Hi,

Which version of SQL server do you use? If you are using SQL 2000 - note that this version is no longer supported.

Moreover, were there any other issues or is that error message whole? The query in the error is not complete - this is very strange.

I would like to recommend to rolling back the upgrade and execute it from scratch again.

Best regards,
Juraj Ondrus

Member

Nicola - 6/22/2010 3:21:43 PM

RE:Error in Site Manager after 5.0 > 5.5 upgrade

I also get this error on BizForms after upgrading to 5.5. The site is using SQL 2005. The error shows on the Data tab of the BizForm in CMSDesk.

Server Error in '/' Application.
--------------------------------------------------------------------------------

[DataConnection.ExecuteQuery]: Query: WITH AllData AS (SELECT * FROM PromoterForm WHERE 1=1 ) SELECT *, (SELECT COUNT(*) FROM AllData) AS CMS_TOT FROM AllData WHERE CMS_RN BETWEEN 1 AND 25: caused exception: Invalid column name 'CMS_RN'.
Invalid column name 'CMS_RN'.
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: [DataConnection.ExecuteQuery]: Query: WITH AllData AS (SELECT * FROM PromoterForm WHERE 1=1 ) SELECT *, (SELECT COUNT(*) FROM AllData) AS CMS_TOT FROM AllData WHERE CMS_RN BETWEEN 1 AND 25: caused exception: Invalid column name 'CMS_RN'.
Invalid column name 'CMS_RN'.

Source Error:

Line 155: {
Line 156: GeneralConnection genConn = ConnectionHelper.GetConnection();
Line 157: return genConn.ExecuteQuery(className + ".selectall", null, null, currentOrder, currentTopN, columnNames, currentOffset, currentPageSize, ref totalRecords);
Line 158: }
Line 159:

Source File: h:\Websites\WebProject\CMSModules\Bizforms\Tools\BizForm_Edit_Data.aspx.cs Line: 157


Member	quickpaw2000-hotmail - 6/24/2010 6:19:43 AM RE:Error in Site Manager after 5.0 > 5.5 upgrade I ended up doing a fresh install for Kentico 5.5 (.Net 3.5), and then importing my old 5.0 (.Net 3.5) site into it. That seemed to do the trick. I'm not sure if something I'm not using is broken, but as of now, everything seems to be running fine.

Kentico Support

kentico_jurajo - 6/24/2010 8:20:54 AM

RE:Error in Site Manager after 5.0 > 5.5 upgrade

Hi,

By importing the 5.0 site to 5.5 you might have overwritten the web parts, document types, inline controls back to the 5.0 version. But as you mentioned, everything works fine so far.

Regarding the issue - this query comes from UniGrid, in your case from some custom table "PromoterForm" - are you using any custom SQL queries? If so, in the SELECT statement you need to use macro fro columns - ##COLUMNS##, so the columns which are missing are added automatically, in this case the CMS_RN column.

Best regards,
Juraj Ondrus


Member	Nicola - 6/28/2010 6:58:31 PM RE:Error in Site Manager after 5.0 > 5.5 upgrade We are not using any custom SQL queries that I know of. I've found a reference to the SQL script that is throwing the error in CMS.SettingsProvider.dll - PreparePagedQuery.


Kentico Support	kentico_jurajo - 6/29/2010 11:14:10 AM RE:Error in Site Manager after 5.0 > 5.5 upgrade Hi, Which version of SQL server do you use? Could you please send us whole error message you are getting? Thank you. Best regards, Juraj Ondrus

Member

Nicola - 6/29/2010 2:53:55 PM

RE:Error in Site Manager after 5.0 > 5.5 upgrade

Using SQL 2005. Full error message below.

Server Error in '/' Application.
--------------------------------------------------------------------------------

[DataConnection.ExecuteQuery]: Query: WITH AllData AS (SELECT * FROM PromoterForm WHERE 1=1 ) SELECT *, (SELECT COUNT(*) FROM AllData) AS CMS_TOT FROM AllData WHERE CMS_RN BETWEEN 1 AND 25: caused exception: Invalid column name 'CMS_RN'.
Invalid column name 'CMS_RN'.
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: [DataConnection.ExecuteQuery]: Query: WITH AllData AS (SELECT * FROM PromoterForm WHERE 1=1 ) SELECT *, (SELECT COUNT(*) FROM AllData) AS CMS_TOT FROM AllData WHERE CMS_RN BETWEEN 1 AND 25: caused exception: Invalid column name 'CMS_RN'.
Invalid column name 'CMS_RN'.

Source Error:

Line 155: {
Line 156: GeneralConnection genConn = ConnectionHelper.GetConnection();
Line 157: return genConn.ExecuteQuery(className + ".selectall", null, null, currentOrder, currentTopN, columnNames, currentOffset, currentPageSize, ref totalRecords);
Line 158: }
Line 159:

Source File: h:\Websites\WebProject\CMSModules\Bizforms\Tools\BizForm_Edit_Data.aspx.cs Line: 157

Stack Trace:

[Exception: [DataConnection.ExecuteQuery]: Query: WITH AllData AS (SELECT * FROM PromoterForm WHERE 1=1 ) SELECT *, (SELECT COUNT(*) FROM AllData) AS CMS_TOT FROM AllData WHERE CMS_RN BETWEEN 1 AND 25: caused exception: Invalid column name 'CMS_RN'.
Invalid column name 'CMS_RN'.]
CMS.DataProviderSQL.DataConnection.ExecuteQuery(String queryText, Object[,] queryParams, QueryTypeEnum queryType) +254
CMS.DataEngine.AbstractDataConnection.CMS.IDataConnectionLibrary.IDataConnection.ExecuteQuery(String queryText, Object[,] queryParams, QueryTypeEnum queryType) +13
CMS.DataEngine.GeneralConnection.RunQuery(QueryParameters query) +278
CMS.DataEngine.GeneralConnection.ExecuteQuery(QueryParameters query) +376
CMS.DataEngine.GeneralConnection.ExecuteQuery(String queryName, Object[,] parameters, String where, String orderBy, Int32 topN, String columns, Int32 offset, Int32 maxRecords, Int32& totalRecords) +254
CMSModules_BizForms_Tools_BizForm_Edit_Data.gridData_OnDataReload(String completeWhere, String currentOrder, Int32 currentTopN, Int32 currentOffset, Int32 currentPageSize, Int32& totalRecords) in h:\Websites\WebProject\CMSModules\Bizforms\Tools\BizForm_Edit_Data.aspx.cs:157
CMS.UIControls.UniGrid.RaiseDataReload() +192
CMSAdminControls_UI_UniGrid_UniGrid.ReloadData() in h:\Websites\WebProject\CMSAdminControls\UI\UniGrid\UniGrid.ascx.cs:457
CMSAdminControls_UI_UniGrid_UniGrid.Page_Load(Object sender, EventArgs e) in h:\Websites\WebProject\CMSAdminControls\UI\UniGrid\UniGrid.ascx.cs:191
System.Web.Util.CalliHelper.EventArgFunctionCaller(IntPtr fp, Object o, Object t, EventArgs e) +14
System.Web.Util.CalliEventHandlerDelegateProxy.Callback(Object sender, EventArgs e) +35
System.Web.UI.Control.OnLoad(EventArgs e) +99
CMS.ExtendedControls.AbstractUserControl.OnLoad(EventArgs e) +47
CMS.UIControls.CMSUserControl.OnLoad(EventArgs e) +73
System.Web.UI.Control.LoadRecursive() +50
System.Web.UI.Control.LoadRecursive() +141
System.Web.UI.Control.LoadRecursive() +141
System.Web.UI.Control.LoadRecursive() +141
System.Web.UI.Control.LoadRecursive() +141
System.Web.UI.Control.LoadRecursive() +141
System.Web.UI.Control.LoadRecursive() +141
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +627

--------------------------------------------------------------------------------
Version Information: Microsoft .NET Framework Version:2.0.50727.3603; ASP.NET Version:2.0.50727.3614

Kentico Support

kentico_jurajo - 7/1/2010 2:33:47 AM

RE:Error in Site Manager after 5.0 > 5.5 upgrade

Hi,

Yes, the query is being composed in mentioned method, however PromoterForm is your custom form. Could you please check this form or send us more details about it?

If it is possible - could you please go to CMS Desk -> Tools -> Bizforms -> edit your form -> Fields tab and hit OK to re-generate the schema definition?

Best regards,
Juraj Ondrus


Member	Nicola - 7/1/2010 2:53:47 PM RE:Error in Site Manager after 5.0 > 5.5 upgrade I went to the Fields tab and clicked OK. The Data tab is now showing correctly. Thanks for your help with this. Cheers, Nicola.


Member	webteam-horizonscompanies - 8/6/2010 10:34:26 AM RE:Error in Site Manager after 5.0 > 5.5 upgrade We had the same issue and this fix also worked for us. Thanks.