Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0006969Openbravo ERPA. Platformpublic2009-01-19 09:252009-03-06 12:34
Reportermtaal 
Assigned Tomtaal 
PrioritynormalSeveritymajorReproducibilityhave not tried
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Versionpi 
Target VersionpiFixed in Version 
Merge Request Status
Review Assigned To
OBNetwork customerNo
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0006969: Column id does not exist when rebuilding system during install of a module
DescriptionI get this exception when installing a new module:
Caused by: org.postgresql.util.PSQLException: ERROR: column "id" does not exist
at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1548)
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1316)
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:191)
at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:452)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:351)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:255)
at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:186)
at org.hibernate.loader.Loader.getResultSet(Loader.java:1787)
at org.hibernate.loader.Loader.doQuery(Loader.java:674)
at org.hibernate.loader.Loader.doQueryAnd InitializeNonLazyCollections(Loader.java:236)
at org.hibernate.loader.Loader.doList(Loader.java:2220)
... 81 more
--- Nested Exception ---
org.hibernate.exception.SQLGrammarException: could not execute query
at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:67)
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
at org.hibernate.loader.Loader.doList(Loader.java:2223)
at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2104)
at org.hibernate.loader.Loader.list(Loader.java:2099)
at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:378)
at org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:338)
at org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:172)
at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1121)
at org.hibernate.impl.QueryImpl.list(QueryImpl.java:79)
at org.openbravo.dal.service.OBQuery.list(OBQuery.java:71)
at org.openbravo.service.db.DataSetService.getExportableObjects(DataSetService.java:241)
at org.openbravo.service.db.DataSetService.getExportableObjects(DataSetService.java:174)
at org.apache.ddlutils.alteration.DataComparator.compareUsingDALToUpdate(DataComparator.java:269)
at org.openbravo.ddlutils.task.AlterDatabaseDataMod.doExecute(AlterDatabaseDataMod.java:234)
at org.openbravo.dal.core.DalInitializingTask.execute(DalInitializingTask.java:121)
at org.openbravo.ddlutils.task.BaseDalInitializingTask.execute(BaseDalInitializingTask.java:80)
at org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:288)
at sun.reflect.GeneratedMethodAccessor117.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at org.apache.tools.ant.dispatch.DispatchUtils.execute(DispatchUtils.java:106)
at org.apache.tools.ant.Task.perform(Task.java:348)
at org.apache.tools.ant.Target.execute(Target.java:357)
at org.apache.tools.ant.Target.performTasks(Target.java:385)
at org.apache.tools.ant.Project.executeSortedTargets(Project.java:1337)
at org.apache.tools.ant.helper.SingleCheckExecutor.executeTargets(SingleCheckExecutor.java:38)
at org.apache.tools.ant.Project.executeTargets(Project.java:1189)
at org.apache.tools.ant.taskdefs.Ant.execute(Ant.java:416)
at org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:288)
at sun.reflect.GeneratedMethodAccessor117.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at org.apache.tools.ant.dispatch.DispatchUtils.execute(DispatchUtils.java:106)
at org.apache.tools.ant.Task.perform(Task.java:348)
at org.apache.tools.ant.Target.execute(Target.java:357)
at org.apache.tools.ant.Target.performTasks(Target.java:385)
at org.apache.tools.ant.Project.executeSortedTargets(Project.java:1337)
at org.apache.tools.ant.helper.SingleCheckExecutor.executeTargets(SingleCheckExecutor.java:38)
at org.apache.tools.ant.Project.executeTargets(Project.java:1189)
at org.apache.tools.ant.taskdefs.Ant.execute(Ant.java:416)
at org.apache.tools.ant.taskdefs.CallTarget.execute(CallTarget.java:105)
at org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:288)
at sun.reflect.GeneratedMethodAccessor117.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at org.apache.tools.ant.dispatch.DispatchUtils.execute(DispatchUtils.java:106)
at org.apache.tools.ant.Task.perform(Task.java:348)
at org.apache.tools.ant.Target.execute(Target.java:357)
at org.apache.tools.ant.Target.performTasks(Target.java:385)
at org.apache.tools.ant.Project.executeSortedTargets(Project.java:1337)
at org.apache.tools.ant.Project.executeTarget(Project.java:1306)
at org.apache.tools.ant.helper.DefaultExecutor.executeTargets(DefaultExecutor.java:41)
at org.apache.tools.ant.Project.executeTargets(Project.java:1189)
at org.openbravo.erpCommon.utility.AntExecutor.runTask(AntExecutor.java:228)
at org.openbravo.erpCommon.ad_process.ApplyModules.startApply(ApplyModules.java:255)
at org.openbravo.erpCommon.ad_process.ApplyModules.doPost(ApplyModules.java:63)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:710)
at org.openbravo.base.HttpBaseServlet.serviceInitialized(HttpBaseServlet.java:245)
at org.openbravo.base.secureApp.HttpSecureAppServlet.service(HttpSecureAppServlet.java:383)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
Steps To Reproduce
Proposed Solution
Additional Information
TagsModularity
Relationships
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2009-01-19 09:25mtaalNew Issue
2009-01-19 09:25mtaalAssigned To => mtaal
2009-01-19 09:25mtaalsf_bug_id0 => 2519085
2009-01-19 09:25mtaalOBNetwork customer => No
2009-01-19 09:25mtaalRegression testing => No
2009-01-19 11:56svnbotCheckin
2009-01-19 11:56svnbotNote Added: 0012317
2009-01-19 11:56svnbotStatusnew => resolved
2009-01-19 11:56svnbotResolutionopen => fixed
2009-01-19 11:56svnbotsvn_revision => 11994
2009-01-19 12:41psarobeTag Attached: Modularity
2009-03-06 12:34psarobeStatusresolved => closed

Notes
(0012317)
svnbot   
2009-01-19 11:56   
Repository: openbravo
Revision: 11994
Author: mtaal
Date: 2009-01-19 11:56:08 +0100 (Mon, 19 Jan 2009)

Fixes issue 6969, rebuild system/export.sample.data resulted in exception id column not found

---
U trunk/referencedata/sampledata/Accounting_Test.xml
U trunk/referencedata/sampledata/BigBazaar.xml
U trunk/src/org/openbravo/service/db/DataExportService.java
U trunk/src/org/openbravo/service/db/DataSetService.java
---

https://dev.openbravo.com/websvn/openbravo/?rev=11994&sc=1 [^]