troubleshooting Question

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

Avatar of srafi78
srafi78Flag for United States of America asked on
Web Applications
1 Comment1 Solution1724 ViewsLast Modified:
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();
			}
		}
	}
ASKER CERTIFIED SOLUTION
srafi78

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 1 Comment.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 1 Comment.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros