cancel
Showing results for 
Search instead for 
Did you mean: 

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.Smiley Sad Any help is greatly appreciated ..
4 Replies

RE: epO4.0 install failure...

Hello,
Any McAfee expert to help?..Come on guys : )

RE: epO4.0 install failure...

What are the credentials you use to connect to the DB ? The user shoudl be set to English-language on the SQL server. Also you need MDAC2.8 on the SQL server.

Cheers Tom

RE: epO4.0 install failure...

Thank you for your answer Tom,
I used both NT Auth. and SQL Auth. with no luck. My NT pass was complex so I used my simple SQL pass. But the error was same.

The server which I am installing ePO was set to English (US). Are you sure SQL needs to be set to English? Nobody is logined there.
My SQL driver is 2000.85.1117.00 on the SQL2000 SRV, MDAC 2.80 seems ok.
Any more comments ?

RE: epO4.0 install failure...

In SQL you get set the user language. This must be set to english. The language of the sql server is not important.