Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0011564Openbravo ERP01. General setuppublic2009-12-01 10:102009-12-09 00:00
Reporterarunkumar 
Assigned Tovinothbabu 
PriorityimmediateSeveritymajorReproducibilityhave not tried
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version2.40 
Target VersionFixed in Version2.50MP10 
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
Summary0011564: Initial client setup process fails due to SQLException
DescriptionWhile setting up the initial client it displayed an error message "java.sql.SQLException:Connection is closed"
Steps To ReproduceLogin as Openbravo/openbravo
Click on icon "user info" and select the role "System Administrator"
Go General Setup -> Client-> Initial client setup
Fill the data and chart of accounts according Client sample data
Click OK

You will see an error message "java.sql.SQLException:Connection is closed" (Please refer the screenshot)
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
related to backport 00113692.40MP12 closed vinothbabu Modification in the Account is not reflected in the combination's name 
depends on backport 0011566 closed vinothbabu Initial client setup process fails due to SQLException 
Attached Filesjpg 240InitialClientSetup.JPG (165,565) 2009-12-01 10:10
https://issues.openbravo.com/file_download.php?file_id=1999&type=bug
jpg
Issue History
Date ModifiedUsernameFieldChange
2009-12-01 10:10arunkumarNew Issue
2009-12-01 10:10arunkumarAssigned To => rafaroda
2009-12-01 10:10arunkumarFile Added: 240InitialClientSetup.JPG
2009-12-01 10:17arunkumarStatusnew => scheduled
2009-12-01 10:17arunkumarfix_in_branch => pi
2009-12-01 11:29arunkumarNote Added: 0022287
2009-12-01 11:42psarobeAssigned Torafaroda => dalsasua
2009-12-01 11:42psarobefix_in_branchpi =>
2009-12-01 11:43psarobeStatusscheduled => feedback
2009-12-01 11:43psarobeStatusfeedback => scheduled
2009-12-01 11:43psarobefix_in_branch => pi
2009-12-01 12:58vmromanosNote Added: 0022300
2009-12-01 15:03vmromanosRelationship addedrelated to 0011369
2009-12-02 05:58vinothbabuAssigned Todalsasua => vinothbabu
2009-12-02 06:51hgbotCheckin
2009-12-02 06:51hgbotNote Added: 0022342
2009-12-02 06:51hgbotStatusscheduled => resolved
2009-12-02 06:51hgbotResolutionopen => fixed
2009-12-02 06:51hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/4b50da253e7ddfe136df11df7d40d4613902c7f2 [^]
2009-12-04 09:14hudsonbotCheckin
2009-12-04 09:14hudsonbotNote Added: 0022437
2009-12-08 10:52sureshbabuNote Added: 0022541
2009-12-08 10:52sureshbabuStatusresolved => closed
2009-12-08 10:52sureshbabuFixed in Version => 2.50MP10
2009-12-09 00:00anonymoussf_bug_id0 => 2911055

Notes
(0022287)
arunkumar   
2009-12-01 11:29   
This breaks the smoke test in both QA and hudson. I have seen few commits in 2.40 today.http://builds.openbravo.com/job/erp_stable_2.40-pgsql-smoke-test/76/changes#detail0. [^] Is any of the commit is the cause of this failure?
(0022300)
vmromanos   
2009-12-01 12:58   
[http-8080-2] ERROR org.openbravo.erpCommon.ad_forms.InitialClientSetupData - SQL error in query: INSERT INTO C_ElementValue (C_ELEMENTVALUE_ID,C_ELEMENT_ID, AD_CLIENT_ID,AD_ORG_ID,ISACTIVE,CREATED,CREATEDBY,UPDATED,UPDATEDBY, VALUE,NAME,DESCRIPTION,ACCOUNTTYPE,ACCOUNTSIGN,ISDOCCONTROLLED,ISSUMMARY,VALIDFROM,VALIDTO, POSTACTUAL,POSTBUDGET,POSTENCUMBRANCE,POSTSTATISTICAL,ISBANKACCOUNT,C_BANKACCOUNT_ID,ISFOREIGNCURRENCY,C_CURRENCY_ID, ELEMENTLEVEL) VALUES (TO_NUMBER(?),TO_NUMBER(?),TO_NUMBER(?),TO_NUMBER(?),'Y',now(),0,now(),0,?,?,?,?,?,?,?,NULL,NULL,'Y','Y','Y','Y', 'N',NULL, 'N',NULL,COALESCE(SUBSTR(?,1,1),'S'))Exception:org.postgresql.util.PSQLException: ERROR: record "old" is not assigned yet
  Detail: The tuple structure of a not-yet-assigned record is indeterminate.
(0022342)
hgbot   
2009-12-02 06:51   
Repository: erp/devel/pi
Changeset: 4b50da253e7ddfe136df11df7d40d4613902c7f2
Author: Vinoth Babu <vinoth.babu <at> openbravo.com>
Date: Wed Dec 02 11:19:22 2009 +0530
URL: http://code.openbravo.com/erp/devel/pi/rev/4b50da253e7ddfe136df11df7d40d4613902c7f2 [^]

Fixes bug 11564 Initial client setup process fails

---
M src-db/database/model/triggers/C_ELEMENTVALUE_TRG.xml
M src-db/database/model/triggers/C_VALIDCOMBINATION_TRG.xml
---
(0022437)
hudsonbot   
2009-12-04 09:14   
---
A changeset related to this issue has passed a series of tests and has been promoted to main:

Changeset: http://code.openbravo.com/erp/devel/main/rev/f6bc559b1872 [^]
Tests: http://builds.openbravo.com/view/devel-int/ [^]
---
(0022541)
sureshbabu   
2009-12-08 10:52   
Tested working fine able to create a client with out any trouble