got 404 error when creating/editing a page in sitefinity 4.2

after upgrading to 4.2, we experience an strange behavior.  I create a new page, it shows 404 error for the content page but the page is created in the list.  Double clicking on the page to edit also give me 404 error.  It looks like it can't create page for some reason.  I can't still open old pages that were previously created.

I looked in sql profiler and noticed it called different sqls for my new page.  when I tried to edit an older page, I see these sql in the profiler and it return one row as expected:

declare

@p1 int

set

@p1=60

sp_prepexec @p1 output

N'@p0 nvarchar(4)

,@p1 uniqueidentifier'

N'SELECT a.[id] AS COL1

, a.[approval_workflow_state_] AS COL2

, a.[description_] AS COL3

, a.[redirect_url_] AS COL4

, a.[title_] AS COL5

, a.[url_name_] AS COL6

, a.[allow_multiple_urls] AS COL7

, a.[allow_parameters_validation] AS COL8

, a.[app_name] AS COL9

, a.[can_inherit_permissions] AS COL10

, a.[date_created] AS COL11

, a.[extension] AS COL12

, a.[inherits_permissions] AS COL13

, a.[last_modified] AS COL14

, a.[linked_node_id] AS COL15

, a.[linked_node_provider] AS COL16

, a.[nme] AS COL17

, a.[node_type] AS COL18

, a.[open_new_window] AS COL19

, a.[ordinal] AS COL20

, a.[ownr] AS COL21

, a.[content_id] AS COL22

, a.[parent_id] AS COL23

, a.[render_as_link] AS COL24

, a.[root_id] AS COL25

, a.[show_in_navigation] AS COL26

, a.[voa_version] AS COL27

FROM [sf_page_node] a WHERE a.[app_name] = @p0

AND a.[id] = @p1 '

@p0=N'CDX/'

@p1='3546EF6C-8160-4DC4-A665-405D2470AE60'

@p1

@p1 int

set

@p1=93

sp_prepexec @p1 output

N'@p0 uniqueidentifier'

N'SELECT b.[id] AS COL1

, b.[approval_workflow_state_] AS COL2

, b.[description_] AS COL3

, b.[redirect_url_] AS COL4

, b.[title_] AS COL5

, b.[url_name_] AS COL6

, b.[allow_multiple_urls] AS COL7

, b.[allow_parameters_validation] AS COL8

, b.[app_name] AS COL9

, b.[can_inherit_permissions] AS COL10

, b.[date_created] AS COL11

, b.[extension] AS COL12

, b.[inherits_permissions] AS COL13

, b.[last_modified] AS COL14

, b.[linked_node_id] AS COL15

, b.[linked_node_provider] AS COL16

, b.[nme] AS COL17

, b.[node_type] AS COL18

, b.[open_new_window] AS COL19

, b.[ordinal] AS COL20

, b.[ownr] AS COL21

, b.[content_id] AS COL22

, b.[parent_id] AS COL23

, b.[render_as_link] AS COL24

, b.[root_id] AS COL25

, b.[show_in_navigation] AS COL26

, b.[voa_version] AS COL27

FROM [sf_page_node] a

LEFT JOIN [sf_page_node] AS b ON (a.[id] = b.[parent_id])

WHERE a.[id] = @p0

ORDER BY b.[ordinal] '

@p0='3546EF6C-8160-4DC4-A665-405D2470AE60'

@p1

@p1 int

set

@p1=130

sp_prepexec @p1 output

N'@p0 nvarchar(4),@p1 nvarchar(11),@p2 nvarchar(18),@p3 nvarchar(23)'

N'SELECT a.[id] AS COL1

, a.[app_name] AS COL2

, a.[culture] AS COL3

, a.[disabled] AS COL4

, a.[is_default] AS COL5

, a.[last_modified] AS COL6

, a.[qery] AS COL7

, a.[redirect] AS COL8

, a.[url] AS COL9

, a.[voa_version] AS COL10

FROM [sf_url_data] a

JOIN [sf_page_node] AS b ON (a.[id2] = b.[id]) WHERE a.[app_name] = @p0

AND b.[allow_multiple_urls] <> 0

AND not (a.[disabled] <> 0)

AND (a.[url] IN (@p1,@p2,@p3))

AND a.[voa_class] = 811102197 '

@p0=N'CDX/'

@p1=N'~/testpage2'

@p2=N'~/testpage2/Action'

@p3=N'~/testpage2/Action/Edit'

@p1

@p1 int

set

@p1=85

sp_prepexec @p1 output

N'@p0 nvarchar(4),@p1 uniqueidentifier'

N'SELECT COUNT(1) AS EXPR1

FROM [sf_page_node] a WHERE a.[app_name] = @p0

AND a.[id] = @p1 '

@p0=N'CDX/'

@p1='F669D9A7-009D-4D83-DDAA-000000000002'

@p1

Hello Thao,

I have answered you in the support ticket you have opened.

Best wishes,
Victor Velev
the Telerik team

how your answer help , if i have the same and i cant see the ticket? and i have no idea where to find it?

Hi Ronen,

We have answered you in the ticket you have submitted regarding the issue. However if Thao wishes, he can share with the community what was the actual cause of the problem.

Greetings,
Victor Velev
the Telerik team

i think it is required. no point keeping such data confident.
anyway after 3 days and 23 hours we found out it is somehow related to Max pages allowed
in sitefinity

Hello Ronen,

There was an issue with previous versions of Sitefinity, when there are more then hundred pages under a single page node. This resulted in 404's when creating / editing pages. In order to fix that you had to set the maxPageNodes property to 200 in the webconfig file, inside the SitefinitySiteMap attribute.

All the best,
Victor Velev
the Telerik team

I have a problem similar to this one.
Every time I want to create a child page i get a 404 error but the page appears in the list pages after that. If I push my page to the root I can edit it, if I drag it to another page and try to edit it I get another 404 error.
Do you know the reason. This should be straight and simple.
Thanks in advanced.

Hi Abílio,

Have you tried the proposed solution - by setting the maxPageNodes property in the webconfig?

Greetings,
Victor Velev
the Telerik team

Thanks for sharing with the rest of us Victor!