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?

*This post is locked for comments

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.