org.pentaho.ui.xul.XulException: Error invoking method: exportHandler.showPreview()

Pentaho BI Platform Tracking | Rob Fellows | 7 years ago
tip
Your exception is missing from the Samebug knowledge base.
Here are the best solutions we found on the Internet.
Click on the to mark the helpful solution and get rewards for you help.
  1. 0

    Created connection to SampleData, selected Aggregation Levels and applied them, then tried to File --> Export & Publish --> Preview button. Got the following stack trace in the console window. 16:23:11,531 ERROR [AbstractXulDomContainer] Error invoking method: exportHandler.showPreview() java.lang.reflect.InvocationTargetException at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:592) at org.pentaho.ui.xul.impl.AbstractXulDomContainer.invoke(AbstractXulDomContainer.java:323) at org.pentaho.ui.xul.swing.tags.SwingButton$OnClickRunnable.run(SwingButton.java:58) at java.awt.event.InvocationEvent.dispatch(InvocationEvent.java:209) at java.awt.EventQueue.dispatchEvent(EventQueue.java:461) at java.awt.EventDispatchThread.pumpOneEventForHierarchy(EventDispatchThread.java:242) at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:163) at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:153) at java.awt.Dialog$1.run(Dialog.java:535) at java.awt.Dialog$2.run(Dialog.java:565) at java.security.AccessController.doPrivileged(Native Method) at java.awt.Dialog.show(Dialog.java:563) at java.awt.Component.show(Component.java:1302) at java.awt.Component.setVisible(Component.java:1255) at org.pentaho.ui.xul.swing.tags.SwingDialog.show(SwingDialog.java:234) at org.pentaho.aggdes.ui.form.controller.ExportHandler.openDialog(ExportHandler.java:144) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:592) at org.pentaho.ui.xul.impl.AbstractXulDomContainer.invoke(AbstractXulDomContainer.java:323) at org.pentaho.ui.xul.swing.tags.SwingButton$OnClickRunnable.run(SwingButton.java:58) at java.awt.event.InvocationEvent.dispatch(InvocationEvent.java:209) at java.awt.EventQueue.dispatchEvent(EventQueue.java:461) at java.awt.EventDispatchThread.pumpOneEventForHierarchy(EventDispatchThread.java:242) at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:163) at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:157) at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:149) at java.awt.EventDispatchThread.run(EventDispatchThread.java:110) Caused by: java.lang.NullPointerException at mondrian.rolap.RolapStar$Column.generateExprString(RolapStar.java:1168) at mondrian.rolap.RolapStar.generateSql(RolapStar.java:925) at org.pentaho.aggdes.model.mondrian.MondrianSchema.generateAggregateSql(MondrianSchema.java:273) at org.pentaho.aggdes.output.impl.PopulateTableGenerator.generate(PopulateTableGenerator.java:59) at org.pentaho.aggdes.output.impl.AbstractGenerator.generateFull(AbstractGenerator.java:34) at org.pentaho.aggdes.output.impl.OutputServiceImpl.getFullArtifact(OutputServiceImpl.java:152) at org.pentaho.aggdes.ui.form.controller.ExportHandler.showPreview(ExportHandler.java:212) ... 32 more 16:23:11,609 ERROR [SwingButton] Error calling oncommand event: exportHandler.showPreview() org.pentaho.ui.xul.XulException: Error invoking method: exportHandler.showPreview() at org.pentaho.ui.xul.impl.AbstractXulDomContainer.invoke(AbstractXulDomContainer.java:327) at org.pentaho.ui.xul.swing.tags.SwingButton$OnClickRunnable.run(SwingButton.java:58) at java.awt.event.InvocationEvent.dispatch(InvocationEvent.java:209) at java.awt.EventQueue.dispatchEvent(EventQueue.java:461) at java.awt.EventDispatchThread.pumpOneEventForHierarchy(EventDispatchThread.java:242) at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:163) at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:153) at java.awt.Dialog$1.run(Dialog.java:535) at java.awt.Dialog$2.run(Dialog.java:565) at java.security.AccessController.doPrivileged(Native Method) at java.awt.Dialog.show(Dialog.java:563) at java.awt.Component.show(Component.java:1302) at java.awt.Component.setVisible(Component.java:1255) at org.pentaho.ui.xul.swing.tags.SwingDialog.show(SwingDialog.java:234) at org.pentaho.aggdes.ui.form.controller.ExportHandler.openDialog(ExportHandler.java:144) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:592) at org.pentaho.ui.xul.impl.AbstractXulDomContainer.invoke(AbstractXulDomContainer.java:323) at org.pentaho.ui.xul.swing.tags.SwingButton$OnClickRunnable.run(SwingButton.java:58) at java.awt.event.InvocationEvent.dispatch(InvocationEvent.java:209) at java.awt.EventQueue.dispatchEvent(EventQueue.java:461) at java.awt.EventDispatchThread.pumpOneEventForHierarchy(EventDispatchThread.java:242) at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:163) at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:157) at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:149) at java.awt.EventDispatchThread.run(EventDispatchThread.java:110) Caused by: java.lang.reflect.InvocationTargetException at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:592) at org.pentaho.ui.xul.impl.AbstractXulDomContainer.invoke(AbstractXulDomContainer.java:323) ... 27 more Caused by: java.lang.NullPointerException at mondrian.rolap.RolapStar$Column.generateExprString(RolapStar.java:1168) at mondrian.rolap.RolapStar.generateSql(RolapStar.java:925) at org.pentaho.aggdes.model.mondrian.MondrianSchema.generateAggregateSql(MondrianSchema.java:273) at org.pentaho.aggdes.output.impl.PopulateTableGenerator.generate(PopulateTableGenerator.java:59) at org.pentaho.aggdes.output.impl.AbstractGenerator.generateFull(AbstractGenerator.java:34) at org.pentaho.aggdes.output.impl.OutputServiceImpl.getFullArtifact(OutputServiceImpl.java:152) at org.pentaho.aggdes.ui.form.controller.ExportHandler.showPreview(ExportHandler.java:212) ... 32 more

    Pentaho BI Platform Tracking | 7 years ago | Rob Fellows
    org.pentaho.ui.xul.XulException: Error invoking method: exportHandler.showPreview()
  2. 0

    Created connection to SampleData, selected Aggregation Levels and applied them, then tried to File --> Export & Publish --> Preview button. Got the following stack trace in the console window. 16:23:11,531 ERROR [AbstractXulDomContainer] Error invoking method: exportHandler.showPreview() java.lang.reflect.InvocationTargetException at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:592) at org.pentaho.ui.xul.impl.AbstractXulDomContainer.invoke(AbstractXulDomContainer.java:323) at org.pentaho.ui.xul.swing.tags.SwingButton$OnClickRunnable.run(SwingButton.java:58) at java.awt.event.InvocationEvent.dispatch(InvocationEvent.java:209) at java.awt.EventQueue.dispatchEvent(EventQueue.java:461) at java.awt.EventDispatchThread.pumpOneEventForHierarchy(EventDispatchThread.java:242) at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:163) at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:153) at java.awt.Dialog$1.run(Dialog.java:535) at java.awt.Dialog$2.run(Dialog.java:565) at java.security.AccessController.doPrivileged(Native Method) at java.awt.Dialog.show(Dialog.java:563) at java.awt.Component.show(Component.java:1302) at java.awt.Component.setVisible(Component.java:1255) at org.pentaho.ui.xul.swing.tags.SwingDialog.show(SwingDialog.java:234) at org.pentaho.aggdes.ui.form.controller.ExportHandler.openDialog(ExportHandler.java:144) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:592) at org.pentaho.ui.xul.impl.AbstractXulDomContainer.invoke(AbstractXulDomContainer.java:323) at org.pentaho.ui.xul.swing.tags.SwingButton$OnClickRunnable.run(SwingButton.java:58) at java.awt.event.InvocationEvent.dispatch(InvocationEvent.java:209) at java.awt.EventQueue.dispatchEvent(EventQueue.java:461) at java.awt.EventDispatchThread.pumpOneEventForHierarchy(EventDispatchThread.java:242) at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:163) at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:157) at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:149) at java.awt.EventDispatchThread.run(EventDispatchThread.java:110) Caused by: java.lang.NullPointerException at mondrian.rolap.RolapStar$Column.generateExprString(RolapStar.java:1168) at mondrian.rolap.RolapStar.generateSql(RolapStar.java:925) at org.pentaho.aggdes.model.mondrian.MondrianSchema.generateAggregateSql(MondrianSchema.java:273) at org.pentaho.aggdes.output.impl.PopulateTableGenerator.generate(PopulateTableGenerator.java:59) at org.pentaho.aggdes.output.impl.AbstractGenerator.generateFull(AbstractGenerator.java:34) at org.pentaho.aggdes.output.impl.OutputServiceImpl.getFullArtifact(OutputServiceImpl.java:152) at org.pentaho.aggdes.ui.form.controller.ExportHandler.showPreview(ExportHandler.java:212) ... 32 more 16:23:11,609 ERROR [SwingButton] Error calling oncommand event: exportHandler.showPreview() org.pentaho.ui.xul.XulException: Error invoking method: exportHandler.showPreview() at org.pentaho.ui.xul.impl.AbstractXulDomContainer.invoke(AbstractXulDomContainer.java:327) at org.pentaho.ui.xul.swing.tags.SwingButton$OnClickRunnable.run(SwingButton.java:58) at java.awt.event.InvocationEvent.dispatch(InvocationEvent.java:209) at java.awt.EventQueue.dispatchEvent(EventQueue.java:461) at java.awt.EventDispatchThread.pumpOneEventForHierarchy(EventDispatchThread.java:242) at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:163) at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:153) at java.awt.Dialog$1.run(Dialog.java:535) at java.awt.Dialog$2.run(Dialog.java:565) at java.security.AccessController.doPrivileged(Native Method) at java.awt.Dialog.show(Dialog.java:563) at java.awt.Component.show(Component.java:1302) at java.awt.Component.setVisible(Component.java:1255) at org.pentaho.ui.xul.swing.tags.SwingDialog.show(SwingDialog.java:234) at org.pentaho.aggdes.ui.form.controller.ExportHandler.openDialog(ExportHandler.java:144) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:592) at org.pentaho.ui.xul.impl.AbstractXulDomContainer.invoke(AbstractXulDomContainer.java:323) at org.pentaho.ui.xul.swing.tags.SwingButton$OnClickRunnable.run(SwingButton.java:58) at java.awt.event.InvocationEvent.dispatch(InvocationEvent.java:209) at java.awt.EventQueue.dispatchEvent(EventQueue.java:461) at java.awt.EventDispatchThread.pumpOneEventForHierarchy(EventDispatchThread.java:242) at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:163) at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:157) at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:149) at java.awt.EventDispatchThread.run(EventDispatchThread.java:110) Caused by: java.lang.reflect.InvocationTargetException at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:592) at org.pentaho.ui.xul.impl.AbstractXulDomContainer.invoke(AbstractXulDomContainer.java:323) ... 27 more Caused by: java.lang.NullPointerException at mondrian.rolap.RolapStar$Column.generateExprString(RolapStar.java:1168) at mondrian.rolap.RolapStar.generateSql(RolapStar.java:925) at org.pentaho.aggdes.model.mondrian.MondrianSchema.generateAggregateSql(MondrianSchema.java:273) at org.pentaho.aggdes.output.impl.PopulateTableGenerator.generate(PopulateTableGenerator.java:59) at org.pentaho.aggdes.output.impl.AbstractGenerator.generateFull(AbstractGenerator.java:34) at org.pentaho.aggdes.output.impl.OutputServiceImpl.getFullArtifact(OutputServiceImpl.java:152) at org.pentaho.aggdes.ui.form.controller.ExportHandler.showPreview(ExportHandler.java:212) ... 32 more

    Pentaho BI Platform Tracking | 7 years ago | Rob Fellows
    org.pentaho.ui.xul.XulException: Error invoking method: exportHandler.showPreview()
  3. 0

    Hello, I am using the Pentaho Aggregate Designer (Enterprise Edition 3.6) and generated 3 Aggregate tables. But am unable to populate the aggregate tables or generate the DML Script. Pentaho Enterprise Edition 3.6 Pentaho Aggregate Designer 1.2.0-RC 1.41573 OS : CentOS release 5.4 (Final) Kernal Version : 2.6.18-164.el5 and 2.6.21.7-2.fc8xen DB: GreenPlum (SNE) - 3.3.6.1 build 1 Single-Node Edition. I am attaching the schema for reference. The Log reports the following message: 2011-02-12 00:26:52,542 ERROR [org.pentaho.ui.xul.impl.AbstractXulDomContainer] Error invoking method: exportHandler.saveDml() java.lang.reflect.InvocationTargetException at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at org.pentaho.ui.xul.impl.AbstractXulDomContainer.invoke(AbstractXulDomContainer.java:323) at org.pentaho.ui.xul.swing.tags.SwingButton$OnClickRunnable.run(SwingButton.java:58) at java.awt.event.InvocationEvent.dispatch(InvocationEvent.java:209) at java.awt.EventQueue.dispatchEvent(EventQueue.java:597) at java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:269) at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:184) at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:178) at java.awt.Dialog$1.run(Dialog.java:1046) at java.awt.Dialog$3.run(Dialog.java:1098) at java.security.AccessController.doPrivileged(Native Method) at java.awt.Dialog.show(Dialog.java:1096) at java.awt.Component.show(Component.java:1563) at java.awt.Component.setVisible(Component.java:1515) at java.awt.Window.setVisible(Window.java:842) at java.awt.Dialog.setVisible(Dialog.java:986) at org.pentaho.ui.xul.swing.tags.SwingDialog.show(SwingDialog.java:234) at org.pentaho.aggdes.ui.form.controller.ExportHandler.openDialog(ExportHandler.java:144) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at org.pentaho.ui.xul.impl.AbstractXulDomContainer.invoke(AbstractXulDomContainer.java:323) at org.pentaho.ui.xul.swing.tags.SwingButton$OnClickRunnable.run(SwingButton.java:58) at java.awt.event.InvocationEvent.dispatch(InvocationEvent.java:209) at java.awt.EventQueue.dispatchEvent(EventQueue.java:597) at java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:269) at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:184) at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:174) at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:169) at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:161) at java.awt.EventDispatchThread.run(EventDispatchThread.java:122) Caused by: java.lang.NullPointerException at mondrian.rolap.RolapStar$Column.generateExprString(RolapStar.java:1168) at mondrian.rolap.RolapStar.generateSql(RolapStar.java:925) at org.pentaho.aggdes.model.mondrian.MondrianSchema.generateAggregateSql(MondrianSchema.java:273) at org.pentaho.aggdes.output.impl.PopulateTableGenerator.generate(PopulateTableGenerator.java:59) at org.pentaho.aggdes.output.impl.OutputServiceImpl.getArtifact(OutputServiceImpl.java:127) at org.pentaho.aggdes.ui.form.controller.ExportHandler.getOutput(ExportHandler.java:402) at org.pentaho.aggdes.ui.form.controller.ExportHandler.saveDml(ExportHandler.java:484) ... 35 more 2011-02-12 00:26:52,544 ERROR [org.pentaho.ui.xul.swing.tags.SwingButton] Error calling oncommand event: exportHandler.saveDml() org.pentaho.ui.xul.XulException: Error invoking method: exportHandler.saveDml() at org.pentaho.ui.xul.impl.AbstractXulDomContainer.invoke(AbstractXulDomContainer.java:327) at org.pentaho.ui.xul.swing.tags.SwingButton$OnClickRunnable.run(SwingButton.java:58) at java.awt.event.InvocationEvent.dispatch(InvocationEvent.java:209) at java.awt.EventQueue.dispatchEvent(EventQueue.java:597) at java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:269) at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:184) at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:178) at java.awt.Dialog$1.run(Dialog.java:1046) at java.awt.Dialog$3.run(Dialog.java:1098) at java.security.AccessController.doPrivileged(Native Method) at java.awt.Dialog.show(Dialog.java:1096) at java.awt.Component.show(Component.java:1563) at java.awt.Component.setVisible(Component.java:1515) at java.awt.Window.setVisible(Window.java:842) at java.awt.Dialog.setVisible(Dialog.java:986) at org.pentaho.ui.xul.swing.tags.SwingDialog.show(SwingDialog.java:234) at org.pentaho.aggdes.ui.form.controller.ExportHandler.openDialog(ExportHandler.java:144) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at org.pentaho.ui.xul.impl.AbstractXulDomContainer.invoke(AbstractXulDomContainer.java:323) at org.pentaho.ui.xul.swing.tags.SwingButton$OnClickRunnable.run(SwingButton.java:58) at java.awt.event.InvocationEvent.dispatch(InvocationEvent.java:209) at java.awt.EventQueue.dispatchEvent(EventQueue.java:597) at java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:269) at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:184) at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:174) at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:169) at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:161) at java.awt.EventDispatchThread.run(EventDispatchThread.java:122) Caused by: java.lang.reflect.InvocationTargetException at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at org.pentaho.ui.xul.impl.AbstractXulDomContainer.invoke(AbstractXulDomContainer.java:323) ... 30 more Caused by: java.lang.NullPointerException at mondrian.rolap.RolapStar$Column.generateExprString(RolapStar.java:1168) at mondrian.rolap.RolapStar.generateSql(RolapStar.java:925) at org.pentaho.aggdes.model.mondrian.MondrianSchema.generateAggregateSql(MondrianSchema.java:273) at org.pentaho.aggdes.output.impl.PopulateTableGenerator.generate(PopulateTableGenerator.java:59) at org.pentaho.aggdes.output.impl.OutputServiceImpl.getArtifact(OutputServiceImpl.java:127) at org.pentaho.aggdes.ui.form.controller.ExportHandler.getOutput(ExportHandler.java:402) at org.pentaho.aggdes.ui.form.controller.ExportHandler.saveDml(ExportHandler.java:484) ... 35 more

    Pentaho BI Platform Tracking | 6 years ago | Mondrian Newbie
    java.lang.reflect.InvocationTargetException
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Hello, I am using the Pentaho Aggregate Designer (Enterprise Edition 3.6) and generated 3 Aggregate tables. But am unable to populate the aggregate tables or generate the DML Script. Pentaho Enterprise Edition 3.6 Pentaho Aggregate Designer 1.2.0-RC 1.41573 OS : CentOS release 5.4 (Final) Kernal Version : 2.6.18-164.el5 and 2.6.21.7-2.fc8xen DB: GreenPlum (SNE) - 3.3.6.1 build 1 Single-Node Edition. I am attaching the schema for reference. The Log reports the following message: 2011-02-12 00:26:52,542 ERROR [org.pentaho.ui.xul.impl.AbstractXulDomContainer] Error invoking method: exportHandler.saveDml() java.lang.reflect.InvocationTargetException at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at org.pentaho.ui.xul.impl.AbstractXulDomContainer.invoke(AbstractXulDomContainer.java:323) at org.pentaho.ui.xul.swing.tags.SwingButton$OnClickRunnable.run(SwingButton.java:58) at java.awt.event.InvocationEvent.dispatch(InvocationEvent.java:209) at java.awt.EventQueue.dispatchEvent(EventQueue.java:597) at java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:269) at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:184) at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:178) at java.awt.Dialog$1.run(Dialog.java:1046) at java.awt.Dialog$3.run(Dialog.java:1098) at java.security.AccessController.doPrivileged(Native Method) at java.awt.Dialog.show(Dialog.java:1096) at java.awt.Component.show(Component.java:1563) at java.awt.Component.setVisible(Component.java:1515) at java.awt.Window.setVisible(Window.java:842) at java.awt.Dialog.setVisible(Dialog.java:986) at org.pentaho.ui.xul.swing.tags.SwingDialog.show(SwingDialog.java:234) at org.pentaho.aggdes.ui.form.controller.ExportHandler.openDialog(ExportHandler.java:144) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at org.pentaho.ui.xul.impl.AbstractXulDomContainer.invoke(AbstractXulDomContainer.java:323) at org.pentaho.ui.xul.swing.tags.SwingButton$OnClickRunnable.run(SwingButton.java:58) at java.awt.event.InvocationEvent.dispatch(InvocationEvent.java:209) at java.awt.EventQueue.dispatchEvent(EventQueue.java:597) at java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:269) at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:184) at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:174) at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:169) at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:161) at java.awt.EventDispatchThread.run(EventDispatchThread.java:122) Caused by: java.lang.NullPointerException at mondrian.rolap.RolapStar$Column.generateExprString(RolapStar.java:1168) at mondrian.rolap.RolapStar.generateSql(RolapStar.java:925) at org.pentaho.aggdes.model.mondrian.MondrianSchema.generateAggregateSql(MondrianSchema.java:273) at org.pentaho.aggdes.output.impl.PopulateTableGenerator.generate(PopulateTableGenerator.java:59) at org.pentaho.aggdes.output.impl.OutputServiceImpl.getArtifact(OutputServiceImpl.java:127) at org.pentaho.aggdes.ui.form.controller.ExportHandler.getOutput(ExportHandler.java:402) at org.pentaho.aggdes.ui.form.controller.ExportHandler.saveDml(ExportHandler.java:484) ... 35 more 2011-02-12 00:26:52,544 ERROR [org.pentaho.ui.xul.swing.tags.SwingButton] Error calling oncommand event: exportHandler.saveDml() org.pentaho.ui.xul.XulException: Error invoking method: exportHandler.saveDml() at org.pentaho.ui.xul.impl.AbstractXulDomContainer.invoke(AbstractXulDomContainer.java:327) at org.pentaho.ui.xul.swing.tags.SwingButton$OnClickRunnable.run(SwingButton.java:58) at java.awt.event.InvocationEvent.dispatch(InvocationEvent.java:209) at java.awt.EventQueue.dispatchEvent(EventQueue.java:597) at java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:269) at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:184) at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:178) at java.awt.Dialog$1.run(Dialog.java:1046) at java.awt.Dialog$3.run(Dialog.java:1098) at java.security.AccessController.doPrivileged(Native Method) at java.awt.Dialog.show(Dialog.java:1096) at java.awt.Component.show(Component.java:1563) at java.awt.Component.setVisible(Component.java:1515) at java.awt.Window.setVisible(Window.java:842) at java.awt.Dialog.setVisible(Dialog.java:986) at org.pentaho.ui.xul.swing.tags.SwingDialog.show(SwingDialog.java:234) at org.pentaho.aggdes.ui.form.controller.ExportHandler.openDialog(ExportHandler.java:144) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at org.pentaho.ui.xul.impl.AbstractXulDomContainer.invoke(AbstractXulDomContainer.java:323) at org.pentaho.ui.xul.swing.tags.SwingButton$OnClickRunnable.run(SwingButton.java:58) at java.awt.event.InvocationEvent.dispatch(InvocationEvent.java:209) at java.awt.EventQueue.dispatchEvent(EventQueue.java:597) at java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:269) at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:184) at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:174) at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:169) at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:161) at java.awt.EventDispatchThread.run(EventDispatchThread.java:122) Caused by: java.lang.reflect.InvocationTargetException at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at org.pentaho.ui.xul.impl.AbstractXulDomContainer.invoke(AbstractXulDomContainer.java:323) ... 30 more Caused by: java.lang.NullPointerException at mondrian.rolap.RolapStar$Column.generateExprString(RolapStar.java:1168) at mondrian.rolap.RolapStar.generateSql(RolapStar.java:925) at org.pentaho.aggdes.model.mondrian.MondrianSchema.generateAggregateSql(MondrianSchema.java:273) at org.pentaho.aggdes.output.impl.PopulateTableGenerator.generate(PopulateTableGenerator.java:59) at org.pentaho.aggdes.output.impl.OutputServiceImpl.getArtifact(OutputServiceImpl.java:127) at org.pentaho.aggdes.ui.form.controller.ExportHandler.getOutput(ExportHandler.java:402) at org.pentaho.aggdes.ui.form.controller.ExportHandler.saveDml(ExportHandler.java:484) ... 35 more

    Pentaho BI Platform Tracking | 6 years ago | Mondrian Newbie
    java.lang.reflect.InvocationTargetException

    Root Cause Analysis

    1. java.lang.NullPointerException

      No message provided

      at mondrian.rolap.RolapStar$Column.generateExprString()
    2. mondrian.rolap
      RolapStar.generateSql
      1. mondrian.rolap.RolapStar$Column.generateExprString(RolapStar.java:1168)
      2. mondrian.rolap.RolapStar.generateSql(RolapStar.java:925)
      2 frames
    3. org.pentaho.aggdes
      ExportHandler.showPreview
      1. org.pentaho.aggdes.model.mondrian.MondrianSchema.generateAggregateSql(MondrianSchema.java:273)
      2. org.pentaho.aggdes.output.impl.PopulateTableGenerator.generate(PopulateTableGenerator.java:59)
      3. org.pentaho.aggdes.output.impl.AbstractGenerator.generateFull(AbstractGenerator.java:34)
      4. org.pentaho.aggdes.output.impl.OutputServiceImpl.getFullArtifact(OutputServiceImpl.java:152)
      5. org.pentaho.aggdes.ui.form.controller.ExportHandler.showPreview(ExportHandler.java:212)
      5 frames
    4. Java RT
      Method.invoke
      1. sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      2. sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
      3. sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
      4. java.lang.reflect.Method.invoke(Method.java:592)
      4 frames
    5. org.pentaho.ui
      SwingButton$OnClickRunnable.run
      1. org.pentaho.ui.xul.impl.AbstractXulDomContainer.invoke(AbstractXulDomContainer.java:323)
      2. org.pentaho.ui.xul.swing.tags.SwingButton$OnClickRunnable.run(SwingButton.java:58)
      2 frames
    6. Java RT
      Component.setVisible
      1. java.awt.event.InvocationEvent.dispatch(InvocationEvent.java:209)
      2. java.awt.EventQueue.dispatchEvent(EventQueue.java:461)
      3. java.awt.EventDispatchThread.pumpOneEventForHierarchy(EventDispatchThread.java:242)
      4. java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:163)
      5. java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:153)
      6. java.awt.Dialog$1.run(Dialog.java:535)
      7. java.awt.Dialog$2.run(Dialog.java:565)
      8. java.security.AccessController.doPrivileged(Native Method)
      9. java.awt.Dialog.show(Dialog.java:563)
      10. java.awt.Component.show(Component.java:1302)
      11. java.awt.Component.setVisible(Component.java:1255)
      11 frames
    7. org.pentaho.ui
      SwingDialog.show
      1. org.pentaho.ui.xul.swing.tags.SwingDialog.show(SwingDialog.java:234)
      1 frame
    8. org.pentaho.aggdes
      ExportHandler.openDialog
      1. org.pentaho.aggdes.ui.form.controller.ExportHandler.openDialog(ExportHandler.java:144)
      1 frame
    9. Java RT
      Method.invoke
      1. sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      2. sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
      3. sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
      4. java.lang.reflect.Method.invoke(Method.java:592)
      4 frames
    10. org.pentaho.ui
      SwingButton$OnClickRunnable.run
      1. org.pentaho.ui.xul.impl.AbstractXulDomContainer.invoke(AbstractXulDomContainer.java:323)
      2. org.pentaho.ui.xul.swing.tags.SwingButton$OnClickRunnable.run(SwingButton.java:58)
      2 frames
    11. Java RT
      EventDispatchThread.run
      1. java.awt.event.InvocationEvent.dispatch(InvocationEvent.java:209)
      2. java.awt.EventQueue.dispatchEvent(EventQueue.java:461)
      3. java.awt.EventDispatchThread.pumpOneEventForHierarchy(EventDispatchThread.java:242)
      4. java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:163)
      5. java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:157)
      6. java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:149)
      7. java.awt.EventDispatchThread.run(EventDispatchThread.java:110)
      7 frames