Microsoft KB Archive/291101

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

Article ID: 291101

Article Last Modified on 2/12/2007

-

APPLIES TO


 * Microsoft Office XP Developer Edition

-



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:  Start SQL Server Enterprise Manager, and then expand the modSystem database. Open the stored procedure modUpdateApplicationCache.  Change the size of the variable @dbname to a number larger than 40, for example: DECLARE @dname VARCHAR(40)  Save the changes to the stored procedure, and then view the Workflow Manager for SQL Server.

Note that the Workflow application is now listed.



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.

Additional query words: prb

Keywords: kbnofix kbprb KB291101

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.