Kentico 7 to 8 upgrade - System Error

Hi,

Are you getting just this resource string or also entire error message? It looks like something went wrong during the upgrade. Have you tried rolling back and upgrading again?

I would check the connection - especially the connection string in web.config file. You could also add this key into the config file to display more detailed error message:

<add key="CMSDisplayApplicationErrorMessages" value="true" />

Hi,

After putting the below key in web.config I am getting below error.

General.Connection.ErrorMessageThe database version '8.0' does not match the project version '8.2', please check your connection string

Thanks Sumit Sharma

As you can see from the error it looks like you are connecting project files that were ugpraded to 8.2 to a database that is version 8.0. In this case I would recommend to roll back the backups and repeat the upgrade 7.0 -> 8.0

Hi,

I am confused here, I ran the upgrade.exe to upgrade kentico 7 to 8. How is that possible it upgraded to kentico 8.2. Please let me know the from where i can get the correct upgrade exe to ugrade it again.

Thanks Sumit

below is the link from where i downloaded exe under the kentico 8. http://devnet.kentico.com/download/upgrades

Hi Sumit,

that should be the correct location.

if you download the "Kentico 7.0 to 8.0" exe. It should contain the upgrade from 7 to 8.

Make sure to follow the manual and let the upgrade finish in the application start (check event log) before moving to 8.1!

Greets,

David

Hi David,

Thanks for reply! I am done with upgrade.

Here is the description of our project - We have developed eCommerce website on kentico 7 with customization and created custom document type for product with transformation. I was getting lot of errors in transformation because kentico use different API for existing methods/property. I have made the changes
still i am getting below errors. I appreciate if you help me out.

Error 1 - <%#GetImageByUrl("http://xxxx.com/Yale_CDN/" + Eval("Image2") + ".png")%> IS this correct way ?

Error 2 -

Is this correct way?

Error 3 - Event log

Full screen Close Event detail Event ID: 732795 Event type: Error Event time: 12/2/2015 3:37:16 PM Source: Control Event code: LOAD User ID: 108 User name: xxxxxx IP address: ::1 Description: Message:

