OFFXPDEV: Workflow Application Is Not Listed in Workflow Manager If Its Name Is Longer Than 40 Characters (291101)


The information in this article applies to:

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

SYMPTOMS

A SQL Server Workflow application with a name that is more than 40 characters long will not appear in the Workflow Manager.

RESOLUTION

To resolve this issue, you can do one of two things. You can either change the database name so that it has fewer than 40 characters, or you can modify a stored procedure in the modSystem database so that it can handle database names that are longer than 40 characters. To modify the stored procedure, follow these steps:
  1. Start SQL Server Enterprise Manager, and then expand the modSystem database.
  2. Open the stored procedure modUpdateApplicationCache.
  3. Change the size of the variable @dbname to a number larger than 40, for example:
    DECLARE @dname VARCHAR(40)
  4. Save the changes to the stored procedure, and then view the Workflow Manager for SQL Server.

    Note that the Workflow application is now listed.

MORE INFORMATION

Steps to Reproduce the Behavior

  1. Start SQL Server Enterprise Manager, and then create a new database with a name that has more than 40 characters.
  2. Open the Microsoft Development Environment, and then create a new SQL Server Workflow project on your local computer.
  3. Add a Workflow process, and then close the project.
  4. Start the Workflow Manager for SQL Server, make sure that you are pointed to your local server, and then click Refresh.

    Note that the Workflow application that you just created is not listed.
Modification Type:MajorLast Reviewed:6/25/2001
Keywords:kbprb KB291101
©2002 Microsoft Corporation. All rights reserved.