Failed to install a new Endpoint Protection Manager which uses SQL server database
search cancel

Failed to install a new Endpoint Protection Manager which uses SQL server database

book

Article ID: 164843

calendar_today

Updated On:

Products

Endpoint Protection

Issue/Introduction

Installing Endpoint Protection Manager using SQL server 2014 database failed at initializing database or upgrading database schema at 2%.

SEPM install log:

2017-3-14 17:24:37  STDERR: SQL Exception:
2017-3-14 17:24:37  STDERR: SQL Command: CREATE VIEW V_AGENT_INCL_RISK_INFO AS      SELECT *,     POWERERASER_PENDING.ALERTS_COUNT AS POWERERASER_PENDING_ALERTS     FROM SEM_AGENT SA with (NOLOCK)     LEFT JOIN (SELECT COUNT(A.ALERT_IDX) AS ALERTS_COUNT,A.COMPUTER_IDX FROM ALERTS A  with (NOLOCK) WHERE  A.SOURCE='PowerEraser' AND A.ACTUALACTION_IDX=14 AND A.DELETED=0 AND A.Mother_Idx = '' AND (DATEDIFF(day,A.ALERTDATETIME, GETDATE()) < 30) GROUP BY A.COMPUTER_IDX) AS POWERERASER_PENDING ON POWERERASER_PENDING.COMPUTER_IDX = SA.COMPUTER_ID
2017-3-14 17:24:37  STDERR: SQLState:  42S22
2017-3-14 17:24:37  STDERR: Message:  Colum 'Mother_Idx' invalid
2017-3-14 17:24:37  STDERR: Vendor:  207
2017-3-14 17:24:37  STDERR: java.sql.SQLException: Colum 'Mother_Idx' invalid
2017-3-14 17:24:37  STDERR:     at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:372)
2017-3-14 17:24:37  STDERR:     at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2988)
2017-3-14 17:24:37  STDERR:     at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2421)
2017-3-14 17:24:37  STDERR:     at net.sourceforge.jtds.jdbc.TdsCore.getMoreResults(TdsCore.java:671)
2017-3-14 17:24:37  STDERR:     at net.sourceforge.jtds.jdbc.JtdsStatement.processResults(JtdsStatement.java:613)
2017-3-14 17:24:37  STDERR:     at net.sourceforge.jtds.jdbc.JtdsStatement.executeSQL(JtdsStatement.java:572)
2017-3-14 17:24:37  STDERR:     at net.sourceforge.jtds.jdbc.JtdsStatement.executeImpl(JtdsStatement.java:809)
2017-3-14 17:24:37  STDERR:     at net.sourceforge.jtds.jdbc.JtdsStatement.execute(JtdsStatement.java:1282)
2017-3-14 17:24:37  STDERR:     at com.sygate.scm.server.db.util.DatabaseUtilities.execCommandFromScript(DatabaseUtilities.java:2099)
2017-3-14 17:24:37  STDERR:     at com.sygate.scm.install.ui.MainFrame.initDatabase(MainFrame.java:2619)
2017-3-14 17:24:37  STDERR:     at com.sygate.scm.install.ui.MainFrame.configureDB(MainFrame.java:1299)
2017-3-14 17:24:37  STDERR:     at com.sygate.scm.install.ui.MainFrame.nextBtnActionPerformed(MainFrame.java:4397)
2017-3-14 17:24:37  STDERR:     at com.sygate.scm.install.ui.MainFrame.access$500(MainFrame.java:296)
2017-3-14 17:24:37  STDERR:     at com.sygate.scm.install.ui.MainFrame$5$1.construct(MainFrame.java:3953)
2017-3-14 17:24:37  STDERR:     at com.sygate.scm.util.SwingWorker$2.run(SwingWorker.java:159)
2017-3-14 17:24:37  STDERR:     at java.lang.Thread.run(Thread.java:745)
2017-3-14 17:24:37  STDERR: java.sql.SQLException: java.sql.SQLException: Colum 'Mother_Idx' invalid
2017-3-14 17:24:37  STDERR:     at com.sygate.scm.server.db.util.DatabaseUtilities.execCommandFromScript(DatabaseUtilities.java:2109)
2017-3-14 17:24:37  STDERR:     at com.sygate.scm.install.ui.MainFrame.initDatabase(MainFrame.java:2619)
2017-3-14 17:24:37  STDERR:     at com.sygate.scm.install.ui.MainFrame.configureDB(MainFrame.java:1299)
2017-3-14 17:24:37  STDERR:     at com.sygate.scm.install.ui.MainFrame.nextBtnActionPerformed(MainFrame.java:4397)
2017-3-14 17:24:37  STDERR:     at com.sygate.scm.install.ui.MainFrame.access$500(MainFrame.java:296)
2017-3-14 17:24:37  STDERR:     at com.sygate.scm.install.ui.MainFrame$5$1.construct(MainFrame.java:3953)
2017-3-14 17:24:37  STDERR:     at com.sygate.scm.util.SwingWorker$2.run(SwingWorker.java:159)
2017-3-14 17:24:37  STDERR:     at java.lang.Thread.run(Thread.java:745)
2017-3-14 17:25:11  STDERR: java.sql.SQLException: object name 'AUDIT_LOG' invalid
2017-3-14 17:25:11  STDERR:     at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:372)
2017-3-14 17:25:11  STDERR:     at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2988)
2017-3-14 17:25:11  STDERR:     at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2421)
2017-3-14 17:25:11  STDERR:     at net.sourceforge.jtds.jdbc.TdsCore.getMoreResults(TdsCore.java:671)
2017-3-14 17:25:11  STDERR:     at net.sourceforge.jtds.jdbc.JtdsStatement.processResults(JtdsStatement.java:613)
2017-3-14 17:25:11  STDERR:     at net.sourceforge.jtds.jdbc.JtdsStatement.executeSQL(JtdsStatement.java:572)
2017-3-14 17:25:11  STDERR:     at net.sourceforge.jtds.jdbc.JtdsPreparedStatement.execute(JtdsPreparedStatement.java:784)
2017-3-14 17:25:11  STDERR:     at com.sygate.scm.server.util.AuditUtil.insertAuditLogToDB(AuditUtil.java:255)
2017-3-14 17:25:11  STDERR:     at com.sygate.scm.server.util.AuditUtil.auditEvent(AuditUtil.java:183)
2017-3-14 17:25:11  STDERR:     at com.sygate.scm.server.util.AuditUtil.auditConfigurationEvent(AuditUtil.java:82)
2017-3-14 17:25:11  STDERR:     at com.sygate.scm.install.ui.MainFrame.auditConfigurationEvent(MainFrame.java:2045)
2017-3-14 17:25:11  STDERR:     at com.sygate.scm.install.ui.MainFrame.configureDB(MainFrame.java:1955)
2017-3-14 17:25:11  STDERR:     at com.sygate.scm.install.ui.MainFrame.nextBtnActionPerformed(MainFrame.java:4397)
2017-3-14 17:25:11  STDERR:     at com.sygate.scm.install.ui.MainFrame.access$500(MainFrame.java:296)
2017-3-14 17:25:11  STDERR:     at com.sygate.scm.install.ui.MainFrame$5$1.construct(MainFrame.java:3953)
2017-3-14 17:25:11  STDERR:     at com.sygate.scm.util.SwingWorker$2.run(SwingWorker.java:159)
2017-3-14 17:25:11  STDERR:     at java.lang.Thread.run(Thread.java:745)

Environment

  • SEP14
  • SQL Server 2014 Enterprize Edition

Cause

SQL server enabled the case-sensitve colation. SEPM 12.1 and SEPM14 does not support case-sensitve collation.

Resolution

Use a SQL server database which does not use case-sensitve collation.

Powered by Wolken Software