Some Eclipse Foundation services are deprecated, or will be soon. Please ensure you've read this important communication.
Bug 369046 - Osee_type_id_map does not exist error
Summary: Osee_type_id_map does not exist error
Status: CLOSED INVALID
Alias: None
Product: OSEE
Classification: Technology
Component: Action Tracking System (ATS) (show other bugs)
Version: unspecified   Edit
Hardware: All All
: P3 normal (vote)
Target Milestone: 0.9.9   Edit
Assignee: Project Inbox CLA
QA Contact:
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2012-01-19 04:30 EST by Vikas K CLA
Modified: 2013-04-23 12:27 EDT (History)
2 users (show)

See Also:

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description Vikas K CLA 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 CLA 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 CLA 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 CLA 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.