SQL Data Generator 3 for DLM Automation Version

spencer_swindell

Hello,

I have a project in Jenkins where I am trying to use the DLM Automation Plugin to run the Test Database Package step. In the step I defined a SQL Data Generator Project that I have created to generate some test data. When attempting to run the Jenkins project, the process fails when trying to run the SQL Data Generator Project, and returns this message in the output:

Invoke-DlmDatabaseTests : SQLDataGenerator.exe terminated with the exit code
200: Fatal execution error.

Looking through the output I see the command calling SQLDataGenerator.exe and running that I see the following error:

SQL Data Generator 3 for DLM Automation V3.2.5.1285
======================================================================================================================
Copyright Copyright c Red Gate Software Ltd 2008-2017

Loading Project
Error: There was a problem creating/loading the project. Invalid file C:\Program Files (x86)\Jenkins\workspace\StockPrices Project\Databases\DataGenerator\StockPricesDataGeneration.sqlgen

I've verified that the file exists in the path and can even open it in SQL Data Generator. I did notice that this output reports version 3.2.5.1285, and the file was authored in SQL Data Generator v4.0.1.1398. Is this error due to an incompatibility between the two versions? If so is there a way to either author the sqlgen file in the correct version or upgrade the exe that is called by the dlm.

Thanks in advance.

Eddie D

Hi, thank you for your forum post.

I suspect that the version of SQL Data Generator (just the command line version) for DLM Automation installed in this folder:

C:\Program Files (x86)\Red Gate\DLM Automation 2\SDG\

Is an older version, compared to the version of SQL Data Generator in the this path where you have both the GUI and command line version:

C:\Program Files (x86)\Red Gate\SQL Data Generator 4\

I recommend that you upgrade your DLM Automation 2, version to V2.0.26.606 released on the 12th December 2017, which includes an upgrade to SQL Data Generator V4.0.2 (added in V2.0.25.599 released 7th December 2017). Please use the link below to download:
ftp://support.red-gate.com/patches/DLMAutomation/18Dec2017/DLMAutomation.zip

This allow you to use the new project file created using V4.* with DLM Automation 2 and Jenkins installation.