Resgrid.Console.exe dbupate -> error

[resgrid]

Resgrid.Console.exe dbupate -> error

[ucswift]

Hello @neuronet77, was this the initial installation or a subsequent update?

[neuronet77]

On initial installation

[ucswift]

What version and edition of SQL are you installing to, any special options, i.e. collation?

[neuronet77]

SQL Server: 11.0.2100
Collation: SQL_Latin1_General_CP1_CI_AS
Basic install.

[neuronet77]

Microsoft SQL Server 2012 - 11.0.2100.60 (X64)
Copyright (c) Microsoft Corporation
Enterprise Edition (64-bit) on Windows NT 6.2 (Build 9200: )

[ucswift]

@neuronet77 thanks for the info! I'm loading up a test env with 2012 now to take a look. Testing wise we've only been testing with 2016 SP1 and 2017.

[neuronet77]

Good morning Shawn. Do you got an update on it? Or should I upgrade to 2016 SP1 or 2017?

[ucswift]

@neuronet77 Sorry for the delay, I was able to stand up a test environment and reproduce this issue. I've tracked it down to the database migration creating constraints with different names then the migration was using to update the schema, causing the update to fail. I have added a fix for this and will be working on cutting a new release.

[neuronet77]

@ucswift Thanks a lot! I'll try it later tonight!

[ucswift]

Cut a new release v0.15 and tested this with multiple versions of SQL and did not receive the error. Can you give it a test and let me know if it works.

[ucswift]

Close issue due to inactivity. If the issue is still occurring please open up a new issue and reference this one.