Client groups do not show information when the "Protection Technology", "Network Information" and "Client system" views are selected

Products

• Endpoint Protection

Issue/Introduction

The "Protection Technology", "Network Information" and "Client system" client views within the Symantec Endpoint Protection (SEP) Manager are empty, whereas other client views display the clients properly. This behavior may be observed on Active Directory OU sync'd groups as well as non-OU sync'd groups.

Dec 10, 2019 2:36:30 AM  STDERR: java.lang.NumberFormatException: For input string: ""
Dec 10, 2019 2:36:30 AM  STDERR: at java.lang.NumberFormatException.forInputString(NumberFormatException.java:65)
Dec 10, 2019 2:36:30 AM  STDERR: at java.lang.Integer.parseInt(Integer.java:592)
Dec 10, 2019 2:36:30 AM  STDERR: at java.lang.Integer.valueOf(Integer.java:766)
Dec 10, 2019 2:36:30 AM  STDERR: at com.sygate.scm.console.handler.SemComputerHandler.getComputerList(SemComputerHandler.java:379)
Dec 10, 2019 2:36:30 AM  STDERR: at com.sygate.scm.console.ui.client.ClientCustomTableModel.getObjectList(ClientCustomTableModel.java:372)
Dec 10, 2019 2:36:30 AM  STDERR: at com.sygate.scm.console.ui.client.ClientCustomTableModel.doQuery(ClientCustomTableModel.java:405)
Dec 10, 2019 2:36:30 AM  STDERR: at com.sygate.scm.console.ui.client.ClientCustomTableModel.access$000(ClientCustomTableModel.java:57)
Dec 10, 2019 2:36:30 AM  STDERR: at com.sygate.scm.console.ui.client.ClientCustomTableModel$1.doInBackground(ClientCustomTableModel.java:305)
Dec 10, 2019 2:36:30 AM  STDERR: at com.sygate.scm.console.ui.client.ClientCustomTableModel$1.doInBackground(ClientCustomTableModel.java:301)
Dec 10, 2019 2:36:30 AM  STDERR: at javax.swing.SwingWorker$1.call(SwingWorker.java:295)
Dec 10, 2019 2:36:30 AM  STDERR: at java.util.concurrent.FutureTask.run(FutureTask.java:266)
Dec 10, 2019 2:36:30 AM  STDERR: at javax.swing.SwingWorker.run(SwingWorker.java:334)
Dec 10, 2019 2:36:30 AM  STDERR: at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)

Dec 10, 2019 2:36:30 AM  STDERR: at java.util.concurrent.FutureTask.run(FutureTask.java:266)
Dec 10, 2019 2:36:30 AM  STDERR: at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
Dec 10, 2019 2:36:30 AM  STDERR: at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
Dec 10, 2019 2:36:30 AM  STDERR: at java.lang.Thread.run(Thread.java:748)
Dec 10, 2019 2:36:30 AM  STDERR: com.sygate.scm.console.util.ConsoleException: Unexpected console error. [0x80010000]
Dec 10, 2019 2:36:30 AM  STDERR: at com.sygate.scm.console.handler.SemComputerHandler.getComputerList(SemComputerHandler.java:969)

Environment

SEP 14.2 RU2

Cause

Incorrect SQL queries used for Clients views in Active Directory sync'd groups.

Resolution

This issue is fixed in Symantec Endpoint Protection 14.2.2.1 (RU2 MP1)  For information on how to obtain the latest build of Symantec Endpoint Protection, see Download the latest version of Symantec Endpoint Protection.