Agile (MOSC)

MOSC Banner

Anyone familiar with the following error : Exhausted Resultset

edited Aug 20, 2015 10:08AM in Agile (MOSC) 1 commentAnswered

I have a Java PX that uses IQUERY to retrieve a list of documents and process them with some logic. Occasionally, upon exiting the PX, some of the documents receives a "Exhausted Resultset" error when I tried to view the document from the web client. Has anyone ever experience such an error?

I also ran into the same error when the following statement fails trying to add an item to the Affected Items tab:

IRow affectedItemRow = affectedtable.createRow(docObject);

It appears to be some sort of locking problem in Agile. After a period of time, the error goes away.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center