Comments
Sort by recent activity
A. SQL Clone It's an amazing product! / comments
A. SQL Clone It's an amazing product!
Ok found the issue. There is a rule which Truncates data in a processing table, then repopulates the table with data. All the tasks use the data in that processing table. When I added some new command rules they were not dependant on the first step completing. So they ran the scripts against the processing table which had Zero records. The deletion scripts ran successfully as they use the records in the processing table to identify the records to delete. Yes Chris Unwin has done a nice video on setting up dependency in Redgate University. Which I will need to study some more, to see if I can set up the dependency as suggested. Today was another learning opportunity which hopefully I have gained some knowledge from. / comments
Ok found the issue. There is a rule which Truncates data in a processing table, then repopulates the table with data. All the tasks use the data in that processing table. When I added some new c...
Hi @Alex B thanks for the reply. Most of the Command Rules that I have created till now have been Script mode (I think). That is to say on the 'Options' tab select "Check for errors in every...." line, ending with a semicolon? The only significant change that I have made in my approach till now is to use a CTE to populate a temp table. I'm going to do some testing again this afternoon (hopefully) to see if I can reproduce the results I saw yesterday. / comments
Hi @Alex B thanks for the reply.Most of the Command Rules that I have created till now have been Script mode (I think). That is to say on the 'Options' tab select"Check for errors in every...." lin...
Ok after some testing I was able to reproduce the error [image] I have two commands, one check's for table existence, the next one creates a temp table. Then semicolonon and then a CTE. With the semicolon at the start of a the CTE statement is the issue. At least that's my assumption. I am going to re-write the script and see if it I can get it to work / comments
Ok after some testing I was able to reproduce the error I have two commands, one check's for table existence, the next one creates a temp table. Then semicolonon and then a CTE. With the semico...
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? / comments
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, cor...
Sorry found the issue - https://documentation.red-gate.com/clone2/troubleshooting/common-issues/newtonsoft-json-jsonserializationexception-cannot-create-and-populate-list-type / comments
Sorry found the issue - https://documentation.red-gate.com/clone2/troubleshooting/common-issues/newtonsoft-json-jsonserializationexception-cannot-create-and-populate-list-type
Thanks for the reply "Just to help us, can you tell us the size of your datamasker file?" - 5mb "Regarding to reducing the datamasker file, theres no way of reducing it other than removing rules" - tried that then saved the updated datamasker file. The size did not significantly change only reduced by 10's of KB :-( / comments
Thanks for the reply"Just to help us, can you tell us the size of your datamasker file?" - 5mb"Regarding to reducing the datamasker file, theres no way of reducing it other than removing rules" - t...
Please ignore the previous question, I was having a silly moment. All sorted now :-) / comments
Please ignore the previous question, I was having a silly moment. All sorted now :-)
Opps my bad! Yes the directory in the error message was changed to the protect the innocent. Yes the directory does exist. When I was testing this on Friday I was able to create images without any issues. So the AD group my account is a part of had the required permissions to networkshare on Friday. All we have done since then is download and upgrade the version of SQL Clone to 3.0.7.14330. I will ask our sysadmin to double check the permissions on the networkshare. That said they might be a bit grumpy about since that was one aspect set up documentation that could be improved. / comments
Opps my bad! Yes the directory in the error message was changed to the protect the innocent. Yes the directory does exist. When I was testing this on Friday I was able to create images without a...
Follow up question, we might require to change the location of the file share where the images are stored. How can we do this? I cannot see anything in the GUI or documentation. Thanks / comments
Follow up question, we might require to change the location of the file share where the images are stored. How can we do this? I cannot see anything in the GUI or documentation. Thanks