Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0004678Openbravo ERP01. General setuppublic2008-08-21 18:152008-11-25 18:42
Reporterpdumon 
Assigned Tocromero 
PrioritynormalSeverityminorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version2.40beta 
Target VersionFixed in Version 
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
Summary0004678: Initial client setup fails with c_currency not null constraint
DescriptionAfter filling in all the data (including the currency) in the Initial Client Setup Field, I get

javax.servlet.ServletException: @CODE=@@CODE=0@ERROR: null value in column "c_currency_id" violates not-null constraint.

It was a default, brand new Openbravo setup, and the Initial Client Setup was the very first thing I did. Same issue both on Windows (tomcat+postgres 8.3+webbrowser on the windows pc) and on Debian Linux (tomcat+postgres 8.1 on the remote linux server + webbrowser on client PC).

Report Summary

Create client process completed succesfully

Create document types process completed succesfully

Create master data failed

Steps To Reproduce
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
related to defect 0005999 closed eduardo_Argal Initial client setup error creating masterdata without selecting accounting file 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2008-08-21 18:15pdumonNew Issue
2008-08-21 18:15pdumonAssigned To => cromero
2008-08-21 18:15pdumonsf_bug_id0 => 2065154
2008-08-22 13:27psarobeNote Added: 0008685
2008-08-22 13:27psarobeSeveritymajor => minor
2008-08-22 13:27psarobeStatusnew => scheduled
2008-11-04 12:32svnbotCheckin
2008-11-04 12:32svnbotNote Added: 0009967
2008-11-04 12:32svnbotStatusscheduled => resolved
2008-11-04 12:32svnbotResolutionopen => fixed
2008-11-04 12:32svnbotsvn_revision => 9627
2008-11-25 18:40rafarodaRelationship addedrelated to 0005999
2008-11-25 18:42rafarodaRegression testing => No
2008-11-25 18:42rafarodaStatusresolved => closed
2008-11-25 18:42rafarodaNote Added: 0010663

Notes
(0008685)
psarobe   
2008-08-22 13:27   
The problem happens if you don't select a COA (chart of accounts) so when creating the price list for the master data it fails that part. This is not major because:
1. It only affects to master data. This master data is only for sample purpose. You can work with the new client without problems
2. An easy workaround would be to select a COA and everything will go fine
(0009967)
svnbot   
2008-11-04 12:32   
Repository: openbravo
Revision: 9627
Author: cromeroherrero
Date: 2008-11-04 12:32:57 +0100 (Tue, 04 Nov 2008)

Fixed bug 4678: Initial client setup fails with c_currency not null constraint

---
U trunk/src/org/openbravo/erpCommon/ad_forms/InitialClientSetup.java
U trunk/src/org/openbravo/erpCommon/ad_forms/InitialClientSetup_data.xsql
---

https://dev.openbravo.com/websvn/openbravo/?rev=9627&sc=1 [^]
(0010663)
rafaroda   
2008-11-25 18:42   
The fix does not correspond with the issue description but solves another problem. Anyway, this issue keeps open and un-resolved in https://issues.openbravo.com/view.php?id=5999 [^]