Cannot complete this action. The URL 'Pages/Home.aspx' is invalid. It may refer to a nonexistent file or folder, or refer to a valid file or folder that is not in the current Web.

2011-07-12

Question

_{Tuesday, July 12, 2011 4:43 AM}

Hi all,

I have been happily updating a page on my SP site for awhile now and now all of a sudden i am no longer able to check out the file as it produces the following error.

The URL 'Pages/Home.aspx' is invalid. It may refer to a nonexistent file or folder, or refer to a valid file or folder that is not in the current Web.

And now i cannot check it out, i have tried to take a copy of the same page and upload it to a different location but that will not work, also tried to copy from my last snapshot but that also didnt work. I have also tried to roll back to a previopus version but because i cant check it out it wont work either.

I have traced through the logs aand i have found the following extra information. This is being thrown when the page is attempted to be checked out.

SqlError: 'Cannot insert duplicate key row in object 'dbo.AllWebParts' with unique index 'AllWebParts_IdNCI'.' Source: '.Net SqlClient Data Provider' Number: 2601 State: 1 Class: 14 Procedure: 'proc_CloneForWebPart' LineNumber: 32 Server: 'CGKEWSPDB01\SHAREPOINT2010'

Does anyone know what could cause this??

Thanks in advance

Courtney O'Sullivan

All replies (10)

_{Sunday, July 17, 2011 6:06 AM ✅Answered}

Hi,

Please go to windows event viewer to check if there any error about this issue.

And check the hard drive where the database are located if there have free space.

Xue-Mei Chang

_{Wednesday, November 14, 2012 6:49 AM}

Hi,

I have exactly the same issue. Windows event viewer lists no errors about this issue and there is plenty of free space on hard drive with db. I have already spent a lot of time on this but still can't find any solution. So any help is very appreciated!

_{Wednesday, July 10, 2013 8:05 PM}

I have also run into this same issue. Anybody have any update?

_{Thursday, August 22, 2013 4:57 PM}

I'm having the same issue on a SharePoint Server 2010 build version 14.0.6134.5000.

Some days ago I had a low disk space occurrence on SQL Server (~500MB available), but now it's solved and problem persists.

Any idea?

Log details:

RPC method = checkout document

System.Data.SqlClient.SqlException: Cannot insert duplicate key row in object 'dbo.AllWebParts' with unique index 'AllWebParts_IdNCI'. The duplicate key value is (67e315eb-cb04-43fb-b728-c39cb3764132, 1, d4ba234b-8da0-4511-926a-1fe9c84b1411, 0, 255). The statement has been terminated.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlDataReader.ConsumeMetaData()
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)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result)
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.ExecuteReader(CommandBehavior behavior)
at Microsoft.SharePoint.Utilities.SqlSession.ExecuteReader(SqlCommand command, CommandBehavior behavior, SqlQueryData monitoringData, Boolean retryForDeadLock)

at Microsoft.SharePoint.SPSqlClient.ExecuteQueryInternal(Boolean retryfordeadlock) at Microsoft.SharePoint.SPSqlClient.ExecuteQuery(Boolean retryfordeadlock)

SqlError: 'Cannot insert duplicate key row in object 'dbo.AllWebParts' with unique index 'AllWebParts_IdNCI'. The duplicate key value is (67e315eb-cb04-43fb-b728-c39cb3764132, 1, d4ba234b-8da0-4511-926a-1fe9c84b1411, 0, 255).' Source: '.Net SqlClient Data Provider' Number: 2601 State: 1 Class: 14 Procedure: 'proc_CloneForWebPart' LineNumber: 32 Server: 'ServerName'

SqlError: 'The statement has been terminated.' Source: '.Net SqlClient Data Provider' Number: 3621 State: 0 Class: 0 Procedure: 'proc_CloneForWebPart' LineNumber: 32 Server: 'ServerName'

ConnectionString: 'Data Source=SQLServerName;Initial Catalog=WSS_Content_WebAppName;Integrated Security=True;Enlist=False;Asynchronous Processing=False;Connect Timeout=15' ConnectionState: Closed ConnectionTimeout: 15

