Microsoft KB Archive/272583

= MOD2000: &quot;Multiple-Step OLE DB Operation Generated Errors&quot; Error Message with Document Library Sample =

Article ID: 272583

Article Last Modified on 7/31/2001

-

APPLIES TO


 * Microsoft Office 2000 Developer Edition

-



This article was previously published under Q272583



SYMPTOMS
Microsoft provides a Document Library Sample template http://msdn.microsoft.com/library/techart/mod_doclib.htm for Microsoft Access Workflow Designer for SQL Server. After this solution is deployed, you choose documents to be reviewed and one or more reviewers for each document to perform the document review.

However, in a multiple reviewer situation where one reviewer attempts to move a document from the &quot;In Process&quot; state to the &quot;Approved&quot; state (on the reviewitem.htm page), you receive the following error message:

Microsoft Internet Explorer

Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done.



RESOLUTION
To resolve this error message, follow these steps:

 In the ReviewItemsWorkflow script code (in Access Workflow Designer), locate the State2_OnExit procedure.  Near the end of the code (before the two End If statements), you see the following lines of code: rsReview.Fields(&quot;StatusId&quot;).Value = rstat rsReview.Update   Modify the code (add an If and End If around the lines of code in Item 2 above) so that the code looks as follows: If not isempty(rstat) then rsReview.Fields(&quot;StatusId&quot;).Value = rstat rsReview.Update end if                    Click Save. Stop and restart Microsoft SQL Server. When any of the reviewers attempts to move the document from &quot;In Process&quot; to &quot;Approved,&quot; this error message should no longer occur.

NOTE: You have to click Refresh on the Internet Explorer toolbar to see the updated document status.</ol>

<div class="moreinformation_section">

Steps to Reproduce the Behavior
<ol> Set up at least two computers on a private domain for this situation. Install this software on the first computer as the computer's Administrator:

</li> Create these user accounts on the private domain:

</li> On the second computer, install the following software:

</li> Add TestUser, Reviewer1, and Reviewer2 as administrators for this computer. As you perform the test as each user, ensure that the MSSQLServer and SQLServerAgent services use the proper domain account. For example, if you are logged onto this computer as TestUser, ensure that TestUser has logged in and installed the client utilities and that the MSSQLServer and SQLServerAgent services use the TestUser domain account.</li> On the first computer (the PDC and Exchange server), start the Team Solutions Manager.</li> Click the Templates tab.</li> Click the Import tab. Import the DocumentLibrarySample template (from the http://msdn.microsoft.com/library/techart/mod_doclib.htm site).</li> Deploy the DocumentLibrarySample template onto this computer. Set the following roles:

</li> In the Team Solutions Manager, click the Users tab.</li> Click Synchronize. Specify the Exchange server name.</li> Click Synchronize Now. Ensure that all users show up in the Team Solutions Manager after you click Synchronize Now.</li> On the server computer (the first computer), create three test documents in Notepad and store them into this computer's inetpub\wwwroot\DocumentLibrarySample folder. Name the test documents Test1.htm, Test2.htm, and Test3.htm.</li> On the main development computer, submit Test1, Test2, and Test3 (that you created in the previous step) as new documents (see default.htm and click Submit a new document for each file). Be sure to give the proper URL and a deadline for each document. When you get to newreview.htm (&quot;Starting a New Document Review&quot; page), select all the defaults for the Mark document approved if combo box, the End review when criteria is met check box, and the Route to all reviewers at the same time button.</li> On the main development computer, set the following reviewers for each document:

</li> Log on to the second computer, the client workstation, as TestUser. Ensure that the SQL Server services use this user's domain account.</li> Install the Microsoft Office 2000 Developer SR-1 Client Components for Workflow Designer for SQL Server.</li> <li>Browse to http://servername/DocumentLibrarySample/default.htm.</li> <li>Click the hyperlink that indicates how many documents you have to review.</li> <li>Pick Test1 from the list (currevitems.htm). Click Start a new review. This opens the reviewitem.htm page.</li> <li>On the toolbar, click Approved, and then click Save. Note that you receive the following error message:

Microsoft Internet Explorer

Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done.

</li></ol>

Additional query words: pra

Keywords: kberrmsg kbbug kbpending kbworkflowdesigner KB272583

-

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

© Microsoft Corporation. All rights reserved.