upgrade Web_Scheduling_2016_SP9_UP4_1 issues (web service stopped)

SOLVED

I am upgrading the new version of SedApta Web Scheduling,all installation procedures are fine and no error messages.

Restart the VM and logon Web Scheduling with MODX3, it pops up " Unable to reach Web Scheduler Service, check Web.config connection parameters."

  

From Task Manager I found SedAptaSchedulerService stopped and it cannot be restart by manually.

Does anybody know how to fix it? Thanks.

  • 0

    For the instance of SQL server being used for web scheduling, is it the default instance name (e.g. MSSQLSERVER), or did you give it a unique name?  If the default name was used, you'll want to roll everything back and reinstall using a unique named instance.  During the sedApta install, your values should look like this:

    • Hostname: <hostname>\<instance_name>
    • Instance: <empty>
    • Port: <empty>
  • 0 in reply to Chuck Lamborn

    Hi Lamborn, 

    Thanks for reply. Actually I am using the Sage Training VM of Webscheduling for upgrades. It worked  before.

  • +1 in reply to Wang Tony
    verified answer

    In [sedapta install path]/SupplyChain\Nicim64\Scheduler_Web\SelfHost\resources\XMLF_Resources.xml, verify that the DataSource tag still contains the SQL instance name, not just the machine name.

  • 0 in reply to Chuck Lamborn

    Yeah, you are right. The Installer will change the XMLF_Resources.xml DataSource tag to machine name automatically. I backup the old version one and restore it when upgrading finished, restart the machine, the  SedAptaSchedulerService started. But there is a new issue happened when I login with MODX3 user, the log file like this:

    -------------------------------------------------------------------------------------------------------------------------------------

    Server error / See log for details
    Invalid object name 'S_P_KPI_USER_VERSION_VALUE'.
    System.Data.SqlClient.SqlException
    at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlDataReader.TryConsumeMetaData() at System.Data.SqlClient.SqlDataReader.get_MetaData() at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted) at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method) at COSMOS.Data.LoadMgr`1.Load(DataProvider provider) at COSMOS.Data.ReadDataMgr`1.Load(DataProvider provider) at COSMOS.Data.ReadDataMgr`1.Load(DataProvider provider, Boolean append) at COSMOS.ObjectMgr.Load(DataProvider provider, Boolean append) at COSMOS.PP.Scenario.LoadKPIVersion(List`1 parameters) at COSMOS.PP.ScenarioLoadingMainFunction.Load(List`1 parameters, Boolean notifyStart, Boolean notifyProgress, Boolean notifyEnd, Int32 nsteps, Int32& step) at COSMOS.PP.Scenario.LoadVersionData(DataProvider provider) at COSMOS.PP.MSModel_GUI.StartScheduler() at SedApta.PP.Server.PatternBuilder_GUI.startScheduler(String userName, IWorkgroupMgr workgroupMgr, DataProvider provider) at SedApta.PP.Server.UserSessionMgr.InitGuiModel(UserSession session, Func`4 startScheduler) at SedApta.PP.Server.ApiController.LoadSessionData(String sessionGuid, String timeStamp) at lambda_method(Closure , Object , Object[] ) at System.Web.Http.Controllers.ReflectedHttpActionDescriptor.ActionExecutor.<>c__DisplayClass6_2.<GetExecutor>b__2(Object instance, Object[] methodParameters) at System.Web.Http.Controllers.ReflectedHttpActionDescriptor.ExecuteAsync(HttpControllerContext controllerContext, IDictionary`2 arguments, CancellationToken cancellationToken) --- End of stack trace from previous location where exception was thrown --- at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) at System.Web.Http.Controllers.ApiControllerActionInvoker.<InvokeActionAsyncCore>d__1.MoveNext() --- End of stack trace from previous location where exception was thrown --- at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) at System.Web.Http.Filters.ActionFilterAttribute.<CallOnActionExecutedAsync>d__6.MoveNext() --- End of stack trace from previous location where exception was thrown --- at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() at System.Web.Http.Filters.ActionFilterAttribute.<CallOnActionExecutedAsync>d__6.MoveNext() --- End of stack trace from previous location where exception was thrown --- at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) at System.Web.Http.Filters.ActionFilterAttribute.<ExecuteActionFilterAsyncCore>d__5.MoveNext() --- End of stack trace from previous location where exception was thrown --- at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) at System.Web.Http.Controllers.ActionFilterResult.<ExecuteAsync>d__5.MoveNext() --- End of stack trace from previous location where exception was thrown --- at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) at System.Web.Http.Filters.AuthorizationFilterAttribute.<ExecuteAuthorizationFilterAsyncCore>d__3.MoveNext() --- End of stack trace from previous location where exception was thrown --- at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) at System.Web.Http.Controllers.ExceptionFilterResult.<ExecuteAsync>d__6.MoveNext() --- End of stack trace from previous location where exception was thrown --- at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() at System.Web.Http.Controllers.ExceptionFilterResult.<ExecuteAsync>d__6.MoveNext() --- End of stack trace from previous location where exception was thrown --- at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) at System.Web.Http.Dispatcher.HttpControllerDispatcher.<SendAsync>d__15.MoveNext()