• Data set to JSON

    Can we convert a data set to a JSON string using build in functionality or do we need to loop/build dynamically using a variable ?

  • RE: Database Trigger - get row information?

    We are monitoring for insertion in this case.

  • RE: Database Trigger - get row information?

    Leonard,

    Thanks for the reply. Do you have any guidance on what a good approach would be for this, re: the additional queries?

    -Matt

  • Database Trigger - get row information?

    See the old thread here:

    http://forums.networkautomation.com/forum/messageview.cfm?catid=73&threadid=13421&highlight_key=y&keyword1=database%20trigger%20get%20row

    Can we retrieve row and column information for a database table being monitored? Currently, we're only able to retrieve extremely limited information about the triggering action:

    • AMTrigger.Action
    • AMTrigger.Table
    • AMTrigger.Type
    • AMTrigger.Source
  • RE: E-mail action: Use file contents as body (with variables)

    @Leonard - Yes, we've tried that but the content of the e-mail still contains string representations of variables when we do it that way. For example, Hello %Username%" remains this way even if we have a variable named %Username% in the task.

  • Performance Condition - Remote Computer

    Please see the following thread:

    http://forums.networkautomation.com/forum/messageview.cfm?catid=73&threadid=14849&highlight_key=y&keyword1=performance%20condition

    Does this condition work with remote computers? We are running the latest version of Automate Enterprise (11.0.6) and it doesn't appear to be triggering tasks when selecting "Remote Computer"

  • RE: Copying task steps crashes the application

    Followed by:

     

    Application: AMTB.exe
    Framework Version: v4.0.30319
    Description: The process was terminated due to an unhandled exception.
    Exception Info: System.Runtime.InteropServices.COMException
    at System.Runtime.InteropServices.Marshal.ThrowExceptionForHRInternal(Int32, IntPtr)
    at System.Windows.Clipboard.Flush()
    at System.Windows.Clipboard.CriticalSetDataObject(System.Object, Boolean)
    at System.Windows.Clipboard.SetDataInternal(System.String, System.Object)
    at AutoMate.TaskBuilder.Helpers.ClipboardHelper.Copy(System.Collections.Generic.List`1<AutoMate.TaskBuilder.ViewModels.StepViewModelBase>, Boolean)
    at AutoMate.TaskBuilder.ViewModels.WorkspaceViewModel.CopyCommand_Executed(System.Object, System.Windows.Input.ExecutedRoutedEventArgs)
    at System.Windows.Input.CommandBinding.OnExecuted(System.Object, System.Windows.Input.ExecutedRoutedEventArgs)
    at System.Windows.Input.CommandManager.ExecuteCommandBinding(System.Object, System.Windows.Input.ExecutedRoutedEventArgs, System.Windows.Input.CommandBinding)
    at System.Windows.Input.CommandManager.FindCommandBinding(System.Windows.Input.CommandBindingCollection, System.Object, System.Windows.RoutedEventArgs, System.Windows.Input.ICommand, Boolean)
    at System.Windows.Input.CommandManager.FindCommandBinding(System.Object, System.Windows.RoutedEventArgs, System.Windows.Input.ICommand, Boolean)
    at System.Windows.Input.CommandManager.OnExecuted(System.Object, System.Windows.Input.ExecutedRoutedEventArgs)
    at System.Windows.RoutedEventArgs.InvokeHandler(System.Delegate, System.Object)
    at System.Windows.RoutedEventHandlerInfo.InvokeHandler(System.Object, System.Windows.RoutedEventArgs)
    at System.Windows.EventRoute.InvokeHandlersImpl(System.Object, System.Windows.RoutedEventArgs, Boolean)
    at System.Windows.UIElement.RaiseEventImpl(System.Windows.DependencyObject, System.Windows.RoutedEventArgs)
    at System.Windows.UIElement.RaiseTrustedEvent(System.Windows.RoutedEventArgs)
    at System.Windows.Input.RoutedCommand.ExecuteImpl(System.Object, System.Windows.IInputElement, Boolean)
    at System.Windows.Input.CommandManager.TranslateInput(System.Windows.IInputElement, System.Windows.Input.InputEventArgs)
    at System.Windows.UIElement.OnKeyDownThunk(System.Object, System.Windows.Input.KeyEventArgs)
    at System.Windows.RoutedEventArgs.InvokeHandler(System.Delegate, System.Object)
    at System.Windows.RoutedEventHandlerInfo.InvokeHandler(System.Object, System.Windows.RoutedEventArgs)
    at System.Windows.EventRoute.InvokeHandlersImpl(System.Object, System.Windows.RoutedEventArgs, Boolean)
    at System.Windows.UIElement.RaiseEventImpl(System.Windows.DependencyObject, System.Windows.RoutedEventArgs)
    at System.Windows.UIElement.RaiseTrustedEvent(System.Windows.RoutedEventArgs)
    at System.Windows.Input.InputManager.ProcessStagingArea()
    at System.Windows.Input.InputManager.ProcessInput(System.Windows.Input.InputEventArgs)
    at System.Windows.Input.InputProviderSite.ReportInput(System.Windows.Input.InputReport)
    at System.Windows.Interop.HwndKeyboardInputProvider.ReportInput(IntPtr, System.Windows.Input.InputMode, Int32, System.Windows.Input.RawKeyboardActions, Int32, Boolean, Boolean, Int32)
    at System.Windows.Interop.HwndKeyboardInputProvider.ProcessKeyAction(System.Windows.Interop.MSG ByRef, Boolean ByRef)
    at System.Windows.Interop.HwndSource.CriticalTranslateAccelerator(System.Windows.Interop.MSG ByRef, System.Windows.Input.ModifierKeys)
    at System.Windows.Interop.HwndSource.OnPreprocessMessage(System.Object)
    at System.Windows.Threading.ExceptionWrapper.InternalRealCall(System.Delegate, System.Object, Int32)
    at System.Windows.Threading.ExceptionWrapper.TryCatchWhen(System.Object, System.Delegate, System.Object, Int32, System.Delegate)
    at System.Windows.Threading.Dispatcher.LegacyInvokeImpl(System.Windows.Threading.DispatcherPriority, System.TimeSpan, System.Delegate, System.Object, Int32)
    at System.Windows.Threading.Dispatcher.Invoke(System.Windows.Threading.DispatcherPriority, System.Delegate, System.Object)
    at System.Windows.Interop.HwndSource.OnPreprocessMessageThunk(System.Windows.Interop.MSG ByRef, Boolean ByRef)
    at System.Windows.Interop.ThreadMessageEventHandler.Invoke(System.Windows.Interop.MSG ByRef, Boolean ByRef)
    at System.Windows.Interop.ComponentDispatcherThread.RaiseThreadMessage(System.Windows.Interop.MSG ByRef)
    at System.Windows.Threading.Dispatcher.PushFrameImpl(System.Windows.Threading.DispatcherFrame)
    at System.Windows.Application.RunDispatcher(System.Object)
    at System.Windows.Application.RunInternal(System.Windows.Window)
    at AutoMate.TaskBuilder.App.Main()

     

  • RE: Copying task steps crashes the application

    Here's a snipped from the Windows event viewer that captured the error when this happened:

    Faulting application name: AMTB.exe, version: 11.0.1.17, time stamp: 0x5956723b
    Faulting module name: KERNELBASE.dll, version: 6.1.7601.24214, time stamp: 0x5b627415
    Exception code: 0xe0434352
    Fault offset: 0x000000000001a06d
    Faulting process id: 0x16f4
    Faulting application start time: 0x01d449d6c56347df
    Faulting application path: C:\Program Files\Automate Enterprise 11\AMTB.exe
    Faulting module path: C:\Windows\system32\KERNELBASE.dll
    Report Id: 0bbd6018-b5ca-11e8-8265-005056c00008

     

    Followed by:

     

    Application: AMTB.exe
    Framework Version: v4.0.30319
    Description: The process was terminated due to an unhandled exception.
    Exception Info: System.Runtime.InteropServices.COMException
    at System.Runtime.InteropServices.Marshal.ThrowExceptionForHRInternal(Int32, IntPtr)
    at System.Windows.Clipboard.Flush()
    at System.Windows.Clipboard.CriticalSetDataObject(System.Object, Boolean)
    at System.Windows.Clipboard.SetDataInternal(System.String, System.Object)
    at AutoMate.TaskBuilder.Helpers.ClipboardHelper.Copy(System.Collections.Generic.List`1<AutoMate.TaskBuilder.ViewModels.StepViewModelBase>, Boolean)
    at AutoMate.TaskBuilder.ViewModels.WorkspaceViewModel.CopyCommand_Executed(System.Object, System.Windows.Input.ExecutedRoutedEventArgs)
    at System.Windows.Input.CommandBinding.OnExecuted(System.Object, System.Windows.Input.ExecutedRoutedEventArgs)
    at System.Windows.Input.CommandManager.ExecuteCommandBinding(System.Object, System.Windows.Input.ExecutedRoutedEventArgs, System.Windows.Input.CommandBinding)
    at System.Windows.Input.CommandManager.FindCommandBinding(System.Windows.Input.CommandBindingCollection, System.Object, System.Windows.RoutedEventArgs, System.Windows.Input.ICommand, Boolean)
    at System.Windows.Input.CommandManager.FindCommandBinding(System.Object, System.Windows.RoutedEventArgs, System.Windows.Input.ICommand, Boolean)
    at System.Windows.Input.CommandManager.OnExecuted(System.Object, System.Windows.Input.ExecutedRoutedEventArgs)
    at System.Windows.RoutedEventArgs.InvokeHandler(System.Delegate, System.Object)
    at System.Windows.RoutedEventHandlerInfo.InvokeHandler(System.Object, System.Windows.RoutedEventArgs)
    at System.Windows.EventRoute.InvokeHandlersImpl(System.Object, System.Windows.RoutedEventArgs, Boolean)
    at System.Windows.UIElement.RaiseEventImpl(System.Windows.DependencyObject, System.Windows.RoutedEventArgs)
    at System.Windows.UIElement.RaiseTrustedEvent(System.Windows.RoutedEventArgs)
    at System.Windows.Input.RoutedCommand.ExecuteImpl(System.Object, System.Windows.IInputElement, Boolean)
    at System.Windows.Input.CommandManager.TranslateInput(System.Windows.IInputElement, System.Windows.Input.InputEventArgs)
    at System.Windows.UIElement.OnKeyDownThunk(System.Object, System.Windows.Input.KeyEventArgs)
    at System.Windows.RoutedEventArgs.InvokeHandler(System.Delegate, System.Object)
    at System.Windows.RoutedEventHandlerInfo.InvokeHandler(System.Object, System.Windows.RoutedEventArgs)
    at System.Windows.EventRoute.InvokeHandlersImpl(System.Object, System.Windows.RoutedEventArgs, Boolean)
    at System.Windows.UIElement.RaiseEventImpl(System.Windows.DependencyObject, System.Windows.RoutedEventArgs)
    at System.Windows.UIElement.RaiseTrustedEvent(System.Windows.RoutedEventArgs)
    at System.Windows.Input.InputManager.ProcessStagingArea()
    at System.Windows.Input.InputManager.ProcessInput(System.Windows.Input.InputEventArgs)
    at System.Windows.Input.InputProviderSite.ReportInput(System.Windows.Input.InputReport)
    at System.Windows.Interop.HwndKeyboardInputProvider.ReportInput(IntPtr, System.Windows.Input.InputMode, Int32, System.Windows.Input.RawKeyboardActions, Int32, Boolean, Boolean, Int32)
    at System.Windows.Interop.HwndKeyboardInputProvider.ProcessKeyAction(System.Windows.Interop.MSG ByRef, Boolean ByRef)
    at System.Windows.Interop.HwndSource.CriticalTranslateAccelerator(System.Windows.Interop.MSG ByRef, System.Windows.Input.ModifierKeys)
    at System.Windows.Interop.HwndSource.OnPreprocessMessage(System.Object)
    at System.Windows.Threading.ExceptionWrapper.InternalRealCall(System.Delegate, System.Object, Int32)
    at System.Windows.Threading.ExceptionWrapper.TryCatchWhen(System.Object, System.Delegate, System.Object, Int32, System.Delegate)
    at System.Windows.Threading.Dispatcher.LegacyInvokeImpl(System.Windows.Threading.DispatcherPriority, System.TimeSpan, System.Delegate, System.Object, Int32)
    at System.Windows.Threading.Dispatcher.Invoke(System.Windows.Threading.DispatcherPriority, System.Delegate, System.Object)
    at System.Windows.Interop.HwndSource.OnPreprocessMessageThunk(System.Windows.Interop.MSG ByRef, Boolean ByRef)
    at System.Windows.Interop.ThreadMessageEventHandler.Invoke(System.Windows.Interop.MSG ByRef, Boolean ByRef)
    at System.Windows.Interop.ComponentDispatcherThread.RaiseThreadMessage(System.Windows.Interop.MSG ByRef)
    at System.Windows.Threading.Dispatcher.PushFrameImpl(System.Windows.Threading.DispatcherFrame)
    at System.Windows.Application.RunDispatcher(System.Object)
    at System.Windows.Application.RunInternal(System.Windows.Window)
    at AutoMate.TaskBuilder.App.Main()

     

  • Copying task steps crashes the application

    System: Windows 2016 64 Bit

    Automate: Automate Enterprise 11.0.1.17

    Copying/cutting task steps crashes the task builder. We have a simple task that queries a database and writes the results to a file. Copying or cutting the SQL task step causes the Task Builder to crash every time we try to perform this action.

     

     

     

  • RE: Task running on agent could not start because the logon failed.

    A quick update on our end - we swapped the defaults for how workflows are executed to be as a "background user" in all cases, and the workflows started working. It just appears as though when we try to use the interactive Logon method we get this error. In the future we may have interactive tasks, so I'd still like to uncover the cause of failure.

    Happy to set up a remote session to debug further, but here's some info on our configuration:

    • OS: Windows 2016 64 bit
    • Automate: 11.0 Enterprise edition