No input source supplied to the exporter.

[makweatan]

Hi,

I am getting this error and cannot print for certain record, but ok with some record. I am so confused.
Can anyone explain?

Thank you very much.

[9/27/10 11:14:37:764 SGT] 00000030 SystemErr R Caused by: com.ibm.db2.jcc .a.SqlException : DB2 SQL error: SQLCODE: -811, SQLSTATE: 21000, SQLERRMC: null
[9/27/10 11:14:37:764 SGT] 00000030 SystemErr R at com.ibm.db2.jcc .a.jf.b(jf.java :3198)
[9/27/10 11:14:37:764 SGT] 00000030 SystemErr R at com.ibm.db2.jcc .a.jf.a(jf.java :3182)
[9/27/10 11:14:37:764 SGT] 00000030 SystemErr R at com.ibm.db2.jcc .b.jb.e(jb.java :589)
[9/27/10 11:14:37:764 SGT] 00000030 SystemErr R at com.ibm.db2.jcc .b.jb.n(jb.java :579)
[9/27/10 11:14:37:764 SGT] 00000030 SystemErr R at com.ibm.db2.jcc .b.jb.j(jb.java :247)
[9/27/10 11:14:37:764 SGT] 00000030 SystemErr R at com.ibm.db2.jcc .b.jb.c(jb.java :57)
[9/27/10 11:14:37:764 SGT] 00000030 SystemErr R at com.ibm.db2.jcc .b.w.c(w.java:4 2)
[9/27/10 11:14:37:764 SGT] 00000030 SystemErr R at com.ibm.db2.jcc .b.cc.h(cc.java :177)
[9/27/10 11:14:37:764 SGT] 00000030 SystemErr R at com.ibm.db2.jcc .a.rf.p(rf.java :1256)
[9/27/10 11:14:37:764 SGT] 00000030 SystemErr R at com.ibm.db2.jcc .a.sf.d(sf.java :2312)
[9/27/10 11:14:37:764 SGT] 00000030 SystemErr R at com.ibm.db2.jcc .a.sf.X(sf.java :508)
[9/27/10 11:14:37:764 SGT] 00000030 SystemErr R at com.ibm.db2.jcc .a.sf.executeQu ery(sf.java:491 )
[9/27/10 11:14:37:764 SGT] 00000030 SystemErr R at net.sf.jasperre ports.engine.qu ery.JRJdbcQuery Executer.create Datasource(JRJd bcQueryExecuter .java:115)
[9/27/10 11:14:37:764 SGT] 00000030 SystemErr R at net.sf.jasperre ports.engine.fi ll.JRFillDatase t.createQueryDa tasource(JRFill Dataset.java:66 5)
[9/27/10 11:14:37:764 SGT] 00000030 SystemErr R at net.sf.jasperre ports.engine.fi ll.JRFillDatase t.setDatasource (JRFillDataset. java:609)
[9/27/10 11:14:37:764 SGT] 00000030 SystemErr R at net.sf.jasperre ports.engine.fi ll.JRFillDatase t.setParameterV alues(JRFillDat aset.java:598)
[9/27/10 11:14:37:780 SGT] 00000030 SystemErr R at net.sf.jasperre ports.engine.fi ll.JRBaseFiller .setParameters( JRBaseFiller.ja va:879)
[9/27/10 11:14:37:780 SGT] 00000030 SystemErr R at net.sf.jasperre ports.engine.fi ll.JRBaseFiller .fill(JRBaseFil ler.java:708)
[9/27/10 11:14:37:780 SGT] 00000030 SystemErr R at net.sf.jasperre ports.engine.fi ll.JRBaseFiller .fill(JRBaseFil ler.java:666)
[9/27/10 11:14:37:780 SGT] 00000030 SystemErr R at net.sf.jasperre ports.engine.fi ll.JRFillSubrep ort.fillSubrepo rt(JRFillSubrep ort.java:494)
[9/27/10 11:14:37:780 SGT] 00000030 SystemErr R at net.sf.jasperre ports.engine.fi ll.JRSubreportR unnable.run(JRS ubreportRunnabl e.java:63)
[9/27/10 11:14:37:780 SGT] 00000030 SystemErr R at net.sf.jasperre ports.engine.fi ll.JRThreadSubr eportRunner.run (JRThreadSubrep ortRunner.java: 137)
[9/27/10 11:14:37:780 SGT] 00000030 SystemErr R at java.lang.Threa d.run(Thread.ja va:813)
[9/27/10 11:14:51:466 SGT] 00000030 SystemOut O ReptWbUtil here
[9/27/10 11:14:52:294 SGT] 00000030 SystemOut O Pdf Exporter
[9/27/10 11:14:58:699 SGT] 00000030 SystemOut O Start export report
[9/27/10 11:15:21:306 SGT] 00000030 SystemErr R net.sf.jasperre ports.engine.JR Exception: No input source supplied to the exporter.
[9/27/10 11:15:21:306 SGT] 00000030 SystemErr R at net.sf.jasperre ports.engine.JR AbstractExporte r.setInput(JRAb stractExporter. java)
[9/27/10 11:15:21:306 SGT] 00000030 SystemErr R at net.sf.jasperre ports.engine.ex port.JRPdfExpor ter.exportRepor t(JRPdfExporter .java)
[9/27/10 11:15:21:306 SGT] 00000030 SystemErr R at my.org.hasil.dc ms.report.web.R eportWebUtil.vi ewPdfReport(Rep ortWebUtil.java )
[9/27/10 11:15:21:306 SGT] 00000030 SystemErr R at my.org.hasil.dc ms.grq.web.XcAc tion.performPos t(XcAction.java )
[9/27/10 11:15:21:306 SGT] 00000030 SystemErr R at sun.reflect.Nat iveMethodAccess orImpl.invoke0( Native Method)
[9/27/10 11:15:21:306 SGT] 00000030 SystemErr R at sun.reflect.Nat iveMethodAccess orImpl.invoke(N ativeMethodAcce ssorImpl.java:8 5)
[9/27/10 11:15:21:306 SGT] 00000030 SystemErr R at sun.reflect.Nat iveMethodAccess orImpl.invoke(N ativeMethodAcce ssorImpl.java:5 8)
[9/27/10 11:15:21:306 SGT] 00000030 SystemErr R at sun.reflect.Del egatingMethodAc cessorImpl.invo ke(DelegatingMe thodAccessorImp l.java:60)
[9/27/10 11:15:21:306 SGT] 00000030 SystemErr R at java.lang.refle ct.Method.invok e(Method.java:3 91)
[9/27/10 11:15:21:306 SGT] 00000030 SystemErr R at my.com.mesiniag a.web.CommonAct ion.execute(Com monAction.java: 176)
[9/27/10 11:15:21:306 SGT] 00000030 SystemErr R at org.apache.stru ts.chain.comman ds.servlet.Exec uteAction.execu te(ExecuteActio n.java:53)
[9/27/10 11:15:21:306 SGT] 00000030 SystemErr R at org.apache.stru ts.chain.comman ds.AbstractExec uteAction.execu te(AbstractExec uteAction.java: 64)
[9/27/10 11:15:21:306 SGT] 00000030 SystemErr R at org.apache.stru ts.chain.comman ds.ActionComman dBase.execute(A ctionCommandBas e.java:48)
[9/27/10 11:15:21:306 SGT] 00000030 SystemErr R at org.apache.comm ons.chain.impl. ChainBase.execu te(ChainBase.ja va:190)
[9/27/10 11:15:21:306 SGT] 00000030 SystemErr R at org.apache.comm ons.chain.gener ic.LookupComman d.execute(Looku pCommand.java:3 04)
[9/27/10 11:15:21:306 SGT] 00000030 SystemErr R at org.apache.comm ons.chain.impl. ChainBase.execu te(ChainBase.ja va:190)
[9/27/10 11:15:21:306 SGT] 00000030 SystemErr R at org.apache.stru ts.chain.Compos ableRequestProc essor.process(C omposableReques tProcessor.java :280)
[9/27/10 11:15:21:306 SGT] 00000030 SystemErr R at org.apache.stru ts.action.Actio nServlet.proces s(ActionServlet .java:1858)
[9/27/10 11:15:21:322 SGT] 00000030 SystemErr R at org.apache.stru ts.action.Actio nServlet.doPost (ActionServlet. java:459)
[9/27/10 11:15:21:322 SGT] 00000030 SystemErr R at javax.servlet.h ttp.HttpServlet .service(HttpSe rvlet.java:763)
[9/27/10 11:15:21:322 SGT] 00000030 SystemErr R at javax.servlet.h ttp.HttpServlet .service(HttpSe rvlet.java:856)
[9/27/10 11:15:21:322 SGT] 00000030 SystemErr R at com.ibm.ws.webc ontainer.servle t.ServletWrappe r.service(Servl etWrapper.java: 1212)
[9/27/10 11:15:21:322 SGT] 00000030 SystemErr R at com.ibm.ws.webc ontainer.servle t.ServletWrappe r.handleRequest (ServletWrapper .java:629)
[9/27/10 11:15:21:322 SGT] 00000030 SystemErr R at com.ibm.ws.webc ontainer.webapp .WebApp.handleR equest(WebApp.j ava:2837)
[9/27/10 11:15:21:322 SGT] 00000030 SystemErr R at com.ibm.ws.webc ontainer.webapp .WebGroup.handl eRequest(WebGro up.java:220)
[9/27/10 11:15:21:322 SGT] 00000030 SystemErr R at com.ibm.ws.webc ontainer.Virtua lHost.handleReq uest(VirtualHos t.java:204)
[9/27/10 11:15:21:322 SGT] 00000030 SystemErr R at com.ibm.ws.webc ontainer.WebCon tainer.handleRe quest(WebContai ner.java:1681)
[9/27/10 11:15:21:322 SGT] 00000030 SystemErr R at com.ibm.ws.webc ontainer.channe l.WCChannelLink .ready(WCChanne lLink.java:77)
[9/27/10 11:15:21:322 SGT] 00000030 SystemErr R at com.ibm.ws.http .channel.inboun d.impl.HttpInbo undLink.handleD iscrimination(H ttpInboundLink. java:421)
[9/27/10 11:15:21:322 SGT] 00000030 SystemErr R at com.ibm.ws.http .channel.inboun d.impl.HttpInbo undLink.handleN ewInformation(H ttpInboundLink. java:367)
[9/27/10 11:15:21:322 SGT] 00000030 SystemErr R at com.ibm.ws.http .channel.inboun d.impl.HttpICLR eadCallback.com plete(HttpICLRe adCallback.java :94)
[9/27/10 11:15:21:322 SGT] 00000030 SystemErr R at com.ibm.ws.tcp. channel.impl.Wo rkQueueManager. requestComplete (WorkQueueManag er.java:548)
[9/27/10 11:15:21:322 SGT] 00000030 SystemErr R at com.ibm.ws.tcp. channel.impl.Wo rkQueueManager. attemptIO(WorkQ ueueManager.jav a:601)
[9/27/10 11:15:21:322 SGT] 00000030 SystemErr R at com.ibm.ws.tcp. channel.impl.Wo rkQueueManager. workerRun(WorkQ ueueManager.jav a:934)
[9/27/10 11:15:21:322 SGT] 00000030 SystemErr R at com.ibm.ws.tcp. channel.impl.Wo rkQueueManager$ Worker.run(Work QueueManager.ja va:1021)
[9/27/10 11:15:21:322 SGT] 00000030 SystemErr R at com.ibm.ws.util .ThreadPool$Wor ker.run(ThreadP ool.java:1332)

