Error upgrading ESET Protect to newest Version via Webconsole Task

[axel06 0]

Hello after Upgrade my ESET Protect Server via Webconsole to the latest Version i got same Error as a other older Topic in This Forum. 

 

Problems with this Table : Unknown table 'eset_manager.fact_fe_threat_event'

 

Thanks for help

● eraserver.service - ESET PROTECT Server
   Loaded: loaded (/etc/systemd/system/eraserver.service; enabled; vendor preset: enabled)
   Active: failed (Result: exit-code) since Fri 2022-09-23 23:50:02 CEST; 38min ago
  Process: 18363 ExecStart=/opt/eset/RemoteAdministrator/Server/ERAServer --daemon --pidfile /var/run/eraserver.pid (code=exited, status=0/SUCCESS)
 Main PID: 18364 (code=exited, status=70)

Sep 23 23:50:01 Ubuntu systemd[1]: Starting ESET PROTECT Server...
Sep 23 23:50:01 Ubuntu systemd[1]: Started ESET PROTECT Server.
Sep 23 23:50:02 Ubuntu systemd[1]: eraserver.service: Main process exited, code=exited, status=70/n/a
Sep 23 23:50:02 Ubuntu systemd[1]: eraserver.service: Unit entered failed state.
Sep 23 23:50:02 Ubuntu systemd[1]: eraserver.service: Failed with result 'exit-code'.

 

same Problem but no solution

 

