Toad World® Forums

Workflows Behaving Badly

Just upgraded to and Workflows are not behaving nicely.

I have a WorkBook with two Workflows. This WorkBook was created in the previous version.

  • Workflow 1 has one query, then three pivots are created from it...each pivot exports to a separate Excel file.

  • Workflow 2 has one query, one pivot is created from it, and then one Excel file from the pivot.

  • I click Execute All.

  • Workflow 1's query runs, then the pivots begin to refresh, and the Excel files are created.

  • Workflow 2's query runs, the pivot window shows a large red X, but the Excel file does create successfully.

  • I right-click the pivot with the red X and "Refresh from here". Then this dialog box appears:
    double entrance
    Stack Trace:
    at DevExpress.XtraPivotGrid.ViewInfo.BaseViewInfo.Calculate()
    at DevExpress.XtraPivotGrid.Data.PivotGridViewInfoData.get_ViewInfo()
    at DevExpress.XtraPivotGrid.Customization.PivotCustomizationTreeBox.CreateItemViewInfo(IVisualCustomizationTreeItem item)
    at DevExpress.XtraPivotGrid.Customization.PivotCustomizationTreeBoxBase.GetItemViewInfo(Int32 index)
    at DevExpress.XtraPivotGrid.Customization.PivotCustomizationTreeBoxBase.DrawItemObject(GraphicsCache cache, Int32 index, Rectangle bounds, DrawItemState itemState)
    at DevExpress.XtraEditors.Customization.CustomizationListBoxBase.RaiseDrawItem(ListBoxDrawItemEventArgs e)
    at DevExpress.XtraEditors.Drawing.BaseListBoxPainter.DrawItem(ControlGraphicsInfoArgs info, ItemInfo itemInfo)
    at DevExpress.XtraEditors.Drawing.BaseListBoxPainter.DrawVisibleItems(ControlGraphicsInfoArgs info)
    at DevExpress.XtraEditors.Drawing.BaseListBoxPainter.DrawContent(ControlGraphicsInfoArgs info)
    at DevExpress.XtraEditors.Drawing.BaseControlPainter.Draw(ControlGraphicsInfoArgs info)
    at DevExpress.XtraEditors.BaseControl.OnPaint(PaintEventArgs e)
    at DevExpress.XtraEditors.BaseListBoxControl.OnPaint(PaintEventArgs e)
    at DevExpress.XtraEditors.Customization.CustomizationListBoxBase.OnPaint(PaintEventArgs e)
    at System.Windows.Forms.Control.PaintWithErrorHandling(PaintEventArgs e, Int16 layer)
    at System.Windows.Forms.Control.WmPaint(Message& m)
    at System.Windows.Forms.Control.WndProc(Message& m)
    at DevExpress.Utils.Controls.ControlBase.WndProc(Message& m)
    at DevExpress.XtraEditors.BaseListBoxControl.WndProc(Message& m)
    at DevExpress.XtraPivotGrid.Customization.PivotCustomizationTreeBoxBase.WndProc(Message& m)
    at System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m)
    at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)
    at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)

Click OK, and while the pivot window remains a red X, the Excel file does successfully export.

I then looked back at Workflow 1's pivots to discover that 1 of the 3 pivots also has the red X and the data is not displayed.

I was also able to duplicate the exact same error.

Hi, this is a defect. It is logged under QAT-14939 and we're working on it.