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.
To get round this problem you need to increase the heap size available to the Java VM and to do this you need to amend the AppServer configuration on the machine which runs your DataPA AppServer.
The line highlighted in yellow needs to be inserted to achieve this and then the AppServer needs stopped and restarted.
| [UBroker.AS.bigsports] appserviceNameList=bigsports autoStart=1 brkrLogAppend=0 brkrLoggingLevel=3 brokerLogFile=c:\openedge\wrk\bigsports\bigsports.broker.log controllingNameServer=NS1 initialSrvrInstance=1 jvmArgs=-Xms128m -Xmx1024m maxSrvrInstance=2 mqBrokerLogFile=@{WorkPath}\bigsports.mqbroker.log mqServerLogFile=@{WorkPath}\bigsports.mqserver.log operatingMode=Stateless portNumber=7187 PROPATH=c:\openedge\wrk\datapa.pl;@{WinChar Startup\PROPATH};@{WorkPath} srvrLogAppend=0 srvrLogFile=c:\openedge\wrk\bigsports\bigsports.server.log srvrLoggingLevel=3 srvrStartupParam=-db c:\openedge\wrk\databases\bigsports\bigsports.db srvrStartupProc=startup.p uuid=55c948639f186661:-420618c3:146a32707f2:-4a33 workDir=c:\openedge\wrk\bigsports |
The values shown in the setting above should normally suffice but this Progress KB details what the settings options are should these need to be amended:
The Following links to Progress KB entries document all of this.
http://knowledgebase.progress.com/articles/Article/P188382
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
