473,461 Members | 1,844 Online
Bytes | Software Development & Data Engineering Community
Create Post

Home Posts Topics Members FAQ

No input source supplied to the exporter.

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:42)
[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.executeQuery(sf.java:491)
[9/27/10 11:14:37:764 SGT] 00000030 SystemErr R at net.sf.jasperreports.engine.query.JRJdbcQueryExecu ter.createDatasource(JRJdbcQueryExecuter.java:115)
[9/27/10 11:14:37:764 SGT] 00000030 SystemErr R at net.sf.jasperreports.engine.fill.JRFillDataset.cre ateQueryDatasource(JRFillDataset.java:665)
[9/27/10 11:14:37:764 SGT] 00000030 SystemErr R at net.sf.jasperreports.engine.fill.JRFillDataset.set Datasource(JRFillDataset.java:609)
[9/27/10 11:14:37:764 SGT] 00000030 SystemErr R at net.sf.jasperreports.engine.fill.JRFillDataset.set ParameterValues(JRFillDataset.java:598)
[9/27/10 11:14:37:780 SGT] 00000030 SystemErr R at net.sf.jasperreports.engine.fill.JRBaseFiller.setP arameters(JRBaseFiller.java:879)
[9/27/10 11:14:37:780 SGT] 00000030 SystemErr R at net.sf.jasperreports.engine.fill.JRBaseFiller.fill (JRBaseFiller.java:708)
[9/27/10 11:14:37:780 SGT] 00000030 SystemErr R at net.sf.jasperreports.engine.fill.JRBaseFiller.fill (JRBaseFiller.java:666)
[9/27/10 11:14:37:780 SGT] 00000030 SystemErr R at net.sf.jasperreports.engine.fill.JRFillSubreport.f illSubreport(JRFillSubreport.java:494)
[9/27/10 11:14:37:780 SGT] 00000030 SystemErr R at net.sf.jasperreports.engine.fill.JRSubreportRunnab le.run(JRSubreportRunnable.java:63)
[9/27/10 11:14:37:780 SGT] 00000030 SystemErr R at net.sf.jasperreports.engine.fill.JRThreadSubreport Runner.run(JRThreadSubreportRunner.java:137)
[9/27/10 11:14:37:780 SGT] 00000030 SystemErr R at java.lang.Thread.run(Thread.java: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.jasperreports.engine.JRException: No input source supplied to the exporter.
[9/27/10 11:15:21:306 SGT] 00000030 SystemErr R at net.sf.jasperreports.engine.JRAbstractExporter.set Input(JRAbstractExporter.java)
[9/27/10 11:15:21:306 SGT] 00000030 SystemErr R at net.sf.jasperreports.engine.export.JRPdfExporter.e xportReport(JRPdfExporter.java)
[9/27/10 11:15:21:306 SGT] 00000030 SystemErr R at my.org.hasil.dcms.report.web.ReportWebUtil.viewPdf Report(ReportWebUtil.java)
[9/27/10 11:15:21:306 SGT] 00000030 SystemErr R at my.org.hasil.dcms.grq.web.XcAction.performPost(XcA ction.java)
[9/27/10 11:15:21:306 SGT] 00000030 SystemErr R at sun.reflect.NativeMethodAccessorImpl.invoke0(Nativ e Method)
[9/27/10 11:15:21:306 SGT] 00000030 SystemErr R at sun.reflect.NativeMethodAccessorImpl.invoke(Native MethodAccessorImpl.java:85)
[9/27/10 11:15:21:306 SGT] 00000030 SystemErr R at sun.reflect.NativeMethodAccessorImpl.invoke(Native MethodAccessorImpl.java:58)
[9/27/10 11:15:21:306 SGT] 00000030 SystemErr R at sun.reflect.DelegatingMethodAccessorImpl.invoke(De legatingMethodAccessorImpl.java:60)
[9/27/10 11:15:21:306 SGT] 00000030 SystemErr R at java.lang.reflect.Method.invoke(Method.java:391)
[9/27/10 11:15:21:306 SGT] 00000030 SystemErr R at my.com.mesiniaga.web.CommonAction.execute(CommonAc tion.java:176)
[9/27/10 11:15:21:306 SGT] 00000030 SystemErr R at org.apache.struts.chain.commands.servlet.ExecuteAc tion.execute(ExecuteAction.java:53)
[9/27/10 11:15:21:306 SGT] 00000030 SystemErr R at org.apache.struts.chain.commands.AbstractExecuteAc tion.execute(AbstractExecuteAction.java:64)
[9/27/10 11:15:21:306 SGT] 00000030 SystemErr R at org.apache.struts.chain.commands.ActionCommandBase .execute(ActionCommandBase.java:48)
[9/27/10 11:15:21:306 SGT] 00000030 SystemErr R at org.apache.commons.chain.impl.ChainBase.execute(Ch ainBase.java:190)
[9/27/10 11:15:21:306 SGT] 00000030 SystemErr R at org.apache.commons.chain.generic.LookupCommand.exe cute(LookupCommand.java:304)
[9/27/10 11:15:21:306 SGT] 00000030 SystemErr R at org.apache.commons.chain.impl.ChainBase.execute(Ch ainBase.java:190)
[9/27/10 11:15:21:306 SGT] 00000030 SystemErr R at org.apache.struts.chain.ComposableRequestProcessor .process(ComposableRequestProcessor.java:280)
[9/27/10 11:15:21:306 SGT] 00000030 SystemErr R at org.apache.struts.action.ActionServlet.process(Act ionServlet.java:1858)
[9/27/10 11:15:21:322 SGT] 00000030 SystemErr R at org.apache.struts.action.ActionServlet.doPost(Acti onServlet.java:459)
[9/27/10 11:15:21:322 SGT] 00000030 SystemErr R at javax.servlet.http.HttpServlet.service(HttpServlet .java:763)
[9/27/10 11:15:21:322 SGT] 00000030 SystemErr R at javax.servlet.http.HttpServlet.service(HttpServlet .java:856)
[9/27/10 11:15:21:322 SGT] 00000030 SystemErr R at com.ibm.ws.webcontainer.servlet.ServletWrapper.ser vice(ServletWrapper.java:1212)
[9/27/10 11:15:21:322 SGT] 00000030 SystemErr R at com.ibm.ws.webcontainer.servlet.ServletWrapper.han dleRequest(ServletWrapper.java:629)
[9/27/10 11:15:21:322 SGT] 00000030 SystemErr R at com.ibm.ws.webcontainer.webapp.WebApp.handleReques t(WebApp.java:2837)
[9/27/10 11:15:21:322 SGT] 00000030 SystemErr R at com.ibm.ws.webcontainer.webapp.WebGroup.handleRequ est(WebGroup.java:220)
[9/27/10 11:15:21:322 SGT] 00000030 SystemErr R at com.ibm.ws.webcontainer.VirtualHost.handleRequest( VirtualHost.java:204)
[9/27/10 11:15:21:322 SGT] 00000030 SystemErr R at com.ibm.ws.webcontainer.WebContainer.handleRequest (WebContainer.java:1681)
[9/27/10 11:15:21:322 SGT] 00000030 SystemErr R at com.ibm.ws.webcontainer.channel.WCChannelLink.read y(WCChannelLink.java:77)
[9/27/10 11:15:21:322 SGT] 00000030 SystemErr R at com.ibm.ws.http.channel.inbound.impl.HttpInboundLi nk.handleDiscrimination(HttpInboundLink.java:421)
[9/27/10 11:15:21:322 SGT] 00000030 SystemErr R at com.ibm.ws.http.channel.inbound.impl.HttpInboundLi nk.handleNewInformation(HttpInboundLink.java:367)
[9/27/10 11:15:21:322 SGT] 00000030 SystemErr R at com.ibm.ws.http.channel.inbound.impl.HttpICLReadCa llback.complete(HttpICLReadCallback.java:94)
[9/27/10 11:15:21:322 SGT] 00000030 SystemErr R at com.ibm.ws.tcp.channel.impl.WorkQueueManager.reque stComplete(WorkQueueManager.java:548)
[9/27/10 11:15:21:322 SGT] 00000030 SystemErr R at com.ibm.ws.tcp.channel.impl.WorkQueueManager.attem ptIO(WorkQueueManager.java:601)
[9/27/10 11:15:21:322 SGT] 00000030 SystemErr R at com.ibm.ws.tcp.channel.impl.WorkQueueManager.worke rRun(WorkQueueManager.java:934)
[9/27/10 11:15:21:322 SGT] 00000030 SystemErr R at com.ibm.ws.tcp.channel.impl.WorkQueueManager$Worke r.run(WorkQueueManager.java:1021)
[9/27/10 11:15:21:322 SGT] 00000030 SystemErr R at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.j ava:1332)

Here's the codes:

Expand|Select|Wrap|Line Numbers
  1. public ActionForward performPost(ActionMapping mapping, ActionForm form,
  2.             HttpServletRequest request, HttpServletResponse response)
  3.             throws java.io.IOException, javax.servlet.ServletException{
  4.         ActionErrors errors = new ActionErrors();
  5.            ActionForward forward = new ActionForward();  // return value
  6.            HttpSession httpSession = request.getSession();
  7.            MESSession session = (MESSession) httpSession.getAttribute(DCMSConstants.DCMSConstants_MESSESSION);
  8.            XcBO xcbo = new XcBO(session);
  9.            try{
  10.                XcForm xcForm = (XcForm) form;  
  11.                BeanUtils.copyProperties(xcbo,xcForm);
  12.                if(xcForm.getHiddenPrint()!= null)
  13.                {
  14.                    xcbo.repodataForUpdatePage();
  15.                }
  16.                else
  17.                xcbo.retriveRepoData();
  18.            String fdigi=xcbo.getFile_no().substring(xcbo.getFile_no().length()-1);
  19.            String sdigi=xcbo.getFile_no().substring(xcbo.getFile_no().length()-3,xcbo.getFile_no().length()-1);
  20.            String tdigi=xcbo.getFile_no().substring(0,xcbo.getFile_no().length()-3);
  21.            String userId = getUserIdInSession( request );
  22.            IOnlineListGenerator generator = OnlineListFactory.lookupGenerator("xc18report");
  23.            String[] multivalue=null;
  24.            if(xcForm.getHiddenPrint()!= null)
  25.            {
  26.            }
  27.            else
  28.             multivalue=xcForm.getFileArr();
  29. //           System.out.println("it ref no"+xcbo.getIt_ref_no());
  30.            Map inputData = new HashMap(); 
  31.            //parameter required for date list
  32. //           inputData.put("file_type",xcbo.getFile_type());
  33. //           inputData.put("instyear",xcbo.getInstall_year());
  34. //           inputData.put("instmonth",xcbo.getInstall_month());
  35.             // //System.out.println("year length.........."+xcbo.getAssmt_year().length);
  36.            inputData.put("yeararr",xcbo.getAssmt_year());
  37.            //parameter for date list
  38.            if(xcForm.getHiddenPrint()!= null)
  39.         {
  40.                inputData.put("print","print");
  41.                inputData.put("fileNo",xcForm.getFile_no());
  42.                inputData.put("taxpayer_key",xcForm.getTaxpayer_key());
  43.                inputData.put("status",xcForm.getStatus());
  44.                inputData.put("year",xcForm.getInstall_year());
  45.                inputData.put("month",xcForm.getInstall_month());
  46.                inputData.put("filetype",xcForm.getFile_type());
  47.                inputData.put("taxtype_key",xcForm.getTaxtype_key());
  48.                inputData.put("it_ref_no",xcbo.getIt_ref_no());
  49.         }
  50.            else
  51.         {
  52.                inputData.put("multivalue",multivalue[0]);
  53.                inputData.put("print","selectPrint");
  54.         }
  55.         inputData.put("newic",xcbo.getNew_ic_no());
  56.         inputData.put("name",xcbo.getTaxpayer_name());
  57.         inputData.put("add1ra",xcbo.getRa_address_line1());
  58.         inputData.put("add2ra",xcbo.getRa_address_line2());
  59.         inputData.put("add3ra",xcbo.getRa_address_line3());
  60.         inputData.put("cityra",xcbo.getRa_city());
  61.         inputData.put("statera",xcbo.getRa_state());
  62.         inputData.put("posra",xcbo.getRa_postcode());
  63.         inputData.put("proffkod",xcbo.getProfession_code());
  64.         inputData.put("empname",xcbo.getEmployer_name());
  65.         inputData.put("add1re",xcbo.getRe_address_line1());
  66.         inputData.put("add2re",xcbo.getRe_address_line2());
  67.         inputData.put("add3re",xcbo.getRe_address_line3());
  68.         inputData.put("cityre",xcbo.getRe_city());
  69.         inputData.put("statere",xcbo.getRe_state());
  70.         inputData.put("posre",xcbo.getRe_postcode());
  71.         inputData.put("offpre",xcbo.getOfficer_prepare());
  72.         inputData.put("datpre",xcbo.getDate_prepare());
  73.         inputData.put("offapp",xcbo.getOfficer_approve());
  74.         inputData.put("datapp",xcbo.getDate_approve());
  75.         inputData.put("creby",xcbo.getCrt_by());
  76.         inputData.put("creon",xcbo.getCrt_on());
  77.         inputData.put("totpaid",xcbo.getTotal_paid_amount());
  78.         inputData.put("totnetbal",xcbo.getTotal_net_balance_amount());
  79.         inputData.put("totbal",xcbo.getTotal_balance());
  80.         inputData.put("fdig",fdigi);
  81.         inputData.put("sdig",sdigi);
  82.         inputData.put("tdig",tdigi);
  83.         inputData.put("filetype_category",xcbo.getFile_category());
  84.         JasperPrint jasperPrint = generator.process("xc18report",userId,inputData);
  85.         ReportWebUtil.viewPdfReport(response, jasperPrint, "xc18report");
  86.        // ReportWebUtil.viewPdfReport(response,"xc18report");
  87.            }catch(Exception e)
  88.         {
  89.                e.printStackTrace();
  90.            }
  91.  
  92.  
  93.  
  94.  
  95.         return null;
  96.     }
  97. }
  98.  
Sep 27 '10 #1
0 1824

Sign in to post your reply or Sign up for a free account.

Similar topics

1
Input statement question
by: ron | last post by:
Hi, I'm still new at Python and have been away from programming for a number of years in general. I apologized in advance if this has been discussed extensively already. Is the input()...
Python
0
DXL exporter and VB.net
by: Jonathan | last post by:
Not sure if anyone can help me but thought it worth a try, as DXL is Domino XML Language. I am using VB .net to retrieve emails stored in a Domino journal database and then export them to hard...
.NET Framework
5
Input from a CSV file double quotation mark proglem
by: Gregg | last post by:
Hello all, I have been banging my head over a problem that I am having reading a comma seperated file (CSV) that can contain from 1 to 10,000 records. My code snipit is as follows: **Start...
.NET Framework
3
Linking Error, 3DS Max Exporter
by: mac | last post by:
Hey All: Here's my problem, I'm using VC++ in Studio 6 to write an exporter for 3D Studio max 7, so I'm learning the joys of writing a DLL, everything compiles ok but the following error is...
C / C++
0
Problem Hiding Generic Implementation from Type Library Exporter
by: Tom Z. | last post by:
Hi All, I'm trying to make an assembly in C# to use as a COM server. I'm building as normal and ruinning regasm at the end. Everything is generally working, except that I'm having a problem...
.NET Framework
7
how to update sqlj routine source in catalogs ?
by: Jean-Marc Blaise | last post by:
Hi, The dev center calls sqlj.DB2_UPDATEJARINFO ('JMARC.JMB','JMB','file:JMB.sqlj') to update the sqlj routine source. I tried in CLP from the directory containing jar and sqlj files (Windows...
DB2 Database
3
Check that input is supplied from a particular PC?
by: walterbyrd | last post by:
I am working on a timecard app. When somebody logs in, it stamps his/her time. Problem is, I have to make sure that somebody is not logging in from a remote site. I want all the logins from one...
PHP
13
Tidy transforms "&" in the source-xml into a "&"
by: Ragnar | last post by:
Hi, 2 issues left with my tidy-work: 1) Tidy transforms a "&amp;" in the source-xml into a "&" in the tidied version. My XML-Importer cannot handle it 2) in a long <title>-string a wrap is...
.NET Framework
1
Windows Vista browser input stream buffering, how to stop it?
by: coolsti | last post by:
I am having a curious problem with Vista working on a Lenovo thinkpad. To test and demonstrate this problem, I have a PHP script that does not terminate. It enters an infinite loop where it...
Microsoft Windows
4
Please Help - Undefined index & Invalid argument supplied for foreach()
by: mattehz | last post by:
Hey there, I am trying to upload old source files and came across these errors: Warning: Invalid argument supplied for foreach() in /home/mattehz/public_html/acssr/trunk/inc_html.php on line 59...
PHP
1
Looking to do Android software development, any suggestions? Is flutter better?
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
General
1
Is that possible of reading the .csv file in column wise and the column have different lengths ?
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
C / C++
0
How to build RAID in BIOS?
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
Computer Hardware
0
marktang
What is ONU?
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
General
0
Changing the language in Windows 10
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
Windows Server
1
The easy way to turn off automatic updates for Windows 10/11
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
Windows Server
0
tracyyun
Discussion: How does Zigbee compare with other wireless protocols in smart home applications?
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
General
0
agi2029
AI Job Threat for Devs
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
Career Advice
0
Trying to create a lan-to-lan vpn between two differents networks
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The...
Networking - Hardware / Configuration

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.

BYTES.COM © 2024
About Bytes
Terms Of Use
Privacy Policy
Sitemap
Advertise on Bytes:
Feedback Welcomed! Contact Us