<p>Hi everyone,</p>
<p> </p>
<p>I have run into an issue with the customer where when certain reports are run(in each instance a modified version of the woprint.rptdesign report) they show only the header and footer data, and the log file shows </p>
<p> </p>
<div>DataSet [mainDataSet] fetch failed: </div>
<div>java.sql.SQLException: ORA-00604: error occurred at recursive SQL level 1</div>
<div>ORA-01000: maximum open cursors exceeded</div>
<div>ORA-00604: error occurred at recursive SQL level 1</div>
<div>ORA-01000: maximum open cursors exceeded</div>
<div>ORA-01000: maximum open cursors exceeded</div>
<div> </div>
<div>When I run the report on our test instance with the defaultlogfile set to debug, it shows all of the datasets being closed correctly. I'm not sure what the issue is here. </div>
<div> </div>
<div>Any suggestions? </div>
<div><br>
Thanks in advance!</div>
