OFFXPDEV: Cannot Deploy Solution That Is Based on a Copy of the Issue Tracking Workflow Template (287069)


The information in this article applies to:

  • Microsoft Office XP Developer
This article was previously published under Q287069

SYMPTOMS

When you try to instantiate a template that you created from the Issue Tracking Workflow sample template, you see the following error in a window named DCOM Server modTBAD failure:
[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'IssuesView'.

CAUSE

Views are referencing object IDs that are no longer valid on SQL Server. This happens when the original table is dropped and then re-created.

RESOLUTION

Issue Tracking is a sample template, and it is not recommended that you create other templates from the resulting Workflow Application that it creates.

STATUS

Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.

MORE INFORMATION

Steps to Reproduce the Behavior

  1. Click Start, point to Programs, point to Microsoft Office XP Developer, and then click Workflow Manager for SQL Server.
  2. In the Workflow Manager for SQL Server, if you see Issue Tracking on the Workflow Applications tab, skip to step 8. If Issue Tracking is not on the Workflow Applications tab, continue with step 3.
  3. On the Templates tab, click Instantiate Template.
  4. In the SQL Server Workflow Template Instantiation Wizard, click Next.
  5. On the Choose a Template page of the wizard, choose your server from the drop-down list, and then click Connect.
  6. Note that the Issue Tracking template appears in the box. Click the template, and then click Next.
  7. Click Next through the remaining pages of the wizard. On the last page of the wizard, click Finish. Wait until you are notified that the application was instantiated successfully.
  8. On the Workflow Applications tab of the Workflow Manager for SQL Server, click the new Issue Tracking solution, and then click Create Template.
  9. In the SQL Server Workflow Template Creation Wizard, click Next.
  10. On the Identify the Source Project type page of the wizard, choose your server from the drop-down list, and then click Connect.
  11. In the Applications available on this server box, click IssueTracking, and then click Next.
  12. On the Provide the Template Information page of the wizard, change Template Name to Issue Tracking2, and then click Next.
  13. Click Next through the remaining pages of the wizard. On the last page of the wizard, click Finish. Wait until you are notified that the template has been created.
  14. Note that the new Issue Tracking2 template appears on the Templates tab. Click Instantiate Template.
  15. In the SQL Server Workflow Template Instantiation Wizard, click Next.
  16. On the Choose a Template page of the wizard, choose your server from the drop-down list, and then click Connect.
  17. Note that the Issue Tracking2 template appears in the box. Click the template, and then click Next.
  18. Click Next on the remaining pages of the wizard. On the last page of the wizard, click Finish.

    Note that after a while, you see the error that is mentioned in the "Symptoms" section of this article.
Modification Type:MinorLast Reviewed:1/26/2005
Keywords:kbbug kberrmsg kbnofix KB287069
©2004 Microsoft Corporation. All rights reserved.