Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0001815Openbravo ERPZ. Otherspublic2007-08-21 22:452008-06-12 09:43
Reporteruser71 
Assigned Touser71 
PrioritynormalSeverityminorReproducibilityalways
StatusclosedResolutionunable to reproduce 
PlatformOS5OS Version
Product Version 
Target VersionFixed in Versionpi 
Merge Request Status
Review Assigned To
OBNetwork customer
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0001815: Import an account file doesn\\\'t work
DescriptionSteps to reproduce:

1. Create an entity without the accounting file
2. Go to: Master Data Management -> Import data -> Import File Loader
3. Select an cvs account file, for example AccountsESOpenbravo_v1.3.csv.
4. Select Accounts - account in the Format File menu.
5. Check the Header First Line box
6. Click OK.

Then you get this error:

Error: Error
java.lang.NullPointerException

I'm using v2.33 running on Debian Etch.
Steps To Reproduce
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
Attached Files
Issue History
Date ModifiedUsernameFieldChange

Notes
(0005404)
user71   
2005-06-01 00:00   
(edited on: 2008-06-12 09:43)
This bug was originally reported in SourceForge bug tracker and then migrated to Mantis.

You can see the original bug report in:
https://sourceforge.net/support/tracker.php?aid=1778992 [^]
(0001850)
psarobe   
2007-09-03 20:58   
(edited on: 2008-06-12 09:20)
Logged In: YES
user_id=1500703
Originator: NO

And which DB are you using?
(0001851)
psarobe   
2007-09-03 22:07   
(edited on: 2008-06-12 09:20)
Logged In: YES
user_id=1500703
Originator: NO

I have tried what you describe and it works fine for DB Oracle 10g.
(0001852)
user71   
2007-09-03 22:22   
(edited on: 2008-06-12 09:20)
Logged In: YES
user_id=1624063
Originator: YES

Oh, i forgot that, i'm using postgres 8.2.

However i've found the reason of the bug, when i go to Master Data Management -> Import Data -> Import Loader Format i select "Accounting - Account" because is the format of the chart of accounts file.

Then i go to Field format and all the fields are repeated, i mean: There are 9 records with the 10 sequence, 9 with the 20 sequence and so on. I don't have a screenshot to show you right now, but i'm gonna reproduce the bug again.

The solution was to remove all the duplicate records and import the file again. Now it works.
(0001853)
psarobe   
2007-09-04 12:37   
(edited on: 2008-06-12 09:20)
Logged In: YES
user_id=1500703
Originator: NO

Please, it would be great if you can reproduce the bug. It seems a process may duplicate those rows.
(0001854)
pjuvara   
2007-10-19 13:02   
(edited on: 2008-06-12 09:20)
Logged In: YES
user_id=1871571
Originator: NO

We have not been able to reproduce this bug internally. We have never observed these records being duplicated.
If you find a reproducible test case, please reopen.