Some Eclipse Foundation services are deprecated, or will be soon. Please ensure you've read this important communication.

Bug 316744

Summary: Exception when trying to initialise the demo database on 0.9.4
Product: [Technology] OSEE Reporter: Mark D-B <mark.db>
Component: OSEE Application FrameworkAssignee: Project Inbox <osee.framework-inbox>
Status: CLOSED INVALID QA Contact:
Severity: major    
Priority: P3    
Version: 0.9.4   
Target Milestone: 0.9.5   
Hardware: All   
OS: All   
See Also: https://bugs.eclipse.org/bugs/show_bug.cgi?id=316743
Whiteboard:

Description Mark D-B CLA 2010-06-14 06:44:50 EDT
1. Initialise an empty database
2. Start the 0.9.4 application server (postgresql version)
3. Change to the directory in which the 0.9.4 client is installed
4. eclipse -nosplash -application
org.eclipse.osee.framework.database.init.configClient -console -vmargs
-XX:MaxPermSize=256m -Xmx512m -Dosee.application.server=http://localhost:8089

The script runs as far as asking which initialisation type to run, but does not
accept 0 (see linked bug). 1 is accepted, but gets an exception and then gets
stuck(see below).

osgi> 1
Adding Schema: [support/COVERAGE.SCHEMA.xml]
Adding Schema: [dbschemas/SKYNET.VERSIONING.SCHEMA.xml]
Drop Indices
Database Configuration completed in [0:01:08.656] ms
Mon Jun 14 11:33:00 BST 2010      org.eclipse.osee.framework.skynet.core.interna
l.Activator
SEVERE   org.eclipse.osee.framework.skynet.core.event.RemoteEventManager   check
JiniRegistration (113)
ERROR: relation "osee_artifact" does not exist
org.eclipse.osee.framework.core.exception.OseeDataStoreException: ERROR: relatio
n "osee_artifact" does not exist
        at org.eclipse.osee.framework.database.internal.core.OseeStatementImpl.r
unPreparedQuery(OseeStatementImpl.java:88)
        at org.eclipse.osee.framework.database.internal.core.OseeDatabaseService
Impl.runPreparedQueryFetchObject(OseeDatabaseServiceImpl.java:203)
        at org.eclipse.osee.framework.database.internal.core.OseeDatabaseService
Impl.runPreparedQueryFetchObject(OseeDatabaseServiceImpl.java:187)
        at org.eclipse.osee.framework.database.core.ConnectionHandler.runPrepare
dQueryFetchLong(ConnectionHandler.java:148)
        at org.eclipse.osee.framework.skynet.core.artifact.Artifact.isUniqueHRID
(Artifact.java:1449)
        at org.eclipse.osee.framework.skynet.core.artifact.Artifact.populateHuma
nReadableID(Artifact.java:1443)
        at org.eclipse.osee.framework.skynet.core.artifact.Artifact.<init>(Artif
act.java:128)
        at org.eclipse.osee.framework.skynet.core.User.<init>(User.java:44)
        at org.eclipse.osee.framework.skynet.core.BootStrapUser.<init>(BootStrap
User.java:32)
        at org.eclipse.osee.framework.skynet.core.BootStrapUser.getInstance(Boot
StrapUser.java:41)
        at org.eclipse.osee.framework.skynet.core.ClientUser.populateCurrentUser
(ClientUser.java:65)
        at org.eclipse.osee.framework.skynet.core.ClientUser.getMainUser(ClientU
ser.java:50)
        at org.eclipse.osee.framework.skynet.core.UserManager.getUser(UserManage
r.java:62)
        at org.eclipse.osee.framework.skynet.core.event.RemoteEventManager.check
JiniRegistration(RemoteEventManager.java:107)
        at org.eclipse.osee.framework.skynet.core.event.RemoteEventManager.<init
>(RemoteEventManager.java:100)
        at org.eclipse.osee.framework.skynet.core.event.RemoteEventManager.<clin
it>(RemoteEventManager.java:90)
        at org.eclipse.osee.framework.skynet.core.internal.Activator.stop(Activa
tor.java:71)
        at org.eclipse.osgi.framework.internal.core.BundleContextImpl$2.run(Bund
leContextImpl.java:843)
        at java.security.AccessController.doPrivileged(Native Method)
        at org.eclipse.osgi.framework.internal.core.BundleContextImpl.stop(Bundl
eContextImpl.java:836)
        at org.eclipse.osgi.framework.internal.core.BundleHost.stopWorker(Bundle
Host.java:474)
        at org.eclipse.osgi.framework.internal.core.AbstractBundle.suspend(Abstr
actBundle.java:546)
        at org.eclipse.osgi.framework.internal.core.Framework.suspendBundle(Fram
ework.java:1098)
        at org.eclipse.osgi.framework.internal.core.StartLevelManager.decFWSL(St
artLevelManager.java:593)
        at org.eclipse.osgi.framework.internal.core.StartLevelManager.doSetStart
Level(StartLevelManager.java:261)
        at org.eclipse.osgi.framework.internal.core.StartLevelManager.shutdown(S
tartLevelManager.java:216)
        at org.eclipse.osgi.framework.internal.core.InternalSystemBundle.suspend
(InternalSystemBundle.java:266)
        at org.eclipse.osgi.framework.internal.core.Framework.shutdown(Framework
.java:685)
        at org.eclipse.osgi.framework.internal.core.Framework.close(Framework.ja
va:583)
        at org.eclipse.core.runtime.adaptor.EclipseStarter.shutdown(EclipseStart
er.java:409)
        at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.ja
va:200)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
        at java.lang.reflect.Method.invoke(Unknown Source)
        at org.eclipse.equinox.launcher.Main.invokeFramework(Main.java:559)
        at org.eclipse.equinox.launcher.Main.basicRun(Main.java:514)
        at org.eclipse.equinox.launcher.Main.run(Main.java:1311)
Caused by: org.postgresql.util.PSQLException: ERROR: relation "osee_artifact" do
es not exist
        at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryEx
ecutorImpl.java:1608)
        at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutor
Impl.java:1343)
        at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.ja
va:194)
        at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Stat
ement.java:451)
        at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(Abstract
Jdbc2Statement.java:350)
        at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc
2Statement.java:254)
        at org.eclipse.osee.framework.database.internal.core.OseeStatementImpl.r
unPreparedQuery(OseeStatementImpl.java:86)
        ... 37 more
Comment 1 Mark D-B CLA 2010-06-14 06:55:55 EDT
Sorry guys, this was my fault - I forgot to create the osee schema in the empty database.