SqlCommand: 'proc_CheckoutDocument' CommandType: StoredProcedure CommandTimeout: 0 Parameter: '@RETURN_VALUE' Type: Int Size: 0 Direction: ReturnValue Value: '0' Parameter: '@SiteId' Type: UniqueIdentifier Size: 0 Direction: Input Value: '67e315eb-cb04-43fb-b728-c39cb3764132' Parameter: '@WebId' Type: UniqueIdentifier Size: 0 Direction: Input Value: 'b3290c13-a3f6-4f99-b549-86e9a2c27aa4' Parameter: '@DirName' Type: NVarChar Size: 4000 Direction: Input Value: 'Paginas' Parameter: '@LeafName' Type: NVarChar Size: 4000 Direction: Input Value: 'default.aspx' Parameter: '@Level' Type: TinyInt Size: 1 Direction: Input Value: '1' Parameter: '@EnableMinorVersions' Type: Bit Size: 0 Direction: Input Value: 'True' Parameter: '@IsModerated' Type: Bit Size: 0 Direction: Input Value: 'False' Parameter: '@UserId' Type: Int Size: 0 Direction: Input Value: '640' Parameter: '@CheckoutTimeout' Type: Int Size: 0 Direction: Input Value: '' Parameter: '@RefreshLock' Type: Bit Size: 0 Direction: Input Value: 'False' Parameter: '@CheckoutToLocal' Type: Bit Size: 0 Direction: Input Value: 'False' Parameter: '@IsForceCheckout' Type: Bit Size: 0 Direction: Input Value: 'True' Parameter: '@IsSharedLock' Type: Bit Size: 0 Direction: Input Value: 'False' Parameter: '@IsConvertLock' Type: Bit Size: 0 Direction: Input Value: 'False' Parameter: '@DocMetaInfo' Type: VarBinary Size: 8000 Direction: Input Parameter: '@DocMetaInfoSize' Type: Int Size: 0 Direction: Input Value: '1359' Parameter: '@DocMetaInfoVersion' Type: Int Size: 0 Direction: Input Value: '8' Parameter: '@GetLinkInfo' Type: Bit Size: 0 Direction: Input Value: 'True' Parameter: '@RequestGuid' Type: UniqueIdentifier Size: 0 Direction: Input Value: 'fd10c9fe-de0a-4fc1-8684-d425af31edb3'

Leaving Monitored Scope (Request (POST:http://WebAppUrl:80/_vti_bin/_vti_aut/author.dll)). Execution Time=1295,5377

Tks!

Tarcísio Gambin | MCP, MCT, MCTS, MCITP, ITILv3
Você já viu seus logs hoje? | www.tarcisiogambin.net

_{Thursday, August 22, 2013 8:26 PM}

I temporary solved this problem doing the following changes:

The 'problem page' was the default.aspx. The library has check-out enforced and it was practically impossible to checked it out without having error messages or web part errors.
I just made a copy (default_copy.aspx) and try to access the new (and checked-out) default_copy.aspx. Everything is working! The check-in operation was done and also working well.
After renaming the old default.aspx page to default.old.aspx (to preserve version's history, because the copy page just remains the last published version), I created another copy from default.old.aspx and checked-in. After all that's my page's library structure:

[+] Pages

-- [-] default.old.aspx (old page that having problems on checkout, just to preserve version's history);

-- [-] default.aspx (a copy of above page that apparently all right);

-- [-] default_copy.aspx (a copy of above page that apparently all right).

Now I changed the name default_copy.aspx to default.aspx (without doing check-out, SharePoint mysteriously allow me to do it), replacing it.
Now I defined my new default.aspx as the home page (instead the default.old.aspx).
That's it. Everything is working well now!

Helpful links:

http://www.chaitumadala.com/2011/10/sharepoint-2010-server-error-url-is.html

http://sympmarc.com/2012/05/07/sharepoint-designer-error-when-saving-a-page-with-data-view-web-parts/

[]s

Tarcísio Gambin | MCP, MCT, MCTS, MCITP, ITILv3
Você já viu seus logs hoje? | www.tarcisiogambin.net

_{Thursday, August 14, 2014 6:37 PM}

I have this problem and still have not been able to fix it. I found a possible solution in checking the properties.bag in SharePoint 2010 Manager and was able to ensure the __PublishingFeatureActivated is set to "True"

I have tried the making a copy without success. The entire Pages library will not allow pages to be checked back in without receiving the error: Cannot complete this action. The URL 'Pages/index.aspx' is invalid. It may refer to a nonexistent file or folder, or refer to a valid file or folder that is not in the current Web.

Konnie McCauley

_{Monday, August 18, 2014 10:27 AM}

Could you please check you Content Types and fields in SharePoint Library. It may have duplicates. Please let us know.

In my farm I created a content type which got duplicated and ended up in the same error.

I deleted one and tried it worked fine.

Regards Chen V [MCTS SharePoint 2010]

_{Wednesday, April 8, 2015 2:01 PM}

awesome answer, worked thanks Xue-Mei Chang.

_{Wednesday, September 16, 2015 7:18 PM}

I had similar error message and was not able to check out/in files or save.

Looking into Event Viewer error log and found WSS_Content database error with database size limitation.

Check into WSS_Content database auto increase and it's set to increase automatically. But the size stay at 4096MB and can not be updated. Then I realized Sharepoint was installed by previous admin with SQL 2008 Express which has 4GB database limit.

Upgrade to SQL 2008 R2 Express which has 10GB database limit instead of 4GB which fixed the problem.

Event viewer now shows other Sharepoint error like sync web application user profile failed, but sharepoint 2010 is working with check in/out and adding new content.

_{Monday, November 13, 2017 9:51 AM}

For me, I was able to check in the document, even though it was checked out to someone else by going to:

/pages/Forms/AllItems.aspx

Then, click the down arrow by the document, and click check in.

From that interface, I was able to check the document in and discard the check out successfully.

Share via

Cannot complete this action. The URL 'Pages/Home.aspx' is invalid. It may refer to a nonexistent file or folder, or refer to a valid file or folder that is not in the current Web.

Question

All replies (10)

Additional resources