Bem-vindo, Visitante
Nome do utilizador: Senha: Memorizar
  • Página:
  • 1
  • 2
  • 3

TÓPICO: Problemas com o motor PostgreSQL

Problemas com o motor PostgreSQL 25 Set. 2016 09:30 #10560

  • gfsilva
  • Avatar de gfsilva
  • Offline
  • Mensagens: 2
Bom dia,

Tenho a versão 10 do Colibri com base de dados do PostreSQL. Pretendia migrar para um novo computador, fiz a instalação do novo programa e PostreSQL 9.6, fiz o restore da base de dados através dos comandos psql.

Ao arrancar o programa, devolve-me um erro relacionado com a tabela MOEDAS que não sei como solucionar e para a qual agradecia a vossa ajuda ("Exception thrown while querying indices for table=MOEDAS"):



Incluo também o log do programa:

!ENTRY org.projectocolibri.rcp 4 0 2016-09-25 00:28:54.598
!MESSAGE 
!STACK 0
javax.jdo.JDODataStoreException: Exception thrown while querying indices for table=MOEDAS
	at org.datanucleus.jdo.NucleusJDOHelper.getJDOExceptionForNucleusException(NucleusJDOHelper.java:319)
	at org.datanucleus.jdo.JDOPersistenceManager.newObjectIdInstance(JDOPersistenceManager.java:1549)
	at org.datanucleus.jdo.JDOPersistenceManager.getObjectById(JDOPersistenceManager.java:1667)
	at org.projectocolibri.rcp.colibri.dao.database.manager.ParametrosManager.load(ParametrosManager.java:129)
	at org.projectocolibri.rcp.colibri.dao.database.ColibriDatabase.loadParametros(ColibriDatabase.java:370)
	at org.projectocolibri.rcp.colibri.dao.database.ColibriDatabase.getParametros(ColibriDatabase.java:126)
	at org.projectocolibri.rcp.colibri.dao.database.ColibriDatabase.populate(ColibriDatabase.java:234)
	at org.projectocolibri.rcp.colibri.dao.database.ColibriDatabase.initialize(ColibriDatabase.java:196)
	at org.projectocolibri.rcp.colibri.dao.database.ColibriLogin.process(ColibriLogin.java:46)
	at org.projectocolibri.rcp.colibri.workbench.shells.login.LoginShell$1.widgetSelected(LoginShell.java:185)
	at org.eclipse.swt.widgets.TypedListener.handleEvent(TypedListener.java:248)
	at org.eclipse.swt.widgets.EventTable.sendEvent(EventTable.java:84)
	at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:1053)
	at org.eclipse.swt.widgets.Display.runDeferredEvents(Display.java:4169)
	at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:3758)
	at org.dma.eclipse.swt.custom.CustomShell.openAndSleep(CustomShell.java:53)
	at org.projectocolibri.rcp.colibri.workbench.shells.login.LoginShell.<init>(LoginShell.java:82)
	at org.projectocolibri.rcp.Application.start(Application.java:41)
	at org.eclipse.equinox.internal.app.EclipseAppHandle.run(EclipseAppHandle.java:196)
	at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.runApplication(EclipseAppLauncher.java:110)
	at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.start(EclipseAppLauncher.java:79)
	at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:353)
	at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:180)
	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:629)
	at org.eclipse.equinox.launcher.Main.basicRun(Main.java:584)
	at org.eclipse.equinox.launcher.Main.run(Main.java:1438)
