Upgrade v9.2 to v9.3 fails with Database error 2601: Cannot insert duplicate key row in object 'dbo.DialogColumn' with unique index 'QBM_XA2DialogColumn'

Hi.

Thanks so much for your help. Apologies for the delay, I was running more tests. 

Eventually, here are the steps I've followed, they might be useful for other users:

• Restore backup from production
• Configwizard->Enable a restored database. Compilation ends with no errors.
• Ran Designer, updates applied.
• Checked db consistency according to the documentation. Only two errors that could not be automatically corrected, but they were related to PWO pointing to apps that no longer exist. So I skipped that.
  
  
• Installed v93, ran config wizard -> update database. Cleared DialogDBQueue.
• Upgrade ended with no errors this time.

As Markus Weiss-Ehlers pointed out at one point errors might have ocurred on a previous attempt, but I cannot recall having done so. We know how updates work: Should the process fails, recover from backup and retry.

Only thing I can think of: The DB I was trying our first testing was:

• An already dev database that's been thoroughly used for our testings.
• Running on SQLServer dev edition on Linux. In this case, I have to say v93 won't install at all and will fail later on during the upgrade process.

Thanks again!

We have test pipelines running the Linux-based SQL Server image mcr.microsoft.com/mssql/server:2022-latest to host several versions of OneIM including 9.3 without problems.
Several colleagues use the same image to host OneIM databases locally on their workstations, also without problems.

Can you provide any details regarding your installation issues?  (Logs, latest errors and warings from the system journal, ...)

Hi, Andreas,

Up to v9.2 we've been deploying our lab installations based on mssqlserver developer for Linux on Centos and they're running smoothly. The install process for v93 did not complain at all (incompatibillity warnings or missing patches) but failed during the schema installation. I'll retry tomorrow and give you more details.

Thanks!

Looking at the Supported Platforms for SQL Server 2022 on Linux it seems that CentOS is not explicitly supported by Microsoft,

https://learn.microsoft.com/en-us/sql/linux/sql-server-linux-setup?view=sql-server-ver16#supported-platforms

Not explicitly, but it runs like a charm (RedHat) and updates just the same.

Not explicitly, but it runs like a charm (RedHat) and updates just the same.