How can we help you today? How can we help you today?

Problem in MSSQL deployment

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


karim guliyev
0

Comments

3 comments

Sort by
  • KGuliyev

    KGuliyev
    0
  • DanC
    Hi @KGuliyev

    I'm going to reach out via a support ticket as we will need full debug looks to investigate this!
    DanC
    0
  • 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?))
    KGuliyev
    0

Add comment

Please sign in to leave a comment.