9.1 to 9.4 or 9.5?

[antherITguy]

I'm looking into upgrading from 9.1 to either 9.4 or 9.5.  I'm seeking input from other on-prem users that have gone through this upgrade.  How straight forward was it?  Any gotchas?

[ChrisHuhnChrisH]

I saw that response earlier. So all you are validating is database version?
Which Table or View would I find that?
I was more concerned about database integrity.
To me, the only validation is to start Console and DS after they are updated - a little late to find a problem.

[LukeDC]

The DB has a version table and the only validation Airwatch wants you to perform at that point is that it reads the version you are expecting. Not sure how you would validate data outside of using the console.

[ChrisHuhnChrisH]

>> the only validation Airwatch wants you to perform...
Understood, thanks for that hint.  The script must have a bunch of checks-and-balances as it progresses.

[techiecheng]

Thanks Luke for your insight on this discussion. I couldn't agree more on keeping up with the version upgrade. However, it can be difficult if your environment is like mine (on-premises) with multiple hosts spanning between two sites. I'm still running 9.1 as well along with report server and SEG . I understand the current version of SEG is going away and admins must upgrade to SEG 2.0. Did anyone come across any issue when upgrading SEG all the way to 9.5?

[MikeSimms]

Thomas
Run this on the DB at each step of the DB upgrade.
select * from dbo.DatabaseVersion
should return something like
MajorVersion, Minor version, Revision, Version date, Hotfix, CommitID, Build Key
9                    4                5        2018-05-31    0 3a5849cb2433ef91ba0cf42271e3e77e6219e7fb  

[jhildenbrand]

We are currently on 9.2.3 on premise. I went to see if there were any upgrades and now I see there is a 9.3, 9.4, and a 9.5. What's with all the new significant versions in such a short time? I upgraded to 9.2.3 earlier this year and it was the latest when I installed it. Has anyone tried them all and find one to be more stable than the others? Stability matters most to me. Do any provide a better user experience?

[antherITguy]

I performed a 9.1.3.8 to 9.5.0.6 upgrade in my lab environment and the upgrade was fairly straightforward.  I'll be applying in production next week.

[ChrisHuhnChrisH]

Thanks Mike S., re: select * from dbo.DatabaseVersion

[RichB2u2]

Since you mentioned the correct SQL Query to ' Confirm current DB verions,'  for us on-premise customers relying on the ' Self Upgrade Plan from X.X.X to 9.X'  [https://resources.workspaceone.com/view/lf72h9pc5n2kdnvsynl7/en] (which hasn't been update for over a year - and includes flaws), beware of the wording in the 9th line on the Excel Validation checklist that is at the beginning under Environment Testing / Database / Confirm current DB verions (yes it is supposed to say ' versions' ) where it says: WRONG: Run the following SQL query: Select * from database version This omits the ' dbo.,'  changes capitalization and adds a space '  ' . This stumped me at first, as we are on our own and feel somewhat unsupported as on-premise customers who have to search for answers all the time! I called support last year and got this answer but the checklist needs help! CORRECT (same as Mike S.): select * from dbo.DatabaseVersion This help page is correct too: ' Verify Proper Database Installation'  https://docs.vmware.com/en/VMware-Workspace-ONE-UEM/9.5/vmware-airwatch-guides-95/GUID-AW95-Verify_D... : SELECT * FROM dbo.DatabaseVersion

[bspencer505]

Luke or anyone - 9.0 to 9.5? - Can I just make that jump?

[LukeDC]

Yes, you can. Just test your SQL updates. You'll have to run through several DB installs to get to 9.5 before you can continue the app installs

[bspencer505]

Ahh man.. I was hoping I could just go straight to 9.5 with out doing 9.1/2/3/4 DB installs.

[jhildenbrand]

On the database part. I spoke with support and they said to upgrade to 9.3 on the database and there was no newer version for the database. I'm not sure if they just aren't aware of the newer versions in the full installer or they aren't needed. Anyone know for sure.

[bspencer505]

I have a ticket into support now.... hopefully I'lll get some ground truth. Ultimately our fault for not keeping up with upgrades.

[LukeDC]

I did a test from 9.2 to 9.5 on DB installs and I can confirm at the 9.5 Db install it simply said the DB needs to be at 9.3 before continuing.
The best way to know for sure is to start a DB install and read the SQL info screen, it will tell you what version you need to be at to continue.

[bspencer505]

Thanks, Luke! - I just downloaded the 9.0 to 9.2 DB install and also downloaded the 9.3 DB install. After I get the DB to 9.3 - I'll run the 9.5 for both the app and the DB.

[JustinGrazulis]

After jumping from 9.0 to 9.5, we've lost many of the included reports. We had a bunch of included reports when on 9.0 and after moving to 9.5, we are down to 21. I've ran the upgrade to get our report installation to 9.1 but I believe that was the last update the report installer got. Any additional information would be great? I also get the ' Something unexpected happened. If the issue persists, please contact your system administrator.'  when selecting All Settings > System > Reports Subscription from global or anywhere else.

[MPFS]

Has there been anyone that has upgraded to 9.6 yet?

[LukeDC]

9.6 is not available for on-prem just yet

[LukeDC]

Justin, the old legacy SSRS reports are in a different database. Has that been updated?