First published on MSDN on Aug 06, 2018
Authored by rajsell@microsoft.com
Overview
The Database Experimentation Assistant (DEA) is a new A/B testing solution for SQL Server upgrades. Th...
Updated Feb 21, 2023
Version 9.0
Blog Post
I get the following bacpac error on the analysis when I compare two traces or XEvents when SQL 2017 i used for the repository. I have no problems if SQL 2016 is the repository used for analysis.
Here is what is braking incase it helps.
DEA Information: 0 : DiagnosticEvent, 10/17/2019 19:20:16, Data: {"Message":"Error occurred while running process. Command: \"C:\\Program Files\\Microsoft SQL Server\\130\\DAC\\bin\\SqlPackage.exe /Action:Publish /SourceFile:\"ExperimentationDatabase.dacpac\" /TargetDatabaseName:\"AnalysisTempTable637069368000347489\" /TargetServerName:\"DESKTOP-H2V08UL\" /Variables:\"DatabaseA\"=\"ATempTable637069368000347489\" /Variables:\"DatabaseB\"=\"BTempTable637069368000347489\" /Variables:\"ReportName\"=\"TempTable\" /Variables:\"DEAVersion\"=\"2.6.61459.2\" /Variables:\"SchemaVersion\"=\"1.3\" /p:BlockOnPossibleDataLoss=False\", Error:\"*** Could not deploy package.\r\nUnable to connect to master or target server 'AnalysisTempTable637069368000347489'. You must have a user with the same password in master or target server 'AnalysisTempTable637069368000347489'.\r\n\r\n\"","Timestamp":"2019-10-17T19:20:16.2065652Z"