Unable to use developer's license for bitbucket

[Leena Bakshi]

Hi,

I am trying to install Bitbucket 5.1 on a new server (windows 2016) as part of an upgrade. However I am using developer's license it gives error 500 : 

Incorrect number of rows updated: expected 1, actual -1

Please see your system administrator

This is suppose to be a test env for the upgrade as I ll be migrating bitbucket from windows 2012 server to this one (windows 2016). 

Any suggestions? 

Thanks

[Mikael Sandberg · Accepted solution]

Are you using MS SQL Server and if so, have you turned off the SET NOCOUNT in the database? Have a look at this trouble shooting guide.

[Leena Bakshi]

Yes Mikael, I am using MS SQL 2012 and did ask the DBA to turn off SET NOCOUNT. I guess I need to verify that. Thanks for the prompt reply and the troubleshooting guide.

[Leena Bakshi]

I had to turn off the NOCOUNT on SQL server under default connections and then I could go past the error. Thanks Mikael.

[Kunjan Sanghavi]

@Mikael Sandberg I had the same problem, after your solution I had to restart the SQL Server service.

Thanks.