Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0020171Openbravo ERP01. General setuppublic2012-03-31 14:402012-07-09 16:28
Reportermarkhsu 
Assigned Togorka_gil 
PrioritynormalSeverityminorReproducibilityalways
StatusclosedResolutionunable to reproduce 
PlatformOS10OS VersionXP SP3
Product Version3.0MP8.1 
Target VersionFixed in Version 
Merge Request Status
Review Assigned To
OBNetwork customer
Web browserGoogle Chrome
ModulesOpenbravo 3.0
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0020171: Installation problem
DescriptionSystem complained following message after submit command "ant install.source":
-------------------------------------------------------------------------------
ADD CONSTRAINT AD_AUXILIARINPUT_AD_MODULE FOREIGN KEY (AD_MODULE_ID) REFERENCES AD_MODULE (AD_MODULE_ID)
[createdatabase] at org.apache.ddlutils.platform.PlatformImplBase.evaluateBatch(PlatformImplBase.java:366)
[createdatabase] at org.apache.ddlutils.platform.postgresql.PostgreSqlPlatform.enableAllFK(PostgreSqlPlatform.java:307)
[createdatabase] ... 44 more
[createdatabase] Caused by: org.postgresql.util.PSQLException: ERROR: insert or update on table "ad_auxiliarinput" violates foreign key constraint "ad_auxiliarinput_ad_module"
[createdatabase] Detail：Key (ad_module_id)=(9BA0836A3CD74EE4AB48753A47211BCC) is not present in table "ad_module".
[createdatabase] at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2102)
[createdatabase] at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1835)
[createdatabase] at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257)
[createdatabase] at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:500)
[createdatabase] at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:374)
[createdatabase] at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:366)
[createdatabase] at org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStatement.java:264)
[createdatabase] at org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStatement.java:264)
[createdatabase] at org.apache.ddlutils.platform.PlatformImplBase.evaluateBatch(PlatformImplBase.java:333)
[createdatabase] ... 45 more

Steps To Reproduceant install.source
Proposed Solution
Additional Information
TagsVMA-Reviewed
Relationships
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2012-03-31 14:40markhsuNew Issue
2012-03-31 14:40markhsuAssigned To => vmromanos
2012-03-31 14:40markhsuWeb browser => Google Chrome
2012-03-31 14:40markhsuModules => Openbravo 3.0
2012-04-02 04:26markhsuNote Added: 0047082
2012-04-11 11:20vmromanosAssigned Tovmromanos => gorka_gil
2012-04-11 11:21vmromanosTag Attached: VMA-Reviewed
2012-04-11 12:05gorka_gilNote Added: 0047471
2012-04-11 12:05gorka_gilStatusnew => feedback
2012-07-09 16:28shuehnerNote Added: 0050398
2012-07-09 16:28shuehnerStatusfeedback => closed
2012-07-09 16:28shuehnerResolutionopen => unable to reproduce

Notes
(0047082)
markhsu   
2012-04-02 04:26   
This problem only happened on tar ball.
Murcurial clone has no such problem.

Mark
(0047471)
gorka_gil   
2012-04-11 12:05   
Hi Mark,

The contents of the tarball are the same that the clone.

Could you check again in a clean scenario?

Thanks
(0050398)
shuehner   
2012-07-09 16:28   
Closing as not reproducible as not reproducible by us and no no feedback from reporter for 3 month.