Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0038693Openbravo ERPA. Platformpublic2018-06-04 13:202018-06-05 18:37
Reporterdmiguelez 
Assigned Tocaristu 
PriorityurgentSeveritymajorReproducibilityalways
StatusclosedResolutionno change required 
PlatformOS5OS Version
Product Version 
Target VersionFixed in Version 
Merge Request Status
Review Assigned Tocaristu
OBNetwork customer
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0038693: Error when exporting database due to a selector definition
DescriptionError when exporting database due to a selector definition.

Trying to define a selector that allows to select Products, but shows information about available quantity also, there is a problem that does not allow to export the database properly
Steps To ReproduceInstall this module:
https://code.openbravo.com/erp/mods/org.openbravo.distributionorder [^]

Apply the patch provided for the module.

As System Admin, set the Module as In Development = Y
Do ant.export.database

This error message is raised:

Log del export.database:
[exportdatabase] 43708 INFO - Validating Module...
[exportdatabase] 44792 ERROR -
[exportdatabase]
[exportdatabase] +++++++++++++++++++++++++++++++++++++++++++++++++++
[exportdatabase] Errors for Validation type: WRONG_LENGTH
[exportdatabase] +++++++++++++++++++++++++++++++++++++++++++++++++++
[exportdatabase] Column OBDO_DISTORDERLINE.M_PRODUCT_ID has incorrect length, expecting 32 but was 64. If this a foreign key column then the expected length is either 32 (a uuid) or based on the fieldLength (so not the db columnlength) of the referenced column, as defined in AD_COLUMN.

BUILD FAILED
/home/openbravo/3.0/awo-pg/openbravo/erp/devel/pi/build.xml:694: The following error occurred while executing this line:
/home/openbravo/3.0/awo-pg/openbravo/erp/devel/pi/src-db/database/build.xml:124: org.openbravo.base.exception.OBException: Module validation failed, see the above list of errors for more information
    at org.openbravo.ddlutils.task.ExportDatabase.validateDatabaseForModule(ExportDatabase.java:295)
    at org.openbravo.ddlutils.task.ExportDatabase.execute(ExportDatabase.java:165)
    at org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:292)
    at sun.reflect.GeneratedMethodAccessor4.invoke(Unknown Source)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
    at java.lang.reflect.Method.invoke(Method.java:498)
    at org.apache.tools.ant.dispatch.DispatchUtils.execute(DispatchUtils.java:106)
    at org.apache.tools.ant.Task.perform(Task.java:350)
    at org.apache.tools.ant.Target.execute(Target.java:448)
    at org.apache.tools.ant.Target.performTasks(Target.java:469)
    at org.apache.tools.ant.Project.executeSortedTargets(Project.java:1399)
    at org.apache.tools.ant.helper.SingleCheckExecutor.executeTargets(SingleCheckExecutor.java:36)
    at org.apache.tools.ant.Project.executeTargets(Project.java:1260)
    at org.apache.tools.ant.taskdefs.Ant.execute(Ant.java:446)
    at org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:292)
    at sun.reflect.GeneratedMethodAccessor4.invoke(Unknown Source)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
    at java.lang.reflect.Method.invoke(Method.java:498)
    at org.apache.tools.ant.dispatch.DispatchUtils.execute(DispatchUtils.java:106)
    at org.apache.tools.ant.Task.perform(Task.java:350)
    at org.apache.tools.ant.Target.execute(Target.java:448)
    at org.apache.tools.ant.Target.performTasks(Target.java:469)
    at org.apache.tools.ant.Project.executeSortedTargets(Project.java:1399)
    at org.apache.tools.ant.Project.executeTarget(Project.java:1370)
    at org.apache.tools.ant.helper.DefaultExecutor.executeTargets(DefaultExecutor.java:41)
    at org.apache.tools.ant.Project.executeTargets(Project.java:1260)
    at org.apache.tools.ant.Main.runBuild(Main.java:849)
    at org.apache.tools.ant.Main.startAnt(Main.java:228)
    at org.apache.tools.ant.launch.Launcher.run(Launcher.java:283)
    at org.apache.tools.ant.launch.Launcher.main(Launcher.java:101)
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
related to feature request 0038596 closed vmromanos Modules Show available quantity in Product selector in Distribution order Issue Window 
related to defect 0038698 closed platform Openbravo ERP Reference window needs some reorganization 
Attached Filesdiff FixesIssue38596.diff (34,890) 2018-06-04 13:20
https://issues.openbravo.com/file_download.php?file_id=11825&type=bug
Issue History
Date ModifiedUsernameFieldChange
2018-06-04 13:20dmiguelezNew Issue
2018-06-04 13:20dmiguelezAssigned To => platform
2018-06-04 13:20dmiguelezFile Added: FixesIssue38596.diff
2018-06-04 13:20dmiguelezModules => Core
2018-06-04 13:20dmiguelezResolution time => 1529877600
2018-06-04 13:20dmiguelezTriggers an Emergency Pack => No
2018-06-04 13:20dmiguelezRelationship addedrelated to 0038596
2018-06-05 09:59caristuRelationship addedrelated to 0038698
2018-06-05 18:37caristuReview Assigned To => caristu
2018-06-05 18:37caristuNote Added: 0104965
2018-06-05 18:37caristuStatusnew => closed
2018-06-05 18:37caristuResolutionopen => no change required
2018-06-05 18:37caristuAssigned Toplatform => caristu

Notes
(0104965)
caristu   
2018-06-05 18:37   
The validation is correct, the problem is in the table definition itself: M_PRODUCT_ID should have length 32 instead of 64 in OBDO_DISTORDERLINE table.