Error message when running PowerShell Script

BobF · January 23, 2019 10:01AM

I am trying to run the following PowerShell comands

PS C:\Users\AUser> Connect-SqlClone -ServerUrl 'http://SQLCloneURL/'

$Image = Get-SqlCloneImage -Name 'Test_Image'

The error message I get is this -:

Get-SqlCloneImage : Cannot create and populate list type System.Collections.Generic.IReadOnlyCollection`1[System.String]. Path 'value.sourceLocationResourceNames', line 1, position 113.

At line:2 char:10

+ $Image = Get-SqlCloneImage -Name 'Test_Image'

+ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

+ CategoryInfo : NotSpecified: (:) [Get-SqlCloneImage], JsonSerializationException

+ FullyQualifiedErrorId : RedGate.SqlClone.PowerShell.Commands.GetSqlCloneImageCommand

What is causing the issue?

BobF · January 23, 2019 10:34AM

Sorry found the issue - https://documentation.red-gate.com/clone2/troubleshooting/common-issues/newtonsoft-json-jsonserializationexception-cannot-create-and-populate-list-type

BobF · January 23, 2019 10:36AM

Ok now I've found the underlying issue. This script is run from local machine, which does not have SQL Clone installed. The resolution seems to be to install the newtonsoft DLL on my machine, correct?

AaronC · January 24, 2019 10:56AM

Yes, the resolution would be replacing the Newtonsoft.json dll in the GAC of the machines that uses SQL Clone (Agent, Client and Server) with the one shipped with SQL Clone. Or remove the dll from GAC, which may cause problems in other applications.

Error message when running PowerShell Script

Answers

Product Learning

Community Forums

Events & Friends

Simple Talk