I am having an issue with adding Pivot transformations to a data table - error messages included below. Any help would be greatly appreciated!

[Ken Maksimchuk]

Error message: Could not add transformations.

TargetInvocationException at Spotfire.Dxp.Framework:

Exception has been thrown by the target of an invocation. (HRESULT: 80131604)

Stack Trace:

  at Spotfire.Dxp.Framework.ApplicationModel.ProgressService.ExecuteWithProgressCore(String title, String description, ProgressOperation operation)

  at Spotfire.Dxp.Forms.Data.Transformations.EditTransformationsDialog.DoOperationWithExceptionHandling(String progressTitle, String progressDescription, Func`2 indexAfterOperationGetter, Action`1 actionOnSelectedIndex)

  at Spotfire.Dxp.Forms.Data.Transformations.EditTransformationsDialog.InsertTransformation(Int32 insertIndex)

  at System.Windows.Forms.Control.OnClick(EventArgs e)

  at System.Windows.Forms.Button.OnMouseUp(MouseEventArgs mevent)

  at System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons button, Int32 clicks)

  at System.Windows.Forms.Control.WndProc(Message& m)

  at System.Windows.Forms.ButtonBase.WndProc(Message& m)

  at System.Windows.Forms.Button.WndProc(Message& m)

  at System.Windows.Forms.NativeWindow.DebuggableCallback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)

  at System.Windows.Forms.UnsafeNativeMethods.DispatchMessageW(MSG& msg)

  at System.Windows.Forms.Application.ComponentManager.System.Windows.Forms.UnsafeNativeMethods.IMsoComponentManager.FPushMessageLoop(IntPtr dwComponentID, Int32 reason, Int32 pvLoopData)

  at System.Windows.Forms.Application.ThreadContext.RunMessageLoopInner(Int32 reason, ApplicationContext context)

  at System.Windows.Forms.Application.ThreadContext.RunMessageLoop(Int32 reason, ApplicationContext context)

  at System.Windows.Forms.Form.ShowDialog(IWin32Window owner)

  at Spotfire.Dxp.Forms.Application.FormsProgressService.<>c__DisplayClass13_0.<Prompt>b__1()

  at Spotfire.Dxp.Forms.Application.FormsProgressService.<>c__DisplayClass20_0.<PerformPrompt>b__0()

  at Spotfire.Dxp.Forms.Application.FormsProgressService.PerformPrompt(Func`1 promptMethod)

  at Spotfire.Dxp.Forms.FormsDataCanvasWebViewImpl.HandleInsertTransformationsProducer(JsonBundle args)

ArgumentException at System.Windows.Forms:

An item with the same key has already been added. (HRESULT: 80070057)

Stack Trace:

  at System.Windows.Forms.Control.MarshaledInvoke(Control caller, Delegate method, Object[] args, Boolean synchronous)

  at System.Windows.Forms.Control.Invoke(Delegate method, Object[] args)

  at System.Windows.Forms.WindowsFormsSynchronizationContext.Send(SendOrPostCallback d, Object state)

  at Spotfire.Dxp.Forms.Application.FormsApplicationThread.InvokeOnUIThreadAndTransferTransactionStartPermission(ApplicationInvocation method)

  at Spotfire.Dxp.Framework.DocumentModel.ThreadTransactionInfo.InvokeAndTransferCurrentInfo(ApplicationThread invoker, ApplicationInvocation method)

  at Spotfire.Dxp.Forms.Application.FormsProgressService.PerformPrompt(Func`1 promptMethod)

  at Spotfire.Dxp.Data.Transformations.EditTransformationsModel.PromptTransformation(LoadingView inputView, DataTransformation transformation, SnapshotSafeImportContext importContext, Action`1 promptOverride)

  at Spotfire.Dxp.Data.Transformations.EditTransformationsModel.<>c__DisplayClass23_0.<InsertAndConfigureTransformation>b__0()

  at Spotfire.Dxp.Data.Transformations.EditTransformationsModel.CloneLoadingViewAndExecuteWithRollbackOnException(Action action)

  at Spotfire.Dxp.Forms.Data.Transformations.EditTransformationsDialog.<>c__DisplayClass19_0.<InsertTransformation>b__1(Int32 selectedIndex)

  at Spotfire.Dxp.Framework.ApplicationModel.Progress.<>c__DisplayClass22_0.<Start>b__0()

  at Spotfire.Dxp.Framework.ApplicationModel.MonitorableProgress.Start[T](Func`1 action)

  at Spotfire.Dxp.Forms.Application.FormsProgressService.ProgressThread.<DoOperationLoop>b__11_0()

[Fredrik Rosell]

Hello Ken,

That sounds like an issue that would be better handled as a support case - we would need to get more information about your analysis and the data. So, please open a case in the Support portal - https://support.tibco.com/s/ - and our support team will assist you.

Best Regards

Fredrik (TIBCO Support)