Question

Photo of Keith Pavia

0

Update Help

Help.  I upgraded to .11 yesterday and the site would not comeback up.  I restored the DB and the website, but it still will not come up.  What did I do or am i doing wrong?

 

Thanks!

  • Photo of Jeremy Hoff

    0

    Hi Keith,

    Sorry for the trouble.

    Here's a link to a bit of documentation that can help get us started with troubleshooting: http://www.rockrms.com/Rock/BookContent/9/9#whattodowhenthingsgowrong

    What is happening now that the DB and website (I presume filesystem) have been restored?

    • Keith Pavia

      Hi Jeremy, it seems I have to be able to login to follow along with that info. I cannot get the site to work at all. I am confused. I did a backup of the CB and website, right before I tried the upgrade. But when I restore it, still nothing, it is almost like the restore is not working, even though it says it completed. I have no idea what to do at this point.

    • Keith Pavia

      I just did the restore again, and I saw a message flash by that said "Cannot find/open backup catalog" I will call arvixe. I hope I am not completely messed up.

    • Keith Pavia

      Is there maybe a particular file that may have gotten corrupt during the upgrade, if it got interrupted? I still can not get it to come back up. Any other ideas?

    • Jeremy Hoff

      Hi Keith,
      Regarding the corruption during an upgrade.. while that is possible I'm not sure that's where I'd start... especially since restoring the backup didn't work. Did Arvixe have any suggestions?


      Have you made many changes to your code.. i.e. the files in your filesystem? What version were you running before you upgraded to .11?

    • Keith Pavia

      I tried chatting with Arvixe tech support but that was useless. I submitted an email ticket, and they said they are working on it, but I have not herd back.


      The only changes I have made were to copy the default template to another name and set that one to be used by our site, then made a change to that copy that would allow 4 small add blocks across the bottom of the main ad block, so I would have 4 ads instead of 3.


      I was on what ever version was the latest before upgrading.
      I also ran the SQL query that was in the link you sent, but the data does not make sense to me.
      I had a schedule running to create backup Zip files. I had to download that unzip it and copy the contents back to the site. Since restoring it from the CP was not working.
      I have a DB "akzcce_cloud" that is in restore mode. Is this one used? If so there may be an issue with it since it it staying in this mode.

    • Jeremy Hoff

      OK. If you have a ZIP file, and it's about 115-120MB, then I'd say it's a complete backup. What I suggest is connecting via FTP (or even better SFTP) and uploading the contents of the ZIP folder to overwrite what's already there... and then ensuring that security is set properly.. Generally you need the IUSR account to have Modify rights... Arvixe's tools can help set this, and support can help here if need be.


      Optionally, and maybe preferably, setup a whole new site and practice the above restore procedure on that new site to protect the old one for now.


      I hope that helps,

    • Keith Pavia

      Yeah, I already uploaded the contents of the ZIP folder (196.83 MB) and overwrote what was there and restored the DB. It should work. Maybe it is a permission issue.

    • Keith Pavia

      Does RockRMS put itself into a Maintenance Mode? I had Arvixe set enhanced loggin on and now I am getting the following message from RockRMS:


      Updates in Progress...
      Our website is unavailable for the moment. We'll be back and running before long so please try again soon.
      Thanks for your patience!

    • Jeremy Hoff

      >>Does RockRMS put itself into a Maintenance Mode?


      Yes.
      There is a file named app_offline-template.htm in the root of the RockRMS web folder. If it is renamed to"app_offline.htm" it will trigger IIS to show that file instead of the default document. (Keep this handy trick in mind whenever you want to take your RockRMS-powered websites offline for maintenance... just remember to rename it something like "app_offline1.htm" when you want the sites to work again.)

    • Keith Pavia

      So, If I rename it back, do you think my site will come back online? :-)


      Actually there are 2 of them, app_offline-template.htm and app_offline.htm. Is this normal? Do I just delete one?
      Thank you Jeremy! The site is back up! I guess it was that maintenance page that was causing the issue. I am getting the following error though. Do you know what it means?
      External component has thrown an exception.


      at System.Web.Compilation.AssemblyBuilder.Compile()
      at System.Web.Compilation.BuildProvidersCompiler.PerformBuild()
      at System.Web.Compilation.BuildManager.CompileWebFile(VirtualPath virtualPath)
      at System.Web.Compilation.BuildManager.GetVPathBuildResultInternal(VirtualPath virtualPath, Boolean noBuild, Boolean allowCrossApp, Boolean allowBuildInPrecompile, Boolean throwIfNotFound, Boolean ensureIsUpToDate)
      at System.Web.Compilation.BuildManager.GetVPathBuildResultWithNoAssert(HttpContext context, VirtualPath virtualPath, Boolean noBuild, Boolean allowCrossApp, Boolean allowBuildInPrecompile, Boolean throwIfNotFound, Boolean ensureIsUpToDate)
      at System.Web.Compilation.BuildManager.GetVPathBuildResult(HttpContext context, VirtualPath virtualPath, Boolean noBuild, Boolean allowCrossApp, Boolean allowBuildInPrecompile, Boolean ensureIsUpToDate)
      at System.Web.UI.TemplateControl.LoadControl(VirtualPath virtualPath)
      at System.Web.UI.TemplateControl.LoadControl(String virtualPath)
      at Rock.Web.UI.RockPage.OnInit(EventArgs e)
      I also received a Compilation Error after upgrading to .12. Lot of weird stuff. I did make the changes to the config fie to turn on detailed error reporting. I may have been getting these all along, but did not see them until I turned that on.
      Thank you for all of your help!

    • Keith Pavia

      Actually there are 2 of them. app_offline-template.htm and app_offline.htm. Is this normal? Just delete one?

    • Jeremy Hoff

      >> Do I just delete one?
      Yes - That's okay. Or rename it... either will do the trick to trigger IIS to try to reload the RockRMS website... whether you delete or rename depends on whether you need to keep the file. You'd want to keep the file if it were "branded" to match your church, for example.

    • Keith Pavia

      It is back up! Thank you Jeremy! I guess all it was, was that maintenance page. I am getting the following error now. Do you know what this means?
      External component has thrown an exception.


      at System.Web.Compilation.AssemblyBuilder.Compile()
      at System.Web.Compilation.BuildProvidersCompiler.PerformBuild()
      at System.Web.Compilation.BuildManager.CompileWebFile(VirtualPath virtualPath)
      at System.Web.Compilation.BuildManager.GetVPathBuildResultInternal(VirtualPath virtualPath, Boolean noBuild, Boolean allowCrossApp, Boolean allowBuildInPrecompile, Boolean throwIfNotFound, Boolean ensureIsUpToDate)
      at System.Web.Compilation.BuildManager.GetVPathBuildResultWithNoAssert(HttpContext context, VirtualPath virtualPath, Boolean noBuild, Boolean allowCrossApp, Boolean allowBuildInPrecompile, Boolean throwIfNotFound, Boolean ensureIsUpToDate)
      at System.Web.Compilation.BuildManager.GetVPathBuildResult(HttpContext context, VirtualPath virtualPath, Boolean noBuild, Boolean allowCrossApp, Boolean allowBuildInPrecompile, Boolean ensureIsUpToDate)
      at System.Web.UI.TemplateControl.LoadControl(VirtualPath virtualPath)
      at System.Web.UI.TemplateControl.LoadControl(String virtualPath)
      at Rock.Web.UI.RockPage.OnInit(EventArgs e)

    • Jeremy Hoff

      Hi Keith,


      I'm afraid I don't see the cause. Are you in a position to run the following SQL statement via SQL Server Management Studio?


      SELECT TOP 100 *
      FROM [ExceptionLog]
      ORDER BY [CreatedDateTime] DESC

    • Nick Airdo

      Having both app_offline* files is normal during an update, but the app_offline.htm is automatically removed after a successful update. Since you still saw both after the update, something definitely went wrong during your update. When you restore your filesystem, be sure to remove all existing files first since any new files from the update would still remain after you unzip-restore.


      Looking at the stack trace you provided makes me think the other problem may be with the copy-paste-new Rock template you created. Perhaps you could publish it (like to dropbox/google-docs/etc.) and provide a link so we can take a closer look at it.

    • Nick Airdo

      Having both the app_offline-template.htm and app_offline.htm is normal during an update, but the app_offline.htm is automatically removed after a successful update. Since you were left with that one after your update, you can be sure that the update did not complete successfully.


      When restoring your filesystem after a failed update, be sure to remove all the files before unzip-restoring since any new files introduced during the update will not be removed during your restore. Also as Jeremy mentions, depending on how you restore, you need to be sure the restored files have the same/correct permissions.


      Lastly, based on that stack trace you provided, it appears the problem may be with trying to load the new copy-paste template you created. If you can zip it up, publish it somewhere (like dropbox, google docs, etc) and provide the link, we can take a closer look at it.

    • Nick Airdo

      Having both the app_offline-template.htm and app_offline.htm is normal during an update, but the app_offline.htm is automatically removed after a successful update. Since you were left with that one after your update, you can be sure that the update did not complete successfully.


      When restoring your filesystem after a failed update, be sure to remove all the files before unzip-restoring since any new files introduced during the update will not be removed during your restore. Also as Jeremy mentions, depending on how you restore, you need to be sure the restored files have the same/correct permissions.


      Lastly, based on that stack trace you provided, it appears the problem may be with trying to load the new copy-paste template you created. If you can zip it up, publish it somewhere (like dropbox, google docs, etc) and provide the link, we can take a closer look at it.

  • Photo of Keith Pavia

    0

    Thank you!  It just says "The service is unavailable." when going to the site.