Issue

The installation fails to continue, and the Apex One Master Service now encounters unable to stop the issue.

Resolution

1. Set the following Services to Manual:
   • Apex One Master Service
   • World wide Web service
2. Reboot the Apex One server.
3. After the reboot, unload the Apex One agent (installed on Apex One server).
4. Right-click the patch installer, and select Run as Administrator.
5. Verify that patch has been installed successfully. (Help-> About and check the build).
6. After the installation of the patch, ensure that the following Services are set to automatic:
   • Apex One Master Service
   • World Wide Web service

Issue

Application event log

Exception Type: ADOException
Program:[ C:\Program Files (x86)\Trend Micro\Apex One\PCCSRV\Web\Service\DbServer.exe ] (14.0.10123)
Process ID:[ 3436(0x00000d6c) ] Thread ID[ 3472(0x00000d90) ]
Error Code[ -2147217913(0x80040e07) ]
Error Description[ ADOException: Code meaning = IDispatch error #3079 Source = 
    Microsoft SQL Server Native Client 11.0 Description = Error converting data type nvarchar(max) 
    to int. Info = { call .[osp_cb_dbSetClientComponentVersion]
    (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, 
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) } ]

    Function:[ADOHelper::CADOCommand::Execute] Source file:
    [ D:\ws\workspace\OSCE\OSCE_Onpremise_2019_Patch6_REL\build\src\Server\DatabaseServer\libADOHelper\CADOCommand.cpp(81) ]

Resolution

Re-establish the communication between Apex One Server and Microsoft SQL Server through the use of SQL Migration Tool.

Issue

Log Collection

ofcdebug.log
[ERROR] [lwcs_httpserver.cpp (352)] Deinit CompletionPort failed, ret=-49996
[ERROR] [webreputationservice.cpp ( 33)] Initial LWCSManager failed!(errno=22)
[ERROR] [lwcsagentservice.cpp (222)] Failed to initial Web Reputation Service!(dwRet=22)
[ERROR] [lwcs_httpserver.cpp (599)] TM::Utility::Thread::Threat::Close failed with OfficeScan error code= -62985

Resolution

1. Login to the Apex One web console, and navigate to Administration > Setting > Proxy > Server.
2. Take note of the information configured for Proxy Server settings.
3. Back up proxy.ini located in C:\Program Files (x86)\Trend Micro\Apex One\PCCSRV\LWCS\
4. Return LWCS/proxy.ini to its initial value as follows:
    

   This action should not impact the current normal functionality.

    

   [Proxy]
   UseProxy=0
   ProxyServer=
   ProxyPort=80
   ProxyProtocol=0
   ProxyUsername=
   ProxyPassword=
   RequireAuth=0
   

5. Save the changes to the proxy.ini file, then restart LWCS Service or reboot the Apex One server.
6. Re-configure the proxy information from the web management console.