SELECT * FROM ( SELECT YaleproductdevID, Image, Image2, QuckshipPartNumber, FactoryPartNumber, UPCNumber, Collection, CollectionDescription, Style, Name, Function, Type, Finish, FinishDescription, FunctionDescription, Price, FinishWarranty, MechanicalWarranty, Bullet1, Bullet2, Bullet3, Bullet4, Grade, RoseStyle, EdgeBore, Backset, LatchFront, DoorThickness, StrikeFront, Cylinder, Keyway1, NumberOfKeys, Weight, PackageLength, PackageHeight, PackageWidth, FaceBore, Image3, AllFinishes, BuilderDiscount, EmployeeDiscount, SKUID, SKUNumber, SKUName, SKUDescription, SKUPrice, SKUEnabled, SKUDepartmentID, SKUManufacturerID, SKUInternalStatusID, SKUPublicStatusID, SKUSupplierID, SKUAvailableInDays, SKUGUID, SKUImagePath, SKUWeight, SKUWidth, SKUDepth, SKUHeight, SKUAvailableItems, SKUSellOnlyAvailable, SKUCustomData, SKUOptionCategoryID, SKUOrder, SKULastModified, SKUCreated, SKUSiteID, SKUPrivateDonation, SKUNeedsShipping, SKUMaxDownloads, SKUValidUntil, SKUProductType, SKUMaxItemsInOrder, SKUMaxPrice, SKUValidity, SKUValidFor, SKUMinPrice, SKUMembershipGUID, SKUConversionName, SKUConversionValue, SKUBundleInventoryType, SKUMinItemsInOrder, SKURetailPrice, SKUParentSKUID, SKUAllowAllVariants, SKUInheritsTaxClasses, SKUInheritsDiscounts, SKUTrackInventory, SKUShortDescription, SKUEproductFilesCount, SKUBundleItemsCount, SKUInStoreFrom, SKUReorderAt, SKUBuilderDiscount, SKUEmployeeDiscount, SKUFreeShippingEnabled, SKULocksmithDiscount, NULL AS Handing, NULL AS Thumbturn, NULL AS ElectronicWarranty, NULL AS LockDimension, NULL AS KeypadType, NULL AS BatteriesRequired, NULL AS Latch, NULL AS Strike, NULL AS Interior, NULL AS AlternateAddress, NodeID, NodeAliasPath, NodeName, NodeAlias, NodeClassID, NodeParentID, NodeLevel, NodeACLID, NodeSiteID, NodeGUID, NodeOrder, IsSecuredNode, NodeCacheMinutes, NodeSKUID, NodeDocType, NodeHeadTags, NodeBodyElementAttributes, NodeInheritPageLevels, NodeChildNodesCount, RequiresSSL, NodeLinkedNodeID, NodeOwner, NodeCustomData, NodeGroupID, NodeLinkedNodeSiteID, NodeTemplateID, NodeWireframeTemplateID, NodeWireframeComment, NodeTemplateForAllCultures, NodeInheritPageTemplate, NodeWireframeInheritPageLevels, NodeAllowCacheInFileSystem, DocumentID, DocumentName, DocumentNamePath, DocumentModifiedWhen, DocumentModifiedByUserID, DocumentForeignKeyValue, DocumentCreatedByUserID, DocumentCreatedWhen, DocumentCheckedOutByUserID, DocumentCheckedOutWhen, DocumentCheckedOutVersionHistoryID, DocumentPublishedVersionHistoryID, DocumentWorkflowStepID, DocumentPublishFrom, DocumentPublishTo, DocumentUrlPath, DocumentCulture, DocumentNodeID, DocumentPageTitle, DocumentPageKeyWords, DocumentPageDescription, DocumentShowInSiteMap, DocumentMenuItemHideInNavigation, DocumentMenuCaption, DocumentMenuStyle, DocumentMenuItemImage, DocumentMenuItemLeftImage, DocumentMenuItemRightImage, DocumentPageTemplateID, DocumentMenuJavascript, DocumentMenuRedirectUrl, DocumentUseNamePathForUrlPath, DocumentStylesheetID, DocumentContent, DocumentMenuClass, DocumentMenuStyleOver, DocumentMenuClassOver, DocumentMenuItemImageOver, DocumentMenuItemLeftImageOver, DocumentMenuItemRightImageOver, DocumentMenuStyleHighlighted, DocumentMenuClassHighlighted, DocumentMenuItemImageHighlighted, DocumentMenuItemLeftImageHighlighted, DocumentMenuItemRightImageHighlighted, DocumentMenuItemInactive, DocumentCustomData, DocumentExtensions, DocumentCampaign, DocumentTags, DocumentTagGroupID, DocumentWildcardRule, DocumentWebParts, DocumentRatingValue, DocumentRatings, DocumentPriority, DocumentType, DocumentLastPublished, DocumentUseCustomExtensions, DocumentGroupWebParts, DocumentCheckedOutAutomatically, DocumentTrackConversionName, DocumentConversionValue, DocumentSearchExcluded, DocumentLastVersionName, DocumentLastVersionNumber, DocumentIsArchived, DocumentLastVersionType, DocumentLastVersionMenuRedirectUrl, DocumentHash, DocumentLogVisitActivity, DocumentGUID, DocumentWorkflowCycleGUID, DocumentSitemapSettings, DocumentIsWaitingForTranslation, DocumentSKUName, DocumentSKUDescription, DocumentSKUShortDescription, DocumentWorkflowActionStatus, DocumentMenuRedirectToFirstChild, Published, SiteName, ClassName, ClassDisplayName, ROW_NUMBER() OVER (ORDER BY DocumentName) AS CMS_SRN, 0 AS CMS_SN, 'cms.document.yale.knob' AS CMS_T, NodeXML FROM View_CMS_Tree_Joined_Versions INNER JOIN yale_knob ON View_CMS_Tree_Joined_Versions.DocumentForeignKeyValue = yale_knob.YaleproductdevID WHERE (ClassName = N'yale.knob') AND (NodeSiteID = @NodeSiteID AND ((NodeAliasPath = N'/Products/Accessories/Brass-Lever-Lock-Cylinder-KW1-5,-KD,-03') AND DocumentCulture = @DocumentCulture)) UNION ALL SELECT YaleproductdevID, Image, Image2, QuckshipPartNumber, FactoryPartNumber, UPCNumber, Collection, CollectionDescription, Style, Name, Function, Type, Finish, FinishDescription, FunctionDescription, Price, FinishWarranty, MechanicalWarranty, Bullet1, Bullet2, Bullet3, Bullet4, Grade, RoseStyle, EdgeBore, Backset, LatchFront, DoorThickness, StrikeFront, Cylinder, Keyway1, NumberOfKeys, Weight, PackageLength, PackageHeight, PackageWidth, FaceBore, Image3, AllFinishes, BuilderDiscount, EmployeeDiscount, SKUID, SKUNumber, SKUName, SKUDescription, SKUPrice, SKUEnabled, SKUDepartmentID, SKUManufacturerID, SKUInternalStatusID, SKUPublicStatusID, SKUSupplierID, SKUAvailableInDays, SKUGUID, SKUImagePath, SKUWeight, SKUWidth, SKUDepth, SKUHeight, SKUAvailableItems, SKUSellOnlyAvailable, SKUCustomData, SKUOptionCategoryID, SKUOrder, SKULastModified, SKUCreated, SKUSiteID, SKUPrivateDonation, SKUNeedsShipping, SKUMaxDownloads, SKUValidUntil, SKUProductType, SKUMaxItemsInOrder, SKUMaxPrice, SKUValidity, SKUValidFor, SKUMinPrice, SKUMembershipGUID, SKUConversionName, SKUConversionValue, SKUBundleInventoryType, SKUMinItemsInOrder, SKURetailPrice, SKUParentSKUID, SKUAllowAllVariants, SKUInheritsTaxClasses, SKUInheritsDiscounts, SKUTrackInventory, SKUShortDescription, SKUEproductFilesCount, SKUBundleItemsCount, SKUInStoreFrom, SKUReorderAt, SKUBuilderDiscount, SKUEmployeeDiscount, SKUFreeShippingEnabled, SKULocksmithDiscount, Handing, NULL AS Thumbturn, NULL AS ElectronicWarranty, NULL AS LockDimension, NULL AS KeypadType, NULL AS BatteriesRequired, NULL AS Latch, NULL AS Strike, NULL AS Interior, NULL AS AlternateAddress, NodeID, NodeAliasPath, NodeName, NodeAlias, NodeClassID, NodeParentID, NodeLevel, NodeACLID, NodeSiteID, NodeGUID, NodeOrder, IsSecuredNode, NodeCacheMinutes, NodeSKUID, NodeDocType, NodeHeadTags, NodeBodyElementAttributes, NodeInheritPageLevels, NodeChildNodesCount, RequiresSSL, NodeLinkedNodeID, NodeOwner, NodeCustomData, NodeGroupID, NodeLinkedNodeSiteID, NodeTemplateID, NodeWireframeTemplateID, NodeWireframeComment, NodeTemplateForAllCultures, NodeInheritPageTemplate, NodeWireframeInheritPageLevels, NodeAllowCacheInFileSystem, DocumentID, DocumentName, DocumentNamePath, DocumentModifiedWhen, DocumentModifiedByUserID, DocumentForeignKeyValue, DocumentCreatedByUserID, DocumentCreatedWhen, DocumentCheckedOutByUserID, DocumentCheckedOutWhen, DocumentCheckedOutVersionHistoryID, DocumentPublishedVersionHistoryID, DocumentWorkflowStepID, DocumentPublishFrom, DocumentPublishTo, DocumentUrlPath, DocumentCulture, DocumentNodeID, DocumentPageTitle, DocumentPageKeyWords, DocumentPageDescription, DocumentShowInSiteMap, DocumentMenuItemHideInNavigation, DocumentMenuCaption, DocumentMenuStyle, DocumentMenuItemImage, DocumentMenuItemLeftImage, DocumentMenuItemRightImage, DocumentPageTemplateID, DocumentMenuJavascript, DocumentMenuRedirectUrl, DocumentUseNamePathForUrlPath, DocumentStylesheetID, DocumentContent, DocumentMenuClass, DocumentMenuStyleOver, DocumentMenuClassOver, DocumentMenuItemImageOver, DocumentMenuItemLeftImageOver, DocumentMenuItemRightImageOver, DocumentMenuStyleHighlighted, DocumentMenuClassHighlighted, DocumentMenuItemImageHighlighted, DocumentMenuItemLeftImageHighlighted, DocumentMenuItemRightImageHighlighted, DocumentMenuItemInactive, DocumentCustomData, DocumentExtensions, DocumentCampaign, DocumentTags, DocumentTagGroupID, DocumentWildcardRule, DocumentWebParts, DocumentRatingValue, DocumentRatings, DocumentPriority, DocumentType, DocumentLastPublished, DocumentUseCustomExtensions, DocumentGroupWebParts, DocumentCheckedOutAutomatically, DocumentTrackConversionName, DocumentConversionValue, DocumentSearchExcluded, DocumentLastVersionName, DocumentLastVersionNumber, DocumentIsArchived, DocumentLastVersionType, DocumentLastVersionMenuRedirectUrl, DocumentHash, DocumentLogVisitActivity, DocumentGUID, DocumentWorkflowCycleGUID, DocumentSitemapSettings, DocumentIsWaitingForTranslation, DocumentSKUName, DocumentSKUDescription, DocumentSKUShortDescription, DocumentWorkflowActionStatus, DocumentMenuRedirectToFirstChild, Published, SiteName, ClassName, ClassDisplayName, ROW_NUMBER() OVER (ORDER BY DocumentName) AS CMS_SRN, 1 AS CMS_SN, 'cms.document.yale.lever' AS CMS_T, NodeXML FROM View_CMS_Tree_Joined_Versions INNER JOIN yale_lever ON View_CMS_Tree_Joined_Versions.DocumentForeignKeyValue = yale_lever.YaleproductdevID WHERE (ClassName = N'yale.lever') AND (NodeSiteID = @NodeSiteID AND ((NodeAliasPath = N'/Products/Accessories/Brass-Lever-Lock-Cylinder-KW1-5,-KD,-03') AND DocumentCulture = @DocumentCulture)) UNION ALL SELECT YaleproductdevID, Image, Image2, QuckshipPartNumber, FactoryPartNumber, UPCNumber, Collection, CollectionDescription, Style, Name, Function, Type, Finish, FinishDescription, FunctionDescription, Price, FinishWarranty, MechanicalWarranty, Bullet1, Bullet2, Bullet3, Bullet4, Grade, NULL AS RoseStyle, EdgeBore, Backset, LatchFront, DoorThickness, StrikeFront, Cylinder, Keyway1, NumberOfKeys, Weight, PackageLength, PackageHeight, PackageWidth, FaceBore, Image3, AllFinishes, BuilderDiscount, EmployeeDiscount, SKUID, SKUNumber, SKUName, SKUDescription, SKUPrice, SKUEnabled, SKUDepartmentID, SKUManufacturerID, SKUInternalStatusID, SKUPublicStatusID, SKUSupplierID, SKUAvailableInDays, SKUGUID, SKUImagePath, SKUWeight, SKUWidth, SKUDepth, SKUHeight, SKUAvailableItems, SKUSellOnlyAvailable, SKUCustomData, SKUOptionCategoryID, SKUOrder, SKULastModified, SKUCreated, SKUSiteID, SKUPrivateDonation, SKUNeedsShipping, SKUMaxDownloads, SKUValidUntil, SKUProductType, SKUMaxItemsInOrder, SKUMaxPrice, SKUValidity, SKUValidFor, SKUMinPrice, SKUMembershipGUID, SKUConversionName, SKUConversionValue, SKUBundleInventoryType, SKUMinItemsInOrder, SKURetailPrice, SKUParentSKUID, SKUAllowAllVariants, SKUInheritsTaxClasses, SKUInheritsDiscounts, SKUTrackInventory, SKUShortDescription, SKUEproductFilesCount, SKUBundleItemsCount, SKUInStoreFrom, SKUReorderAt, SKUBuilderDiscount, SKUEmployeeDiscount, SKUFreeShippingEnabled, SKULocksmithDiscount, Handing, Thumbturn, ElectronicWarranty, LockDimension, KeypadType, BatteriesRequired, Latch, Strike, NULL AS Interior, NULL AS AlternateAddress, NodeID, NodeAliasPath, NodeName, NodeAlias, NodeClassID, NodeParentID, NodeLevel, NodeACLID, NodeSiteID, NodeGUID, NodeOrder, IsSecuredNode, NodeCacheMinutes, NodeSKUID, NodeDocType, NodeHeadTags, NodeBodyElementAttributes, NodeInheritPageLevels, NodeChildNodesCount, RequiresSSL, NodeLinkedNodeID, NodeOwner, NodeCustomData, NodeGroupID, NodeLinkedNodeSiteID, NodeTemplateID, NodeWireframeTemplateID, NodeWireframeComment, NodeTemplateForAllCultures, NodeInheritPageTemplate, NodeWireframeInheritPageLevels, NodeAllowCacheInFileSystem, DocumentID, DocumentName, DocumentNamePath, DocumentModifiedWhen, DocumentModifiedByUserID, DocumentForeignKeyValue, DocumentCreatedByUserID, DocumentCreatedWhen, DocumentCheckedOutByUserID, DocumentCheckedOutWhen, DocumentCheckedOutVersionHistoryID, DocumentPublishedVersionHistoryID, DocumentWorkflowStepID, DocumentPublishFrom, DocumentPublishTo, DocumentUrlPath, DocumentCulture, DocumentNodeID, DocumentPageTitle, DocumentPageKeyWords, DocumentPageDescription, DocumentShowInSiteMap, DocumentMenuItemHideInNavigation, DocumentMenuCaption, DocumentMenuStyle, DocumentMenuItemImage, DocumentMenuItemLeftImage, DocumentMenuItemRightImage, DocumentPageTemplateID, DocumentMenuJavascript, DocumentMenuRedirectUrl, DocumentUseNamePathForUrlPath, DocumentStylesheetID, DocumentContent, DocumentMenuClass, DocumentMenuStyleOver, DocumentMenuClassOver, DocumentMenuItemImageOver, DocumentMenuItemLeftImageOver, DocumentMenuItemRightImageOver, DocumentMenuStyleHighlighted, DocumentMenuClassHighlighted, DocumentMenuItemImageHighlighted, DocumentMenuItemLeftImageHighlighted, DocumentMenuItemRightImageHighlighted, DocumentMenuItemInactive, DocumentCustomData, DocumentExtensions, DocumentCampaign, DocumentTags, DocumentTagGroupID, DocumentWildcardRule, DocumentWebParts, DocumentRatingValue, DocumentRatings, DocumentPriority, DocumentType, DocumentLastPublished, DocumentUseCustomExtensions, DocumentGroupWebParts, DocumentCheckedOutAutomatically, DocumentTrackConversionName, DocumentConversionValue, DocumentSearchExcluded, DocumentLastVersionName, DocumentLastVersionNumber, DocumentIsArchived, DocumentLastVersionType, DocumentLastVersionMenuRedirectUrl, DocumentHash, DocumentLogVisitActivity, DocumentGUID, DocumentWorkflowCycleGUID, DocumentSitemapSettings, DocumentIsWaitingForTranslation, DocumentSKUName, DocumentSKUDescription, DocumentSKUShortDescription, DocumentWorkflowActionStatus, DocumentMenuRedirectToFirstChild, Published, SiteName, ClassName, ClassDisplayName, ROW_NUMBER() OVER (ORDER BY DocumentName) AS CMS_SRN, 2 AS CMS_SN, 'cms.document.yale.keyless' AS CMS_T, NodeXML FROM View_CMS_Tree_Joined_Versions INNER JOIN yale_keyless ON View_CMS_Tree_Joined_Versions.DocumentForeignKeyValue = yale_keyless.YaleproductdevID WHERE (ClassName = N'yale.keyless') AND (NodeSiteID = @NodeSiteID AND ((NodeAliasPath = N'/Products/Accessories/Brass-Lever-Lock-Cylinder-KW1-5,-KD,-03') AND DocumentCulture = @DocumentCulture)) UNION ALL SELECT YaleproductdevID, Image, Image2, QuckshipPartNumber, FactoryPartNumber, UPCNumber, Collection, CollectionDescription, Style, Name, Function, Type, Finish, FinishDescription, FunctionDescription, Price, FinishWarranty, MechanicalWarranty, Bullet1, Bullet2, Bullet3, Bullet4, Grade, NULL AS RoseStyle, EdgeBore, Backset, LatchFront, DoorThickness, StrikeFront, Cylinder, Keyway1, NumberOfKeys, Weight, PackageLength, PackageHeight, PackageWidth, FaceBore, Image3, AllFinishes, BuilderDiscount, EmployeeDiscount, SKUID, SKUNumber, SKUName, SKUDescription, SKUPrice, SKUEnabled, SKUDepartmentID, SKUManufacturerID, SKUInternalStatusID, SKUPublicStatusID, SKUSupplierID, SKUAvailableInDays, SKUGUID, SKUImagePath, SKUWeight, SKUWidth, SKUDepth, SKUHeight, SKUAvailableItems, SKUSellOnlyAvailable, SKUCustomData, SKUOptionCategoryID, SKUOrder, SKULastModified, SKUCreated, SKUSiteID, SKUPrivateDonation, SKUNeedsShipping, SKUMaxDownloads, SKUValidUntil, SKUProductType, SKUMaxItemsInOrder, SKUMaxPrice, SKUValidity, SKUValidFor, SKUMinPrice, SKUMembershipGUID, SKUConversionName, SKUConversionValue, SKUBundleInventoryType, SKUMinItemsInOrder, SKURetailPrice, SKUParentSKUID, SKUAllowAllVariants, SKUInheritsTaxClasses, SKUInheritsDiscounts, SKUTrackInventory, SKUShortDescription, SKUEproductFilesCount, SKUBundleItemsCount, SKUInStoreFrom, SKUReorderAt, SKUBuilderDiscount, SKUEmployeeDiscount, SKUFreeShippingEnabled, SKULocksmithDiscount, NULL AS Handing, NULL AS Thumbturn, NULL AS ElectronicWarranty, LockDimension, NULL AS KeypadType, NULL AS BatteriesRequired, NULL AS Latch, NULL AS Strike, Interior, AlternateAddress, NodeID, NodeAliasPath, NodeName, NodeAlias, NodeClassID, NodeParentID, NodeLevel, NodeACLID, NodeSiteID, NodeGUID, NodeOrder, IsSecuredNode, NodeCacheMinutes, NodeSKUID, NodeDocType, NodeHeadTags, NodeBodyElementAttributes, NodeInheritPageLevels, NodeChildNodesCount, RequiresSSL, NodeLinkedNodeID, NodeOwner, NodeCustomData, NodeGroupID, NodeLinkedNodeSiteID, NodeTemplateID, NodeWireframeTemplateID, NodeWireframeComment, NodeTemplateForAllCultures, NodeInheritPageTemplate, NodeWireframeInheritPageLevels, NodeAllowCacheInFileSystem, DocumentID, DocumentName, DocumentNamePath, DocumentModifiedWhen, DocumentModifiedByUserID, DocumentForeignKeyValue, DocumentCreatedByUserID, DocumentCreatedWhen, DocumentCheckedOutByUserID, DocumentCheckedOutWhen, DocumentCheckedOutVersionHistoryID, DocumentPublishedVersionHistoryID, DocumentWorkflowStepID, DocumentPublishFrom, DocumentPublishTo, DocumentUrlPath, DocumentCulture, DocumentNodeID, DocumentPageTitle, DocumentPageKeyWords, DocumentPageDescription, DocumentShowInSiteMap, DocumentMenuItemHideInNavigation, DocumentMenuCaption, DocumentMenuStyle, DocumentMenuItemImage, DocumentMenuItemLeftImage, DocumentMenuItemRightImage, DocumentPageTemplateID, DocumentMenuJavascript, DocumentMenuRedirectUrl, DocumentUseNamePathForUrlPath, DocumentStylesheetID, DocumentContent, DocumentMenuClass, DocumentMenuStyleOver, DocumentMenuClassOver, DocumentMenuItemImageOver, DocumentMenuItemLeftImageOver, DocumentMenuItemRightImageOver, DocumentMenuStyleHighlighted, DocumentMenuClassHighlighted, DocumentMenuItemImageHighlighted, DocumentMenuItemLeftImageHighlighted, DocumentMenuItemRightImageHighlighted, DocumentMenuItemInactive, DocumentCustomData, DocumentExtensions, DocumentCampaign, DocumentTags, DocumentTagGroupID, DocumentWildcardRule, DocumentWebParts, DocumentRatingValue, DocumentRatings, DocumentPriority, DocumentType, DocumentLastPublished, DocumentUseCustomExtensions, DocumentGroupWebParts, DocumentCheckedOutAutomatically, DocumentTrackConversionName, DocumentConversionValue, DocumentSearchExcluded, DocumentLastVersionName, DocumentLastVersionNumber, DocumentIsArchived, DocumentLastVersionType, DocumentLastVersionMenuRedirectUrl, DocumentHash, DocumentLogVisitActivity, DocumentGUID, DocumentWorkflowCycleGUID, DocumentSitemapSettings, DocumentIsWaitingForTranslation, DocumentSKUName, DocumentSKUDescription, DocumentSKUShortDescription, DocumentWorkflowActionStatus, DocumentMenuRedirectToFirstChild, Published, SiteName, ClassName, ClassDisplayName, ROW_NUMBER() OVER (ORDER BY DocumentName) AS CMS_SRN, 3 AS CMS_SN, 'cms.document.yale.handleset' AS CMS_T, NodeXML FROM View_CMS_Tree_Joined_Versions INNER JOIN yale_handleset ON View_CMS_Tree_Joined_Versions.DocumentForeignKeyValue = yale_handleset.YaleproductdevID WHERE (ClassName = N'yale.handleset') AND (NodeSiteID = @NodeSiteID AND ((NodeAliasPath = N'/Products/Accessories/Brass-Lever-Lock-Cylinder-KW1-5,-KD,-03') AND DocumentCulture = @DocumentCulture)) ) AS SubData ORDER BY CMS_SRN, CMS_SN

