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

Bug 369046

Summary:	Osee_type_id_map does not exist error
Product:	[Technology] OSEE	Reporter:	Vikas K <vikas.kuswaha>
Component:	Action Tracking System (ATS)	Assignee:	Project Inbox <osee.ats-inbox>
Status:	CLOSED INVALID	QA Contact:
Severity:	normal
Priority:	P3	CC:	donald.g.dunne, misinco
Version:	unspecified
Target Milestone:	0.9.9
Hardware:	All
OS:	All
Whiteboard:

Description Vikas K

2012-01-19 04:30:28 EST

We are often getting the error "Osee_type_map_id does not exist".
Once we get the above error, we need to start osee server as well as server machine several times.
We tried reload Cache also on server side but not able to conclude the reason why this error happens?

Comment 1 Vikas K

2012-01-19 05:01:20 EST

Error:

ERROR: relation "osee_type_id_map" does not exist
  ERROR: relation "osee_type_id_map" does not exist
  ERROR: relation "osee_type_id_map" does not exist
  org.eclipse.osee.framework.core.exception.OseeExceptions.wrapAndThrow(OseeExceptions.java:28)
  org.eclipse.osee.framework.database.internal.core.OseeStatementImpl.runPreparedQuery(OseeStatementImpl.java:90)
  org.eclipse.osee.framework.database.internal.core.IdentityServiceImpl.reloadCache(IdentityServiceImpl.java:73)
  org.eclipse.osee.framework.database.internal.core.IdentityServiceImpl.getLocalId(IdentityServiceImpl.java:47)
  org.eclipse.osee.framework.database.internal.core.IdentityServiceImpl.getLocalId(IdentityServiceImpl.java:121)
  org.eclipse.osee.framework.skynet.core.artifact.search.ArtifactQueryBuilder.getArtifactSelectSql(ArtifactQueryBuilder.java:298)
  org.eclipse.osee.framework.skynet.core.artifact.search.ArtifactQueryBuilder.internalGetArtifacts(ArtifactQueryBuilder.java:525)
  org.eclipse.osee.framework.skynet.core.artifact.search.ArtifactQueryBuilder.getArtifacts(ArtifactQueryBuilder.java:497)
  org.eclipse.osee.framework.skynet.core.artifact.search.ArtifactQuery.getArtifactListFromType(ArtifactQuery.java:316)
  org.eclipse.osee.framework.skynet.core.UserManager.ensurePopulated(UserManager.java:230)
  org.eclipse.osee.framework.skynet.core.UserManager.getUserByUserId(UserManager.java:213)
  org.eclipse.osee.framework.skynet.core.ClientUser.populateCurrentUser(ClientUser.java:83)
  org.eclipse.osee.framework.skynet.core.ClientUser.getMainUser(ClientUser.java:51)
  org.eclipse.osee.framework.skynet.core.UserManager.getUser(UserManager.java:64)
  org.eclipse.osee.framework.ui.skynet.ArtifactExplorer.createPartControl(ArtifactExplorer.java:282)
  org.eclipse.ui.internal.ViewReference.createPartHelper(ViewReference.java:375)
  org.eclipse.ui.internal.ViewReference.createPart(ViewReference.java:229)
  org.eclipse.ui.internal.WorkbenchPartReference.getPart(WorkbenchPartReference.java:595)
  org.eclipse.ui.internal.PartPane.setVisible(PartPane.java:313)
  org.eclipse.ui.internal.ViewPane.setVisible(ViewPane.java:534)
  org.eclipse.ui.internal.presentations.PresentablePart.setVisible(PresentablePart.java:180)
  org.eclipse.ui.internal.presentations.util.PresentablePartFolder.select(PresentablePartFolder.java:270)
  org.eclipse.ui.internal.presentations.util.LeftToRightTabOrder.select(LeftToRightTabOrder.java:65)
  org.eclipse.ui.internal.presentations.util.TabbedStackPresentation.selectPart(TabbedStackPresentation.java:473)
  org.eclipse.ui.internal.PartStack.refreshPresentationSelection(PartStack.java:1245)
  org.eclipse.ui.internal.PartStack.createControl(PartStack.java:662)
  org.eclipse.ui.internal.PartStack.createControl(PartStack.java:570)
  org.eclipse.ui.internal.PartSashContainer.createControl(PartSashContainer.java:568)
  org.eclipse.ui.internal.PerspectiveHelper.activate(PerspectiveHelper.java:272)
  org.eclipse.ui.internal.Perspective.onActivate(Perspective.java:981)
  org.eclipse.ui.internal.WorkbenchPage.onActivate(WorkbenchPage.java:2714)
  org.eclipse.ui.internal.WorkbenchWindow$27.run(WorkbenchWindow.java:3023)
  org.eclipse.swt.custom.BusyIndicator.showWhile(BusyIndicator.java:70)
  org.eclipse.ui.internal.WorkbenchWindow.setActivePage(WorkbenchWindow.java:3004)
  org.eclipse.ui.internal.WorkbenchWindow$20.runWithException(WorkbenchWindow.java:2290)
  org.eclipse.ui.internal.StartupThreading$StartupRunnable.run(StartupThreading.java:31)
  org.eclipse.swt.widgets.RunnableLock.run(RunnableLock.java:35)
  org.eclipse.swt.widgets.Synchronizer.runAsyncMessages(Synchronizer.java:135)
  org.eclipse.swt.widgets.Display.runAsyncMessages(Display.java:4140)
  org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:3757)
  org.eclipse.ui.application.WorkbenchAdvisor.openWindows(WorkbenchAdvisor.java:803)
  org.eclipse.ui.internal.Workbench$33.runWithException(Workbench.java:1595)
  org.eclipse.ui.internal.StartupThreading$StartupRunnable.run(StartupThreading.java:31)
  org.eclipse.swt.widgets.RunnableLock.run(RunnableLock.java:35)
  org.eclipse.swt.widgets.Synchronizer.runAsyncMessages(Synchronizer.java:135)
  org.eclipse.swt.widgets.Display.runAsyncMessages(Display.java:4140)
  org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:3757)
  org.eclipse.ui.internal.Workbench.runUI(Workbench.java:2604)
  org.eclipse.ui.internal.Workbench.access$4(Workbench.java:2494)
  org.eclipse.ui.internal.Workbench$7.run(Workbench.java:674)
  org.eclipse.core.databinding.observable.Realm.runWithDefault(Realm.java:332)
  org.eclipse.ui.internal.Workbench.createAndRunWorkbench(Workbench.java:667)
  org.eclipse.ui.PlatformUI.createAndRunWorkbench(PlatformUI.java:149)
  org.eclipse.ui.internal.ide.application.IDEApplication.start(IDEApplication.java:123)
  org.eclipse.equinox.internal.app.EclipseAppHandle.run(EclipseAppHandle.java:196)
  org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.runApplication(EclipseAppLauncher.java:110)
  org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.start(EclipseAppLauncher.java:79)
  org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:344)
  org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:179)
  sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
  sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
  java.lang.reflect.Method.invoke(Unknown Source)
  org.eclipse.equinox.launcher.Main.invokeFramework(Main.java:622)
  org.eclipse.equinox.launcher.Main.basicRun(Main.java:577)
  org.eclipse.equinox.launcher.Main.run(Main.java:1410)
     caused by 
  ERROR: relation "osee_type_id_map" does not exist
  org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1608)
  org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1343)
  org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:194)
  org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:451)
  org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:350)
  org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:254)
  org.eclipse.osee.framework.database.internal.core.OseeStatementImpl.runPreparedQuery(OseeStatementImpl.java:88)
  org.eclipse.osee.framework.database.internal.core.IdentityServiceImpl.reloadCache(IdentityServiceImpl.java:73)
  org.eclipse.osee.framework.database.internal.core.IdentityServiceImpl.getLocalId(IdentityServiceImpl.java:47)
  org.eclipse.osee.framework.database.internal.core.IdentityServiceImpl.getLocalId(IdentityServiceImpl.java:121)
  org.eclipse.osee.framework.skynet.core.artifact.search.ArtifactQueryBuilder.getArtifactSelectSql(ArtifactQueryBuilder.java:298)
  org.eclipse.osee.framework.skynet.core.artifact.search.ArtifactQueryBuilder.internalGetArtifacts(ArtifactQueryBuilder.java:525)
  org.eclipse.osee.framework.skynet.core.artifact.search.ArtifactQueryBuilder.getArtifacts(ArtifactQueryBuilder.java:497)
  org.eclipse.osee.framework.skynet.core.artifact.search.ArtifactQuery.getArtifactListFromType(ArtifactQuery.java:316)
  org.eclipse.osee.framework.skynet.core.UserManager.ensurePopulated(UserManager.java:230)
  org.eclipse.osee.framework.skynet.core.UserManager.getUserByUserId(UserManager.java:213)
  org.eclipse.osee.framework.skynet.core.ClientUser.populateCurrentUser(ClientUser.java:83)
  org.eclipse.osee.framework.skynet.core.ClientUser.getMainUser(ClientUser.java:51)
  org.eclipse.osee.framework.skynet.core.UserManager.getUser(UserManager.java:64)
  org.eclipse.osee.framework.ui.skynet.ArtifactExplorer.createPartControl(ArtifactExplorer.java:282)
  org.eclipse.ui.internal.ViewReference.createPartHelper(ViewReference.java:375)
  org.eclipse.ui.internal.ViewReference.createPart(ViewReference.java:229)
  org.eclipse.ui.internal.WorkbenchPartReference.getPart(WorkbenchPartReference.java:595)
  org.eclipse.ui.internal.PartPane.setVisible(PartPane.java:313)
  org.eclipse.ui.internal.ViewPane.setVisible(ViewPane.java:534)
  org.eclipse.ui.internal.presentations.PresentablePart.setVisible(PresentablePart.java:180)
  org.eclipse.ui.internal.presentations.util.PresentablePartFolder.select(PresentablePartFolder.java:270)
  org.eclipse.ui.internal.presentations.util.LeftToRightTabOrder.select(LeftToRightTabOrder.java:65)
  org.eclipse.ui.internal.presentations.util.TabbedStackPresentation.selectPart(TabbedStackPresentation.java:473)
  org.eclipse.ui.internal.PartStack.refreshPresentationSelection(PartStack.java:1245)
  org.eclipse.ui.internal.PartStack.createControl(PartStack.java:662)
  org.eclipse.ui.internal.PartStack.createControl(PartStack.java:570)
  org.eclipse.ui.internal.PartSashContainer.createControl(PartSashContainer.java:568)
  org.eclipse.ui.internal.PerspectiveHelper.activate(PerspectiveHelper.java:272)
  org.eclipse.ui.internal.Perspective.onActivate(Perspective.java:981)
  org.eclipse.ui.internal.WorkbenchPage.onActivate(WorkbenchPage.java:2714)
  org.eclipse.ui.internal.WorkbenchWindow$27.run(WorkbenchWindow.java:3023)
  org.eclipse.swt.custom.BusyIndicator.showWhile(BusyIndicator.java:70)
  org.eclipse.ui.internal.WorkbenchWindow.setActivePage(WorkbenchWindow.java:3004)
  org.eclipse.ui.internal.WorkbenchWindow$20.runWithException(WorkbenchWindow.java:2290)
  org.eclipse.ui.internal.StartupThreading$StartupRunnable.run(StartupThreading.java:31)
  org.eclipse.swt.widgets.RunnableLock.run(RunnableLock.java:35)
  org.eclipse.swt.widgets.Synchronizer.runAsyncMessages(Synchronizer.java:135)
  org.eclipse.swt.widgets.Display.runAsyncMessages(Display.java:4140)
  org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:3757)
  org.eclipse.ui.application.WorkbenchAdvisor.openWindows(WorkbenchAdvisor.java:803)
  org.eclipse.ui.internal.Workbench$33.runWithException(Workbench.java:1595)
  org.eclipse.ui.internal.StartupThreading$StartupRunnable.run(StartupThreading.java:31)
  org.eclipse.swt.widgets.RunnableLock.run(RunnableLock.java:35)
  org.eclipse.swt.widgets.Synchronizer.runAsyncMessages(Synchronizer.java:135)
  org.eclipse.swt.widgets.Display.runAsyncMessages(Display.java:4140)
  org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:3757)
  org.eclipse.ui.internal.Workbench.runUI(Workbench.java:2604)
  org.eclipse.ui.internal.Workbench.access$4(Workbench.java:2494)
  org.eclipse.ui.internal.Workbench$7.run(Workbench.java:674)
  org.eclipse.core.databinding.observable.Realm.runWithDefault(Realm.java:332)
  org.eclipse.ui.internal.Workbench.createAndRunWorkbench(Workbench.java:667)
  org.eclipse.ui.PlatformUI.createAndRunWorkbench(PlatformUI.java:149)
  org.eclipse.ui.internal.ide.application.IDEApplication.start(IDEApplication.java:123)
  org.eclipse.equinox.internal.app.EclipseAppHandle.run(EclipseAppHandle.java:196)
  org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.runApplication(EclipseAppLauncher.java:110)
  org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.start(EclipseAppLauncher.java:79)
  org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:344)
  org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:179)
  sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
  sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
  java.lang.reflect.Method.invoke(Unknown Source)
  org.eclipse.equinox.launcher.Main.invokeFramework(Main.java:622)
  org.eclipse.equinox.launcher.Main.basicRun(Main.java:577)
  org.eclipse.equinox.launcher.Main.run(Main.java:1410)

Comment 2 John Misinco

2012-03-16 13:21:30 EDT

Is this still an issue?  It appears that you are trying to use a new version of OSEE with an older database schema.  A new dbInit should solve this.

Comment 3 Donald Dunne

2013-04-23 12:27:36 EDT

It appears that you are trying to use a new version of OSEE with an older database schema.  A new dbInit should solve this.