COM.IBM.CE.CM.OBJECTCLOSEDEXCEPTION:dsra9110e:

Hi,
    I have an issue on hand, my application generates reports for plants, for one of the reports for a particular plant, it is returning this
gop.report.ReportProcess.validateHorizonDate(ReportProcess.java:1693)
[3/3/09 12:48:09:885 EST] 00001a8a SystemErr     R       at gop.report.ReportProcess.run(ReportProcess.java:362)
[3/3/09 12:48:16:648 EST] 00001a8b SystemErr     R java.lang.ArrayIndexOutOfBoundsException: 18
      at gop.report.PeriodReport.processingPeriodData(PeriodReport.java:393)
      at gop.report.PeriodReport.periodProcess(PeriodReport.java:346)
      at gop.report.PeriodReport.constructData(PeriodReport.java:97)
      at gop.report.ReportProcess.getDetailData(ReportProcess.java:653)
      at gop.report.ReportProcess.doProcess(ReportProcess.java:402)
      at gop.report.ReportProcess.run(ReportProcess.java:335)

[3/3/09 12:48:16:649 EST] 00001a8b SystemErr     R       at gop.report.PeriodReport.processingPeriodData(PeriodReport.java:393)
[3/3/09 12:48:16:649 EST] 00001a8b SystemErr     R       at gop.report.PeriodReport.periodProcess(PeriodReport.java:346)
[3/3/09 12:48:16:649 EST] 00001a8b SystemErr     R       at gop.report.PeriodReport.constructData(PeriodReport.java:97)
[3/3/09 12:48:16:649 EST] 00001a8b SystemErr     R       at gop.report.ReportProcess.getDetailData(ReportProcess.java:653)
[3/3/09 12:48:16:649 EST] 00001a8b SystemErr     R       at gop.report.ReportProcess.doProcess(ReportProcess.java:402)
[3/3/09 12:48:16:650 EST] 00001a8b SystemErr     R       at gop.report.ReportProcess.run(ReportProcess.java:335)
[3/3/09 12:48:16:651 EST] 00001a8b SystemErr     R 12:48:16 03/03 [EROR] PeriodReport          Error in construct Data
com.ibm.websphere.ce.cm.ObjectClosedException: DSRA9110E: ResultSet is closed.
      at com.ibm.ws.rsadapter.jdbc.WSJdbcResultSet.getStatement(WSJdbcResultSet.java:1763)
      at gop.report.PeriodReport.periodProcess(PeriodReport.java:362)
      at gop.report.PeriodReport.constructData(PeriodReport.java:97)
      at gop.report.ReportProcess.getDetailData(ReportProcess.java:653)
      at gop.report.ReportProcess.doProcess(ReportProcess.java:402)
      at gop.report.ReportProcess.run(ReportProcess.java:335)
[3/3/09 12:48:16:652 EST] 00001a8b SystemErr     R 12:48:16 03/03 [EROR] ReportProcess         Error in getDetailData
com.ibm.websphere.ce.cm.ObjectClosedException: DSRA9110E: ResultSet is closed.
      at com.ibm.ws.rsadapter.jdbc.WSJdbcResultSet.getStatement(WSJdbcResultSet.java:1763)
      at gop.report.PeriodReport.periodProcess(PeriodReport.java:362)
      at gop.report.PeriodReport.constructData(PeriodReport.java:97)
      at gop.report.ReportProcess.getDetailData(ReportProcess.java:653)
      at gop.report.ReportProcess.doProcess(ReportProcess.java:402)
      at gop.report.ReportProcess.run(ReportProcess.java:335)
[3/3/09 12:48:16:652 EST] 00001a8b SystemErr     R 12:48:16 03/03 [EROR] ReportProcess         Report not generated, due to the following exception. com.ibm.websphere.ce.cm.ObjectClosedException: DSRA9110E: ResultSet is closed.
com.ibm.websphere.ce.cm.ObjectClosedException: DSRA9110E: ResultSet is closed.
      at com.ibm.ws.rsadapter.jdbc.WSJdbcResultSet.getStatement(WSJdbcResultSet.java:1763)
      at gop.report.PeriodReport.periodProcess(PeriodReport.java:362)
      at gop.report.PeriodReport.constructData(PeriodReport.java:97)
      at gop.report.ReportProcess.getDetailData(ReportProcess.java:653)
      at gop.report.ReportProcess.doProcess(ReportProcess.java:402)
      at gop.report.ReportProcess.run(ReportProcess.java:335)
[3/3/09 12:48:16:653 EST] 00001a8b SystemErr     R

I copied the data from production to test for this plant and it gives me error in test too.
Please find the code snippet below...when i commented the st = resultSet.getStatement(); I do not receive the error.
If we see the error trace, we see that we are receiving an ArrayIndexOutOfRangeException, I am not sure whether this is leading to the object closed exception.
Could anyone suggest me how do i go ahead and prevent this from occuring.
Actually this report runs fine for all other plants and has been running fine until now, the thing with this plant is once we get the exception the server is hanging up and requires a restart..as we are unable to go thru the application after we receive the error eiher by restarting the application or staying in the same page.
Early help will be greatly appreciated

private void periodProcess(String aStartDate, String aEndDate,TreeMap aProductionUnits) throws Exception
	{
		GDBTier dbTier = null;
		Transaction tran = null;
		ResultSet rsPeriod = null;
		String sql = "";
		String filterValues = "";
 
		try
		{
			dbTier = DBManager.getGDBTier(plantId, i2Systems);			
			tran = dbTier.getTransaction();
 
			String attribs = "";
 
			attribs = attributes.toString();
			System.out.println("attribs is "+attribs);//t8442vz
			attribs = attribs.substring(1, attribs.length() - 1);
			attribs = Utility.replace(attribs, ", ", "|S;");
 
			sql = GOPQuery.getPeriodReportSql(attributes.size(), allAttr, plantId, i2Systems, frozen);
 
			if (allAttr)
			{
				filterValues = Utility.blankQuoteCheck(aStartDate) + "|S;" + Utility.blankQuoteCheck(aEndDate) + "|S";
			}
			else
			{
				filterValues = Utility.blankQuoteCheck(aStartDate) + "|S;" + Utility.blankQuoteCheck(aEndDate) + "|S;" + attribs + "|S";
			}
			rsPeriod = dbTier.getResultSet(tran, sql, filterValues);
						
			processingPeriodData(rsPeriod);
			System.out.println("after processing");
			if (tran != null)
				tran.commit();
		}
		catch (Exception e)
		{
			if (tran != null)
				tran.rollback();
 
			e.printStackTrace();
		}
		finally
		{
			if (rsPeriod != null)
			{
				Statement st = rsPeriod.getStatement();
				rsPeriod.close();
				st.close();
			}
 
			if (tran != null)
			{
				tran.close();
			}
		}
	}

Select allOpen in new window