Issue with open cursors when running BIRT reports in Maximo 7.5.0.3

amw2326

<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>

wwilliams

<p>Is your test instance a very recent copy of prod?</p>
<p>You mentioned modified, do we know what was modified?</p>