Cannot upgrade database

Hello,

Thank you for contacting us on that matter.

Our Engineering Department is aware of this situation. As a workaround to fix this issue on your database, please follow these steps.

1. Create a backup of your database, validate that it can be restored without issue.
2. Run the SQL statement I will send you in a private message.

Let me know if that helps!

Best regards,

SQL stmt appears to have worked!

Thanks

Hi,

I have exactly the same issue here. The new RDM version tried to upgrade the DB from version 669 to 682 but failed with the same error message. But it seems like some steps have worked fine because after another attempt with the sa account the current version is 681 now. For now, I did a rollback to the previous RDM version.

Is the current version 681 intact or should I restore the DB backup of version 669 as well?

Could you also please send me the script to fix the issue?

Best regards,
Volker Ringel

Hello,

@Maverdude Thank you for your feedback and glad that it worked!

@Volker I have sent you the SQL statement in a private message. I think it would be better to start over the process with a restored database, run the statement and then complete the upgrade process from RDM.

Best regards,

Hi Erica,

We've also run into this issue. Would you mind sending us the SQL script to rectify?

Thanks.

Hello Érica,

I restored the backup I did before the upgrade. The SQL script worked fine on the db version 669. The database upgrade to version 682 after the RDM update was successful as well now.

Thanks a lot for the quick help.

Best regards,
Volker Ringel

Hi Erica,
we have the same problem. Can I also get the script?

Best regards
Christian

Hello

I have the same problem. Can I get workaround.

Robert

Hello,

@robinoswald, @Christian, @Robert, I have sent you the SQL statement in a private message.

@Volker, thank you for your feedback and glad that it worked.

Best regards,

Hello,

For everyone else, here is the SQL statement to run if you experience the same issue while attempting to update the SQL database with RDM.

IF EXISTS (SELECT * FROM sys.syscolumns WHERE name = 'PersonalConnections' AND id = object_id(N'dbo.UserAccount'))
BEGIN
ALTER TABLE dbo.UserAccount ALTER COLUMN PersonalConnections nvarchar(max) NULL
END;

Let us know if you have any questions about this.

Best regards,