Question

Photo of Gladson Jacob

0

Rock Error after migration to Azure

2

Hi, We had a working Rock installation hosted on a shared hosting server.

I imported the DB and copied the files to wwwroot folder.

I do get the login page.

But, once I enter the username and password, it redirects me to /page/3?returnurl=%252f with the message:
That Wasn't Supposed To Happen... An error has occurred while processing your request. Your organization's administrators have been notified of this problem.

I am on Rock 5.5

The Application Event Log is pasted below:

application_event_log.txt


application_error.png

  • Daniel Hazelbaker

    Daniel Hazelbaker

    Just to verify, when you say "imported the DB"; you are talking about using SQL Server Management Studio to backup the old database into a .BAK file and then creating a new database on the Azure host by restoring that .BAK file, correct?


    Also, is there anything different about the old and new host? Different SQL version, OS version, etc.?


    The core error seems to be that Entity Framework is trying to update a History record (which doesn't exist) instead of create one.

    • Photo of Gladson Jacob

      0

      I had to use a combination of SQL Database Migration wizard and SQL Server 2016 Import and Export. It's fine now. Thank you.

    • Photo of Gladson Jacob

      0

      I used "SQL Server 2016 Import and Export Data (32-bit)" tool to directly connect to the old DB server and to the new Azure server and the tool migrated the tables, views and data.

      Old SQL Server: MSSQLSERVER2014
      Azure SQL: V12