Question

Photo of Joanne Domagala

0

Upgrade to Rock v15 - left us without use of Rock

7

Anyone ever have the screen just go blank after an update? We upgraded from v13.5 to 14.4 (whatever was the latest version before 15). After Rock  rebooted, admin.epic.church now just shows the color bar across the top of the page and everything below it is blank. Any ideas on what the problem is? We upgraded fine with our sandbox instance. 

  • Photo of Luke Taylor

    1

    Times when I've seen things like this happen have been when Rock updates get pushed through very quickly.

    A good practice when upgrading is to watch the processor load on the web server and the sql server.  When update is hit and then Rock is restarted, Rock does a lot of work in the background to move things around.  If it's restarted again before that work is all done, sometimes things aren't left in the right state for working.

    Since Rock was coming up but the page content doesn't look right, it can be useful to make sure that all the Rock themes are fully compiled so that Rock knows where to put all the information on the screen.

  • Photo of Tony Visconti

    0

    I am seeing this when I go to admin.epic.church
    Screenshot_2024-05-08_154001.png

    Are you seeing the blank screen after login?

  • Photo of Joanne Domagala

    0

    Thank you so much Luke for fixing our problem. I thought we were in big trouble! 

  • Photo of Matthew Widjaja

    0

    Hi all! We had to revert to Rock 16.4 because when we made it to Rock 16.5, we got this exception. Has anyone else saw it and/or have a way to figure out what happened?


    [SqlException (0x80131904): Conversion failed when converting the nvarchar value '35 or 74 or 76 or 81 or 82 or 84' to data type int.]

       System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) +277

       System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) +764

       System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) +4620

       System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite) +1344

       System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry) +420

       System.Data.SqlClient.SqlCommand.ExecuteNonQuery() +391

       System.Data.Entity.Infrastructure.Interception.InternalDispatcher`1.Dispatch(TTarget target, Func`3 operation, TInterceptionContext interceptionContext, Action`3 executing, Action`3 executed) +958

       System.Data.Entity.Infrastructure.Interception.DbCommandDispatcher.NonQuery(DbCommand command, DbCommandInterceptionContext interceptionContext) +490

       System.Data.Entity.Migrations.DbMigrator.ExecuteSql(MigrationStatement migrationStatement, DbConnection connection, DbTransaction transaction, DbInterceptionContext interceptionContext) +125

       System.Data.Entity.Migrations.Infrastructure.MigratorLoggingDecorator.ExecuteSql(MigrationStatement migrationStatement, DbConnection connection, DbTransaction transaction, DbInterceptionContext interceptionContext) +169

       System.Data.Entity.Migrations.DbMigrator.ExecuteStatementsInternal(IEnumerable`1 migrationStatements, DbConnection connection, DbTransaction transaction, DbInterceptionContext interceptionContext) +124

       System.Data.Entity.Migrations.DbMigrator.ExecuteStatementsWithinTransaction(IEnumerable`1 migrationStatements, DbTransaction transaction, DbInterceptionContext interceptionContext) +94

       System.Data.Entity.Migrations.DbMigrator.ExecuteStatementsWithinNewTransaction(IEnumerable`1 migrationStatements, DbConnection connection, DbInterceptionContext interceptionContext) +211

       System.Data.Entity.Migrations.DbMigrator.ExecuteStatementsInternal(IEnumerable`1 migrationStatements, DbConnection connection, DbInterceptionContext interceptionContext) +462

       System.Data.Entity.Migrations.DbMigrator.ExecuteStatementsInternal(IEnumerable`1 migrationStatements, DbConnection connection) +693

       System.Data.Entity.SqlServer.<>c__DisplayClass2_0.<Execute>b__0() +18

       System.Data.Entity.SqlServer.DefaultSqlExecutionStrategy.Execute(Func`1 operation) +234

       System.Data.Entity.Migrations.DbMigrator.ExecuteStatements(IEnumerable`1 migrationStatements, DbTransaction existingTransaction) +270

       System.Data.Entity.Migrations.DbMigrator.ExecuteOperations(String migrationId, VersionedModel targetModel, IEnumerable`1 operations, IEnumerable`1 systemOperations, Boolean downgrading, Boolean auto) +1208

       System.Data.Entity.Migrations.DbMigrator.ApplyMigration(DbMigration migration, DbMigration lastMigration) +513

       System.Data.Entity.Migrations.Infrastructure.MigratorLoggingDecorator.ApplyMigration(DbMigration migration, DbMigration lastMigration) +102

       System.Data.Entity.Migrations.DbMigrator.Upgrade(IEnumerable`1 pendingMigrations, String targetMigrationId, String lastMigrationId) +192

       System.Data.Entity.Migrations.Infrastructure.MigratorLoggingDecorator.Upgrade(IEnumerable`1 pendingMigrations, String targetMigrationId, String lastMigrationId) +205

       System.Data.Entity.Migrations.DbMigrator.UpdateInternal(String targetMigration) +602

       System.Data.Entity.Migrations.DbMigrator.EnsureDatabaseExists(Action mustSucceedToKeepDatabase) +578

       System.Data.Entity.Migrations.DbMigrator.Update(String targetMigration) +116

       Rock.WebStartup.RockApplicationStartupHelper.MigrateDatabase(Boolean hasPendingEFMigrations) +421

       Rock.WebStartup.RockApplicationStartupHelper.RunApplicationStartup() +453

       Rock.AssemblyInitializer.Initialize() +76


    [RockStartupException: Error occurred in RunApplicationStartup:Conversion failed when converting the nvarchar value '35 or 74 or 76 or 81 or 82 or 84' to data type int.]

       RockWeb.Global.Application_Start(Object sender, EventArgs e) +785


    [RockStartupException: Error occurred during application startup:Error occurred in RunApplicationStartup:Conversion failed when converting the nvarchar value '35 or 74 or 76 or 81 or 82 or 84' to data type int.]

       RockWeb.Global.Application_Start(Object sender, EventArgs e) +941


    [HttpException (0x80004005): Error occurred during application startup:Error occurred in RunApplicationStartup:Conversion failed when converting the nvarchar value '35 or 74 or 76 or 81 or 82 or 84' to data type int.]

       System.Web.HttpApplicationFactory.EnsureAppStartCalledForIntegratedMode(HttpContext context, HttpApplication app) +517

       System.Web.HttpApplication.RegisterEventSubscriptionsWithIIS(IntPtr appContext, HttpContext context, MethodInfo[] handlers) +185

       System.Web.HttpApplication.InitSpecial(HttpApplicationState state, MethodInfo[] handlers, IntPtr appContext, HttpContext context) +168

       System.Web.HttpApplicationFactory.GetSpecialApplicationInstance(IntPtr appContext, HttpContext context) +277

       System.Web.Hosting.PipelineRuntime.InitializeApplication(IntPtr appContext) +369


    [HttpException (0x80004005): Error occurred during application startup:Error occurred in RunApplicationStartup:Conversion failed when converting the nvarchar value '35 or 74 or 76 or 81 or 82 or 84' to data type int.]

       System.Web.HttpRuntime.FirstRequestInit(HttpContext context) +532

       System.Web.HttpRuntime.EnsureFirstRequestInit(HttpContext context) +111

       System.Web.HttpRuntime.ProcessRequestNotificationPrivate(IIS7WorkerRequest wr, HttpContext context) +714

  • Photo of Tony Visconti

    0

    Hi Matthew I would recommend reposting your question here: https://community.rockrms.com/ask/troubleshooting/q/new

    It looks like you posted your question to a preexisting thread.

  • Photo of Luke Taylor

    0

    @Tony - Matthew is one of Epic's Rock admins

  • Photo of Tony Visconti

    0

    gotcha thanks for clarifying