Problem in MSSQL deployment

KGuliyev

Hi,

We are getting error during database deploy with Azure Devops Server. Error occurs when redgate try to alter system versioned table.

error text is.

2023-05-23T12:09:47.4419254Z ##[warning]The error 'Either the parameter @objname is ambiguous or the claimed @objtype (INDEX) is wrong.' occurred when executing the following SQL:

EXEC sp_rename N'[dbo].[MEDICINES].[RG_Recovery_209b_PK_MEDICAMENTS_1]', N'PK_MEDICAMENTS_1', N'INDEX'

2023-05-23T12:09:48.2341173Z ##[warning]The error 'System versioned temporal table 'medical.dbo.MEDICINES' must have primary key defined.' occurred when executing the following SQL:

ALTER TABLE [dbo].[MEDICINES] SET (SYSTEM_VERSIONING = ON (HISTORY_TABLE = [dbo].[MEDICINE_HISTORY], HISTORY_RETENTION_PERIOD = INFINITE))

2023-05-23T12:09:48.3704015Z The database update failed

KGuliyev

DanC

Hi @KGuliyev

I'm going to reach out via a support ticket as we will need full debug looks to investigate this!

KGuliyev

DanC said:

Hi @KGuliyev

I'm going to reach out via a support ticket as we will need full debug looks to investigate this!

Any updates?))