read 7f002ac20740]: Initializing module CTranslatorModule
2022-09-23 21:50:01 Information: CTranslatorModule [Thread 7f002ac20740]: Registering translator resource
2022-09-23 21:50:01 Information: CTranslatorModule [Thread 7f002ac20740]: Module successfully initialized
2022-09-23 21:50:01 Information: Kernel [Thread 7f002ac20740]: Initialized module CTranslatorModule (used 0 KB) initialization took 0 milliseconds
2022-09-23 21:50:01 Information: Kernel [Thread 7f002ac20740]: Initializing module CUpdatesModule
2022-09-23 21:50:01 Information: Kernel [Thread 7f002ac20740]: Initialized module CUpdatesModule (used 2776 KB) initialization took 0 milliseconds
2022-09-23 21:50:01 Information: Kernel [Thread 7f002ac20740]: Initializing module CDatabaseModule
2022-09-23 21:50:01 Information: CDatabaseModule [Thread 7f002ac20740]: Startup configuration builder builds successfully ...
2022-09-23 21:50:01 Information: CDatabaseModule [Thread 7f002ac20740]: Startup connection pool created ...
2022-09-23 21:50:01 Information: CDatabaseModule [Thread 7f002ac20740]: ESMC microservice uuid = bac7ac89-e84d-43ee-bf62-b2cb6e60e65d
2022-09-23 21:50:01 Information: CDatabaseModule [Thread 7f002ac20740]: Static object event streaming enabled = 0
2022-09-23 21:50:01 Information: CDatabaseModule [Thread 7f002ac20740]: Registering EventIniter Certificates with priority: 99996
2022-09-23 21:50:01 Information: CDatabaseModule [Thread 7f002ac20740]: Registering EventIniter UserGroupsManagementMapper with priority: 99995
2022-09-23 21:50:01 Information: CDatabaseModule [Thread 7f002ac20740]: Registering EventIniter StaticGroups with priority: 99999
2022-09-23 21:50:01 Information: CDatabaseModule [Thread 7f002ac20740]: Registering EventIniter DynamicTemplates with priority: 100000
2022-09-23 21:50:01 Information: CDatabaseModule [Thread 7f002ac20740]: Registering EventIniter PoliciesManagerMapper with priority: 99998
2022-09-23 21:50:01 Information: CDatabaseModule [Thread 7f002ac20740]: Registering EventIniter AutomationStuff with priority: 99997
2022-09-23 21:50:01 Information: CDatabaseModule [Thread 7f002ac20740]: Registering EventIniter AccessTokenMapper with priority: 99994
2022-09-23 21:50:01 Information: CDatabaseModule [Thread 7f002ac20740]: Builder rebuilds successfully ...
2022-09-23 21:50:01 Information: CDatabaseModule [Thread 7f002ac20740]: Connection pool recreated ...
2022-09-23 21:50:01 Information: CDatabaseModule [Thread 7f002ac20740]: ESMC microservice uuid = bac7ac89-e84d-43ee-bf62-b2cb6e60e65d
2022-09-23 21:50:01 Information: CDatabaseModule [Thread 7f002ac20740]: Static object event streaming enabled = 0
2022-09-23 21:50:01 Information: CDatabaseModule [Thread 7f002ac20740]: Registering EventIniter Certificates with priority: 99996
2022-09-23 21:50:01 Information: CDatabaseModule [Thread 7f002ac20740]: Registering EventIniter UserGroupsManagementMapper with priority: 99995
2022-09-23 21:50:01 Information: CDatabaseModule [Thread 7f002ac20740]: Registering EventIniter StaticGroups with priority: 99999
2022-09-23 21:50:01 Information: CDatabaseModule [Thread 7f002ac20740]: Registering EventIniter DynamicTemplates with priority: 100000
2022-09-23 21:50:01 Information: CDatabaseModule [Thread 7f002ac20740]: Registering EventIniter PoliciesManagerMapper with priority: 99998
2022-09-23 21:50:01 Information: CDatabaseModule [Thread 7f002ac20740]: Registering EventIniter AutomationStuff with priority: 99997
2022-09-23 21:50:01 Information: CDatabaseModule [Thread 7f002ac20740]: Registering EventIniter AccessTokenMapper with priority: 99994
2022-09-23 21:50:01 Information: CDatabaseModule [Thread 7f002ac20740]: CDBSetupperBase::PerformUpgradeIfNecessary: Checking if ETL DB is required
2022-09-23 21:50:01 Information: CDatabaseModule [Thread 7f002ac20740]: CDBSetupperBase::PerformUpgradeIfNecessary: ETL upgrade required.
2022-09-23 21:50:02 Information: CDatabaseModule [Thread 7f002ac20740]: CDBSetupperBase::PerformUpgradeIfNecessary: Going to destroy tables because of previous fail: fact_fe_threat_event tbl_computers_aggr tbld_activethreats_status_engineversion tbld_application_identifier tbld_application_parameters tbld_apps_installed_status_name tbld_apps_installed_status_vendor tbld_cause tbld_computers_comment tbld_computers_name tbld_devicecontrol_device_event_device tbld_deviceinformation_device_status_manufacturer tbld_deviceinformation_device_status_model tbld_devicelocation_gps_status_provider tbld_diagnostics_diagnosticzip_event_data tbld_eesvirusdb_status_versiondate tbld_enterpriseinspectoralert_event_rulename tbld_exportedconfiguration_event_configuration tbld_firewallagregated_event_protocol tbld_hwinventory_chassis_status_description tbld_hwinventory_chassis_status_manufacturer tbld_hwinventory_display_status_description tbld_hwinventory_display_status_manufacturer tbld_hwinventory_displayadapter_status_description tbld_hwinventory_displayadapter_status_manufacturer tbld_hwinventory_inputdevice_status_description tbld_hwinventory_inputdevice_status_manufacturer tbld_hwinventory_massstorage_status_description tbld_hwinventory_massstorage_status_manufacturer tbld_hwinventory_networkadapter_status_description tbld_hwinventory_networkadapter_status_manufacturer tbld_hwinventory_printer_status_description tbld_hwinventory_processor_status_description tbld_hwinventory_processor_status_manufacturer tbld_hwinventory_ram_status_description tbld_hwinventory_ram_status_manufacturer tbld_hwinventory_sounddevice_status_description tbld_hwinventory_sounddevice_status_manufacturer tbld_identifiers_list_status_value tbld_ip_mask tbld_loggedusers_list_status_domain tbld_loggedusers_list_status_fullname tbld_loggedusers_list_status_name tbld_osinformation_edition_status_os_info_edition tbld_osinformation_locale_status_os_locale_language tbld_osinformation_timezone_status_time_zone_name_offset tbld_processname tbld_quarantine_uploadedfile_event_password tbld_quarantine_uploadedfile_event_path tbld_rdsensor_newcomputers_status_computer_identifier tbld_rdsensor_newcomputers_status_ipv4ipv6 tbld_rdsensor_newcomputers_status_mergedidentifier tbld_rdsensor_newcomputers_status_netcardvendor tbld_rdsensor_newcomputers_status_osname tbld_remote_host tbld_rulename tbld_scantargetsid tbld_security_product_status_nameversion tbld_srvsecproduct_scantargets_status_data tbld_static_groups_comment tbld_static_groups_name tbld_submittedfiles_event_username tbld_sysinspector_sysinspector_event_logdata tbld_threat_event_engineversion tbld_threatname tbld_used_license_status_licenseid_licenseproductname tbld_usergroup tbld_username tblf_activethreats_status tblf_applicationactivationmatrix_status tblf_appliedpoliciescount_status tblf_appliedpolicieslist_status tblf_appliedpolicyproducts_status tblf_apps_currentversion_status tblf_apps_installed_status tblf_apps_securitystatus_status tblf_apps_versioncheck_status tblf_audit_event tblf_blockedfiles_event tblf_certificates_peercertificate_status tblf_computer_connected_event tblf_computer_lost_event tblf_computercloningtickets_status tblf_computeridentityrecovered_event tblf_computerlocationmembership_status tblf_devicecontrol_device_event tblf_deviceinformation_device_status tblf_devicelocation_gps_status tblf_diagnostics_devicecontrol_device_event tblf_diagnostics_diagnosticzip_event tblf_diagnostics_firewall_event tblf_diagnostics_hips_event tblf_diagnostics_spam_event tblf_diagnostics_webcontrol_link_event tblf_dynamicgroups_content_status tblf_dynamicgroupsmembership_status tblf_dynamicthreatdetectionanalyses_status tblf_dynamicthreatdetectionglobalcustomersstatistics_status tblf_dynamicthreatdetectionglobaldetectionstatistics_status tblf_eesevent__event tblf_eesvirusdb_status tblf_encryption_storage_status tblf_enterpriseinspectoralert_event tblf_enterpriseinspectoroverview_status tblf_enterpriseinspectoroverviewtotals_status tblf_epns_status tblf_exclusionhitsagregated__event tblf_exclusionhitssummary_status tblf_exportedconfiguration_event tblf_featurestatus_status tblf_filteredwebsites_event tblf_firewallagregated_event tblf_functionality_computer_status tblf_functionality_problemsdetails_status tblf_functionality_products_status tblf_hipsagregated_event tblf_hwinventory_chassis_status tblf_hwinventory_display_status tblf_hwinventory_displayadapter_status tblf_hwinventory_inputdevice_status tblf_hwinventory_massstorage_status tblf_hwinventory_networkadapter_status tblf_hwinventory_printer_status tblf_hwinventory_processor_status tblf_hwinventory_ram_status tblf_hwinventory_sounddevice_status tblf_identifiers_list_status tblf_livegrid_status tblf_location_status tblf_loggedusers_list_status tblf_managed_products_status tblf_mdm_core_status tblf_mdm_enrollmenturls_status tblf_mdm_reenrollmenturls_status tblf_network_adapters_status tblf_network_ipaddresses_status tblf_network_mobile_status tblf_newcomputerenrolled_event tblf_osinformation_edition_status tblf_osinformation_locale_status tblf_osinformation_timezone_status tblf_performance_server_event tblf_performance_server_state_status tblf_qos_database_event tblf_qos_network_event tblf_quarantine_content_status tblf_quarantine_uploadedfile_event tblf_rdsensor_newcomputers_status tblf_repository_agent_status tblf_repository_epi_status tblf_repository_server_status tblf_repository_software_status tblf_scan_event tblf_security_product_status tblf_serverseatchanged_event tblf_spam_topdomains_status tblf_spam_toprecipients_status tblf_spam_topsenders_status tblf_srvsecproduct_scantargets_status tblf_static_groups tblf_storage_list_status tblf_submittedfiles_event tblf_sysinspector_sysinspector_event tblf_task_client_event tblf_task_client_trigger_notification_event tblf_task_detail_agentdeployment_status tblf_task_server_status tblf_threat_event tblf_threatsmute_event tblf_threatsmuteeitoera_event tblf_threatsmuteeratoei_event tblf_tryandbuyfeatures_status tblf_used_license_status tblf_webcontrolagregated_event
2022-09-23 21:50:02 Information: Kernel [Thread 7f002ac20740]: Unloading module: CUpdatesModule
2022-09-23 21:50:02 Information: Kernel [Thread 7f002ac20740]: Unloading module: CTranslatorModule
2022-09-23 21:50:02 Error: Service [Thread 7f002ac20740]: Service run-time failed with: [MySQL][ODBC 8.0(a) Driver][mysqld-5.7.33-0ubuntu0.16.04.1]Unknown table 'eset_manager.fact_fe_threat_event'

 

[Marcos 5,074]

Please open a support ticket for further troubleshooting of the issue. Probably a dump of the database from before upgrade will be requested as well as more info about the hardware configuration of the server, especially the amount of installed RAM. Insufficient RAM during upgrade may lead to issues with the db.

[axel06 0]

I think i found a Solution. i Import the missing table fact_fe_threat_event from Backup.

Now ERASERVER startet again and the Upgrade is Running  with 100% Mysql Prozess. (  100.0 15.6  42:28.22 mysqld)

I hope this time everythings works.

[axel06 0]

Problem Solved ERA Server Running. Upgrade finished.