Uploaded image for project: 'Pentaho Aggregation Designer'
  1. Pentaho Aggregation Designer
  2. PAD-86

Unable to Populate Aggregate Tables and generate DML Script using Aggregation Designer in Pentaho Enterprise 3.6 Version

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed
    • Severity: High
    • Resolution: Duplicate
    • Affects Version/s: 3.6.0 GA Suite Release
    • Fix Version/s: Not Planned
    • Component/s: None
    • Labels:
      None
    • Environment:
      Amazon EC2 Server Instance : m1.large
    • Notice:
      When an issue is open, the "Fix Version/s" field conveys a target, not necessarily a commitment. When an issue is closed, the "Fix Version/s" field conveys the version that the issue was fixed in.

      Description

      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

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              Unassigned
              Reporter:
              mondrian_newbie Mondrian Newbie
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved: