Trouble running Open Anzo snapshot

[Rolf Bardeli]

I am trying to run the latest Open Anzo snapshot on Linux using Oracle
11g. After the configuration steps mentioned in the wiki, I get the
following exception when trying to start Open Anzo. Does anyone have
any idea what the problem might be?

Thanks,
Rolf

My configuration file
(org.openanzo.datasource.nodecentric.defaultDatasource.properties) is:


service.factoryPid=org.openanzo.datasource.nodecentric.Factory
org.openanzo.services.enabled=true
org.openanzo.services.instanceURI=http://openanzo.org/datasource/
systemDatasour
org.openanzo.datasource.initFiles=resource:/org/openanzo/datasource/
nodecentric
org.openanzo.datasource.isPrimary=true
org.openanzo.database.password=<I entered my oracle password here>
org.openanzo.database.user=<I entered my oracle username here>
org.openanzo.database.type=ServerOracle
#org.openanzo.database.url=jdbc:h2:${bundleLocation}/databases/
systemDB
org.openanzo.database.url=jdbc:oracle:thin:@127.0.0.2:1521/orcl
org.openanzo.datasource.uriPatterns=*



The exception is:

-> 2009-01-08 10:18:55,034 1 [ERROR] [Configuration Updater]
[OpName=] [OpId=] [OpUser=] [RunAs=] [UserDesc=]
org.apache.felix.configadmin - [org.openanzo.osgi.IStatusProvider,
org.osgi.service.cm.ManagedServiceFactory,
org.openanzo.datasource.nodecentric.NodeCentricDatasourceFactory,
org.openanzo.osgi.ServiceActivator,
org.osgi.service.metatype.MetaTypeProvider]: Unexpected problem
updating configuration
java.lang.NoClassDefFoundError: org/ietf/jgss/GSSException
at java.lang.Class.forName0(Native Method)
at java.lang.Class.forName(Class.java:169)
at oracle.net.ano.Ano.init(Unknown Source)
at oracle.net.ns.NSProtocol.connect(NSProtocol.java:229)
at oracle.jdbc.driver.T4CConnection.connect(T4CConnection.java:
1335)
at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:
319)
at oracle.jdbc.driver.PhysicalConnection.<init>
(PhysicalConnection.java:493)
at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:
198)
at oracle.jdbc.driver.T4CDriverExtension.getConnection
(T4CDriverExtension.java:29)
at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:
493)
at java.sql.DriverManager.getConnection(DriverManager.java:
582)
at java.sql.DriverManager.getConnection(DriverManager.java:
154)
at
org.apache.commons.dbcp.DriverManagerConnectionFactory.createConnection
(DriverManagerConnectionFactory.java:68)
at org.apache.commons.dbcp.PoolableConnectionFactory.makeObject
(PoolableConnectionFactory.java:294)
at org.openanzo.datasource.nodecentric.NodeCentricDatasource
$2.makeObject(NodeCentricDatasource.java:403)
at org.apache.commons.pool.impl.GenericObjectPool.borrowObject
(GenericObjectPool.java:974)
at
org.openanzo.datasource.nodecentric.NodeCentricDatasource.getQueryConnection
(NodeCentricDatasource.java:669)
at
org.openanzo.datasource.nodecentric.NodeCentricDatasource.getQueryContext
(NodeCentricDatasource.java:731)
at
org.openanzo.datasource.nodecentric.NodeCentricModelService.getServerUriInternal
(NodeCentricModelService.java:367)
at
org.openanzo.datasource.nodecentric.NodeCentricModelService.start
(NodeCentricModelService.java:75)
at
org.openanzo.datasource.nodecentric.NodeCentricDatasource.<init>
(NodeCentricDatasource.java:238)
at
org.openanzo.datasource.nodecentric.NodeCentricDatasourceFactory.updated
(NodeCentricDatasourceFactory.java:202)
at org.apache.felix.cm.impl.ConfigurationManager
$ManagedServiceFactoryUpdate.run(ConfigurationManager.java:1056)
at org.apache.felix.cm.impl.UpdateThread.run(UpdateThread.java:
90)
Caused by: java.lang.ClassNotFoundException:
org.ietf.jgss.GSSException
at
org.apache.felix.framework.searchpolicy.R4SearchPolicyCore.findClass
(R4SearchPolicyCore.java:198)
at
org.apache.felix.framework.searchpolicy.R4SearchPolicy.findClass
(R4SearchPolicy.java:45)
at
org.apache.felix.framework.searchpolicy.ContentClassLoader.loadClass
(ContentClassLoader.java:109)
at java.lang.ClassLoader.loadClass(ClassLoader.java:252)
at java.lang.ClassLoader.loadClassInternal(ClassLoader.java:
320)
... 24 more
Caused by: java.lang.ClassNotFoundException:
org.ietf.jgss.GSSException
at
org.apache.felix.framework.searchpolicy.R4SearchPolicyCore.findClassOrResource
(R4SearchPolicyCore.java:486)
at
org.apache.felix.framework.searchpolicy.R4SearchPolicyCore.findClass
(R4SearchPolicyCore.java:185)
... 28 more

