java.sql.SQLException: User not found: SA

Hi all:
Opendeploy (6.0.2) service can not start, got a error in od.log as following:
DriverManager.getConnection("jdbc:HypersonicSQL:C:\Interwoven\OpenDeployNG\db\schedDB")
trying driver[className=org.hsql.jdbcDriver,org.hsql.jdbcDriver@11c2b67]
java.sql.SQLException: User not found: SA
at org.hsql.Trace.getError(Trace.java:124)
at org.hsql.Trace.getError(Trace.java:115)
at org.hsql.Trace.error(Trace.java:130)
at org.hsql.Access.get(Access.java:109)
at org.hsql.Access.getUser(Access.java:88)
at org.hsql.Database.connect(Database.java:60)
at org.hsql.jdbcConnection.openStandalone(jdbcConnection.java:662)
at org.hsql.jdbcConnection.(jdbcConnection.java:524)
at org.hsql.jdbcDriver.connect(jdbcDriver.java:78)
at java.sql.DriverManager.getConnection(DriverManager.java:512)
at java.sql.DriverManager.getConnection(DriverManager.java:171)
at com.interwoven.deploy.engine.TMacroDeployInitiator.compactHsql(TMacroDeployInitiator.java:2623)
at com.interwoven.deploy.engine.TMacroDeployInitiator.initScheduler(TMacroDeployInitiator.java:389)
at com.interwoven.deploy.engine.TMacroDeployInitiator.(TMacroDeployInitiator.java:130)
at com.interwoven.deploy.engine.TDeploySvrEngine.(TDeploySvrEngine.java:796)
at com.interwoven.deploy.engine.TDeploySvrEngine.create(TDeploySvrEngine.java:251)
at com.interwoven.deploy.cdmain.IWCDMain.main(IWCDMain.java:1671)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:324)
at com.interwoven.deploy.cdmain.IWCDBoot.run(IWCDBoot.java:255)
at java.lang.Thread.run(Thread.java:534)
SQLException: SQLState(S1000)
getConnection failed: java.sql.SQLException: User not found: SA
could anyone help me on this?
Ming

Find more posts tagged with

Comments

Adam Stoller

It sounds like something might have gone wrong with (or after?) the installation - as "SA" is the default user, setup during installation, to administer the hypersonic DB - check the manuals and/or contact support. You might be able to just re-run the ODHOME/db/schedDB.script and/or ODHOME/db/openjms.db.script to fix it

Migrateduser

Delete or rename the schedDB.* files in od-home/OpenDeployNG/db directory. Then restart OD, and these files should be re-created.

nipper

Delete or rename the schedDB.* files in od-home/OpenDeployNG/db directory. Then restart OD, and these files should be re-created.

Cool, I noticed this on a 6.1 dev system, I was not really concerned, but it made my like easier.

Andy

MAK

Hi ,

Thank you for this, it saved lotta time .. :-)

Cheers..