Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: Displaying pentaho report with PDI as datasource [HELP]

  1. #1
    Join Date
    Sep 2016
    Posts
    23

    Angry Displaying pentaho report with PDI as datasource [HELP]

    hi.. i have a project with netbeans to display pentaho report,

    if for displaying report without any datasource [just text only], my report will show up / appear.

    but if my report use some parameter or PDI as datasource, my report is not show..

    this is my netbeans project, in this project already include pentaho library and prpt's file.

    https://drive.google.com/open?id=0B3...WkteW1mY2pEa0E

    this is my ktr's file where i use in pentaho report file.

    https://drive.google.com/open?id=0B3...UR1OTVFcWFnRlU




    this is the log.

    WARNING: Configured configuration-properties based override for global read-hander. Change your code to use proper module-initializers instead. This method of configuring the parser will go away in the next major version.org.pentaho.reporting.libraries.resourceloader.ResourceCreationException: Unable to parse the document: ResourceKey{schema=org.pentaho.reporting.libraries.docbundle.bundleloader.ZipResourceBundleLoader, identifier=content.xml, factoryParameters={org.pentaho.reporting.libraries.resourceloader.FactoryParameterKey{name=repository}=org.pentaho.reporting.libraries.repository.zipreader.ZipReadRepository@43f1dc96, org.pentaho.reporting.libraries.resourceloader.FactoryParameterKey{name=repository-loader}=org.pentaho.reporting.libraries.docbundle.bundleloader.ZipResourceBundleLoader@3bc91eb3}, parent=ResourceKey{schema=org.pentaho.reporting.libraries.resourceloader.loader.URLResourceLoader, identifier=file:/C:/Users/User/Documents/NetBeansProjects/directprinting/build/classes/directprinting/invoicehalf_1.prpt, factoryParameters={}, parent=null}}
    at org.pentaho.reporting.libraries.xmlns.parser.AbstractXmlResourceFactory.create(AbstractXmlResourceFactory.java:250)
    at org.pentaho.reporting.libraries.resourceloader.DefaultResourceManagerBackend.create(DefaultResourceManagerBackend.java:273)
    at org.pentaho.reporting.libraries.resourceloader.ResourceManager.create(ResourceManager.java:419)
    at org.pentaho.reporting.libraries.resourceloader.ResourceManager.create(ResourceManager.java:378)
    at org.pentaho.reporting.libraries.resourceloader.ResourceManager.createDirectly(ResourceManager.java:214)
    at directprinting.Directprinting.getReportDefinition(Directprinting.java:94)
    at directprinting.Directprinting.getCompleteReportDefinition(Directprinting.java:57)
    at directprinting.Directprinting.main(Directprinting.java:38)
    Caused by: org.pentaho.reporting.libraries.xmlns.parser.ParseException: Failure while loading data: datadefinition.xml [Location: Line=5 Column=11]
    at org.pentaho.reporting.libraries.xmlns.parser.AbstractXmlReadHandler.performExternalParsing(AbstractXmlReadHandler.java:337)
    at org.pentaho.reporting.engine.classic.core.modules.parser.bundle.content.ContentRootElementHandler.parseDataDefinition(ContentRootElementHandler.java:376)
    at org.pentaho.reporting.engine.classic.core.modules.parser.bundle.content.ContentRootElementHandler.parseLocalFiles(ContentRootElementHandler.java:328)
    at org.pentaho.reporting.engine.classic.core.modules.parser.bundle.content.ContentRootElementHandler.doneParsing(ContentRootElementHandler.java:307)
    at org.pentaho.reporting.libraries.xmlns.parser.AbstractXmlReadHandler.endElement(AbstractXmlReadHandler.java:163)
    at org.pentaho.reporting.libraries.xmlns.parser.RootXmlReadHandler.endElement(RootXmlReadHandler.java:585)
    at com.sun.org.apache.xerces.internal.parsers.AbstractSAXParser.endElement(AbstractSAXParser.java:609)
    at com.sun.org.apache.xerces.internal.impl.XMLDocumentFragmentScannerImpl.scanEndElement(XMLDocumentFragmentScannerImpl.java:1782)
    at com.sun.org.apache.xerces.internal.impl.XMLDocumentFragmentScannerImpl$FragmentContentDriver.next(XMLDocumentFragmentScannerImpl.java:2973)
    at com.sun.org.apache.xerces.internal.impl.XMLDocumentScannerImpl.next(XMLDocumentScannerImpl.java:606)
    at com.sun.org.apache.xerces.internal.impl.XMLNSDocumentScannerImpl.next(XMLNSDocumentScannerImpl.java:117)
    at com.sun.org.apache.xerces.internal.impl.XMLDocumentFragmentScannerImpl.scanDocument(XMLDocumentFragmentScannerImpl.java:510)
    at com.sun.org.apache.xerces.internal.parsers.XML11Configuration.parse(XML11Configuration.java:848)
    at com.sun.org.apache.xerces.internal.parsers.XML11Configuration.parse(XML11Configuration.java:777)
    at com.sun.org.apache.xerces.internal.parsers.XMLParser.parse(XMLParser.java:141)
    at com.sun.org.apache.xerces.internal.parsers.AbstractSAXParser.parse(AbstractSAXParser.java:1213)
    at com.sun.org.apache.xerces.internal.jaxp.SAXParserImpl$JAXPSAXParser.parse(SAXParserImpl.java:648)
    at org.pentaho.reporting.libraries.xmlns.parser.AbstractXmlResourceFactory.create(AbstractXmlResourceFactory.java:237)
    ... 7 more
    Caused by: org.pentaho.reporting.libraries.resourceloader.ResourceCreationException: Unable to parse the document: ResourceKey{schema=org.pentaho.reporting.libraries.docbundle.bundleloader.ZipResourceBundleLoader, identifier=datadefinition.xml, factoryParameters={org.pentaho.reporting.libraries.resourceloader.FactoryParameterKey{name=repository}=org.pentaho.reporting.libraries.repository.zipreader.ZipReadRepository@43f1dc96, org.pentaho.reporting.libraries.resourceloader.FactoryParameterKey{name=::Report}=null, org.pentaho.reporting.libraries.resourceloader.FactoryParameterKey{name=prpt-spec-version}=5003000, org.pentaho.reporting.libraries.resourceloader.FactoryParameterKey{name=repository-loader}=org.pentaho.reporting.libraries.docbundle.bundleloader.ZipResourceBundleLoader@3bc91eb3, org.pentaho.reporting.libraries.resourceloader.FactoryParameterKey{name=property-expansion}=false}, parent=ResourceKey{schema=org.pentaho.reporting.libraries.resourceloader.loader.URLResourceLoader, identifier=file:/C:/Users/User/Documents/NetBeansProjects/directprinting/build/classes/directprinting/invoicehalf_1.prpt, factoryParameters={}, parent=null}}
    at org.pentaho.reporting.libraries.xmlns.parser.AbstractXmlResourceFactory.create(AbstractXmlResourceFactory.java:250)
    at org.pentaho.reporting.libraries.resourceloader.DefaultResourceManagerBackend.create(DefaultResourceManagerBackend.java:273)
    at org.pentaho.reporting.libraries.docbundle.BundleResourceManagerBackend.create(BundleResourceManagerBackend.java:168)
    at org.pentaho.reporting.libraries.resourceloader.ResourceManager.create(ResourceManager.java:419)
    at org.pentaho.reporting.libraries.resourceloader.ResourceManager.create(ResourceManager.java:378)
    at org.pentaho.reporting.libraries.xmlns.parser.AbstractXmlReadHandler.performExternalParsing(AbstractXmlReadHandler.java:327)
    ... 24 more
    Caused by: org.pentaho.reporting.libraries.xmlns.parser.ParseException: Failure while loading data: datasources/compound-ds.xml [Location: Line=27 Column=96]
    at org.pentaho.reporting.libraries.xmlns.parser.AbstractXmlReadHandler.performExternalParsing(AbstractXmlReadHandler.java:337)
    at org.pentaho.reporting.libraries.xmlns.parser.AbstractXmlReadHandler.performExternalParsing(AbstractXmlReadHandler.java:300)
    at org.pentaho.reporting.engine.classic.core.modules.parser.bundle.data.DataSourceElementHandler.startParsing(DataSourceElementHandler.java:73)
    at org.pentaho.reporting.libraries.xmlns.parser.AbstractXmlReadHandler.startElement(AbstractXmlReadHandler.java:116)
    at org.pentaho.reporting.libraries.xmlns.parser.RootXmlReadHandler.recurse(RootXmlReadHandler.java:329)
    at org.pentaho.reporting.libraries.xmlns.parser.AbstractXmlReadHandler.startElement(AbstractXmlReadHandler.java:133)
    at org.pentaho.reporting.libraries.xmlns.parser.RootXmlReadHandler.startElement(RootXmlReadHandler.java:468)
    at com.sun.org.apache.xerces.internal.parsers.AbstractSAXParser.startElement(AbstractSAXParser.java:509)
    at com.sun.org.apache.xerces.internal.parsers.AbstractXMLDocumentParser.emptyElement(AbstractXMLDocumentParser.java:182)
    at com.sun.org.apache.xerces.internal.impl.XMLNSDocumentScannerImpl.scanStartElement(XMLNSDocumentScannerImpl.java:356)
    at com.sun.org.apache.xerces.internal.impl.XMLDocumentFragmentScannerImpl$FragmentContentDriver.next(XMLDocumentFragmentScannerImpl.java:2786)
    at com.sun.org.apache.xerces.internal.impl.XMLDocumentScannerImpl.next(XMLDocumentScannerImpl.java:606)
    at com.sun.org.apache.xerces.internal.impl.XMLNSDocumentScannerImpl.next(XMLNSDocumentScannerImpl.java:117)
    at com.sun.org.apache.xerces.internal.impl.XMLDocumentFragmentScannerImpl.scanDocument(XMLDocumentFragmentScannerImpl.java:510)
    at com.sun.org.apache.xerces.internal.parsers.XML11Configuration.parse(XML11Configuration.java:848)
    at com.sun.org.apache.xerces.internal.parsers.XML11Configuration.parse(XML11Configuration.java:777)
    at com.sun.org.apache.xerces.internal.parsers.XMLParser.parse(XMLParser.java:141)
    at com.sun.org.apache.xerces.internal.parsers.AbstractSAXParser.parse(AbstractSAXParser.java:1213)
    at com.sun.org.apache.xerces.internal.jaxp.SAXParserImpl$JAXPSAXParser.parse(SAXParserImpl.java:648)
    at org.pentaho.reporting.libraries.xmlns.parser.AbstractXmlResourceFactory.create(AbstractXmlResourceFactory.java:237)
    ... 29 more
    Caused by: org.pentaho.reporting.libraries.resourceloader.ResourceCreationException: Unable to parse the document: ResourceKey{schema=org.pentaho.reporting.libraries.docbundle.bundleloader.ZipResourceBundleLoader, identifier=datasources/compound-ds.xml, factoryParameters={org.pentaho.reporting.libraries.resourceloader.FactoryParameterKey{name=repository}=org.pentaho.reporting.libraries.repository.zipreader.ZipReadRepository@43f1dc96, org.pentaho.reporting.libraries.resourceloader.FactoryParameterKey{name=::Report}=null, org.pentaho.reporting.libraries.resourceloader.FactoryParameterKey{name=prpt-spec-version}=5003000, org.pentaho.reporting.libraries.resourceloader.FactoryParameterKey{name=repository-loader}=org.pentaho.reporting.libraries.docbundle.bundleloader.ZipResourceBundleLoader@3bc91eb3, org.pentaho.reporting.libraries.resourceloader.FactoryParameterKey{name=property-expansion}=false}, parent=ResourceKey{schema=org.pentaho.reporting.libraries.resourceloader.loader.URLResourceLoader, identifier=file:/C:/Users/User/Documents/NetBeansProjects/directprinting/build/classes/directprinting/invoicehalf_1.prpt, factoryParameters={}, parent=null}}
    at org.pentaho.reporting.libraries.xmlns.parser.AbstractXmlResourceFactory.create(AbstractXmlResourceFactory.java:250)
    at org.pentaho.reporting.libraries.resourceloader.DefaultResourceManagerBackend.create(DefaultResourceManagerBackend.java:273)
    at org.pentaho.reporting.libraries.docbundle.BundleResourceManagerBackend.create(BundleResourceManagerBackend.java:168)
    at org.pentaho.reporting.libraries.docbundle.BundleResourceManagerBackend.create(BundleResourceManagerBackend.java:168)
    at org.pentaho.reporting.libraries.resourceloader.ResourceManager.create(ResourceManager.java:419)
    at org.pentaho.reporting.libraries.resourceloader.ResourceManager.create(ResourceManager.java:378)
    at org.pentaho.reporting.libraries.xmlns.parser.AbstractXmlReadHandler.performExternalParsing(AbstractXmlReadHandler.java:327)
    ... 48 more
    Caused by: org.pentaho.reporting.libraries.xmlns.parser.ParseException: Unable to parse resource for ResourceKey{schema=org.pentaho.reporting.libraries.docbundle.bundleloader.ZipResourceBundleLoader, identifier=datasources/compound-ds.xml, factoryParameters={org.pentaho.reporting.libraries.resourceloader.FactoryParameterKey{name=repository}=org.pentaho.reporting.libraries.repository.zipreader.ZipReadRepository@43f1dc96, org.pentaho.reporting.libraries.resourceloader.FactoryParameterKey{name=::Report}=null, org.pentaho.reporting.libraries.resourceloader.FactoryParameterKey{name=prpt-spec-version}=5003000, org.pentaho.reporting.libraries.resourceloader.FactoryParameterKey{name=repository-loader}=org.pentaho.reporting.libraries.docbundle.bundleloader.ZipResourceBundleLoader@3bc91eb3, org.pentaho.reporting.libraries.resourceloader.FactoryParameterKey{name=property-expansion}=false}, parent=ResourceKey{schema=org.pentaho.reporting.libraries.resourceloader.loader.URLResourceLoader, identifier=file:/C:/Users/User/Documents/NetBeansProjects/directprinting/build/classes/directprinting/invoicehalf_1.prpt, factoryParameters={}, parent=null}} and kettle-ds.xml [Location: Line=2 Column=44]
    at org.pentaho.reporting.engine.classic.core.modules.parser.base.common.DataFactoryRefReadHandler.startParsing(DataFactoryRefReadHandler.java:73)
    at org.pentaho.reporting.engine.classic.core.modules.parser.base.common.AbstractPropertyXmlReadHandler.startParsing(AbstractPropertyXmlReadHandler.java:66)
    at org.pentaho.reporting.libraries.xmlns.parser.AbstractXmlReadHandler.startElement(AbstractXmlReadHandler.java:116)
    at org.pentaho.reporting.libraries.xmlns.parser.RootXmlReadHandler.recurse(RootXmlReadHandler.java:329)
    at org.pentaho.reporting.libraries.xmlns.parser.AbstractXmlReadHandler.startElement(AbstractXmlReadHandler.java:133)
    at org.pentaho.reporting.libraries.xmlns.parser.RootXmlReadHandler.startElement(RootXmlReadHandler.java:468)
    at com.sun.org.apache.xerces.internal.parsers.AbstractSAXParser.startElement(AbstractSAXParser.java:509)
    at com.sun.org.apache.xerces.internal.parsers.AbstractXMLDocumentParser.emptyElement(AbstractXMLDocumentParser.java:182)
    at com.sun.org.apache.xerces.internal.impl.XMLNSDocumentScannerImpl.scanStartElement(XMLNSDocumentScannerImpl.java:356)
    at com.sun.org.apache.xerces.internal.impl.XMLDocumentFragmentScannerImpl$FragmentContentDriver.next(XMLDocumentFragmentScannerImpl.java:2786)
    at com.sun.org.apache.xerces.internal.impl.XMLDocumentScannerImpl.next(XMLDocumentScannerImpl.java:606)
    at com.sun.org.apache.xerces.internal.impl.XMLNSDocumentScannerImpl.next(XMLNSDocumentScannerImpl.java:117)
    at com.sun.org.apache.xerces.internal.impl.XMLDocumentFragmentScannerImpl.scanDocument(XMLDocumentFragmentScannerImpl.java:510)
    at com.sun.org.apache.xerces.internal.parsers.XML11Configuration.parse(XML11Configuration.java:848)
    at com.sun.org.apache.xerces.internal.parsers.XML11Configuration.parse(XML11Configuration.java:777)
    at com.sun.org.apache.xerces.internal.parsers.XMLParser.parse(XMLParser.java:141)
    at com.sun.org.apache.xerces.internal.parsers.AbstractSAXParser.parse(AbstractSAXParser.java:1213)
    at com.sun.org.apache.xerces.internal.jaxp.SAXParserImpl$JAXPSAXParser.parse(SAXParserImpl.java:648)
    at org.pentaho.reporting.libraries.xmlns.parser.AbstractXmlResourceFactory.create(AbstractXmlResourceFactory.java:237)
    ... 54 more
    Caused by: org.pentaho.reporting.libraries.resourceloader.ResourceCreationException: Unable to parse the document: ResourceKey{schema=org.pentaho.reporting.libraries.docbundle.bundleloader.ZipResourceBundleLoader, identifier=datasources/kettle-ds.xml, factoryParameters={org.pentaho.reporting.libraries.resourceloader.FactoryParameterKey{name=repository}=org.pentaho.reporting.libraries.repository.zipreader.ZipReadRepository@43f1dc96, org.pentaho.reporting.libraries.resourceloader.FactoryParameterKey{name=prpt-spec-version}=5003000, org.pentaho.reporting.libraries.resourceloader.FactoryParameterKey{name=::Report}=null, org.pentaho.reporting.libraries.resourceloader.FactoryParameterKey{name=property-expansion}=false, org.pentaho.reporting.libraries.resourceloader.FactoryParameterKey{name=repository-loader}=org.pentaho.reporting.libraries.docbundle.bundleloader.ZipResourceBundleLoader@3bc91eb3}, parent=ResourceKey{schema=org.pentaho.reporting.libraries.resourceloader.loader.URLResourceLoader, identifier=file:/C:/Users/User/Documents/NetBeansProjects/directprinting/build/classes/directprinting/invoicehalf_1.prpt, factoryParameters={}, parent=null}}
    at org.pentaho.reporting.libraries.xmlns.parser.AbstractXmlResourceFactory.create(AbstractXmlResourceFactory.java:250)
    at org.pentaho.reporting.libraries.resourceloader.DefaultResourceManagerBackend.create(DefaultResourceManagerBackend.java:273)
    at org.pentaho.reporting.libraries.docbundle.BundleResourceManagerBackend.create(BundleResourceManagerBackend.java:168)
    at org.pentaho.reporting.libraries.docbundle.BundleResourceManagerBackend.create(BundleResourceManagerBackend.java:168)
    at org.pentaho.reporting.libraries.docbundle.BundleResourceManagerBackend.create(BundleResourceManagerBackend.java:168)
    at org.pentaho.reporting.libraries.resourceloader.ResourceManager.create(ResourceManager.java:419)
    at org.pentaho.reporting.libraries.resourceloader.ResourceManager.create(ResourceManager.java:378)
    at org.pentaho.reporting.engine.classic.core.modules.parser.base.common.DataFactoryRefReadHandler.startParsing(DataFactoryRefReadHandler.java:63)
    ... 72 more
    Caused by: org.pentaho.reporting.libraries.xmlns.parser.NoRootHandlerException: No suitable root handler known for this document: XmlDocumentInfo={rootElementTag=kettle-datasource, rootElementNS=http://jfreereport.sourceforge.net/namespaces/datasources/kettle, SystemDTD-ID=null, PublicDTD-ID=null, defaultnamespace=} [Location: Line=-1 Column=-1]
    at org.pentaho.reporting.libraries.xmlns.parser.MultiplexRootElementHandler.interceptFirstStartElement(MultiplexRootElementHandler.java:217)
    at org.pentaho.reporting.libraries.xmlns.parser.RootXmlReadHandler.startElement(RootXmlReadHandler.java:429)
    at com.sun.org.apache.xerces.internal.parsers.AbstractSAXParser.startElement(AbstractSAXParser.java:509)
    at com.sun.org.apache.xerces.internal.impl.XMLNSDocumentScannerImpl.scanStartElement(XMLNSDocumentScannerImpl.java:379)
    at com.sun.org.apache.xerces.internal.impl.XMLNSDocumentScannerImpl$NSContentDriver.scanRootElementHook(XMLNSDocumentScannerImpl.java:605)
    at com.sun.org.apache.xerces.internal.impl.XMLDocumentFragmentScannerImpl$FragmentContentDriver.next(XMLDocumentFragmentScannerImpl.java:3138)
    at com.sun.org.apache.xerces.internal.impl.XMLDocumentScannerImpl$PrologDriver.next(XMLDocumentScannerImpl.java:880)
    at com.sun.org.apache.xerces.internal.impl.XMLDocumentScannerImpl.next(XMLDocumentScannerImpl.java:606)
    at com.sun.org.apache.xerces.internal.impl.XMLNSDocumentScannerImpl.next(XMLNSDocumentScannerImpl.java:117)
    at com.sun.org.apache.xerces.internal.impl.XMLDocumentFragmentScannerImpl.scanDocument(XMLDocumentFragmentScannerImpl.java:510)
    at com.sun.org.apache.xerces.internal.parsers.XML11Configuration.parse(XML11Configuration.java:848)
    at com.sun.org.apache.xerces.internal.parsers.XML11Configuration.parse(XML11Configuration.java:777)
    at com.sun.org.apache.xerces.internal.parsers.XMLParser.parse(XMLParser.java:141)
    at com.sun.org.apache.xerces.internal.parsers.AbstractSAXParser.parse(AbstractSAXParser.java:1213)
    at com.sun.org.apache.xerces.internal.jaxp.SAXParserImpl$JAXPSAXParser.parse(SAXParserImpl.java:648)
    at org.pentaho.reporting.libraries.xmlns.parser.AbstractXmlResourceFactory.create(AbstractXmlResourceFactory.java:237)
    ... 79 more
    Exception in thread "main" java.lang.NullPointerException
    at directprinting.Directprinting.getCompleteReportDefinition(Directprinting.java:63)
    at directprinting.Directprinting.main(Directprinting.java:38)
    Java Result: 1
    BUILD SUCCESSFUL (total time: 1 second)
    Last edited by bobby0204; 12-01-2016 at 07:48 AM.

  2. #2
    Join Date
    Sep 2016
    Posts
    23

    Default

    Quote Originally Posted by bobby0204 View Post
    hi.. i have a project with netbeans to display pentaho report,

    if for displaying report without any datasource [just text only], my report will show up / appear.

    but if my report use some parameter or PDI as datasource, my report is not show..

    this is my netbeans project, in this project already include pentaho library and prpt's file.

    https://drive.google.com/open?id=0B3...WkteW1mY2pEa0E

    this is my ktr's file where i use in pentaho report file.

    https://drive.google.com/open?id=0B3...UR1OTVFcWFnRlU




    this is the log.
    why no one want to answer me

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Privacy Policy | Legal Notices | Safe Harbor Privacy Policy

Copyright © 2005 - 2019 Hitachi Vantara Corporation. All Rights Reserved.