User profile for JamesMB

Mike, Thanks. That's got me past the initial issue but now I'm seeing another new error. The test step is supposed to be testing the NuGet package built by my build step (and used to do this) but now I'm getting an error that looks like it's treating the root folder of the build as a script folder, which it is not. It says there's no RedGateDatabaseInfo.xml in the root (which is true, there isn't but there is in the NuGet package) and then errors trying to parse a SQL file which is in a separate folder from the database and is not even involved in the build (it's filtered out using a path filter in the build trigger, the actual database schema being in a different directory within the repository. As a result, I still can't enable the test step. Here is an extract from the build log: 2018-05-25T09:50:01.2217316Z ##[warning]No 'RedGateDatabaseInfo.xml' file located at the root of the scripts folder 'D:\agents\01\_work\72\s'. Some features, such as static data, may not work as expected. 2018-05-25T09:50:14.8868666Z ##[error]RedGate.DLMAutomation.Shared.Errors.TerminatingException: SQLCompare.exe terminated with the exit code 126: Failed due to a SQL Server error. 2018-05-25T09:50:14.8868666Z SQLCompare.exe produced this error output: 2018-05-25T09:50:14.8868666Z Error: Comparison of 'Scripts.s' and 'bbamtortst01.dlmautomation_86e0d208-947a-4ca7-8937-59bfbae35871' failed: Errors occurred whilst parsing file [image] \agents\01\_work\72\s\Torch\CREXML\UpsertCalculation.sql '' at line 6, column 25 2018-05-25T09:50:14.8868666Z Comparison of 'Scripts.s' and 'bbamtortst01.dlmautomation_86e0d208-947a-4ca7-8937-59bfbae35871' failed: Errors occurred whilst parsing file [image] \agents\01\_work\72\s\Torch\CREXML\UpsertCalculation.sql Note that it shouldn't go near the Torch\CREXML folder (and never did before) as the database schema is in a completely separate folder under Torch\DB / comments

Mike,Thanks. That's got me past the initial issue but now I'm seeing another new error. The test step is supposed to be testing the NuGet package built by my build step (and used to do this) but no...

0 votes

TFS build suddently started failing with an exception adding queryBatchTimeout

I've had to increase the queryBatchTimeout for a database build to prevent it failing with timeouts and at first this worked fine but since yesterday it started failing with an error that suggests ...

3 followers 3 comments 0 votes

Hi Grant, I've only just seen the database for the first time yesterday, so I'm not really that familiar with it myself, I just know that I've never seen SQL compare behave in this way before. I've been told that there's an awful partitioning scheme with thousands of partitions and the colleague that told me this seemed to think that was most likely the issue. There are just over 400 tables and I know that there are also a number of indexed views. Selecting from sys.indexes gives me a count of just under 1100 indexes. Hope that helps James / comments

Hi Grant,I've only just seen the database for the first time yesterday, so I'm not really that familiar with it myself, I just know that I've never seen SQL compare behave in this way before. I've ...

0 votes

How can we help you today?

JamesMB

Activity overview