Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
0006518Openbravo ERPA. Platformpublic2008-12-12 18:022009-04-21 12:39
shuehner 
mtaal 
urgentmajorhave not tried
closedfixed 
20
pi 
 
Core
No
0006518: Export Client does not work
When starting the Export Client to xml process an error message is shown.
Switch role to Openbravo Admin
Open the Export Client Window/Popup
Select any Client in the combobox
Press OK
The error-message in the attached screenshot is shown
No tags attached.
png export-client.png (35,446) 2008-12-12 18:02
https://issues.openbravo.com/file_download.php?file_id=531&type=bug
png
Issue History
2008-12-12 18:02shuehnerNew Issue
2008-12-12 18:02shuehnerAssigned To => rafaroda
2008-12-12 18:02shuehnersf_bug_id0 => 2421948
2008-12-12 18:02shuehnerFile Added: export-client.png
2008-12-12 18:02shuehnerRegression testing => No
2008-12-12 18:04shuehnerNote Added: 0011270
2008-12-14 20:03shuehnerAssigned Torafaroda => mtaal
2008-12-14 20:56mtaalStatusnew => scheduled
2008-12-14 20:57mtaalStatusscheduled => resolved
2008-12-14 20:57mtaalsvn_revision => 11178
2009-01-21 10:53plujanStatusresolved => new
2009-01-21 10:53plujanNote Added: 0012435
2009-01-21 10:53plujanStatusnew => scheduled
2009-01-21 10:53plujanfix_in_branch => trunk
2009-01-21 10:55mtaalNote Added: 0012436
2009-01-21 10:56mtaalAssigned Tomtaal => plujan
2009-01-21 10:56mtaalStatusscheduled => feedback
2009-01-21 10:56mtaalfix_in_branchtrunk =>
2009-01-21 12:55plujanNote Added: 0012445
2009-01-21 12:55plujanAssigned Toplujan => mtaal
2009-01-21 12:55plujanStatusfeedback => new
2009-01-21 12:55plujanStatusnew => scheduled
2009-01-21 12:55plujanfix_in_branch => trunk
2009-01-21 13:54mtaalNote Added: 0012453
2009-01-22 16:02mtaalAssigned Tomtaal => plujan
2009-01-22 16:02mtaalStatusscheduled => feedback
2009-01-22 16:02mtaalfix_in_branchtrunk =>
2009-01-30 12:30psarobeNote Added: 0012893
2009-01-30 12:30psarobeAssigned Toplujan => mtaal
2009-01-30 12:54plujanStatusfeedback => scheduled
2009-01-30 12:54plujanNote Added: 0012895
2009-01-30 12:54plujanfix_in_branch => trunk
2009-02-02 06:18pjuvaraPrioritynormal => urgent
2009-02-02 06:18pjuvarafix_in_branchtrunk =>
2009-02-03 12:09svnbotCheckin
2009-02-03 12:09svnbotNote Added: 0013075
2009-02-03 12:09svnbotStatusscheduled => resolved
2009-02-03 12:09svnbotResolutionopen => fixed
2009-02-03 12:09svnbotsvn_revision11178 => 12700
2009-04-21 12:39psarobeStatusresolved => closed

Notes
(0011270)
shuehner   
2008-12-12 18:04   
When using the System Administrator role. The Combobox only displays the System Client but after pressing OK no error-message is shown and the exportfile is created.
(0012435)
plujan   
2009-01-21 10:53   
I tried using a more recent trunk and PostgreSQL and I still can not export a client. Now the message is different:
      
Done with Errors
could not execute query

But no client is exported anyway.
(0012436)
mtaal   
2009-01-21 10:55   
Hi,
I would need some more info, like a stacktrace from catalina.out. Can you provide that?

gr. Martin
(0012445)
plujan   
2009-01-21 12:55   
Martin, this is log4j log:

51037 09:28:41 [ajp-8009-2] ERROR org.hibernate.util.JDBCExceptionReporter - Bad value for type int : 9999999999
51038 09:28:41 [ajp-8009-2] ERROR org.openbravo.service.db.ExportClientProcess - org.hibernate.exception.DataException: could not execute query

And here, the catalina.out:
10 WARNING: Parameters: Invalid chunk ignored.
11 Jan 21, 2009 11:53:05 AM org.apache.tomcat.util.http.Parameters processParame ters
12 WARNING: Parameters: Invalid chunk ignored.
13 Jan 21, 2009 11:53:20 AM org.apache.tomcat.util.http.Parameters processParame ters
14 WARNING: Parameters: Invalid chunk ignored.
15 Jan 21, 2009 11:53:21 AM org.apache.tomcat.util.http.Parameters processParame ters
16 WARNING: Parameters: Invalid chunk ignored.
17 Jan 21, 2009 11:53:27 AM org.apache.tomcat.util.http.Parameters processParame ters
18 WARNING: Parameters: Invalid chunk ignored.
19 Jan 21, 2009 11:53:28 AM org.apache.tomcat.util.http.Parameters processParame ters
20 WARNING: Parameters: Invalid chunk ignored.
21 Jan 21, 2009 11:53:44 AM org.apache.tomcat.util.http.Parameters processParame ters
22 WARNING: Parameters: Invalid chunk ignored.
23 Jan 21, 2009 11:53:45 AM org.apache.tomcat.util.http.Parameters processParame ters
24 WARNING: Parameters: Invalid chunk ignored.
(0012453)
mtaal   
2009-01-21 13:54   
Hi,
And does catalina.out show anything special?

It seems that apparently there is a value 9999999999 defined for an int field. Either as a default or in the database. Do you remember if you made that change or can you see which field it is.

gr. Martin
(0012893)
psarobe   
2009-01-30 12:30   
Hi Martin,

Please don't change the "assign to". I know you did because the status feedback but this is not the correct way of doing this. Unless you decide that you are not the person in charge of solving the bug don't change it. Pablo Lujan will receive the feedback anyway as whenever someone change the status or other things then the bug is automatically monitored by that person

thanks
(0012895)
plujan   
2009-01-30 12:54   
Martin,

I tried again with a more recent trunk revision and a different machine and the error is the same. There are not changes on any configuration file other than required ones.
(0013075)
svnbot   
2009-02-03 12:09   
Repository: openbravo
Revision: 12700
Author: mtaal
Date: 2009-02-03 12:09:11 +0100 (Tue, 03 Feb 2009)

Fixes issue 7307 Validate.database should be able to run for a single module and only check module-specific db artifacts
Validate module is now run as part of export.database
Fixes issue 6518 Export Client does not work

---
U trunk/src/org/openbravo/base/model/Property.java
U trunk/src/org/openbravo/base/model/Reference.java
U trunk/src/org/openbravo/dal/core/DalMappingGenerator.java
U trunk/src/org/openbravo/service/system/DatabaseValidator.java
U trunk/src/org/openbravo/service/system/SystemService.java
U trunk/src/org/openbravo/service/system/SystemValidationTask.java
U trunk/src-db/database/lib/dbsourcemanager.jar
U trunk/src-test/org/openbravo/test/dal/DalPerformanceInventoryLineTest.java
U trunk/src-test/org/openbravo/test/dal/ValidationTest.java
U trunk/src-test/org/openbravo/test/security/EntityAccessTest.java
U trunk/src-test/org/openbravo/test/xml/EntityXMLImportTestBusinessObject.java
---

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