MOD2000: "Multiple-Step OLE DB Operation Generated Errors" Error Message with Document Library Sample (272583)

The information in this article applies to:

Microsoft Office 2000 Developer

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 "In Process" state to the "Approved" 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("StatusId").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("StatusId").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 "In Process" to "Approved," this error message should no longer occur.

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

MORE INFORMATION

Steps to Reproduce the Behavior

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:

Microsoft Windows NT Server 4.0 SP6, per seat

Microsoft Windows NT 4.0 Option Pack

Reapply SP6

Microsoft Exchange Server Standard 5.5 with SP3

Microsoft Office SR-1

Microsoft FrontPage Server Extensions SR 1.1

Microsoft SQL Server 7.0 Standard Edition, per seat

Microsoft SQL Server SP2

Microsoft Office Developer SR-1 including the Workflow Designer for SQL Server Server Components the Workflow Designer for SQL Server Developer Tools/Components

Create these user accounts on the private domain:
TestUser Domain Administrator
Reviewer1 Domain User
Reviewer2 Domain User
ContentMgr Domain User
Contributor Domain User

On the second computer, install the following software:

Microsoft Windows NT Workstation SP6, per seat

MSDE, from the Microsoft Office 2000 SR-1 CD

Microsoft SQL Server SP2

The Workflow Designer for SQL Server Client utilities (install them from http://server/modweb/default.htm, where server is the name of the first computer).

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.
On the first computer (the PDC and Exchange server), start the Team Solutions Manager.
Click the Templates tab.
Click the Import tab. Import the DocumentLibrarySample template (from the http://msdn.microsoft.com/library/techart/mod_doclib.htm site).
Deploy the DocumentLibrarySample template onto this computer. Set the following roles:
TestUser All roles (db_owner, Contributor, Reviewer, Content Manager)
ContentMgr Content Manager role only
Reviewer1 Reviewer role only
Reviewer2 Reviewer role only
Contributor Contributor role only
In the Team Solutions Manager, click the Users tab.
Click Synchronize. Specify the Exchange server name.
Click Synchronize Now. Ensure that all users show up in the Team Solutions Manager after you click Synchronize Now.
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.
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 ("Starting a New Document Review" 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.
On the main development computer, set the following reviewers for each document:
Test1.htm Required reviewers are TestUser and Reviewer1
Test2.htm Required reviewers are Reviewer1 and Reviewer2
Test3.htm Required reviewer is Reviewer1
Log on to the second computer, the client workstation, as TestUser. Ensure that the SQL Server services use this user's domain account.
Install the Microsoft Office 2000 Developer SR-1 Client Components for Workflow Designer for SQL Server.
Browse to http://servername/DocumentLibrarySample/default.htm.
Click the hyperlink that indicates how many documents you have to review.
Pick Test1 from the list (currevitems.htm). Click Start a new review. This opens the reviewitem.htm page.
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.

Modification Type:	Major	Last Reviewed:	7/31/2001
Keywords:	kbbug kberrmsg kbWorkFlowDesigner KB272583

©2002 Microsoft Corporation. All rights reserved.