NestedThrowablesStackTrace:
org.postgresql.util.PSQLException: ERROR: column am.amcanorder does not exist
  Position: 407
	at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2161)
	at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1890)
	at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:255)
	at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:559)
	at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:403)
	at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:283)
	at org.postgresql.jdbc2.AbstractJdbc2DatabaseMetaData.getIndexInfo(AbstractJdbc2DatabaseMetaData.java:4234)
	at org.datanucleus.store.rdbms.schema.RDBMSSchemaHandler.getRDBMSTableIndexInfoForTable(RDBMSSchemaHandler.java:616)
	at org.datanucleus.store.rdbms.schema.RDBMSSchemaHandler.getRDBMSTableIndexInfoForTable(RDBMSSchemaHandler.java:585)
	at org.datanucleus.store.rdbms.schema.RDBMSSchemaHandler.getSchemaData(RDBMSSchemaHandler.java:202)
	at org.datanucleus.store.rdbms.table.TableImpl.getExistingCandidateKeys(TableImpl.java:1099)
	at org.datanucleus.store.rdbms.table.TableImpl.validateCandidateKeys(TableImpl.java:698)
	at org.datanucleus.store.rdbms.table.TableImpl.validateConstraints(TableImpl.java:400)
	at org.datanucleus.store.rdbms.table.ClassTable.validateConstraints(ClassTable.java:3298)
	at org.datanucleus.store.rdbms.RDBMSStoreManager$ClassAdder.performTablesValidation(RDBMSStoreManager.java:2777)
	at org.datanucleus.store.rdbms.RDBMSStoreManager$ClassAdder.addClassTablesAndValidate(RDBMSStoreManager.java:2507)
	at org.datanucleus.store.rdbms.RDBMSStoreManager$ClassAdder.run(RDBMSStoreManager.java:2152)
	at org.datanucleus.store.rdbms.AbstractSchemaTransaction.execute(AbstractSchemaTransaction.java:113)
	at org.datanucleus.store.rdbms.RDBMSStoreManager.addClasses(RDBMSStoreManager.java:987)
	at org.datanucleus.store.rdbms.RDBMSStoreManager.addClasses(RDBMSStoreManager.java:953)
	at org.datanucleus.store.AbstractStoreManager.addClass(AbstractStoreManager.java:914)
	at org.datanucleus.ObjectManagerImpl.newObjectId(ObjectManagerImpl.java:2849)
	at org.datanucleus.jdo.JDOPersistenceManager.newObjectIdInstance(JDOPersistenceManager.java:1545)
	at org.datanucleus.jdo.JDOPersistenceManager.getObjectById(JDOPersistenceManager.java:1667)
	at org.projectocolibri.rcp.colibri.dao.database.manager.ParametrosManager.load(ParametrosManager.java:129)
	at org.projectocolibri.rcp.colibri.dao.database.ColibriDatabase.loadParametros(ColibriDatabase.java:370)
	at org.projectocolibri.rcp.colibri.dao.database.ColibriDatabase.getParametros(ColibriDatabase.java:126)
	at org.projectocolibri.rcp.colibri.dao.database.ColibriDatabase.populate(ColibriDatabase.java:234)
	at org.projectocolibri.rcp.colibri.dao.database.ColibriDatabase.initialize(ColibriDatabase.java:196)
	at org.projectocolibri.rcp.colibri.dao.database.ColibriLogin.process(ColibriLogin.java:46)
	at org.projectocolibri.rcp.colibri.workbench.shells.login.LoginShell$1.widgetSelected(LoginShell.java:185)
	at org.eclipse.swt.widgets.TypedListener.handleEvent(TypedListener.java:248)
	at org.eclipse.swt.widgets.EventTable.sendEvent(EventTable.java:84)
	at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:1053)
	at org.eclipse.swt.widgets.Display.runDeferredEvents(Display.java:4169)
	at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:3758)
	at org.dma.eclipse.swt.custom.CustomShell.openAndSleep(CustomShell.java:53)
	at org.projectocolibri.rcp.colibri.workbench.shells.login.LoginShell.<init>(LoginShell.java:82)
	at org.projectocolibri.rcp.Application.start(Application.java:41)
	at org.eclipse.equinox.internal.app.EclipseAppHandle.run(EclipseAppHandle.java:196)
	at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.runApplication(EclipseAppLauncher.java:110)
	at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.start(EclipseAppLauncher.java:79)
	at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:353)
	at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:180)
	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:629)
	at org.eclipse.equinox.launcher.Main.basicRun(Main.java:584)
	at org.eclipse.equinox.launcher.Main.run(Main.java:1438)

Obrigado pela ajuda e parabéns pela qualidade do programa.
O adminstrador desactivou a escrita pública.
  • Página:
  • 1
  • 2
  • 3
Moderadores: marcolopes
Desenvolvido por Kunena