Se connecter
 
AccueilLibrairieFormationTéléchargementsSupport techniqueCommunautésForums
Pour les professionnels de l’informatique >
> 
> 
Cannot delete items from any SharePoint 2010 Enterprise lists within a site collection.

Question Cannot delete items from any SharePoint 2010 Enterprise lists within a site collection.

  • jeudi 10 mai 2012 17:48
     
     
    Connectez-vous pour voter
    0

    I recently moved a SharePoint 2010 content database from one SharePoint Farm to another.  The content database contained a single site collection.  The site collection does not contain any third-party apps or web parts nor was there any specialized customization donw to the site.  It is basically SharePoint right "out of the box."  The moved SharePoint site on the new SharePoint server/farm seems to work correctly without any errors with one exception.  That exception is that I can not delete an item from a list.  If I try to delete an item or items from a list I get one of two errors that read either:

    The server has encountered the following error(s): Exception from HRESULT: 0x80131904

    or

    ERROR   Exception from HRESULT: 0x80131904  Troubleshoot issues with Microsoft SharePoint Foundation  Correlation ID: <GUID>  Date and Time: (<Current data and time>) and a link to "Go back to site."

    I can create a new list and add items to it, but I get the same error when I try to delete an item from the new list.  I can delete items from document libraries without problem.  I can delete the lists, just not individual items from the lists.

    Can someone offer suggestions as to how to allow me to delete items from a list again?

     

Toutes les réponses

  • jeudi 10 mai 2012 18:02
     
     
    Connectez-vous pour voter
    0
    Can you provide the errors for the GUID from the Logs? That will help us to determine what the issue could be.

    Ameet Phadnis (Alexander Open Systems)

     
  • jeudi 10 mai 2012 18:08
     
     
    Connectez-vous pour voter
    0
    Did you give yourself permission to the copied site collection by adding yourself as site collection admin or through the web app policy?

    de Nada

     
  • jeudi 10 mai 2012 20:00
     
     
    Connectez-vous pour voter
    0

    Good idea.  I see the event logged associated with hte error I'm getting, but I'm nor sure what it means.  It looks like some sort of SQL exception error.  I'll past it here below.  Any thoughts on how to fix?

    05/10/2012 14:47:19.37  w3wp.exe (0x1190)                        0x0CDC SharePoint Foundation          Database                       880i High     System.Data.SqlClient.SqlException: Operand type clash: int is incompatible with uniqueidentifier     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(CommandBe... e3f73d0a-2a62-4d0e-80a1-51bf60ae4094
    05/10/2012 14:47:19.37* w3wp.exe (0x1190)                        0x0CDC SharePoint Foundation          Database                       880i High     ...havior 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) e3f73d0a-2a62-4d0e-80a1-51bf60ae4094
    05/10/2012 14:47:19.37  w3wp.exe (0x1190)                        0x0CDC SharePoint Foundation          Database                       880k High        at Microsoft.SharePoint.SPSqlClient.ExecuteQueryInternal(Boolean retryfordeadlock)     at Microsoft.SharePoint.SPSqlClient.ExecuteQuery(Boolean retryfordeadlock)     at Microsoft.SharePoint.Library.SPRequestInternalClass.DeleteItem(String bstrUrl, String bstrListName, Int32 lID, UInt32 dwDeleteOp, Guid& pgDeleteTransactionId)     at Microsoft.SharePoint.Library.SPRequest.DeleteItem(String bstrUrl, String bstrListName, Int32 lID, UInt32 dwDeleteOp, Guid& pgDeleteTransactionId)     at Microsoft.SharePoint.SPListItem.DeleteCore(DeleteOp deleteOp)     at Microsoft.SharePoint.SPListItem.Recycle()     at Microsoft.SharePoint.WebControls.DeleteItemButton.DeleteItem()     at Microsoft.SharePoint.WebControls.SPLinkButton.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument... e3f73d0a-2a62-4d0e-80a1-51bf60ae4094
    05/10/2012 14:47:19.37* w3wp.exe (0x1190)                        0x0CDC SharePoint Foundation          Database                       880k High     ...)     at System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument)     at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)     at System.Web.UI.Page.ProcessRequest(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)     at System.Web.UI.Page.ProcessRequest()     at System.Web.UI.Page.ProcessRequest(HttpContext context)     at ASP.FORM_ASPX__331913002.ProcessRequest(HttpContext context)     at System.Web.HttpApplication.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()     at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)     at System.Web.HttpApplication.PipelineStepManager.ResumeSteps(Exce... e3f73d0a-2a62-4d0e-80a1-51bf60ae4094
    05/10/2012 14:47:19.37* w3wp.exe (0x1190)                        0x0CDC SharePoint Foundation          Database                       880k High     ...ption error)     at System.Web.HttpApplication.BeginProcessRequestNotification(HttpContext context, AsyncCallback cb)     at System.Web.HttpRuntime.ProcessRequestNotificationPrivate(IIS7WorkerRequest wr, HttpContext context)     at System.Web.Hosting.PipelineRuntime.ProcessRequestNotificationHelper(IntPtr managedHttpContext, IntPtr nativeRequestContext, IntPtr moduleData, Int32 flags)     at System.Web.Hosting.PipelineRuntime.ProcessRequestNotification(IntPtr managedHttpContext, IntPtr nativeRequestContext, IntPtr moduleData, Int32 flags)     at System.Web.Hosting.PipelineRuntime.ProcessRequestNotificationHelper(IntPtr managedHttpContext, IntPtr nativeRequestContext, IntPtr moduleData, Int32 flags)     at System.Web.Hosting.PipelineRuntime.ProcessRequestNotification(IntPtr managedHttpConte... e3f73d0a-2a62-4d0e-80a1-51bf60ae4094
    05/10/2012 14:47:19.37* w3wp.exe (0x1190)                        0x0CDC SharePoint Foundation          Database                       880k High     ...xt, IntPtr nativeRequestContext, IntPtr moduleData, Int32 flags)   e3f73d0a-2a62-4d0e-80a1-51bf60ae4094
    05/10/2012 14:47:19.37  w3wp.exe (0x1190)                        0x0CDC SharePoint Foundation          Database                       880j High     SqlError: 'Operand type clash: int is incompatible with uniqueidentifier'    Source: '.Net SqlClient Data Provider' Number: 206 State: 2 Class: 16 Procedure: 'proc_DropListRecord' LineNumber: 43 Server: 'SQL2' e3f73d0a-2a62-4d0e-80a1-51bf60ae4094
    05/10/2012 14:47:19.37  w3wp.exe (0x1190)                        0x0CDC SharePoint Foundation          Database                       5586 Critical Unknown SQL Exception 206 occurred. Additional error information from SQL Server is included below.  Operand type clash: int is incompatible with uniqueidentifier e3f73d0a-2a62-4d0e-80a1-51bf60ae4094
    05/10/2012 14:47:19.37  w3wp.exe (0x1190)                        0x0CDC SharePoint Foundation          Database                       tzku High     ConnectionString: 'Data Source=SQL2;Initial Catalog=InsightST4_Content;Integrated Security=True;Enlist=False;Asynchronous Processing=False;Connect Timeout=15'    ConnectionState: Closed ConnectionTimeout: 15 e3f73d0a-2a62-4d0e-80a1-51bf60ae4094
    05/10/2012 14:47:19.37  w3wp.exe (0x1190)                        0x0CDC SharePoint Foundation          Database                       tzkv High     SqlCommand: 'DECLARE @@iRet int;SET @@iRet = 0;BEGIN TRAN EXEC @@iRet = proc_DropListRecord @wssp0, @wssp1, @wssp2, @wssp3, @wssp4, @wssp5, @wssp6, @wssp7, @wssp8, @wssp9, @wssp10, @wssp11, @wssp12, @wssp13, @wssp14, @wssp15, @wssp16 OUTPUT;;IF @@iRet = 0 BEGIN  EXEC @@iRet = proc_EnsureTranLockNotRequired @wssp17, @wssp18, @wssp19; END;IF @@iRet = 0 COMMIT ELSE ROLLBACK;SET @wssp20= @@iRet;'     CommandType: Text CommandTimeout: 0     Parameter: '@wssp0' Type: UniqueIdentifier Size: 0 Direction: Input Value: '0bc7995f-0c4c-465c-b9b0-09d452aa6150'     Parameter: '@wssp1' Type: UniqueIdentifier Size: 0 Direction: Input Value: '1234af13-b15b-4ed3-91e9-17537b5dc367'     Parameter: '@wssp2' Type: UniqueIdentifier Size: 0 Direction: Input Value: '38eb3526-5c49-4c03-bd22-4bf1cb302757'     Parame... e3f73d0a-2a62-4d0e-80a1-51bf60ae4094
    05/10/2012 14:47:19.37* w3wp.exe (0x1190)                        0x0CDC SharePoint Foundation          Database                       tzkv High     ...ter: '@wssp3' Type: Int Size: 0 Direction: Input Value: '100'     Parameter: '@wssp4' Type: Int Size: 0 Direction: Input Value: '841'     Parameter: '@wssp5' Type: Bit Size: 0 Direction: Input Value: 'True'     Parameter: '@wssp6' Type: Bit Size: 0 Direction: Input Value: 'True'     Parameter: '@wssp7' Type: NVarChar Size: 4000 Direction: Input Value: 'System Account'     Parameter: '@wssp8' Type: Int Size: 0 Direction: Input Value: ''     Parameter: '@wssp9' Type: Int Size: 0 Direction: Input Value: '1073741823'     Parameter: '@wssp10' Type: Bit Size: 0 Direction: Input Value: 'False'     Parameter: '@wssp11' Type: Int Size: 0 Direction: Input Value: '0'     Parameter: '@wssp12' Type: Int Size: 0 Direction: Input Value: '4'     Parameter: '@wssp13' Type: VarBinary Size: 8000 Direction: I... e3f73d0a-2a62-4d0e-80a1-51bf60ae4094
    05/10/2012 14:47:19.37* w3wp.exe (0x1190)                        0x0CDC SharePoint Foundation          Database                       tzkv High     ...nput     Parameter: '@wssp14' Type: VarBinary Size: 8000 Direction: Input     Parameter: '@wssp15' Type: Int Size: 0 Direction: Input Value: '0'     Parameter: '@wssp16' Type: VarBinary Size: 16 Direction: Output     Parameter: '@wssp17' Type: UniqueIdentifier Size: 0 Direction: Input Value: '0bc7995f-0c4c-465c-b9b0-09d452aa6150'     Parameter: '@wssp18' Type: UniqueIdentifier Size: 0 Direction: Input Value: '38eb3526-5c49-4c03-bd22-4bf1cb302757'     Parameter: '@wssp19' Type: Bit Size: 0 Direction: Input Value: 'False'     Parameter: '@wssp20' Type: Int Size: 0 Direction: Output Value: '0' e3f73d0a-2a62-4d0e-80a1-51bf60ae4094
    05/10/2012 14:47:19.38  w3wp.exe (0x1190)                        0x0CDC SharePoint Foundation          Database                       d0d6 High     System.Data.SqlClient.SqlException: Operand type clash: int is incompatible with uniqueidentifier     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(CommandBe... e3f73d0a-2a62-4d0e-80a1-51bf60ae4094
    05/10/2012 14:47:19.38* w3wp.exe (0x1190)                        0x0CDC SharePoint Foundation          Database                       d0d6 High     ...havior 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(... e3f73d0a-2a62-4d0e-80a1-51bf60ae4094
    05/10/2012 14:47:19.38* w3wp.exe (0x1190)                        0x0CDC SharePoint Foundation          Database                       d0d6 High     ...Boolean retryfordeadlock)     at Microsoft.SharePoint.SPSqlClient.ExecuteQuery(Boolean retryfordeadlock) e3f73d0a-2a62-4d0e-80a1-51bf60ae4094
    05/10/2012 14:47:19.38  w3wp.exe (0x1190)                        0x0CDC SharePoint Foundation          General                        8e2s Medium   Unknown SPRequest error occurred. More information: 0x80131904 e3f73d0a-2a62-4d0e-80a1-51bf60ae4094
    05/10/2012 14:47:19.38  w3wp.exe (0x1190)                        0x0CDC SharePoint Foundation          Runtime                        tkau Unexpected System.Runtime.InteropServices.COMException: Exception from HRESULT: 0x80131904    at Microsoft.SharePoint.Library.SPRequestInternalClass.DeleteItem(String bstrUrl, String bstrListName, Int32 lID, UInt32 dwDeleteOp, Guid& pgDeleteTransactionId)     at Microsoft.SharePoint.Library.SPRequest.DeleteItem(String bstrUrl, String bstrListName, Int32 lID, UInt32 dwDeleteOp, Guid& pgDeleteTransactionId) e3f73d0a-2a62-4d0e-80a1-51bf60ae4094
    05/10/2012 14:47:19.38  w3wp.exe (0x1190)                        0x0CDC SharePoint Foundation          Performance                    nask Monitorable An SPRequest object was not disposed before the end of this thread.  To avoid wasting system resources, dispose of this object or its parent (such as an SPSite or SPWeb) as soon as you are done using it.  This object will now be disposed.  Allocation Id: {FB6899A2-FBA8-4730-802E-4B42F2C2BC91}  To determine where this object was allocated, set Microsoft.SharePoint.Administration.SPWebService.ContentService.CollectSPRequestAllocationCallStacks = true. e3f73d0a-2a62-4d0e-80a1-51bf60ae4094
    05/10/2012 14:47:19.38  w3wp.exe (0x1190)                        0x0CDC SharePoint Foundation          Monitoring                     b4ly Medium   Leaving Monitored Scope (Request (POST:http://fesp1:80/Lists/REC_Request/EditForm.aspx?ID=841&ContentTypeId=0x010062F1DB2149BE5346A966484DDBFA3B74&IsDlg=1)). Execution Time=81.1620405924301 e3f73d0a-2a62-4d0e-80a1-51bf60ae4094
    05/10/2012 14:47:19.38  w3wp.exe (0x1190)                        0x12B4 SharePoint Foundation          Monitoring                     nasq Medium   Entering monitored scope (Request (PROPFIND:http://fesp1:80/wip/021.5/21.50000_50500)) 

     
  • jeudi 10 mai 2012 21:04
     
      A du code
    Connectez-vous pour voter
    0

    Are you doing this over HTTPS?

    Do you have the correct Alternate Access Mappings?

    On the following forum I found someone who did this -

    The solution found for this was that was missing this entry in my web.config:

    <system.serviceModel>
    <serviceHostingEnvironment aspNetCompatibilityEnabled="true" />
  </system.serviceModel>
    The thread is - http://social.msdn.microsoft.com/Forums/en-US/sharepoint2010general/thread/bacf9bd5-74cd-44a1-972c-25935832d21e

    Ameet Phadnis (Alexander Open Systems)

     
  • vendredi 11 mai 2012 03:35
     
     
    Connectez-vous pour voter
    0

    I have full permissions -- listed as site collection admin.

    Not ussing SSL or https.

    Alternate access mappings are all correct.  Doesn't matter which URL is used, same behavior.

    The solution described in the referenced thread does not apply to my problem -- the symptoms are different.

    Error log is suggesting a problem with SQL database?  SqlError: 'Operand type clash: int is incompatible with uniqueidentifier'    Does that mean anything to anyone and can that error result by moving the conent database to anoterh SharePoint Farm?  Not sure what that would result in a SQL type error though?

     
  • vendredi 11 mai 2012 14:12
     
     
    Connectez-vous pour voter
    0

    I am not sure what is going on with this. Can you try to update all Service Packs and also the Cumulative updates on SharePoint side and SQL side?

    See if that fixes anything.

    Ameet

    Ameet Phadnis (Alexander Open Systems)

     
  • vendredi 11 mai 2012 14:39
     
     
    Connectez-vous pour voter
    0

    Everything worked fine until I moved the content database to a new SharePoint Farm.  After that, everything still seems to work fine except for this one problem.  I'm trying to figure out why this one thing would "break" by moving the CDB to a new SharePoint Farm.

    Any chance I could get a response from a Microsoft SharePoint employee/forum moderator?

     
  • lundi 14 mai 2012 16:16
     
     
    Connectez-vous pour voter
    0

    I have the latese cummulative updates on SQL and SharePoint servers.   To be clear, the Web.Config file has the suggested lines in it.  I'm stuck.  this makes no sense.  I cannot find any other functional problem in this installation except this error when one tries to delete an item from a list, otherwise all functions appear to be working correctly.

    The error in the event log suggests a problem in a SQL table; i.e., SQLError: 'Operand type clash: int is incom[atible with uniqueidentifier'

    Any thoughts?

     
  • lundi 14 mai 2012 16:52
     
     
    Connectez-vous pour voter
    0

    Check to see if you have anything in your recycle bin, if so try to empty.   Also check the database server to make sure you are not out of space and the file growth setting for the database so that you are not hitting the size limit set. 

    Also could you look in the sql server logs and see what errors it is throwing.  if you see them please paste it here so we can take a look.

     

    de Nada

     
  • lundi 14 mai 2012 17:58
     
     
    Connectez-vous pour voter
    0
    Yes, three are items in the recycle bin.  I was able to empty the recycle bin without errors.  I was also able to delete items from the end-user recycle bin without problem.  I checked all the SQL logs and there are no errors captured in any of them.  Not sure if that seems unusual or not -- there are lots of entries in them (informational), but nothing around the time when I get the error in SharePoint for dtrying to delete an item in a list.  The database is on a seperate SQL server running 2008 R2 standard.  The database is set to unlimited expansion/file growth.
    • Modifié DRGESCH lundi 14 mai 2012 17:59
    •