How to complete a transaction in Project Server 2010? RRS feed

  • Question

  • Hello,

    we're running Project Server 2010 and submitted actual work for a specific assignment via a StatusingClient using the methods UpdateStatus() and SubmitStatusForResource(), which works well. 

    Lately, however we discovered a message box while opening some of our projects in Project Professional saying something like:

    "There are updates for this project. Would you like to close it and apply those updates?"

    When we click on "yes", the Project client closes and nothing happens (verified by SQL Profiler). When clicking on "no" we can open and edit the project as before, but the message box turns up again at the next start.

    Further research with the SQL Profiler took me to understand why this message box shows up. The program executes the MSP_WEB_SP_QRY_ReadTransactionsForProject stored procedure in the published database. This returns an open transaction as stored in the MSP_ASSIGNMENT_TRANSACTIONS table of the published database. Now this transaction has ASSN_TRANS_STATE_ENUM = 2, which means (according to Project SDK) "inProcess". 

    I already tried to change this property via PSI (statusing client -> ReadStatusApprovalsInProcess()) but that does not work for me since I'm not the owner of this assignment.

    Additionally, when initially submitting the status update via PSI, the server log shows "OK", so there weren't any problems at this point. There were 6 more status updates which went through pretty well. Also, the project server queue has no entry for this project and the user's approval center is empty.

    Why is this task update still in procress? How can I force it to reenter the queue? I don't want to set the ASSN_TRANS_STATE_ENUM via SQL manually on "3" since I'm not aware of any consequences.

    Thank you for your help! Happy Easter holidays.. Tom

    Saturday, March 30, 2013 2:51 PM

All replies

  • Hi Tom,

    Thank you for posting in the MSDN Forum.

    According to your description, your issue is a Project issue. I'll move it to Project Customization and Programming Forum for better support.

    Thank you for your understanding.

    Best regards,

    Quist Zhang [MSFT]
    MSDN Community Support | Feedback to us
    Develop and promote your apps in Windows Store
    Please remember to mark the replies as answers if they help and unmark them if they provide no help.

    Monday, April 1, 2013 6:56 AM
  • Hey Quist Zhang,

    I posted it in the Office Development Forum to get MS Support within two days. As the above issue is still (since two weeks) unresolved and it could be a bug of Project Server, I'd really like to get help on it as promised by MSDN licence.

    Maybe you can ask somebody or in case my question raises more question we could discuss the issue here? Are there any missunderstandings?

    Thank you a lot,

    Best, Tom

    Wednesday, April 17, 2013 9:02 AM
  • Hi BIS HD,

    As per the description of the issue, it looks like the assignment transaction table is not updated correctly. At this point you need to manually clear the invalid state of this assignments from MSP_ASSIGNMENT_TRANSACTIONS.


    Dinesh S. Rai

    Tuesday, April 30, 2013 5:22 PM
  • Hey Dinesh,

    so can you garantee that changing the above ASSN_TRANS_STATE_ENUM in the MSP_ASSIGNMENT_TRANSACTIONS table of the Project Published database from 2 to 3 will not affect other things in Project nor will we loose warranty for Project Server if we do that? :) If not, how else can we update the assignment transaction table?? 

    Best, Tom

    Saturday, May 4, 2013 2:30 PM
  • Yes, modifying the database directly will lead to an unsupported incident.

    Please open a support incident with Microsoft, perform these changes with the help of Microsoft Support Team.

    Cheers. Happy troubleshooting !!! Sriram E - MSFT Enterprise Project Management

    Monday, May 13, 2013 5:35 PM