Anonymous | Login
Project:
RSS
  
News | My View | View Issues | Roadmap | Summary

View Issue DetailsJump to Notes ] Issue History ] Print ]
ID
0038693
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] A. Platformmajoralways2018-06-04 13:202018-06-05 18:37
ReporterdmiguelezView Statuspublic 
Assigned Tocaristu 
PriorityurgentResolutionno change requiredFixed in Version
StatusclosedFix in branchFixed in SCM revision
ProjectionnoneETAnoneTarget Version
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionSCM revision 
Review Assigned Tocaristu
Web browser
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0038693: 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)
TagsNo tags attached.
Attached Filesdiff file icon FixesIssue38596.diff [^] (34,890 bytes) 2018-06-04 13:20 [Show Content]

- Relationships Relation Graph ] Dependency Graph ]
related to feature request 0038596 closedvmromanos Modules Show available quantity in Product selector in Distribution order Issue Window 
related to defect 0038698 closedplatform Openbravo ERP Reference window needs some reorganization 

-  Notes
(0104965)
caristu (developer)
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.

- Issue History
Date Modified Username Field Change
2018-06-04 13:20 dmiguelez New Issue
2018-06-04 13:20 dmiguelez Assigned To => platform
2018-06-04 13:20 dmiguelez File Added: FixesIssue38596.diff
2018-06-04 13:20 dmiguelez Modules => Core
2018-06-04 13:20 dmiguelez Resolution time => 1529877600
2018-06-04 13:20 dmiguelez Triggers an Emergency Pack => No
2018-06-04 13:20 dmiguelez Relationship added related to 0038596
2018-06-05 09:59 caristu Relationship added related to 0038698
2018-06-05 18:37 caristu Review Assigned To => caristu
2018-06-05 18:37 caristu Note Added: 0104965
2018-06-05 18:37 caristu Status new => closed
2018-06-05 18:37 caristu Resolution open => no change required
2018-06-05 18:37 caristu Assigned To platform => caristu


Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker