The Error "Broker System failure: Invalid state for deallocate: Current state = STATE_RECEIVING (7249) " is being returned from a query. :

The Error "Broker System failure: Invalid state for deallocate: Current state = STATE_RECEIVING (7249) " is being returned from a query. Print

Modified on: Thu, 12 Apr, 2018 at 12:25 PM

Applicable Versions: All Versions

This error occurs when the process running the query has lost it’s connection to the AppServer. When the query completes on the AppServer it goes to return the data but finds that the client has gone.

Whilst this is most commonly due to a network problem between the machine running the AppServer and the machine running the Scheduler, it can also occur where a large number of records (100,000+) are being returned in a Temp Table. This is due the Java VM that Progress uses as part of the AppServer running out of memory.

If the query is returning a large number of records then the solution would be to increase the amount of memory the AppServer can use.

The Following links to Progress KB entries document all of this.

http://knowledgebase.progress.com/articles/Article/P121822?q=7249&l=en_US&fs=Search&pn=1

http://knowledgebase.progress.com/articles/Article/P99089?popup=true

Did you find it helpful? Yes No

The Error "Broker System failure: Invalid state for deallocate: Current state = STATE_RECEIVING (7249) " is being returned from a query. Print

Related Articles