none
Issues with checkin and publish in Project Online RRS feed

  • Question

  • I see the following intermittent issues while attempting to checkin and publish project plans using Project Online. As an owner of these MPPs I have been able to previously checkin / checkout / publish without any issues. 

    Below are the screenshots that help explain the situation:

    Thanks for any feedback.

    Friday, February 20, 2015 12:14 AM

Answers

All replies

  • One more related screenshot....

    Friday, February 20, 2015 12:15 AM
  • Hi,

    Either an administrator is playing with you and forces the project's checkin from the PWA server settings, or you have network issue, loosing your connection. You could check with your IT guys to see if they had some network troubles recently.


    Hope this helps,


    Guillaume Rouyre, MBA, MVP, P-Seller |

    Friday, February 20, 2015 6:58 AM
    Moderator
  • Here is a trace from one of the error messages:

    <?xml version="1.0" encoding="utf-16"?>
    <errinfo>
         <general>
              <class name="DatabaseForeignKeyViolationError">
                   <error id="50002" name="DatabaseForeignKeyViolationError" uid="56f6a682-82b8-e411-8a94- 00155d88430d"/>
                   <error id="50002" name="DatabaseForeignKeyViolationError" uid="57f6a682-82b8-e411-8a94- 00155d88430d"/>
                   <error id="50002" name="DatabaseForeignKeyViolationError" uid="58f6a682-82b8-e411-8a94- 00155d88430d"/>
                   <error id="50002" name="DatabaseForeignKeyViolationError" uid="59f6a682-82b8-e411-8a94- 00155d88430d"/>
                   <error id="50002" name="DatabaseForeignKeyViolationError" uid="5af6a682-82b8-e411-8a94- 00155d88430d"/>
                   <error id="50002" name="DatabaseForeignKeyViolationError" uid="5bf6a682-82b8-e411-8a94- 00155d88430d"/>
              </class>
              <class name="Microsoft.Office.Project.Server.BusinessLayer.Queue.Message">
                   <error id="23000" name="ProjectPublishFailure" uid="5cf6a682-82b8-e411-8a94- 00155d88430d" projectuid="e0c656bb-76aa-e411-8294-f0def132f2c0" messagetype="Microsoft.Office.Project.Server.BusinessLayer.QueueMsg.FullPublishDeleteMessage" messageID="10" stage="" blocking="Block"/>
              </class>
              <class name="Queue">
                   <error id="26000" name="GeneralQueueJobFailed" uid="5df6a682-82b8-e411-8a94- 00155d88430d" JobUID="e3e81781-82b8-e411-8299-f0def132f2c0" ComputerName="90753517-975c- 4d1b-a721-c594934fc2fa" GroupType="ProjectPublish" MessageType="FullPublishDeleteMessage" MessageId="10" Stage="" CorrelationUID="6b60eb9c-40db-0000-250f-18fc02eef712"/>
              </class>
         </genera

    Friday, February 20, 2015 3:58 PM
  • I agree with Guillaume, sounds like connectivity issues.

    Gary Chefetz, MCITP, MCP, MVP msProjectExperts
    Project and Project ServerFAQs
    Project Server Help BLOG

    Monday, February 23, 2015 5:37 PM
    Moderator
  • Additionally, can you let us know if you are using the Microsoft Project Pro for O365 or Project Professional 2013. In case you are using Project Professional 2013 then let us know the Project Version (File > Account > About Project).


    Cheers! Happy troubleshooting !!! Dinesh S. Rai - MSFT Enterprise Project Management Please click Mark As Answer; if a post solves your problem or Vote As Helpful if a post has been useful to you. This can be beneficial to other community members reading the thread.

    Wednesday, February 25, 2015 1:29 AM
    Moderator
  • I am using MS Project Pro for O365 (is that the same as Project Web). 

    Thanks!

    Wednesday, February 25, 2015 1:45 AM
  • In that case, you are at the latest version.

    A quick check, when you see the performance issue on Project Client do you see performance issues while accessing the PWA site or any other site on the tennant. This is just to isolate whether the issue is with Project or the network.

    How frequently do you see it or is this intermittent? Does it happen for any random project or a specific project


    Cheers! Happy troubleshooting !!! Dinesh S. Rai - MSFT Enterprise Project Management Please click Mark As Answer; if a post solves your problem or Vote As Helpful if a post has been useful to you. This can be beneficial to other community members reading the thread.

    Wednesday, February 25, 2015 5:29 PM
    Moderator
  • This issue occurs while accessing the PWA site. It occurs with a subset of MPPs in the project portfolio. (Not for a "random" project)
    Thursday, February 26, 2015 6:57 AM
  • We are facing same error when trying to publish project. Project Online + Project Professional 2013

    <?xml version="1.0" encoding="utf-16"?>
    <errinfo>
        <general>
            <class name="DatabaseForeignKeyViolationError">
                <error id="50002" name="DatabaseForeignKeyViolationError" uid="a296a1de-7fbe-e411-894c-00155db86908"/>
                <error id="50002" name="DatabaseForeignKeyViolationError" uid="a396a1de-7fbe-e411-894c-00155db86908"/>
                <error id="50002" name="DatabaseForeignKeyViolationError" uid="a496a1de-7fbe-e411-894c-00155db86908"/>
                <error id="50002" name="DatabaseForeignKeyViolationError" uid="a596a1de-7fbe-e411-894c-00155db86908"/>
                <error id="50002" name="DatabaseForeignKeyViolationError" uid="a696a1de-7fbe-e411-894c-00155db86908"/>
                <error id="50002" name="DatabaseForeignKeyViolationError" uid="a796a1de-7fbe-e411-894c-00155db86908"/>
            </class>
            <class name="Microsoft.Office.Project.Server.BusinessLayer.Queue.Message">
                <error id="23000" name="ProjectPublishFailure" uid="a896a1de-7fbe-e411-894c-00155db86908" projectuid="83979129-81b3-e411-8ef9-448a5b26cd6b" messagetype="Microsoft.Office.Project.Server.BusinessLayer.QueueMsg.FullPublishDeleteMessage" messageID="10" stage="" blocking="Block"/>
            </class>
            <class name="Queue">
                <error id="26000" name="GeneralQueueJobFailed" uid="a996a1de-7fbe-e411-894c-00155db86908" JobUID="fb78ecdd-7fbe-e411-a44a-448a5b26cd6b" ComputerName="3b2be480-d5ab-4b37-b507-5046b27abc9e" GroupType="ProjectPublish" MessageType="FullPublishDeleteMessage" MessageId="10" Stage="" CorrelationUID="7cd4ed9c-7039-1000-b44b-3c8332dde114"/>
            </class>
        </general>

    Friday, February 27, 2015 1:25 PM
  • Clear your cache, make sure you have stable connection to internet and try again.

    If this not going to work then your project file could be corrupted. In this case save the file locally and the overwrite with the same name on top of the existing file.

    Hope that helps.

    Alex 

    Friday, February 27, 2015 3:20 PM
    Moderator
  • Could you explain what you mean by "overwrite with the same name"? Do you mean delete the project and create a new project wit the same name and start over?

    I would like to add this that happens to a specific set of projects every time, it is not intermittent like a connectivity problem. I is always the same 5 projects out of hundreds of projects.

    Thanks

    Friday, February 27, 2015 4:22 PM
  • Instead of a Save as you can perform Save For Sharing using the below steps:

    1. In Project Professional 2013, Go to File | Options | Customize ribbon
    2. Under Choose commands from, Select All Commands
    3. Under Customize the ribbon, Click on New Tab and name the Tab "Save For Sharing"
    4. Under Choose Commands from selected "Save For Sharing" and added it to a group in the new tab that we created and clicked on Ok
    5. Now in the Project navigate to the new tab and click on Save for Sharing
    6. Save the file on to your desktop
    7. Once the file is saved then do a save as of the Project back to the server, File > Save As > <PWA Profile name on the client> and click on Save
    8. Save the Project without doing any changes in the pop up window that comes for saving the file to the server


    Cheers! Happy troubleshooting !!! Dinesh S. Rai - MSFT Enterprise Project Management Please click Mark As Answer; if a post solves your problem or Vote As Helpful if a post has been useful to you. This can be beneficial to other community members reading the thread.

    Saturday, February 28, 2015 8:58 AM
    Moderator
  • Hi, we are also getting these errors all of a sudden. I can confirm that we are not having connectivity issues as we tried it from multiple locations. It's only happening on some of the projects. We tried the suggestion of saving offline and saving back to the server, but we are still getting the same error.

    Pieter de Klerk MCP PMP

    Tuesday, March 3, 2015 11:36 AM
  • Hi Pieter,

    Have you tried the save for sharing method?

    Then you should look for any causes of corruption in the given projects: blank lines, predecessors on summary tasks, assignments on milestones, duplicated resources...


    Hope this helps,


    Guillaume Rouyre, MBA, MVP, P-Seller |

    Tuesday, March 3, 2015 11:47 AM
    Moderator
  • Has anyone resolved this? I have several users seeing this issue now too.

    It's not a connectivity issue. I verified this and can re-pro the issue. 

    • Edited by Roland G29 Tuesday, March 3, 2015 5:52 PM
    Tuesday, March 3, 2015 5:43 PM
  • Thanks for the help Guilaume! I checked everything, and the user did have a blank task, some local resources and two manually scheduled tasks. I fixed everything and re-published, but still getting the error. I'm going to play around with it some more today.

    Pieter de Klerk MCP PMP

    Wednesday, March 4, 2015 5:40 AM
  • Got feedback from the user this morning that he is not getting the error any longer.

    So in my case, the error just disappeared - scary.


    Pieter de Klerk MCP PMP

    Wednesday, March 4, 2015 9:31 AM
  • Good news Pieter!

    Did you do the save for sharing method or simply cleaning the file?


    Hope this helps,


    Guillaume Rouyre, MBA, MVP, P-Seller |

    Wednesday, March 4, 2015 9:57 AM
    Moderator
  • The error message indicates that the reason why your previous check-in failed was a failed and blocking publishing correlation in the queue. Publishing failures are most often traceable to unanticipated data conditions or just plain bad data. Guillaume lists the most common conditions that can literally choke the scheduling engine. See PMI's best practices for scheduling standards and create your governance around these.

    Gary Chefetz, MCITP, MCP, MVP msProjectExperts
    Project and Project ServerFAQs
    Project Server Help BLOG

    Thursday, March 12, 2015 1:31 PM
    Moderator