6.5 Application server - Cannot submit new requests to report queue

(0) Share

Report

Posted on by OOB IT

An error is received when submitting new report requests to Application server.

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

I beleive the problem is that the Request ID being assinged has grown to a six digit number but the scheduler table field for the ID only allows for 5 charaters. I have deleted all the requests from the queue but the new request are still getting assigned 6 digit numbers. Would someone know how reset ID application server will assign to the next job request?

All responses (2)

Answers (1)

OOB IT 35 on at

Like (0)

Report

RE: 6.5 Application server - Cannot submit new requests to report queue

That did it. Thank you for your help.
Verified answer

Community Member Microsoft Employee on at

Like (0)

Report

RE: 6.5 Application server - Cannot submit new requests to report queue

That was a problem with version 6.5. It has been some time since I was on that version but I believe we had to reseed the column in the SQL server.