#visual-studio-2015 #sql-server-data-tools
#visual-studio-2015 #sql-server-data-tools
Вопрос:
В нашем решении VStudio 2015 у нас есть ряд SSDT. Один из них возвращает исключение «Неожиданно завершилась ошибка задачи «SqlBuildTask». Microsoft.Data.Инструменты.Schema.Sql.Build.BuildFailedException: запись с тем же ключом уже существует». Я зашел в Microsoft.Data.Инструменты.Схема.SqlTasks.targets и взглянул на (публикуя его ниже)
<SqlBuildTask PostdeployItem="@(PostDeploy->'%(FullPath)')"
PredeployItem="@(PreDeploy->'%(FullPath)')"
RefactorLog="@(RefactorLog->'%(FullPath)')"
SqlTarget="@(SqlTarget)"
ContributorArguments="$(ContributorArguments)"
BuildExtensionConfiguration="@(BuildExtensionConfiguration)"
BuildContributors="$(BuildContributors)"
DeploymentExtensionConfiguration="@(DeploymentExtensionConfiguration)"
DeploymentContributors="$(DeploymentContributors)"
ConnectionString="$(TargetConnectionString)"
CreateScriptFileName="$(CreateScriptFileName)"
DacApplicationName="$(DacApplicationName)"
DacDescription="$(DacDescription)"
DacFile="@(DacFile)"
DacVersion="$(DacVersion)"
DatabaseName="$(TargetDatabase)"
DatabaseSchemaProviderName="$(DSP)"
DefaultSchema="$(DefaultSchema)"
DeploymentScriptName="$(DeployScriptFileName)"
DeployToDatabase="$(UpdateDatabase)"
GenerateCreateScript="$(GenerateCreateScript)"
GenerateDac="$(GenerateDac)"
ImplicitDllAssemblyName="$(AssemblyName)"
ImplicitDllAssemblyOwner="$(AssemblyOwner)"
ImplicitDllFileName="$(IntermediateTargetFullFileName)"
ImplicitDllSymbolsFileName="$(IntermediateSymbolsFullFileName)"
ImplicitDllGenerateSqlClrDdl="$(GenerateSqlClrDdl)"
ImplicitDllIsVisible="$(IsVisible)"
ImplicitDllPermissionSet="$(PermissionSet)"
IntermediateDirectory="$(GeneratedFilesIntermediatePath)"
ModelCollation="$(ModelCollation)"
OutputDirectory="$(TargetDir)"
PreserveHeaderComments="$(PreserveHeaderComments)"
Source="@(Build->'%(FullPath)')"
SqlCmdVariables="@(SqlCmdVariables)"
SqlReferencePath="@(SqlReferencePath)"
SuppressTSqlWarnings="$(SuppressTSqlWarnings)"
TreatTSqlWarningsAsErrors="$(TreatTSqlWarningsAsErrors)"
ValidateCasingOnIdentifiers="$(ValidateCasingOnIdentifiers)"
CmdLineInMemoryStorage="$(CmdLineInMemoryStorage)"
DefaultCollation="$(DefaultCollation)"
AnsiNullDefault="$(AnsiNullDefault)"
AnsiNulls="$(AnsiNulls)"
AnsiPadding="$(AnsiPadding)"
AnsiWarnings="$(AnsiWarnings)"
ArithAbort="$(ArithAbort)"
ConcatNullYieldsNull="$(ConcatNullYieldsNull)"
QuotedIdentifier="$(QuotedIdentifier)"
NumericRoundAbort="$(NumericRoundAbort)"
RecursiveTriggersEnabled="$(RecursiveTriggersEnabled)"
DatabaseChaining="$(DatabaseChaining)"
DatabaseState="$(DatabaseState)"
UpdateOptions="$(UpdateOptions)"
CloseCursorOnCommitEnabled="$(CloseCursorOnCommitEnabled)"
DefaultCursor="$(DefaultCursor)"
AutoClose="$(AutoClose)"
AutoCreateStatistics="$(AutoCreateStatistics)"
AutoShrink="$(AutoShrink)"
AutoUpdateStatistics="$(AutoUpdateStatistics)"
TornPageDetection="$(TornPageDetection)"
DatabaseAccess="$(DatabaseAccess)"
Recovery="$(Recovery)"
EnableFullTextSearch="$(EnableFullTextSearch)"
DefaultFilegroup="$(DefaultFilegroup)"
Trustworthy="$(Trustworthy)"
AutoUpdateStatisticsAsynchronously="$(AutoUpdateStatisticsAsynchronously)"
PageVerify="$(PageVerify)"
ServiceBrokerOption="$(ServiceBrokerOption)"
DateCorrelationOptimizationOn="$(DateCorrelationOptimizationOn)"
Parameterization="$(Parameterization)"
AllowSnapshotIsolation="$(AllowSnapshotIsolation)"
ReadCommittedSnapshot="$(ReadCommittedSnapshot)"
VardecimalStorageFormatOn="$(VardecimalStorageFormatOn)"
SupplementalLoggingOn="$(SupplementalLoggingOn)"
CompatibilityMode="$(CompatibilityMode)"
DefaultFileStreamFilegroup="$(DefaultFileStreamFilegroup)"
IsChangeTrackingOn="$(IsChangeTrackingOn)"
IsChangeTrackingAutoCleanupOn="$(IsChangeTrackingAutoCleanupOn)"
ChangeTrackingRetentionPeriod="$(ChangeTrackingRetentionPeriod)"
ChangeTrackingRetentionUnit="$(ChangeTrackingRetentionUnit)"
IsEncryptionOn="$(IsEncryptionOn)"
IsBrokerPriorityHonored="$(IsBrokerPriorityHonored)"
Containment="$(Containment)"
DatabaseDefaultLanguage="$(DatabaseDefaultLanguage)"
DatabaseDefaultFulltextLanguage="$(DatabaseDefaultFulltextLanguage)"
IsNestedTriggersOn="$(IsNestedTriggersOn)"
IsTransformNoiseWordsOn="$(IsTransformNoiseWordsOn)"
TwoDigitYearCutoff="$(TwoDigitYearCutoff)"
NonTransactedFileStreamAccess="$(NonTransactedFileStreamAccess)"
FileStreamDirectoryName="$(FileStreamDirectoryName)"
TargetRecoveryTimePeriod="$(TargetRecoveryTimePeriod)"
TargetRecoveryTimeUnit="$(TargetRecoveryTimeUnit)"
DelayedDurability="$(DelayedDurability)"
AutoCreateStatisticsIncremental="$(AutoCreateStatisticsIncremental)"
MemoryOptimizedElevateToSnapshot="$(MemoryOptimizedElevateToSnapshot)"
QueryStoreCaptureMode="$(QueryStoreCaptureMode)"
QueryStoreDesiredState="$(QueryStoreDesiredState)"
QueryStoreFlushInterval="$(QueryStoreFlushInterval)"
QueryStoreStatsInterval="$(QueryStoreStatsInterval)"
QueryStoreMaxPlansPerQuery="$(QueryStoreMaxPlansPerQuery)"
QueryStoreStaleQueryThreshold="$(QueryStoreStaleQueryThreshold)"
QueryStoreMaxStorageSize="$(QueryStoreMaxStorageSize)"
DbScopedConfigLegacyCardinalityEstimation="$(DbScopedConfigLegacyCardinalityEstimation)"
DbScopedConfigLegacyCardinalityEstimationSecondary="$(DbScopedConfigLegacyCardinalityEstimationSecondary)"
DbScopedConfigMaxDOP="$(DbScopedConfigMaxDOP)"
DbScopedConfigMaxDOPSecondary="$(DbScopedConfigMaxDOPSecondary)"
DbScopedConfigParameterSniffing="$(DbScopedConfigParameterSniffing)"
DbScopedConfigParameterSniffingSecondary="$(DbScopedConfigParameterSniffingSecondary)"
DbScopedConfigOptimizerHotfixes="$(DbScopedConfigOptimizerHotfixes)"
DbScopedConfigOptimizerHotfixesSecondary="$(DbScopedConfigOptimizerHotfixesSecondary)"
TemporalHistoryRetentionEnabled="$(TemporalHistoryRetentionEnabled)"
AdditionalDeploymentContributorArguments="$(AdditionalDeploymentContributorArguments)"
AdditionalDeploymentContributors="$(AdditionalDeploymentContributors)"
AllowDropBlockingAssemblies="$(AllowDropBlockingAssemblies)"
AllowIncompatiblePlatform="$(AllowIncompatiblePlatform)"
AllowUnsafeRowLevelSecurityDataMovement="$(AllowUnsafeRowLevelSecurityDataMovement)"
BackupDatabaseBeforeChanges="$(BackupDatabaseBeforeChanges)"
BlockOnPossibleDataLoss="$(BlockOnPossibleDataLoss)"
BlockWhenDriftDetected="$(BlockWhenDriftDetected)"
CommentOutSetVarDeclarations="$(CommentOutSetVarDeclarations)"
CompareUsingTargetCollation="$(CompareUsingTargetCollation)"
CreateNewDatabase="$(CreateNewDatabase)"
DeployDatabaseInSingleUserMode="$(DeployDatabaseInSingleUserMode)"
DisableAndReenableDdlTriggers="$(DisableAndReenableDdlTriggers)"
DoNotAlterChangeDataCaptureObjects="$(DoNotAlterChangeDataCaptureObjects)"
DoNotAlterReplicatedObjects="$(DoNotAlterReplicatedObjects)"
DoNotDropAggregates="$(DoNotDropAggregates)"
DoNotDropApplicationRoles="$(DoNotDropApplicationRoles)"
DoNotDropAssemblies="$(DoNotDropAssemblies)"
DoNotDropAsymmetricKeys="$(DoNotDropAsymmetricKeys)"
DoNotDropAudits="$(DoNotDropAudits)"
DoNotDropBrokerPriorities="$(DoNotDropBrokerPriorities)"
DoNotDropCertificates="$(DoNotDropCertificates)"
DoNotDropClrUserDefinedTypes="$(DoNotDropClrUserDefinedTypes)"
DoNotDropColumnEncryptionKeys="$(DoNotDropColumnEncryptionKeys)"
DoNotDropColumnMasterKeys="$(DoNotDropColumnMasterKeys)"
DoNotDropContracts="$(DoNotDropContracts)"
DoNotDropCredentials="$(DoNotDropCredentials)"
DoNotDropCryptographicProviders="$(DoNotDropCryptographicProviders)"
DoNotDropDatabaseAuditSpecifications="$(DoNotDropDatabaseAuditSpecifications)"
DoNotDropDatabaseRoles="$(DoNotDropDatabaseRoles)"
DoNotDropDatabaseScopedCredentials="$(DoNotDropDatabaseScopedCredentials)"
DoNotDropDatabaseTriggers="$(DoNotDropDatabaseTriggers)"
DoNotDropDefaults="$(DoNotDropDefaults)"
DoNotDropEndpoints="$(DoNotDropEndpoints)"
DoNotDropErrorMessages="$(DoNotDropErrorMessages)"
DoNotDropEventNotifications="$(DoNotDropEventNotifications)"
DoNotDropEventSessions="$(DoNotDropEventSessions)"
DoNotDropExtendedProperties="$(DoNotDropExtendedProperties)"
DoNotDropExternalDataSources="$(DoNotDropExternalDataSources)"
DoNotDropExternalFileFormats="$(DoNotDropExternalFileFormats)"
DoNotDropExternalTables="$(DoNotDropExternalTables)"
DoNotDropFilegroups="$(DoNotDropFilegroups)"
DoNotDropFileTables="$(DoNotDropFileTables)"
DoNotDropFullTextCatalogs="$(DoNotDropFullTextCatalogs)"
DoNotDropFullTextStoplists="$(DoNotDropFullTextStoplists)"
DoNotDropLinkedServerLogins="$(DoNotDropLinkedServerLogins)"
DoNotDropLinkedServers="$(DoNotDropLinkedServers)"
DoNotDropLogins="$(DoNotDropLogins)"
DoNotDropMessageTypes="$(DoNotDropMessageTypes)"
DoNotDropPartitionFunctions="$(DoNotDropPartitionFunctions)"
DoNotDropPartitionSchemes="$(DoNotDropPartitionSchemes)"
DoNotDropPermissions="$(DoNotDropPermissions)"
DoNotDropQueues="$(DoNotDropQueues)"
DoNotDropRemoteServiceBindings="$(DoNotDropRemoteServiceBindings)"
DoNotDropRoleMembership="$(DoNotDropRoleMembership)"
DoNotDropRoutes="$(DoNotDropRoutes)"
DoNotDropRules="$(DoNotDropRules)"
DoNotDropScalarValuedFunctions="$(DoNotDropScalarValuedFunctions)"
DoNotDropSearchPropertyLists="$(DoNotDropSearchPropertyLists)"
DoNotDropSecurityPolicies="$(DoNotDropSecurityPolicies)"
DoNotDropSequences="$(DoNotDropSequences)"
DoNotDropServerAuditSpecifications="$(DoNotDropServerAuditSpecifications)"
DoNotDropServerRoleMembership="$(DoNotDropServerRoleMembership)"
DoNotDropServerRoles="$(DoNotDropServerRoles)"
DoNotDropServerTriggers="$(DoNotDropServerTriggers)"
DoNotDropServices="$(DoNotDropServices)"
DoNotDropSignatures="$(DoNotDropSignatures)"
DoNotDropStoredProcedures="$(DoNotDropStoredProcedures)"
DoNotDropSymmetricKeys="$(DoNotDropSymmetricKeys)"
DoNotDropSynonyms="$(DoNotDropSynonyms)"
DoNotDropTables="$(DoNotDropTables)"
DoNotDropTableValuedFunctions="$(DoNotDropTableValuedFunctions)"
DoNotDropUserDefinedDataTypes="$(DoNotDropUserDefinedDataTypes)"
DoNotDropUserDefinedTableTypes="$(DoNotDropUserDefinedTableTypes)"
DoNotDropUsers="$(DoNotDropUsers)"
DoNotDropViews="$(DoNotDropViews)"
DoNotDropXmlSchemaCollections="$(DoNotDropXmlSchemaCollections)"
DropConstraintsNotInSource="$(DropConstraintsNotInSource)"
DropDmlTriggersNotInSource="$(DropDmlTriggersNotInSource)"
DropExtendedPropertiesNotInSource="$(DropExtendedPropertiesNotInSource)"
DropIndexesNotInSource="$(DropIndexesNotInSource)"
DropObjectsNotInSource="$(DropObjectsNotInSource)"
DropPermissionsNotInSource="$(DropPermissionsNotInSource)"
DropRoleMembersNotInSource="$(DropRoleMembersNotInSource)"
DropStatisticsNotInSource="$(DropStatisticsNotInSource)"
ExcludeAggregates="$(ExcludeAggregates)"
ExcludeApplicationRoles="$(ExcludeApplicationRoles)"
ExcludeAssemblies="$(ExcludeAssemblies)"
ExcludeAsymmetricKeys="$(ExcludeAsymmetricKeys)"
ExcludeAudits="$(ExcludeAudits)"
ExcludeBrokerPriorities="$(ExcludeBrokerPriorities)"
ExcludeCertificates="$(ExcludeCertificates)"
ExcludeClrUserDefinedTypes="$(ExcludeClrUserDefinedTypes)"
ExcludeColumnEncryptionKeys="$(ExcludeColumnEncryptionKeys)"
ExcludeColumnMasterKeys="$(ExcludeColumnMasterKeys)"
ExcludeContracts="$(ExcludeContracts)"
ExcludeCredentials="$(ExcludeCredentials)"
ExcludeCryptographicProviders="$(ExcludeCryptographicProviders)"
ExcludeDatabaseAuditSpecifications="$(ExcludeDatabaseAuditSpecifications)"
ExcludeDatabaseRoles="$(ExcludeDatabaseRoles)"
ExcludeDatabaseScopedCredentials="$(ExcludeDatabaseScopedCredentials)"
ExcludeDatabaseTriggers="$(ExcludeDatabaseTriggers)"
ExcludeDefaults="$(ExcludeDefaults)"
ExcludeEndpoints="$(ExcludeEndpoints)"
ExcludeErrorMessages="$(ExcludeErrorMessages)"
ExcludeEventNotifications="$(ExcludeEventNotifications)"
ExcludeEventSessions="$(ExcludeEventSessions)"
ExcludeExternalDataSources="$(ExcludeExternalDataSources)"
ExcludeExternalFileFormats="$(ExcludeExternalFileFormats)"
ExcludeExternalTables="$(ExcludeExternalTables)"
ExcludeFilegroups="$(ExcludeFilegroups)"
ExcludeFileTables="$(ExcludeFileTables)"
ExcludeFullTextCatalogs="$(ExcludeFullTextCatalogs)"
ExcludeFullTextStoplists="$(ExcludeFullTextStoplists)"
ExcludeLinkedServerLogins="$(ExcludeLinkedServerLogins)"
ExcludeLinkedServers="$(ExcludeLinkedServers)"
ExcludeLogins="$(ExcludeLogins)"
ExcludeMessageTypes="$(ExcludeMessageTypes)"
ExcludePartitionFunctions="$(ExcludePartitionFunctions)"
ExcludePartitionSchemes="$(ExcludePartitionSchemes)"
ExcludeQueues="$(ExcludeQueues)"
ExcludeRemoteServiceBindings="$(ExcludeRemoteServiceBindings)"
ExcludeRoutes="$(ExcludeRoutes)"
ExcludeRules="$(ExcludeRules)"
ExcludeScalarValuedFunctions="$(ExcludeScalarValuedFunctions)"
ExcludeSearchPropertyLists="$(ExcludeSearchPropertyLists)"
ExcludeSecurityPolicies="$(ExcludeSecurityPolicies)"
ExcludeSequences="$(ExcludeSequences)"
ExcludeServerAuditSpecifications="$(ExcludeServerAuditSpecifications)"
ExcludeServerRoleMembership="$(ExcludeServerRoleMembership)"
ExcludeServerRoles="$(ExcludeServerRoles)"
ExcludeServerTriggers="$(ExcludeServerTriggers)"
ExcludeServices="$(ExcludeServices)"
ExcludeSignatures="$(ExcludeSignatures)"
ExcludeStoredProcedures="$(ExcludeStoredProcedures)"
ExcludeSymmetricKeys="$(ExcludeSymmetricKeys)"
ExcludeSynonyms="$(ExcludeSynonyms)"
ExcludeTables="$(ExcludeTables)"
ExcludeTableValuedFunctions="$(ExcludeTableValuedFunctions)"
ExcludeUserDefinedDataTypes="$(ExcludeUserDefinedDataTypes)"
ExcludeUserDefinedTableTypes="$(ExcludeUserDefinedTableTypes)"
ExcludeUsers="$(ExcludeUsers)"
ExcludeViews="$(ExcludeViews)"
ExcludeXmlSchemaCollections="$(ExcludeXmlSchemaCollections)"
GenerateSmartDefaults="$(GenerateSmartDefaults)"
IgnoreAnsiNulls="$(IgnoreAnsiNulls)"
IgnoreAuthorizer="$(IgnoreAuthorizer)"
IgnoreColumnCollation="$(IgnoreColumnCollation)"
IgnoreComments="$(IgnoreComments)"
IgnoreCryptographicProviderFilePath="$(IgnoreCryptographicProviderFilePath)"
IgnoreDdlTriggerOrder="$(IgnoreDdlTriggerOrder)"
IgnoreDdlTriggerState="$(IgnoreDdlTriggerState)"
IgnoreDefaultSchema="$(IgnoreDefaultSchema)"
IgnoreDmlTriggerOrder="$(IgnoreDmlTriggerOrder)"
IgnoreDmlTriggerState="$(IgnoreDmlTriggerState)"
IgnoreExtendedProperties="$(IgnoreExtendedProperties)"
IgnoreFileAndLogFilePath="$(IgnoreFileAndLogFilePath)"
IgnoreFilegroupPlacement="$(IgnoreFilegroupPlacement)"
IgnoreFileSize="$(IgnoreFileSize)"
IgnoreFillFactor="$(IgnoreFillFactor)"
IgnoreFullTextCatalogFilePath="$(IgnoreFullTextCatalogFilePath)"
IgnoreIdentitySeed="$(IgnoreIdentitySeed)"
IgnoreIncrement="$(IgnoreIncrement)"
IgnoreIndexOptions="$(IgnoreIndexOptions)"
IgnoreIndexPadding="$(IgnoreIndexPadding)"
IgnoreKeywordCasing="$(IgnoreKeywordCasing)"
IgnoreLockHintsOnIndexes="$(IgnoreLockHintsOnIndexes)"
IgnoreLoginSids="$(IgnoreLoginSids)"
IgnoreNotForReplication="$(IgnoreNotForReplication)"
IgnoreObjectPlacementOnPartitionScheme="$(IgnoreObjectPlacementOnPartitionScheme)"
IgnorePartitionSchemes="$(IgnorePartitionSchemes)"
IgnorePermissions="$(IgnorePermissions)"
IgnoreQuotedIdentifiers="$(IgnoreQuotedIdentifiers)"
IgnoreRoleMembership="$(IgnoreRoleMembership)"
IgnoreRouteLifetime="$(IgnoreRouteLifetime)"
IgnoreSemicolonBetweenStatements="$(IgnoreSemicolonBetweenStatements)"
IgnoreTableOptions="$(IgnoreTableOptions)"
IgnoreUserSettingsObjects="$(IgnoreUserSettingsObjects)"
IgnoreWhitespace="$(IgnoreWhitespace)"
IgnoreWithNocheckOnCheckConstraints="$(IgnoreWithNocheckOnCheckConstraints)"
IgnoreWithNocheckOnForeignKeys="$(IgnoreWithNocheckOnForeignKeys)"
IncludeCompositeObjects="$(IncludeCompositeObjects)"
IncludeTransactionalScripts="$(IncludeTransactionalScripts)"
NoAlterStatementsToChangeCLRTypes="$(NoAlterStatementsToChangeCLRTypes)"
PopulateFilesOnFileGroups="$(PopulateFilesOnFileGroups)"
RegisterDataTierApplication="$(RegisterDataTierApplication)"
ScriptDatabaseCollation="$(ScriptDatabaseCollation)"
ScriptDatabaseCompatibility="$(ScriptDatabaseCompatibility)"
ScriptDatabaseOptions="$(ScriptDatabaseOptions)"
ScriptDeployStateChecks="$(ScriptDeployStateChecks)"
ScriptFileSize="$(ScriptFileSize)"
ScriptNewConstraintValidation="$(ScriptNewConstraintValidation)"
ScriptRefreshModule="$(ScriptRefreshModule)"
TargetDatabaseName="$(TargetDatabaseName)"
TreatVerificationErrorsAsWarnings="$(TreatVerificationErrorsAsWarnings)"
UnmodifiableObjectWarnings="$(UnmodifiableObjectWarnings)"
VerifyCollationCompatibility="$(VerifyCollationCompatibility)"
VerifyDeployment="$(VerifyDeployment)"
>
<Output TaskParameter="IntermediateFileWrites" ItemName="FileWrites"/>
</SqlBuildTask>
On our previous sprint, the build and deploy of the project was working fine. When I did a TFS compare with the previous version there are no major differences.
Это то, что я уже сделал:
-
Я обновил SSDT до самой последней версии (не исправил ее)
-
удален Microsoft.Data.Инструменты.Схема.Файл SqlTasks.targets и восстановление установки ssdt (это тоже не исправило)
Я все еще ищу любые дублированные ключи в целевом файле, как указывает исключение
Любая помощь будет принята с благодарностью…
Ответ №1:
Похоже, это произошло из-за того, что файл журнала рефакторинга (который содержит информацию о переименовании столбцов) содержал две или более записей с одинаковым значением ChangeDateTime. Существует ошибка в том, как SSDT обрабатывает эти дубликаты.
Ответ №2:
У меня была та же проблема. Я просто закрываю и перезапускаю VS 2017, и он работает.
Ответ №3:
Мне пришлось удалить все, кроме файлов, начинающихся с «.NET» в следующей папке:
...UserAccountUsedByTfsBuildAppDataLocalTemp
Это сделало это!
Ответ №4:
- Я сделал это, удалив временную папку локальной системы
- Проверка в Visual Studio 2017 — открыт файл сравнения проекта SSDT — Schema
- Если открыто, закройте то же самое и перезапустите Visual Studio 2017
- Это работает для меня — теперь сборка выполнена успешно
Ответ №5:
У меня была та же проблема. Я просто закрываю и перезапускаю свой VS 2022, и он работает