如何在Project Server 2010中完成事务？ [英] How to complete a transaction in Project Server 2010?

问题描述

您好，

我们正在运行Project Server 2010并使用UpdateStatus（）和SubmitStatusForResource（）方法通过StatusingClient提交特定作业的实际工作好吧。 

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. 

最近，我们在Project Professional中打开一些项目时发现了一个消息框，上面写着：

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?"

当我们点击"是"时，项目客户端关闭，没有任何反应（由SQL事件探查器验证）。点击"否"时我们可以像以前一样打开和编辑项目，但是消息框会在下次启动时再次出现。

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.

使用SQL事件探查器进行的进一步研究让我了解了为什么会显示此消息框。该程序在已发布的数据库中执行MSP_WEB_SP_QRY_ReadTransactionsForProject存储过程。这将返回存储在已发布数据库的MSP_ASSIGNMENT_TRANSACTIONS
表中的打开事务。现在这个事务有ASSN_TRANS_STATE_ENUM = 2，这意味着（根据Project SDK）"inProcess"。 

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". 

我已经尝试通过PSI更改此属性（状态客户端 - > ReadStatusApprovalsInProcess （））但这对我不起作用，因为我不是这项任务的所有者。

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.

此外，当最初通过PSI提交状态更新时，服务器日志显示"OK" ，所以此时没有任何问题。还有6个状态更新，相当不错。此外，项目服务器队列没有此项目的条目
，并且用户的批准中心为空。

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.

为什么此任务更新仍在procress中？如何强制它重新进入队列？我不想在"3"上手动通过SQL设置ASSN_TRANS_STATE_ENUM。因为我不知道有任何后果。

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

推荐答案

嗨汤姆，

感谢您发帖MSDN论坛。

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.

感谢您的理解。

致以最诚挚的问候，

这篇关于如何在Project Server 2010中完成事务？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！