Server Manager failing

Testing Environment Details

• Server: Testing
• Store(s): Above Store - Server Manager
• Logged in User:
  • Username:
  • Password:
• Feature: Web Services tab
• Related Tickets (Stories or Features):
• Other Related Links (Confluence, BRDs, Etc...):
• Feature Configurations: N/A

Expected Result

After creating a new Task in the Web Services Tab, I should be able to view that task without Server Manager throwing an error.

Actual Result

Steps that I took

• Created a new Web Service task
• The task did not show in Server Manager
• I rebooted SM
• The task still did not show
• I found that in tbTaskName, the InstanceNo was set to -1
  • I updated this to be 1, via the database

  • select * from tbTaskName with(nolock)
    where TaskNameId = 605
    
    select * from tbTaskWebService
    where TaskNameId = 605
    
    select * from tbZone
    where zoneid = 936
    

• It still didn't show
• I again cleared SM Cache and rebooted
• The task was now available for selection
  • Note: I was able to manually run the task from the status page, and it did as expected
  • I have also scheduled to task to run overnight
• Note I managed to resolve this
  • ForecastingOffsetDays was set to -1, in tbTaskWebService
• Selecting the task results in the following error
  • 
  • 
  • Details:
  • Event Viewer Error

    • System

    • Provider

    [ Name] CFA Testing Server Manager

    • EventID 5

    [ Qualifiers] 0

    Level 2

    Task 0

    Keywords 0x80000000000000

    • TimeCreated

    [ SystemTime] 2021-04-13T21:26:42.060031500Z

    EventRecordID 4996350

    Channel Application

    Computer ATL2CFANPV002.CFA.local

    Security

    • EventData

    Title: Unhandled Server Manager exception Timestamp: 4/13/2021 9:26:42 PM Message: Unhandled Exception: Value of '-1' is not valid for 'Value'. 'Value' should be between 'Minimum' and 'Maximum'. Parameter name: Value Stack trace: at System.Windows.Forms.NumericUpDown.set_Value(Decimal value) at eStruxure_Manager.FormServerMgr.ComboBoxWebServiceList_SelectedIndexChanged(Object sender, EventArgs e) at System.Windows.Forms.ComboBox.OnSelectedIndexChanged(EventArgs e) at System.Windows.Forms.ComboBox.WndProc(Message& m) at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m) at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam) Activity Token: 0c75d3dd-2d7e-4eeb-908a-02cd708487d3 Category: ServerManager Priority: 30 EventId: 5 Severity: Error Machine: ATL2CFANPV002 Application Domain: eStruxure Manager.exe Process Id: 12728 Process Name: H:\Macromatix\ServerManager\CFATesting\eStruxure Manager.exe Win32 Thread Id: 1380 Thread Name: