Cannot move items under others in the tree

Michael Legacy asked on May 14, 2019 19:41

Hi there, I cannot move nodes under others in the tree. I can order nodes by dragging and dropping them in the SAME LEVEL only. I've tried both the drag and drop method, and right-clicking and selecting "move".

Trying to move a page to a new parent, or under another node results in the following Event Log entry:

Message: 
[DataConnection.HandleError]: 

Query: 
Proc_CMS_Document_UpdateDocumentNamePath

Caused exception: 
Procedure Proc_CMS_Document_UpdateDocumentNamePath has no parameters and arguments were supplied.

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.RunQueryWithRetry(QueryParameters query, Int32 retryCount)
at CMS.DataEngine.GeneralConnection.ExecuteQuery(QueryParameters query, Int32& totalRecords)
at CMS.DataEngine.DataQueryBase`1.GetDataFromDBInternal()
at CMS.DataEngine.DataQueryBase`1.GetDataFromDB()
at CMS.DataEngine.DataQueryBase`1.GetData()
at CMS.DataEngine.DataQueryBase`1.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.DocumentEngine.DocumentPathsUpdater.ExecuteUpdateDocumentPath(DocumentPathPrefixes prefixes, Boolean allCultureVersions)
at CMS.DocumentEngine.DocumentPathsUpdater.<>c__DisplayClass42_0.b__0()
at CMS.DocumentEngine.DocumentContinuousIntegrationHelper.HandleBulkUpdate(Boolean allowContinuousIntegrationActions, IWhereCondition bulkWhere, Action bulkUpdate)
at CMS.DocumentEngine.DocumentPathsUpdater.UpdateOtherCultureVersionsAndDescendantsAllPaths()
at CMS.DocumentEngine.DocumentPathsUpdater.UpdateOtherCultureVersionsAndDescendantsPathsForUpdate()
at CMS.DocumentEngine.TreeNode.UpdateInternal()
at CMS.DocumentEngine.TreeNode.Update(Boolean useDocumentHelper)
at CMS.DocumentEngine.DocumentHelper.MoveDocument(MoveDocumentSettings settings)
at CMS.UIControls.ContentActionsControl.MoveNode(TreeNode node, TreeNode targetNode, TreeProvider tree, Boolean preservePermissions)
at CMS.UIControls.ContentActionsControl.ProcessAction(TreeNode node, TreeNode targetNode, String action, Boolean childNodes, Boolean throwExceptions, Boolean copyPermissions)

Message: Procedure Proc_CMS_Document_UpdateDocumentNamePath has no parameters and arguments were supplied.

Exception type: System.Data.SqlClient.SqlException
Stack trace: 
at System.Data.SqlClient.SqlConnection.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, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted)
at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)
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.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)

Correct Answer

Michael Legacy answered on May 14, 2019 20:12

Dmitry, looking further, the Data Migration Assistant only migrated 3 or 4 lines of the Stored Procedure. I had to manually copy over the stored procedure code from a local DB, and execute.

Azure has been kind of a pain, to be honest. This makes me wonder what other procedures may be corrupted.

Thanks for your answer.

0 votesVote for this answer Unmark Correct answer

Recent Answers


Dmitry Bastron answered on May 14, 2019 19:53 (last edited on May 14, 2019 19:54)

Hi Michael,

I've seen this error when had problems with collation on Azure. I remember you've asked this before. Could you check if you need to change the collation of some of the system fields as well?

Or do you have it on local environment either?

0 votesVote for this answer Mark as a Correct answer

Dmitry Bastron answered on May 14, 2019 20:18

This is why I proposed to install a fresh Kentico on Azure and migrate content and admin related stuff (like Page Types, Localizations, etc.) with Content Staging in your previous question ;)

We started just the same way with deploying the local DB to Azure and got so many problems. But after fresh installation + Staging we got nothing related to this. You can try this on your next project.

0 votesVote for this answer Mark as a Correct answer

Michael Legacy answered on May 14, 2019 20:20

Noted!

Thanks for your answers on these posts!

0 votesVote for this answer Mark as a Correct answer

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