Issue Description

If you are receiving errors in your newly added Insert Into Data Source activity referring to "Method invocation failed", you will need to update the PowerShell version on your CSPro server.

When viewing a batch error in the Monitor, you are receiving the following error message on the Insert Into Data Source activity

System.Management.Automation.RuntimeException: Method invocation failed because [System.Text.StringBuilder] does not contain a method named 'new'. at System.Management.Automation.Runspaces.PipelineBase.Invoke(IEnumerable input) at System.Management.Automation.PowerShell.Worker.ConstructPipelineAndDoWork(Runspace rs, Boolean performSyncInvoke) at System.Management.Automation.PowerShell.Worker.CreateRunspaceIfNeededAndDoWork(Runspace rsToUse, Boolean isSync) at System.Management.Automation.PowerShell.CoreInvokeHelper[TInput,TOutput](PSDataCollection`1 input, PSDataCollection`1 output, PSInvocationSettings settings) at System.Management.Automation.PowerShell.CoreInvoke[TInput,TOutput](PSDataCollection`1 input, PSDataCollection`1 output, PSInvocationSettings settings) at System.Management.Automation.PowerShell.Invoke(IEnumerable input, PSInvocationSettings settings) at WorkerX.Laborer.ExecutePowerShellWithFlags(WorkItem& workitem, String command, Boolean& hadErrorOutput, Boolean& hadTerminatingException, Object& outputFromRoutingExpression, Nullable`1 executionid, Boolean useLocalFunctions)

Issue Resolution

You see this error message because your PowerShell version is not up to date on your CSPro server.

1. Please navigate to the following Microsoft page:
   https://docs.microsoft.com/en-us/powershell/scripting/setup/installing-windows-powershell?view=powershell-6
2. Browse to the section titled Upgrading existing Windows PowerShell
3. Install the latest version of the Windows Management Framework suitable for your operating system.
4. Resubmit all error batches pertaining to this from the Monitor in CSPro