4 Replies Latest reply on Jan 25, 2008 2:13 AM by metalhead

    epO4.0 install failure...

      Hello,
      I am having trouble installing ePO 4.0 on a Windows2003 R2 SP2. There is already a WSUS (using a Sql2005 express db) on that server so I am using a SQL2000 SP4 on a remote machine for my db.. Credentials, server ports are OK.

      Installation is starting smoothly, but during the db creation it is suddenly stopping and starting to roll back. My epo-install.log is as follow.

      db-install:
      [copy] Copying 3 files to F:\PROGRA~1\McAfee\EPOLIC~1
      [run-sql] log4j:WARN No appenders could be found for logger (com.mcafee.orion.core.db.base.Database).
      [run-sql] log4j:WARN Please initialize the log4j system properly.
      [run-sql] 0: IF EXISTS (SELECT * FROM [dbo].[sysobjects] WHERE id = object_id(N'[db...
      [run-sql] 0: IF EXISTS (SELECT * FROM [dbo].[sysobjects] WHERE id = object_id(N'[db...
      [run-sql] 0: IF EXISTS (SELECT * FROM [dbo].[sysobjects] WHERE id = object_id(N'[db...
      [run-sql] 0: if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[...
      [run-sql] 0: if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[...
      [run-sql] 0: if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[...
      [run-sql] 0: if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[...
      [run-sql] 0: if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[...
      [run-sql] 0: if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[...
      [run-sql] 0: if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[...
      [run-sql] 0: if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[...
      [run-sql] 0: if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[...
      [run-sql] 0: IF EXISTS (SELECT * FROM [dbo].[sysobjects] WHERE id = object_id(N'[db...
      [run-sql] 0: IF EXISTS (SELECT * FROM [dbo].[sysobjects] WHERE id = object_id(N'[db...
      [run-sql] 0: if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[...
      [run-sql] 0: if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[...
      [run-sql] 0: if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[...
      [run-sql] 0: if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[...
      [run-sql] 0: if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[...
      [run-sql] 0: if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[...
      [run-sql] 0: if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[...
      [run-sql] 0: if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[...
      [run-sql] 0: if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[...
      [run-sql] 0: if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[...
      [run-sql] 0: if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[...
      [run-sql] 0: if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[...
      [run-sql] 0: if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[...
      [run-sql] 0: if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[...
      [run-sql] 0: if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[...
      [run-sql] 0: if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[...
      [run-sql] 0: if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[...
      [run-sql] 0: if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[...
      [run-sql] 0: if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[...
      [run-sql] 0: if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[...
      [run-sql] 0: if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[...
      [run-sql] 0: if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[...
      [run-sql] 0: if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[...
      [run-sql] 0: if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[...
      [run-sql] 0: if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[...
      [run-sql] 0: if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[...

      [snip]

      [run-sql] 0: if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[...
      [run-sql] 0: if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[...
      [run-sql] 0: if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[...
      [run-sql] 0: if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[...
      [run-sql] 0: if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[...
      [run-sql] 0: if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[...
      [run-sql] 0: if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[...
      [run-sql] 0: if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[...
      [run-sql] 0: if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[...
      [run-sql] 0: if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[...
      [run-sql] 0: if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[...
      [run-sql] 0: if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[...
      [run-sql] 0: if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[...
      [run-sql] 0: if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[...
      [run-sql] 0: if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[...
      [run-sql] 0: if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[...
      [run-sql] 0: if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[...
      [run-sql] 0: if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[...
      [run-sql] 0: if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[...
      [run-sql] 0: if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[...
      [run-sql] 0: if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[...
      [run-sql] 0: if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[...
      [run-sql] 0: if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[...
      [run-sql] 0: if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[...
      [run-sql] 0: if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[...
      [run-sql] 0: if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[...
      [run-sql] java.sql.SQLException: Invalid column name 'ID'.
      [run-sql] at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:367)
      [run-sql] at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2816)
      [run-sql] at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2254)
      [run-sql] at net.sourceforge.jtds.jdbc.TdsCore.getMoreResults(TdsCore.java:631)
      [run-sql] at net.sourceforge.jtds.jdbc.JtdsStatement.processResults(JtdsStatement.java:584)
      [run-sql] at net.sourceforge.jtds.jdbc.JtdsStatement.executeSQL(JtdsStatement.java:546)
      [run-sql] at net.sourceforge.jtds.jdbc.JtdsStatement.executeImpl(JtdsStatement.java:723)
      [run-sql] at net.sourceforge.jtds.jdbc.JtdsStatement.executeUpdate(JtdsStatement.java:1163)
      [run-sql] at net.sourceforge.jtds.jdbc.JtdsStatement.executeUpdate(JtdsStatement.java:1116)
      [run-sql] at com.mcafee.orion.core.db.base.SqlUtil.executeSql(SqlUtil.java:59)
      [run-sql] at com.mcafee.orion.core.db.base.SqlUtil.executeSqlFile(SqlUtil.java:120)
      [run-sql] at com.mcafee.orion.core.db.base.SqlUtil.executeSqlFile(SqlUtil.java:102)
      [run-sql] at com.mcafee.orion.core.install.RunSqlTask.execute(RunSqlTask.java:58)
      [run-sql] at org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:275)
      [run-sql] at org.apache.tools.ant.Task.perform(Task.java:364)
      [run-sql] at org.apache.tools.ant.Target.execute(Target.java:341)
      [run-sql] at org.apache.tools.ant.Target.performTasks(Target.java:369)
      [run-sql] at org.apache.tools.ant.Project.executeSortedTargets(Project.java:1216)
      [run-sql] at org.apache.tools.ant.Project.executeTarget(Project.java:1185)
      [run-sql] at org.apache.tools.ant.helper.DefaultExecutor.executeTargets(DefaultExecutor.java :40)
      [run-sql] at org.apache.tools.ant.Project.executeTargets(Project.java:1068)
      [run-sql] at org.apache.tools.ant.Main.runBuild(Main.java:668)
      [run-sql] at org.apache.tools.ant.Main.startAnt(Main.java:187)
      [run-sql] at org.apache.tools.ant.launch.Launcher.run(Launcher.java:246)
      [run-sql] at org.apache.tools.ant.launch.Launcher.main(Launcher.java:67)

      BUILD FAILED
      F:\Program Files\McAfee\ePolicy Orchestrator\Installer\epo\build.xml:98: java.sql.SQLException: Invalid column name 'ID'.

      Total time: 14 seconds

      I think the problem is "java.sql.SQLException: Invalid column name 'ID'." but could not find any solution for this exception.:( Any help is greatly appreciated ..