Emerson Exchange 365

• Not Answered

DeltaV Analyze upgrade from 3.0 to 4.1

I'm preparing to apply SP1 to DeltaV 13.3, and I also plan to migrate DeltaV Analyze from version 3.0 to version 4.1.

The "database backup" tab has all fields greyed out. It says "only windows administrators can configure database backup", but nonetheless remains greyed out while I am logged in as a Windows administrator, even the default administrator account. Do I need to back up the database before upgrading?

• DeltaV Analyze

John Rezabek

• 31 Mar 2017 7:26 PM
• Cancel

9 Replies

• dave_marshall

  

  • 3 Apr 2017 1:10 PM

  Hi John,
  
  Is this a workgroup or a Domain system? If it is a domain system, try logging in as the domain admin. Additionally, during and after the install of Analyze, you should have the ability specify Admin users to the system. In the configuration tree, there should be a users entry to show you who these would be.
  
  As for your second question, it depends on you. If you are only casually using Analyze (on-demand data, no real back-in-time comparisons, etc), then no. If you are interested in keeping the historical records of the data Analyze produces, then that is a different story.
  
  Dave

  • Cancel
• John Rezabek

  

  • 3 Apr 2017 4:21 PM

  In reply to dave_marshall:

  Dave,
  
  Our system is a domain and I have tried both local and domain administrator logins - in both cases the backup options are greyed out.
  
  I think we will have some motivation to look at older reports since we are starting to deploy dynamic alarming / flood suppression modules and we'd like to compare metrics versus prior shutdowns. Does 4.1 utilize the same SQL database that 3.0 has been generating? I also want to preserve configuration settings like shift times, alarm colors, and so on.
  
  John

  • Cancel
• dave_marshall

  

  • 3 Apr 2017 4:37 PM

  In reply to John Rezabek:

  Hi John,
  
  I'm not sure if it uses the same SQL data table structure, if I follow what you are asking. That would be a product support question.
  
  Did you by chance have automated backups scheduled?
  
  Are you able to get to the Users/User Groups in the administration tree? Can you verify if any of the user accounts you are using are a member of the MessengerAdminGroup?

  • Cancel
• John Rezabek

  

  • 3 Apr 2017 6:07 PM

  In reply to dave_marshall:

  Dave,
  
  Automated backups are not scheduled . . . there appears to have been a one-time backup configured but I am unable to deselect (uncheck) that option. It is pointed to what must have been a removable drive (F:); I connected a removable drive that mapped as F: but nothing changes.
  
  I did poke around in the users/ user groups page and all the accounts I've tried are in the admin group.
  
  John

  • Cancel
• Andre Dicaire

  

  • 3 Apr 2017 10:16 PM

  In reply to dave_marshall:

  John, I had a similar experience with PHV, where I could not save files or perform certain functions, with buttons greyed out. Turns out I did not that the "ADVANCED" functionality enabled from the view/Control Level menu. After I selected that all these features were available to me. I'm wondering if there is a similar setting that an Admin can enable, but until you do, you are restricted to what a non-admin user can do. I don't have my server running to check.
  
  By the way, DeltaV Analyze does not use a SQL database. It connects to the DeltaV Event Chronicle (SQL Express) or to a PEH (SQL SERVER) database(s) and processes alarm and event data into XML data, which is then used to serve the webpages.

  Andre Dicaire

  • Cancel
• John Rezabek

  

  • 4 Apr 2017 1:02 PM

  In reply to Andre Dicaire:

  Poked around a bit more - nothing akin to the "Expert" mode in PHV I could find. I did find a large number of XML files stored on a local hard drive - in lieu of an application-directed backup, would it suffice to make a backup of this directory?

  SP1 is running now on the ProPlus . . . I see there are SQL server updates being deployed, so it should preserve any preexisting database, safe to say? Any other caveats / experiences from 13.3 SP1 (that may not be in the release notes?

  • Cancel
• dave_marshall

  

  • 5 Apr 2017 3:02 PM

  In reply to John Rezabek:

  John,
  
  The XML files are the processed data that Analyze creates. Those are important to back up by hand. This won't get you the reports or the config though.
  
  If you cannot schedule a backup, you may just have to take some screen shots of the config and re-do it once you install 4.1. This is what I ended up doing at one time when I upgraded a server and had to re-install Analyze 3.
  
  Personally, Analyze could use some developer love.

  • Cancel
• John Rezabek

  

  • 7 Apr 2017 5:17 PM

  In reply to dave_marshall:

  Update . . . completed 13.3 SP1 install and installed 4.1. I had to manually uninstall Analyze 3.0 through control panel . . . 4.1 install did find the old database even though 3.0 was no longer there, in C:\Program Files (x86)\PlantWeb\data_2017_4_6_11_2\ - not a place I would have looked. It appears all of the prior configuration - shifts, reports, etc. was carried over. Initially I could not access the administration page because the "MessengerDVUser" account needed to be created on the domain. Otherwise, it appears to have been a fairly clean upgrade - reports are being generated and we can view statistics from a few years ago.

  • Cancel
• dave_marshall

  

  • 7 Apr 2017 7:03 PM

  In reply to John Rezabek:

  Yay! That is great news.

  • Cancel