Caused exception: Incorrect syntax near the keyword 'Function'. Incorrect syntax near the keyword 'Function'. Incorrect syntax near the keyword 'Function'. Incorrect syntax near the keyword 'Function'.

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.GeneralConnection.RunQuery(QueryParameters query) at CMS.DataEngine.GeneralConnection.ExecuteQueryInternal(QueryParameters query) at CMS.DataEngine.DataQueryBase1.GetDataFromDB() at CMS.DataEngine.DataQueryBase1.GetData() at CMS.DataEngine.DataQueryBase1.get_Result() at CMS.DocumentEngine.DocumentQueryProperties.FilterResultsByPermissions(IDataQuery query, Int32& totalRecords) at CMS.DocumentEngine.DocumentQueryProperties.GetResults(IDataQuery query, Boolean coupledData, Int32& totalRecords) at CMS.DataEngine.MultiQueryBase2.GetDataFromDB() at CMS.DataEngine.DataQueryBase1.GetData() at CMS.DataEngine.DataQueryBase1.get_Result() at CMS.Controls.CMSAbstractDataProperties.GetDataSet(String path, String where, Boolean forceReload, Int32 offset, Int32 maxRecords, Int32& totalRecords) at CMS.Controls.CMSAbstractDataProperties.LoadData(Object& dataSource, Boolean forceReload, Int32 offset, Int32 maxRecords, Int32& totalRecords) at CMS.Controls.CMSDocumentsDataSource.GetDataSource(Int32 offset, Int32 maxRecords) at CMS.Controls.CMSBaseDataSource.get_DataSource() at CMS.Controls.CMSRepeater.ReloadDataInternal(Boolean forceReload) at CMS.ExtendedControls.ControlsExtensions.CallHandled(Control ctrl, Action func)

Message: Incorrect syntax near the keyword 'Function'. Incorrect syntax near the keyword 'Function'. Incorrect syntax near the keyword 'Function'. Incorrect syntax near the keyword 'Function'.

Exception type: System.Data.SqlClient.SqlException Stack Trace: at System.Data.SqlClient.SqlConnection.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, TaskCompletionSource1 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) Machine name: SUMIT4519 Event URL: /cms/getdoc/118173b1-f951-4d8b-b10e-a2061df1243d/Brass-Lever-Lock-Cylinder-KW1-5,-KD,-03.aspx?viewmode=6&showpanel=1&lang=en-us&langobjectlifetime=request URL referrer: https://localhost/CMSModules/AdminControls/Pages/UIPage.aspx?elementguid=eeba18a6-c6d0-4c58-a5fa-91e629540986&mode=edit&displaytitle=false&nodeid=6489&culture=en-US User agent: Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/46.0.2490.86 Safari/537.36 Export event details Report bug Back

Hi,
I would recommend to restore the backups and perform the manual upgrade - just like the upgrade deployment steps to be sure everything is applied correctly.