KB164201343: Automation Engine - An error appears when trying to open Pilot after upgrading to verion 14

Summary

After upgrading to Automation Engine 14, you get an error when opening Automation Engine Pilot.

Symptoms

After Upgrade, when you try to open Automation Engine Pilot, the following errors appear:

• Could not connect to the ToDoServer to retrieve the Red Alerts due to the 
  following exception :
  BG_EException
  .server.elm.ELM_ENotServicingException: ElemServer not servicing!
  

  

• The Following exception occurred while trying to load the plugin
  com.barco.bg.coreserver.ui.pilot2.plugins.joboverview.PL_TJobOverviewPlugin :
  
  java.lang.NullPointerException

  

• "An exception occurred while trying to retrieve records:
  Problem in StartQuery:"
  

Solution

Automation Engine cannot open the database tables of all databases (BSJobs, FastLane_TM)!

To solve, follow these next steps:

1. Open SQL Management Studio Express.
2. Connect to database instance on the SQL Server where the databases are installed (default on the Automation Engine Server name) with an user with administrative rights, sa is default.
3. On the left, select Security > Logins Properties > admin.
4. Double click admin and click Server Roles.
   
5. Uncheck the sysadmin checkbox and click OK.
6. Restart Automation Engine Server software with Server Admin.