none
ProjectExceededItemsLimit Error RRS feed

  • Question


  • We are having a Project Server 2010 setup with SP 1 and June 2012 CU installed on the same

    As a part of SAP integration we have developed the .net asmx web service which update the EPM project tasks using "QueueUpdateProject" method of Project PSI, this is working fine when I am working on the smaller set of project (100-200 Tasks) but if I am trying to update the larger set of project (700-800) tasks then this does not work and throws the "ProjectExceededItemsLimit" error as shown below.

    ProjectServerError(s) LastError=ProjectExceededItemsLimit Instructions: Pass this into PSClientError constructor to access all error information ~    at System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClientMessage message, WebResponse response, Stream responseStream, Boolean asyncCall)
       at System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String methodName, Object[] parameters)
       
    While I have looked at all the settings but haven't found any threashhold which could help me to overcome this limitation. I have also looked at the online documentation (link below) where it says "When you create or update a project, the PSI can process up to 1000 rows of data at a time. If the total number of rows of new or updated data in all tables of ProjectDataSet exceeds 1000, the PSI returns the ProjectExceededItemsLimit error." But in my case I am only updating 10 tasks out of 800 but still getting this error.
     
    http://msdn.microsoft.com/en-in/library/websvcproject.project.queueupdateproject(v=office.12).aspx
     
    Can someone please help me with this matter
    Wednesday, April 3, 2013 11:45 AM

All replies

  • Hi Ajay,

    There's already a thread for this, you can find it here, alternate solution is given there. This is a known behavior, you can read it in the remarks area here.

    Hope this helps.


    IN
    Thanks, Kashif

    Thursday, April 4, 2013 7:07 AM
  • Sorry I didn't read your post correctly. Are you sure, you have filter out the dataset before sending it for updates?


    IN
    Thanks, Kashif

    Thursday, April 4, 2013 7:09 AM