[Ben Szekely]

Hi Rolf,
Please excuse the delay in responding. It looks as though the class
that isn't being found is part of the JDK. We are using 1.6.0_07, so
possibly you aren't using the right version. Please let us know if you
still have problems.

- Ben

[Jordi Albornoz Mulligan]

Hi Rolf,

That class is being loaded by Oracle's libaries. I believe those classes
come with the JDK since version 1.4. However, if they aren't imported by
the Oracle OSGi package then the Oracle library won't see them.

How did you build the OSGi bundle for the oracle library?

We have instructions here:
http://www.openanzo.org/projects/openanzo/wiki/OpenAnzoInstallation31#Oracle

But I notice that our config for the bundle excludes the org.ietf.jgss
package. That's most likely the problem. I'm not sure why you are seeing
it and we aren't.

You could try editing the file:
openanzo-3.1.0-SNAPSHOT/lib/buildBundles/oracle/pom.xml
Specifically, edit the content of the <Import-Package> element by
removing the following text:
!org.ietf.jgss

Then re-create the bundle by running:
openanzo-3.1.0-SNAPSHOT/lib/buildBundles/oracle/makeOracleBundle.sh
(or .bat for Windows)

I'm not sure if that will fix your issue but it seems like that may be
the problem.

--
Jordi Albornoz Mulligan
Founding Engineer - Cambridge Semantics
jo...@cambridgesemantics.com
(617) 401-7321

[Rolf Bardeli]

Hi Ben, hi Jordie,

thank you very much for your answers. Unfortunately, I still get the
same exception when trying to run Open Anzo after:
- Checking my JDK version. It is 1.6.0_11.
- Rebuilding the Oracle bundle after removing !org.ietf.jgss from
pom.xml
I am rebuilding using openanzo-3.1.0-SNAPSHOT/lib/buildBundles/
oracle/makeOracleBundle.sh which I modified concerning the paths to
Oracle (see below).

Rolf

My makeOracleBundle.sh:

#!/bin/bash
DB_LIB=/data/u01/app/oracle/product/11.1.0/db_1

if [ -z "$DB_LIB" ]; then
echo "Error: DB_LIB is not defined correctly."
echo "Please set in this script or as an environment variable
and try again"
exit 1
elif [ ! -x "$DB_LIB" ]; then
echo "Error: DB_LIB was defined, but directory specified does not
exist."
echo " Please correct DB_LIB and try again"
exit 1
fi

