How to upgrade BuildMaster from 5.8.3 to latest version 6.2

rhessinger

It sounds like either the database or the application didn't actually update. Would you be able to make a direct SQL query against the ProGet database that is in the config? I would like you to run two different queries:

select * from Applications_Extended

and

select top 10 executed_date, Script_Guid, Script_Name from __InedoDb_DbSchemaChanges order by Executed_Date DESC

Thanks,
Rich

aleksandarsh_4585

@rhessinger Second query is failing, the table " __InedoDb_DbSchemaChanges" is missing.

select * from Applications_Extended
http://prntscr.com/ryyy68

2.select top 10 executed_date, Script_Guid, Script_Name from __InedoDb_DbSchemaChanges order by Executed_Date DESC
http://prntscr.com/ryyz20

Please let me know whether you need more details. Also if I need to do any new update or to change something please let me know.

Also the error message which I receive from web:

http://prntscr.com/ryz1vw

atripp

Thanks; based on this, there's only one application? Is that correct? Seems like it might be off...

Anyways the database definitely wasn't upgraded. I'm guessing, during upgrade, it was pointed to a different database? Hard to guess...

You can manually upgrade the database:
https://docs.inedo.com/docs/buildmaster/installation-and-maintenance/installation-guide/manual

There may have been an error as well (look in the __BuildMAster__DbSchema2 table).

aleksandarsh_4585

@atripp Hi, the issue it can be with the DB not get the update.
The link for download is down, as I can understand from the docs I need "BuildMaster-DbChangeScripts.zip".
If there is another way to download this file?

http://prntscr.com/rz17v1

atripp

Seems, an old link; here it is https://my.inedo.com/buildmaster/versions

aleksandarsh_4585

@atripp Hey, thanks for the link.

The first question is whether you have an update for the docs also? As I can see the db update name is not the same.
I have tried with the name from the zip file but maybe I'm wrong with setting the connection string.
Can you help me with that?

From the screenshot, you can see my Web_appSetting details:

http://prntscr.com/rz2mam

I have tried by running it like this:

C:\Users\Administrator\Downloads\BuildMasterSetup6.1.27_Manual\SqlScripts>dbupdater.exe Update /conn="Data Source=WIN-JG
8E2BQKINK\BUILDMASTER;Initial Catalog=BuildMaster;Integrated Security=SSPI;" /init=yes

but I get the following message:

Script path "/conn=Data Source=WIN-JG8E2BQKINK\BUILDMASTER;Initial Catalog=BuildMaster;Integrated Security=SSPI;" not fo
und.

http://prntscr.com/rz2q77

atripp

Can you try running inedosql instead of dbupdate?

aleksandarsh_4585

@atripp Hey, the name of the exe file is dbupdate and because of that, I'm naming like that.

http://prntscr.com/rz4h6m

aleksandarsh_4585

So from the extracted zip file for db update I have the following data.

http://prntscr.com/rz4h6m

Web app Settings config is the following.

http://prntscr.com/rz4jhp

I'm trying to update using the query which is in your docs

http://prntscr.com/rz4kn2

and I'm unable to make the connection in order the exe file to update the SQL db.

atripp

Can you try...

dbupdater.exe Update . /conn="Data Source=WIN-JG
8E2BQKINK\BUILDMASTER;Initial Catalog=BuildMaster;Integrated Security=SSPI;" /init=yes

Looking at dbupdater, the arguments are dbupdater update <script-path> <connection-string>, so I think the "." will include the current path.

aleksandarsh_4585

@atripp Hey, the provided query didn't pass so we have updated it and it passed with no error.

But as your colleague advised me to check in the db with the provided query I can see that still the Inedo db is missing:

Invalid object name '__InedoDb_DbSchemaChanges'.

And I still have the same error message on web when I enter in the application.

Please advise how to resolve this? Or if there is a way to downgrade and to try to upgrade BM again it will be better.
If you have some other SQL update patch please provide to me.

aleksandarsh_4585

Hello, I just want to let you know that I have successfully made the update of the SQL.
When I log in to web I got new error message now, can you please tell me now what can be this issue?

Also when I run the query in the db I still get the same message: Invalid object name '__InedoDb_DbSchemaChanges'.

select top 10 executed_date, Script_Guid, Script_Name from __InedoDb_DbSchemaChanges order by Executed_Date DESC

Can someone help me with this?

atripp

Can you try this instead? select top 10 executed_date, Script_Guid, Script_Name from __BuildMaster__DbSchemaChanges2 order by Executed_Date DESC

Can you try to restart the web application (in IIS, or restart the Integrated Web Server), then visit the home page? I think something might be cached... that error doesnt' make much sense.

How about browsing to /applications/4/ (since I saw Application with ID = 4 in the database screenshot).

aleksandarsh_4585

@atripp Hey, I have executed the query, so please find the screenshot below.

I have restarted the services and the server but I got the same issue.

aleksandarsh_4585

Any idea how to resolve this error message which is only under application link.

rhessinger

Hi @aleksandarsh_4585,

What version of BuildMaster did you upgrade to (i.e., 6.2.10)? It looks like it did not run the scripts for 6.2 on your database. I just wanted to confirm that the Manual Install zip you downloaded matches the version of BuildMaster that you installed.

Also, could you run the following query? I would like to see if any script errors happened during the SQL upgrade.

select top 10 * from __BuildMaster__DbSchemaChanges2 where Success_Indicator = 'N' order by Executed_Date DESC

Thanks,
Rich

aleksandarsh_4585

I have upgraded to 6.1.27 and this is the latest version that I can upgrade to.
If I want to upgrade to 6.2 it is failing with a message

I have downloaded the BM Setup 6.1.27.

We are using legacy features, so is there any way to upgrade to 6.2 and still using it?

Also please find the executed query which you have provided to me.

atripp

Great, you've got 6.1 running.

So, BuildMaster v6.2 removes all legacy features, and the upgrade is blocked until you run the legacy feature detector and it says no features are detected. See the BuildMaster 6.2 Upgrade Notes.

I'm concerned about the state of your server. How about making a new server for BuildMaster 6.2, and then migrating your applications as per the guidance in the kb article? Then, you won't have more server problems in the future.

As for that script, I'm a little concerned with it. If it failed to run, then it means the BUILDNUMBER and RELEASENUMBER columns in the database may be too short (new length is 50 characters, old length was ... I forgot... but shorter). It's not a huge problem and would likely go undetected. Just woudl give an error if you made a build number that was between the old length and 50 characters.

Anyways, if you follow the plan of making a new BuildMaster 6.2 server, then migrating your applications per that article, then you won't have to worry about it.

aleksandarsh_4585

@atripp Your recommendation is confusing me. As I can see from the documentation which you have in order to migrate your BM project to 6.2 we should have v6.1. But we do not have BMv6.1 in working state, the upgrade fail. What we should do? We are stuck now and we don't know how to go further.

For < v5.0 - first upgrade to v4.9.10, then v6.1.[latest], then migrate to 6.2
For >= v5.0 - first upgrade to v6.1.[latest], then migrate to 6.2

atripp

I'm sorry, I misunderstood, I thought your instance was working. Now that I see older messages, I see not.

OK ...

What happens when you visit /applications/4? The error message you've shared appears to be from /all-applications.