Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0006975Openbravo ERP01. General setuppublic2009-01-19 10:362009-04-21 12:36
Reporterpmagnin 
Assigned Tomtaal 
PriorityhighSeveritymajorReproducibilityhave not tried
StatusclosedResolutionfixed 
PlatformOS10OS Version
Product Version2.50alpha-r4 
Target Version2.50Fixed 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
Summary0006975: Modularity: Build error after configuring a Manual Page
DescriptionI modified a manual page that belongs to a module.
Example: I changed the field name from "Satisfactory18" to "Satisfactory (% Forecast)".

I have an issue when I try to build ma page. See attachment for more details.

--=================================
The problem seems to be associated to the '%' caractere. I tried to do a manual update in the tables ad_field and ad_column to delete the '%' caractere, but I have still the same issue.

This issue is localized in the generate.entities process.
Steps To Reproduce
Proposed Solution
Additional Information
TagsModularity
Relationships
Attached Filespng BuildError.png (33,126) 2009-01-19 10:36
https://issues.openbravo.com/file_download.php?file_id=658&type=bug
png

png BuildError_AD_COLUMN.png (18,937) 2009-01-19 13:35
https://issues.openbravo.com/file_download.php?file_id=665&type=bug
png

png BuildError_AfterDatabaseUpdate.png (15,213) 2009-01-19 13:35
https://issues.openbravo.com/file_download.php?file_id=666&type=bug
png
Issue History
Date ModifiedUsernameFieldChange
2009-01-19 10:36pmagninNew Issue
2009-01-19 10:36pmagninAssigned To => alostale
2009-01-19 10:36pmagninsf_bug_id0 => 2519266
2009-01-19 10:36pmagninFile Added: BuildError.png
2009-01-19 10:36pmagninOBNetwork customer => No
2009-01-19 10:36pmagninRegression testing => No
2009-01-19 12:42psarobeStatusnew => scheduled
2009-01-19 12:42psarobefix_in_branch => trunk
2009-01-19 12:42psarobeTag Attached: Modularity
2009-01-19 13:11pmagninAssigned Toalostale => mtaal
2009-01-19 13:11pmagninPrioritynormal => high
2009-01-19 13:11pmagninfix_in_branchtrunk =>
2009-01-19 13:11pmagninDescription Updated
2009-01-19 13:17mtaalNote Added: 0012327
2009-01-19 13:35pmagninFile Added: BuildError_AD_COLUMN.png
2009-01-19 13:35pmagninFile Added: BuildError_AfterDatabaseUpdate.png
2009-01-19 13:37pmagninNote Added: 0012331
2009-01-19 13:43mtaalNote Added: 0012332
2009-01-19 13:59pmagninNote Added: 0012335
2009-01-19 14:01mtaalNote Added: 0012336
2009-01-19 14:01pmagninStatusscheduled => closed
2009-01-19 14:01pmagninResolutionopen => out of date
2009-01-19 14:02pmagninStatusclosed => new
2009-01-19 14:02pmagninResolutionout of date => open
2009-01-19 14:02pmagninNote Added: 0012337
2009-01-19 14:04mtaalNote Added: 0012339
2009-01-19 14:59svnbotCheckin
2009-01-19 14:59svnbotNote Added: 0012344
2009-01-19 14:59svnbotStatusnew => resolved
2009-01-19 14:59svnbotResolutionopen => fixed
2009-01-19 14:59svnbotsvn_revision => 12006
2009-04-21 12:36psarobeStatusresolved => closed

Notes
(0012327)
mtaal   
2009-01-19 13:17   
Hi Pascal,
What are the values of the following fields:
AD_Column.name
AD_Column.columnname

For the column for which you made the change?

gr. Martin
(0012331)
pmagnin   
2009-01-19 13:37   
Hi martin,
please find in attachment the select and the issue I still have when I try to build. It seems there is no relation with the '%' caratere.
Pascal
(0012332)
mtaal   
2009-01-19 13:43   
Hi Pascal,
I can see that column satisfactoryaxis19 has a different column name than the others.
How does the database handle this columnname? I mean when you look in oracle/postgress what name is used for that column?

gr. Martin
(0012335)
pmagnin   
2009-01-19 13:59   
Martin,
you found it ! I did an updated of some AD_Column.columnname values, and it is working fine. I will try to understand why these values have been modified.
Thanks,
Pascal
(0012336)
mtaal   
2009-01-19 14:01   
Hi Pascal,
Okay but let's keep the call open as I should change the code so that it replaces these characters with characters which are allowed for java.

gr. Martin
(0012337)
pmagnin   
2009-01-19 14:02   
I reopened the call...
Pascal
(0012339)
mtaal   
2009-01-19 14:04   
Re-opening it as I need to make the java code more robust.
(0012344)
svnbot   
2009-01-19 14:59   
Repository: openbravo
Revision: 12006
Author: mtaal
Date: 2009-01-19 14:59:32 +0100 (Mon, 19 Jan 2009)

Fixes issue 6975, be more robust when someone uses illegal java characters for columnnames

---
U trunk/src/org/openbravo/base/model/NamingUtil.java
---

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