Security Software

Hi,

I am trying to install OES with Oracle 10.2 as policy store. I am able to run DBConfig.bat successfully. But when I try to to run install_ales_schema.bat I get the following error:

Dropping deprecated database constraints, stored procedures, sequences, and view
s

D:\oracle\Middleware\ales32-admin\bin>install_ales_schema.bat OES OES
Dropping deprecated database constraints, stored procedures, sequences, and view
s
Exception in thread "Main Thread" org.apache.openjpa.lib.jdbc.ReportingSQLExcept
ion: ORA-00942: table or view does not exist
{stmnt 2110841 ALTER TABLE version ADD dbversion VARCHAR2(20)} [code=942, state
=42000]
at org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.wrap(LoggingCo
nnectionDecorator.java:191)
at org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.access$800(Log
gingConnectionDecorator.java:56)
at org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator$LoggingConnect
ion$LoggingStatement.executeUpdate(LoggingConnectionDecorator.java:753)
at org.apache.openjpa.lib.jdbc.DelegatingStatement.executeUpdate(Delegat
ingStatement.java:114)
at org.apache.openjpa.jdbc.schema.SchemaTool.executeSQL(SchemaTool.java:
1185)
at org.apache.openjpa.jdbc.schema.SchemaTool.addColumn(SchemaTool.java:1
020)
at org.apache.openjpa.jdbc.schema.SchemaTool.add(SchemaTool.java:481)
at org.apache.openjpa.jdbc.schema.SchemaTool.add(SchemaTool.java:344)
at org.apache.openjpa.jdbc.schema.SchemaTool.run(SchemaTool.java:321)
at org.apache.openjpa.jdbc.schema.SchemaTool.run(SchemaTool.java:1488)
at org.apache.openjpa.jdbc.schema.SchemaTool.run(SchemaTool.java:1394)
at org.apache.openjpa.jdbc.schema.SchemaTool.main(SchemaTool.java:1339)
at com.bea.security.management.dbschema.SchemaToolWrapper.main(SchemaToo
lWrapper.java:124)

D:\oracle\Middleware\ales32-admin\bin>


Your response is greatly appreciated!

Edited by: cshirashyad on Oct 14, 2009 10:09 AM