mvn install:install-file -DgroupId=com.oracle -DartifactId=jdbc -
Dversion=11.1.0.6.0 -Dpackaging=jar -Dfile=${DB_LIB}/jdbc/lib/
ojdbc5_g.jar
mvn install:install-file -DgroupId=com.oracle -DartifactId=i18n -
Dversion=11.1.0.6.0 -Dpackaging=jar -Dfile=${DB_LIB}/jlib/orai18n.jar
mvn package
cp target/*.jar ../../dependencies



On Jan 9, 10:32 pm, Jordi Albornoz Mulligan

<jo...@cambridgesemantics.com> wrote:
> Hi Rolf,
>
> That class is being loaded by Oracle's libaries. I believe those classes
> come with the JDK since version 1.4. However, if they aren't imported by
> the Oracle OSGi package then the Oracle library won't see them.
>
> How did you build the OSGi bundle for the oracle library?
>

> We have instructions here:http://www.openanzo.org/projects/openanzo/wiki/OpenAnzoInstallation31...

[Rolf Bardeli]

Hi Ben, hi Jordi,

Thank you very much for your answers. Unfortunately I still get the
same exception when running Open Anzo after:
- Checking my JDK version which is 1.6.0_11
- Rebuilding the Oracle bundle (openanzo-3.1.0-SNAPSHOT/lib/
buildBundles/oracle//makeOracleBundle.sh, see below) after removing !
org.ietf.jgss from pom.xml


Rolf


I edited makeOracleBundle.sh to look like this:

#!/bin/bash
DB_LIB=/data/u01/app/oracle/product/11.1.0/db_1

if [ -z "$DB_LIB" ]; then
echo "Error: DB_LIB is not defined correctly."
echo "Please set in this script or as an environment variable
and try again"
exit 1
elif [ ! -x "$DB_LIB" ]; then
echo "Error: DB_LIB was defined, but directory specified does not
exist."
echo " Please correct DB_LIB and try again"
exit 1
fi

mvn install:install-file -DgroupId=com.oracle -DartifactId=jdbc -
Dversion=11.1.0.6.0 -Dpackaging=jar -Dfile=${DB_LIB}/jdbc/lib/
ojdbc5_g.jar
mvn install:install-file -DgroupId=com.oracle -DartifactId=i18n -
Dversion=11.1.0.6.0 -Dpackaging=jar -Dfile=${DB_LIB}/jlib/orai18n.jar
mvn package
cp target/*.jar ../../dependencies





On Jan 9, 10:32 pm, Jordi Albornoz Mulligan
<jo...@cambridgesemantics.com> wrote:

> Hi Rolf,
>
> That class is being loaded by Oracle's libaries. I believe those classes
> come with the JDK since version 1.4. However, if they aren't imported by
> the Oracle OSGi package then the Oracle library won't see them.
>
> How did you build the OSGi bundle for the oracle library?
>

> We have instructions here:http://www.openanzo.org/projects/openanzo/wiki/OpenAnzoInstallation31...

[Simon Martin]

Hi Rolf,

Its possible that the old component (before your latest recompile) has been cached by the osgi runtime. If you can delete this cache and restart - the directory relative to the bin directory of the openanzo server is ../conf/cache .

Thanks,

Simon.

[Rolf Bardeli]

Hi Simon, all,

thank you very much for your help. The problem is resolved now. (I
needed to clear the cache and first I removed !org.ietf.jgss
completely instead of removing only "!".)
Unfortunately, I still can't get Open Anzo running. The problem now is
that the database tables can't be found (for the simple reason that
they don't exist).
Is there any script for creating them or does Open Anzo try to create
them automatically?
Please find the list of exceptions below (the Oracle exception is in
German. "Tabelle oder View nicht vorhanden" means "table or view does
not exist").

Rolf

Welcome to OpenAnzo running in Felix.
=========================================

-> 2009-01-13 11:51:21,380 0 [ERROR] [Configuration Updater]

[OpName=] [OpId=] [OpUser=] [RunAs=] [UserDesc=]

org.openanzo.datasource.nodecentric.NodeCentricResetService - Error
unlocking db
org.openanzo.jdbc.utils.RdbException: ErrorCode[256:262181]
[RDB_ERROR] Failed to execute an sql operation:[setInitializing] SQL:
[UPDATE SERVER SET INITIALIZED=0 WHERE INITIALIZED IS NULL] Params:[]
Templates:[] Root Cause: java.sql.SQLException ORA-00942: Tabelle oder
View nicht vorhanden

at
org.openanzo.datasource.nodecentric.sql.ServerRdbWrapper.setInitializing
(ServerRdbWrapper.java:420)
at
org.openanzo.datasource.nodecentric.NodeCentricResetService.lockDB
(NodeCentricResetService.java:247)
at
org.openanzo.datasource.nodecentric.NodeCentricResetService.resetDatabase
(NodeCentricResetService.java:150)
at
org.openanzo.datasource.nodecentric.NodeCentricDatasource.initializeConnection
(NodeCentricDatasource.java:453)
at org.openanzo.datasource.nodecentric.NodeCentricDatasource
$2.makeObject(NodeCentricDatasource.java:404)

at org.apache.commons.pool.impl.GenericObjectPool.borrowObject
(GenericObjectPool.java:974)
at
org.openanzo.datasource.nodecentric.NodeCentricDatasource.getQueryConnection
(NodeCentricDatasource.java:669)
at
org.openanzo.datasource.nodecentric.NodeCentricDatasource.getQueryContext
(NodeCentricDatasource.java:731)
at
org.openanzo.datasource.nodecentric.NodeCentricModelService.getServerUriInternal
(NodeCentricModelService.java:367)
at
org.openanzo.datasource.nodecentric.NodeCentricModelService.start
(NodeCentricModelService.java:75)
at
org.openanzo.datasource.nodecentric.NodeCentricDatasource.<init>
(NodeCentricDatasource.java:238)
at
org.openanzo.datasource.nodecentric.NodeCentricDatasourceFactory.updated
(NodeCentricDatasourceFactory.java:202)
at org.apache.felix.cm.impl.ConfigurationManager
$ManagedServiceFactoryUpdate.run(ConfigurationManager.java:1056)
at org.apache.felix.cm.impl.UpdateThread.run(UpdateThread.java:
90)

Caused by: java.sql.SQLException: ORA-00942: Tabelle oder View nicht
vorhanden

at oracle.jdbc.driver.SQLStateMapping.newSQLException
(SQLStateMapping.java:133)
at oracle.jdbc.driver.DatabaseError.newSQLException
(DatabaseError.java:115)
at oracle.jdbc.driver.DatabaseError.throwSqlException
(DatabaseError.java:221)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:
467)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:
417)
at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:1084)
at oracle.jdbc.driver.T4CPreparedStatement.doOall8
(T4CPreparedStatement.java:215)
at oracle.jdbc.driver.T4CPreparedStatement.executeForRows
(T4CPreparedStatement.java:1243)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout
(OracleStatement.java:1515)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal
(OraclePreparedStatement.java:3874)
at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate
(OraclePreparedStatement.java:4018)
at
oracle.jdbc.driver.OraclePreparedStatementWrapper.executeUpdate
(OraclePreparedStatementWrapper.java:3106)
at
org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate
(DelegatingPreparedStatement.java:102)
at
org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate
(DelegatingPreparedStatement.java:102)
at
org.openanzo.datasource.nodecentric.sql.ServerRdbWrapper.setInitializing
(ServerRdbWrapper.java:416)
... 13 more
2009-01-13 11:51:21,390 10 [ERROR] [Configuration Updater]

[OpName=] [OpId=] [OpUser=] [RunAs=] [UserDesc=]

org.openanzo.datasource.nodecentric.NodeCentricResetService - SQL
Error resetting database tables
org.openanzo.exceptions.AnzoException: ErrorCode[320:262162]
[DATASOURCE_ERROR] [RDB_ERROR] Failed to lock database table:SERVER
at
org.openanzo.datasource.nodecentric.NodeCentricDatasource.lockTable
(NodeCentricDatasource.java:801)
at
org.openanzo.datasource.nodecentric.NodeCentricDatasource.begin
(NodeCentricDatasource.java:885)
at
org.openanzo.datasource.nodecentric.NodeCentricResetService.dropTables
(NodeCentricResetService.java:288)
at
org.openanzo.datasource.nodecentric.NodeCentricResetService.resetDatabaseTables
(NodeCentricResetService.java:180)
at
org.openanzo.datasource.nodecentric.NodeCentricResetService.resetDatabase
(NodeCentricResetService.java:151)
at
org.openanzo.datasource.nodecentric.NodeCentricDatasource.initializeConnection
(NodeCentricDatasource.java:453)
at org.openanzo.datasource.nodecentric.NodeCentricDatasource
$2.makeObject(NodeCentricDatasource.java:404)

at org.apache.commons.pool.impl.GenericObjectPool.borrowObject
(GenericObjectPool.java:974)
at
org.openanzo.datasource.nodecentric.NodeCentricDatasource.getQueryConnection
(NodeCentricDatasource.java:669)
at
org.openanzo.datasource.nodecentric.NodeCentricDatasource.getQueryContext
(NodeCentricDatasource.java:731)
at
org.openanzo.datasource.nodecentric.NodeCentricModelService.getServerUriInternal
(NodeCentricModelService.java:367)
at
org.openanzo.datasource.nodecentric.NodeCentricModelService.start
(NodeCentricModelService.java:75)
at
org.openanzo.datasource.nodecentric.NodeCentricDatasource.<init>
(NodeCentricDatasource.java:238)
at
org.openanzo.datasource.nodecentric.NodeCentricDatasourceFactory.updated
(NodeCentricDatasourceFactory.java:202)
at org.apache.felix.cm.impl.ConfigurationManager
$ManagedServiceFactoryUpdate.run(ConfigurationManager.java:1056)
at org.apache.felix.cm.impl.UpdateThread.run(UpdateThread.java:
90)

Caused by: org.openanzo.jdbc.utils.RdbException: ErrorCode[256:262181]
[RDB_ERROR] Failed to execute an sql operation:[lockTable] SQL:[LOCK
TABLE {0} {1}] Params:[] Templates:[tableName=SERVER,tableLocksExtra=
IN EXCLUSIVE MODE] Root Cause: java.sql.SQLException ORA-00942:
Tabelle oder View nicht vorhanden

at
org.openanzo.datasource.nodecentric.sql.ServerRdbWrapper.lockTable
(ServerRdbWrapper.java:499)
at
org.openanzo.datasource.nodecentric.NodeCentricDatasource.lockTable
(NodeCentricDatasource.java:799)
... 15 more
Caused by: java.sql.SQLException: ORA-00942: Tabelle oder View nicht
vorhanden

at oracle.jdbc.driver.SQLStateMapping.newSQLException
(SQLStateMapping.java:133)
at oracle.jdbc.driver.DatabaseError.newSQLException
(DatabaseError.java:115)
at oracle.jdbc.driver.DatabaseError.throwSqlException
(DatabaseError.java:221)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:
467)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:
417)
at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:1084)
at oracle.jdbc.driver.T4CPreparedStatement.doOall8
(T4CPreparedStatement.java:215)
at oracle.jdbc.driver.T4CPreparedStatement.executeForRows
(T4CPreparedStatement.java:1243)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout
(OracleStatement.java:1515)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal
(OraclePreparedStatement.java:3874)
at oracle.jdbc.driver.OraclePreparedStatement.execute
(OraclePreparedStatement.java:4063)
at oracle.jdbc.driver.OraclePreparedStatementWrapper.execute
(OraclePreparedStatementWrapper.java:3191)
at org.apache.commons.dbcp.DelegatingPreparedStatement.execute
(DelegatingPreparedStatement.java:169)
at org.apache.commons.dbcp.DelegatingPreparedStatement.execute
(DelegatingPreparedStatement.java:169)
at
org.openanzo.datasource.nodecentric.sql.ServerRdbWrapper.lockTable
(ServerRdbWrapper.java:496)
... 16 more
2009-01-13 11:51:21,391 11 [ERROR] [Configuration Updater]

[OpName=] [OpId=] [OpUser=] [RunAs=] [UserDesc=]

org.openanzo.datasource.nodecentric.NodeCentricDatasourceFactory -
Exception follows:
org.openanzo.exceptions.AnzoException: ErrorCode[512:262148]
[INTERNAL_ERROR] Error executing database operation:ErrorCode
[320:262162] [DATASOURCE_ERROR] [RDB_ERROR] Failed to lock database
table:SERVER
at
org.openanzo.datasource.nodecentric.NodeCentricResetService.resetDatabaseTables
(NodeCentricResetService.java:196)
at
org.openanzo.datasource.nodecentric.NodeCentricResetService.resetDatabase
(NodeCentricResetService.java:151)
at
org.openanzo.datasource.nodecentric.NodeCentricDatasource.initializeConnection
(NodeCentricDatasource.java:453)
at org.openanzo.datasource.nodecentric.NodeCentricDatasource
$2.makeObject(NodeCentricDatasource.java:404)

at org.apache.commons.pool.impl.GenericObjectPool.borrowObject
(GenericObjectPool.java:974)
at
org.openanzo.datasource.nodecentric.NodeCentricDatasource.getQueryConnection
(NodeCentricDatasource.java:669)
at
org.openanzo.datasource.nodecentric.NodeCentricDatasource.getQueryContext
(NodeCentricDatasource.java:731)
at
org.openanzo.datasource.nodecentric.NodeCentricModelService.getServerUriInternal
(NodeCentricModelService.java:367)
at
org.openanzo.datasource.nodecentric.NodeCentricModelService.start
(NodeCentricModelService.java:75)
at
org.openanzo.datasource.nodecentric.NodeCentricDatasource.<init>
(NodeCentricDatasource.java:238)
at
org.openanzo.datasource.nodecentric.NodeCentricDatasourceFactory.updated
(NodeCentricDatasourceFactory.java:202)
at org.apache.felix.cm.impl.ConfigurationManager
$ManagedServiceFactoryUpdate.run(ConfigurationManager.java:1056)
at org.apache.felix.cm.impl.UpdateThread.run(UpdateThread.java:
90)

Caused by: org.openanzo.exceptions.AnzoException: ErrorCode
[320:262162] [DATASOURCE_ERROR] [RDB_ERROR] Failed to lock database
table:SERVER
at
org.openanzo.datasource.nodecentric.NodeCentricDatasource.lockTable
(NodeCentricDatasource.java:801)
at
org.openanzo.datasource.nodecentric.NodeCentricDatasource.begin
(NodeCentricDatasource.java:885)
at
org.openanzo.datasource.nodecentric.NodeCentricResetService.dropTables
(NodeCentricResetService.java:288)
at
org.openanzo.datasource.nodecentric.NodeCentricResetService.resetDatabaseTables
(NodeCentricResetService.java:180)
... 12 more
Caused by: org.openanzo.jdbc.utils.RdbException: ErrorCode[256:262181]
[RDB_ERROR] Failed to execute an sql operation:[lockTable] SQL:[LOCK
TABLE {0} {1}] Params:[] Templates:[tableName=SERVER,tableLocksExtra=
IN EXCLUSIVE MODE] Root Cause: java.sql.SQLException ORA-00942:
Tabelle oder View nicht vorhanden

at
org.openanzo.datasource.nodecentric.sql.ServerRdbWrapper.lockTable
(ServerRdbWrapper.java:499)
at
org.openanzo.datasource.nodecentric.NodeCentricDatasource.lockTable
(NodeCentricDatasource.java:799)
... 15 more
Caused by: java.sql.SQLException: ORA-00942: Tabelle oder View nicht
vorhanden

at oracle.jdbc.driver.SQLStateMapping.newSQLException
(SQLStateMapping.java:133)
at oracle.jdbc.driver.DatabaseError.newSQLException
(DatabaseError.java:115)
at oracle.jdbc.driver.DatabaseError.throwSqlException
(DatabaseError.java:221)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:
467)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:
417)
at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:1084)
at oracle.jdbc.driver.T4CPreparedStatement.doOall8
(T4CPreparedStatement.java:215)
at oracle.jdbc.driver.T4CPreparedStatement.executeForRows
(T4CPreparedStatement.java:1243)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout
(OracleStatement.java:1515)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal
(OraclePreparedStatement.java:3874)
at oracle.jdbc.driver.OraclePreparedStatement.execute
(OraclePreparedStatement.java:4063)
at oracle.jdbc.driver.OraclePreparedStatementWrapper.execute
(OraclePreparedStatementWrapper.java:3191)
at org.apache.commons.dbcp.DelegatingPreparedStatement.execute
(DelegatingPreparedStatement.java:169)
at org.apache.commons.dbcp.DelegatingPreparedStatement.execute
(DelegatingPreparedStatement.java:169)
at
org.openanzo.datasource.nodecentric.sql.ServerRdbWrapper.lockTable
(ServerRdbWrapper.java:496)
... 16 more
2009-01-13 11:51:21,393 13 [ERROR] [Configuration Updater]

[OpName=] [OpId=] [OpUser=] [RunAs=] [UserDesc=]
org.apache.felix.configadmin - [org.openanzo.osgi.IStatusProvider,
org.osgi.service.cm.ManagedServiceFactory,
org.openanzo.datasource.nodecentric.NodeCentricDatasourceFactory,
org.openanzo.osgi.ServiceActivator,
org.osgi.service.metatype.MetaTypeProvider]: Unexpected problem
updating configuration

org.openanzo.exceptions.AnzoRuntimeException: ErrorCode[512:262148]
[INTERNAL_ERROR] Error executing database operation:ErrorCode
[320:262162] [DATASOURCE_ERROR] [RDB_ERROR] Failed to lock database
table:SERVER
at
org.openanzo.datasource.nodecentric.NodeCentricDatasourceFactory.updated
(NodeCentricDatasourceFactory.java:217)

at org.apache.felix.cm.impl.ConfigurationManager
$ManagedServiceFactoryUpdate.run(ConfigurationManager.java:1056)
at org.apache.felix.cm.impl.UpdateThread.run(UpdateThread.java:
90)

Caused by: org.openanzo.exceptions.AnzoException: ErrorCode
[512:262148] [INTERNAL_ERROR] Error executing database
operation:ErrorCode[320:262162] [DATASOURCE_ERROR] [RDB_ERROR] Failed
to lock database table:SERVER
at
org.openanzo.datasource.nodecentric.NodeCentricResetService.resetDatabaseTables
(NodeCentricResetService.java:196)
at
org.openanzo.datasource.nodecentric.NodeCentricResetService.resetDatabase
(NodeCentricResetService.java:151)
at
org.openanzo.datasource.nodecentric.NodeCentricDatasource.initializeConnection
(NodeCentricDatasource.java:453)
at org.openanzo.datasource.nodecentric.NodeCentricDatasource
$2.makeObject(NodeCentricDatasource.java:404)

at org.apache.commons.pool.impl.GenericObjectPool.borrowObject
(GenericObjectPool.java:974)
at
org.openanzo.datasource.nodecentric.NodeCentricDatasource.getQueryConnection
(NodeCentricDatasource.java:669)
at
org.openanzo.datasource.nodecentric.NodeCentricDatasource.getQueryContext
(NodeCentricDatasource.java:731)
at
org.openanzo.datasource.nodecentric.NodeCentricModelService.getServerUriInternal
(NodeCentricModelService.java:367)
at
org.openanzo.datasource.nodecentric.NodeCentricModelService.start
(NodeCentricModelService.java:75)
at
org.openanzo.datasource.nodecentric.NodeCentricDatasource.<init>
(NodeCentricDatasource.java:238)
at
org.openanzo.datasource.nodecentric.NodeCentricDatasourceFactory.updated
(NodeCentricDatasourceFactory.java:202)

... 2 more
Caused by: org.openanzo.exceptions.AnzoException: ErrorCode
[320:262162] [DATASOURCE_ERROR] [RDB_ERROR] Failed to lock database
table:SERVER
at
org.openanzo.datasource.nodecentric.NodeCentricDatasource.lockTable
(NodeCentricDatasource.java:801)
at
org.openanzo.datasource.nodecentric.NodeCentricDatasource.begin
(NodeCentricDatasource.java:885)
at
org.openanzo.datasource.nodecentric.NodeCentricResetService.dropTables
(NodeCentricResetService.java:288)
at
org.openanzo.datasource.nodecentric.NodeCentricResetService.resetDatabaseTables
(NodeCentricResetService.java:180)
... 12 more
Caused by: org.openanzo.jdbc.utils.RdbException: ErrorCode[256:262181]
[RDB_ERROR] Failed to execute an sql operation:[lockTable] SQL:[LOCK
TABLE {0} {1}] Params:[] Templates:[tableName=SERVER,tableLocksExtra=
IN EXCLUSIVE MODE] Root Cause: java.sql.SQLException ORA-00942:
Tabelle oder View nicht vorhanden

at
org.openanzo.datasource.nodecentric.sql.ServerRdbWrapper.lockTable
(ServerRdbWrapper.java:499)
at
org.openanzo.datasource.nodecentric.NodeCentricDatasource.lockTable
(NodeCentricDatasource.java:799)
... 15 more
Caused by: java.sql.SQLException: ORA-00942: Tabelle oder View nicht
vorhanden

at oracle.jdbc.driver.SQLStateMapping.newSQLException
(SQLStateMapping.java:133)
at oracle.jdbc.driver.DatabaseError.newSQLException
(DatabaseError.java:115)
at oracle.jdbc.driver.DatabaseError.throwSqlException
(DatabaseError.java:221)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:
467)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:
417)
at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:1084)
at oracle.jdbc.driver.T4CPreparedStatement.doOall8
(T4CPreparedStatement.java:215)
at oracle.jdbc.driver.T4CPreparedStatement.executeForRows
(T4CPreparedStatement.java:1243)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout
(OracleStatement.java:1515)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal
(OraclePreparedStatement.java:3874)
at oracle.jdbc.driver.OraclePreparedStatement.execute
(OraclePreparedStatement.java:4063)
at oracle.jdbc.driver.OraclePreparedStatementWrapper.execute
(OraclePreparedStatementWrapper.java:3191)
at org.apache.commons.dbcp.DelegatingPreparedStatement.execute
(DelegatingPreparedStatement.java:169)
at org.apache.commons.dbcp.DelegatingPreparedStatement.execute
(DelegatingPreparedStatement.java:169)
at
org.openanzo.datasource.nodecentric.sql.ServerRdbWrapper.lockTable
(ServerRdbWrapper.java:496)
... 16 more



On Jan 12, 10:07 pm, Simon Martin <si...@cambridgesemantics.com>
wrote:

[Matt Roy]

Hi Rolf,
The system is designed to create all the tables, views and indexes on
startup, but its possible that this failed due to the previous errors,
which left the tables in an invalid state, ie some created and some not
created. I've attached a script that can be used to get rid of
any of the openanzo tables that might have been created. The script
takes 3 parameters, user,password and database. Hope this helps.

Matt

[Rolf Bardeli]

Hi Matt,

thanks for your idea. Unfortunately it did not help. There don't seem
to be any tables created when running Open Anzo.
Is there any logging of the table creation process so that I could
check if anything goes wrong there?

Rolf

On 13 Jan., 15:34, "Matt Roy" <moose...@gmail.com> wrote:
> Hi Rolf,
> The system is designed to create all the tables, views and indexes on
> startup, but its possible that this failed due to the previous errors,
> which left the tables in an invalid state, ie some created and some not
> created. I've attached a script that can be used to get rid of
> any of the openanzo tables that might have been created. The script
> takes 3 parameters, user,password and database. Hope this helps.
>
> Matt
>
> On Tue, Jan 13, 2009 at 5:02 AM, Rolf Bardeli
>

> ...
>
> Erfahren Sie mehr »
>
> droptables.sql
> 1KAnzeigenHerunterladen
>
> droptables.sh
> < 1 KBAnzeigenHerunterladen

[Matthew Roy]

You can try to turn some more logging on:
update the log4j.properties in the conf/config directory and add
log4j.logger.org.openanzo.datasource.nodecentric.NodeCentricDatasource=DEBUG
log4j.logger.org.openanzo.datasource.nodecentric.NodeCentricResetService=DEBUG
log4j.logger.org.openanzo.jdbc.utils.PreparedStatementProvider=DEBUG

You should probably clear the cache directory as well.

This will turn on a lot of db logging, ie when a lot of the sql
operations are executed.

Matt

[Rolf Bardeli]

Hi Matt,

thanks for the info. I am not sure where the logging should go to but
I cannot find it.
I have edited log4j.properties and deleted the cache.
After starting Open Anzo, there is no change (except for the date) to
the (empty) files stderr and stdout in the var directory and I cannot
find any logging anywhere else.
Anybody got an idea what I am doing wrong or where the logging goes
to?


Rolf

> ...
>
> Erfahren Sie mehr »

[Matthew Roy]

The log4j.properties file is in the conf/config directory. You will
need to remove the conf/cache directory after updating the file.
Starting the server should print out the log entries to the osgi
console.

Matt

[Rolf Bardeli]

Thank you everybody for your help and answers.
The final problem has been a lack of privileges on the Oracle user.
Everything is up and running now.

Thanks,
Rolf

> ...
>
> Erfahren Sie mehr »