Unable to move page from one category to another

Manmath Kulkarni asked on March 20, 2017 17:05

Hi,

I am trying to move a page from one category to another category but I am getting different errors as follows.

1. The page of type is not allowed in target location

2. Source node not specified 

3. Message: 
[DataConnection.HandleError]: 
Query: 
Proc_CMS_Document_UpdateDocumentNamePath

I am using Kentico 9 and I have already applied HotFix 9.0.50. On Source server I am able to move a page from one category to another. All settings on source and target servers are same. In addition, I have checked parent and child page allowed types in page types.

Kindly let me know if you any solution.

Thanks in advance,
Manmath.

Recent Answers

Rui Wang answered on March 20, 2017 17:22 (last edited on March 20, 2017 17:23)

Hi Manmath

Are you talking about moving page within the content tree, from one section to another? Because there is no "moving" between categories for page.

Also, are you using Content Staging? If so, you can make all the changes on source, and sync the tree structure including the parent nodes to target.

0 votesVote for this answer Mark as a Correct answer

Trevor Fayas answered on March 20, 2017 17:22

When you say one category to another, do you mean one folder to another?

The error sounds like that the "Allowed Types" is not set up properly (Page Type -> Edit Page type -> Allowed Types -> allowed parent page types

You need to make sure that whatever page type the object you want to move this under is added on that list, otherwise it won't let you move it.

1 votesVote for this answer Mark as a Correct answer

Manmath Kulkarni answered on March 20, 2017 17:27

Hi Guys,

Sorry for confusion. Yes I mean moving from one folder to another. @RuiWang I already have done synchronization. @TrevorFayas I have also checked "Allowed types".

Thanks,
Manmath.

0 votesVote for this answer Mark as a Correct answer

Rui Wang answered on March 20, 2017 17:31

When you sync from higher content tree level, does the new structure gets synced over correctly? And you are saying when you try to move it directly in target side, it throws the error?

With Content Staging setup, making changes in both source and target is not a good practice. You will run into issues down the road.

0 votesVote for this answer Mark as a Correct answer

Juraj Ondrus answered on March 22, 2017 14:36

What is the full detailed error you are getting in #3, please?

0 votesVote for this answer Mark as a Correct answer

Manmath Kulkarni answered on March 31, 2017 09:41

Hi Juraj,

Thanks for your reply. I am still facing this issue. Please find details of exception.

An error occurred when saving data. Please see event log for more details.
Message: 
[DataConnection.HandleError]: 

Query: 
Proc_CMS_Document_UpdateDocumentNamePath

Caused exception: 
Procedure or function Proc_CMS_Document_UpdateDocumentNamePath has too many arguments specified.

Exception type: System.Data.SqlClient.SqlException

Best regards,
Manmath

0 votesVote for this answer Mark as a Correct answer

Juraj Ondrus answered on March 31, 2017 10:37

Thank you!

What is the exact Kentico version including hotfix?
There were some bugs fixed in that stored procedure and respective API. And I have seen this error when the hotfix was not applied correctly - e.g. the stored procedure was not updated in the DB - so the API was passing incorrect parameters or, vice versa.
If you are not running the latest hotfix yet, please apply the hotfix and make sure there are no errors when applying it. This should refresh the code as well as the stored procedure.

0 votesVote for this answer Mark as a Correct answer

Brian Severa answered on June 5, 2017 18:35

Can you tell us which version/hotfix this bug was found in? We are experiencing this same issue running version 9, hotfix 33. I researched the bug fixes on the download page for both version 9 and version 10, but could not find a reference to this specific issue.

0 votesVote for this answer Mark as a Correct answer

Juraj Ondrus answered on June 14, 2017 08:34

Hey,
What I was refering to is that part of the hotfix may have failed - the error you are getting is probably result of incorrect hotfix application. There were changes in the API and the stored procedure parameters due to other bugs. So, in your case either the code files or the stored procedure has still wrong number of parameters.
How are you applying the hotfixes? When you install a fresh Kentico version and compare the stored procedure in the SQL server, is it the same as yours?

0 votesVote for this answer Mark as a Correct answer