Here's the codes:

public ActionForward performPost(ActionMapping mapping, ActionForm form,
			HttpServletRequest request, HttpServletResponse response)
			throws java.io.IOException, javax.servlet.ServletException{
		ActionErrors errors = new ActionErrors();
   		ActionForward forward = new ActionForward();  // return value
   		HttpSession httpSession = request.getSession();
   		MESSession session = (MESSession) httpSession.getAttribute(DCMSConstants.DCMSConstants_MESSESSION);
   		XcBO xcbo = new XcBO(session);
   		try{
   			XcForm xcForm = (XcForm) form;  
   			BeanUtils.copyProperties(xcbo,xcForm);
   			if(xcForm.getHiddenPrint()!= null)
   			{
   				xcbo.repodataForUpdatePage();
   			}
   			else
   			xcbo.retriveRepoData();
   		String fdigi=xcbo.getFile_no().substring(xcbo.getFile_no().length()-1);
   		String sdigi=xcbo.getFile_no().substring(xcbo.getFile_no().length()-3,xcbo.getFile_no().length()-1);
   		String tdigi=xcbo.getFile_no().substring(0,xcbo.getFile_no().length()-3);
   	    String userId = getUserIdInSession( request );
   		IOnlineListGenerator generator = OnlineListFactory.lookupGenerator("xc18report");
   		String[] multivalue=null;
   		if(xcForm.getHiddenPrint()!= null)
   		{
   		}
   		else
   		 multivalue=xcForm.getFileArr();
//   		System.out.println("it ref no"+xcbo.getIt_ref_no());
   	    Map inputData = new HashMap(); 
   	    //parameter required for date list
//   	    inputData.put("file_type",xcbo.getFile_type());
//   	    inputData.put("instyear",xcbo.getInstall_year());
//   	    inputData.put("instmonth",xcbo.getInstall_month());
   	     // //System.out.println("year length.........."+xcbo.getAssmt_year().length);
   	    inputData.put("yeararr",xcbo.getAssmt_year());
   	    //parameter for date list
   	    if(xcForm.getHiddenPrint()!= null)
		{
   	    	inputData.put("print","print");
   	    	inputData.put("fileNo",xcForm.getFile_no());
   	    	inputData.put("taxpayer_key",xcForm.getTaxpayer_key());
   	    	inputData.put("status",xcForm.getStatus());
   	    	inputData.put("year",xcForm.getInstall_year());
   	    	inputData.put("month",xcForm.getInstall_month());
   	    	inputData.put("filetype",xcForm.getFile_type());
   	    	inputData.put("taxtype_key",xcForm.getTaxtype_key());
   	    	inputData.put("it_ref_no",xcbo.getIt_ref_no());
		}
   	    else
        {
   	    	inputData.put("multivalue",multivalue[0]);
   	    	inputData.put("print","selectPrint");
        }
        inputData.put("newic",xcbo.getNew_ic_no());
        inputData.put("name",xcbo.getTaxpayer_name());
        inputData.put("add1ra",xcbo.getRa_address_line1());
        inputData.put("add2ra",xcbo.getRa_address_line2());
        inputData.put("add3ra",xcbo.getRa_address_line3());
        inputData.put("cityra",xcbo.getRa_city());
        inputData.put("statera",xcbo.getRa_state());
        inputData.put("posra",xcbo.getRa_postcode());
        inputData.put("proffkod",xcbo.getProfession_code());
        inputData.put("empname",xcbo.getEmployer_name());
        inputData.put("add1re",xcbo.getRe_address_line1());
        inputData.put("add2re",xcbo.getRe_address_line2());
        inputData.put("add3re",xcbo.getRe_address_line3());
        inputData.put("cityre",xcbo.getRe_city());
        inputData.put("statere",xcbo.getRe_state());
        inputData.put("posre",xcbo.getRe_postcode());
        inputData.put("offpre",xcbo.getOfficer_prepare());
        inputData.put("datpre",xcbo.getDate_prepare());
        inputData.put("offapp",xcbo.getOfficer_approve());
        inputData.put("datapp",xcbo.getDate_approve());
        inputData.put("creby",xcbo.getCrt_by());
        inputData.put("creon",xcbo.getCrt_on());
        inputData.put("totpaid",xcbo.getTotal_paid_amount());
        inputData.put("totnetbal",xcbo.getTotal_net_balance_amount());
        inputData.put("totbal",xcbo.getTotal_balance());
        inputData.put("fdig",fdigi);
        inputData.put("sdig",sdigi);
        inputData.put("tdig",tdigi);
        inputData.put("filetype_category",xcbo.getFile_category());
        JasperPrint jasperPrint = generator.process("xc18report",userId,inputData);
        ReportWebUtil.viewPdfReport(response, jasperPrint, "xc18report");
       // ReportWebUtil.viewPdfReport(response,"xc18report");
   		}catch(Exception e)
		{
   			e.printStackTrace();
   		}
   		
     
      
    
		return null;
	}
}