Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

Troubleshooting
Research
Professional Opinions
Ask a Question
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE

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
Avatar of srafi78
srafi78Flag of United States of America image

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

Commented:
This problem has been solved!
Unlock 1 Answer and 1 Comment.
See Answers