Teiid VDB and Pentaho Xaction
zachary.price Aug 24, 2014 6:05 AMHello,
Has anyone had any experience pulling data from a VDB using a Pentaho xaction? When I attempt to execute my xaction through the Pentaho User Console I get a blank report. Here is the error that shows up in the log as soon as I execute the xaction..
03:55:49,732 ERROR [ExpressionEventHelper] Failed to fire report-done event: java.lang.NullPointerException
Here are the contents of the xaction file I am attempting to execute. Any ideas are greatly appreciated.
<?xml version="1.0" encoding="UTF-8"?> <action-sequence> <version>1</version> <logging-level>ERROR</logging-level> <documentation> <author>Michael D'Amour</author> <description>Testing VDB connectivity.</description> <help/> <result-type>report</result-type> <icon/> </documentation> <inputs> <outputType type="string"> <default-value>text/html</default-value> <sources> <request>outputType</request> </sources> </outputType> <outputTypeList type="property-map-list"> <sources> <runtime>outputTypeList</runtime> </sources> <default-value type="property-map-list"> <property-map> <entry key="report-output-desc">PDF</entry> <entry key="report-output-type-id">application/pdf</entry> </property-map> <property-map> <entry key="report-output-desc">Excel</entry> <entry key="report-output-type-id">application/vnd.ms-excel</entry> </property-map> <property-map> <entry key="report-output-desc">Web Page</entry> <entry key="report-output-type-id">text/html</entry> </property-map> </default-value> </outputTypeList> </inputs> <outputs> <myReport type="content" is-output-parameter="true"> <destinations> <response>content</response> </destinations> </myReport> </outputs> <resources> <reportDefinition> <solution-file> <location>testreport.prpt</location> <mime-type>application/zip</mime-type> </solution-file> </reportDefinition> </resources> <actions> <action-definition> <component-name>SecureFilterComponent</component-name> <action-type>Prompt for Product Line and Report Format</action-type> <action-inputs> <outputTypeList type="property-map-list"/> <outputType type="string"/> </action-inputs> <component-definition> <selections> <outputType style="radio"> <title>Select Report Format</title> <filter value-col-name="report-output-type-id" display-col-name="report-output-desc">outputTypeList</filter> </outputType> </selections> </component-definition> </action-definition> <action-definition> <component-name>SQLLookupRule</component-name> <action-type>SQL Query For Report Data</action-type> <action-outputs> <query-result type="result-set"/> </action-outputs> <component-definition> <query><![CDATA[SELECT * FROM test.account]]></query> <live><![CDATA[true]]></live> <driver><![CDATA[org.teiid.jdbc.TeiidDriver]]></driver> <connection><![CDATA[jdbc:teiid:NewVDB@mm://192.168.1.105:31000]]></connection> <password><![CDATA[user]]></password> <user-id><![CDATA[user]]></user-id> </component-definition> </action-definition> <action-definition> <component-name>SimpleReportingComponent</component-name> <action-type>Generate the report using a solution path to the report definition</action-type> <component-definition/> <action-resources> <reportDefinition type="resource"/> </action-resources> <action-inputs> <queryData type="result-set" mapping="query-result"/> <outputType type="string"/> </action-inputs> <action-outputs> <outputstream type="content" mapping="myReport"/> </action-outputs> </action-definition> </actions> </action-sequence>