Anonymous | Login
Project:
RSS
  
News | My View | View Issues | Roadmap | Summary

View Issue Details[ Jump to Notes ] [ Issue History ] [ Print ]
ID
0011564
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] 01. General setupmajorhave not tried2009-12-01 10:102009-12-09 00:00
ReporterarunkumarView Statuspublic 
Assigned Tovinothbabu 
PriorityimmediateResolutionfixedFixed in Version2.50MP10
StatusclosedFix in branchpiFixed in SCM revision4b50da253e7d
ProjectionnoneETAnoneTarget Version
OSAnyDatabasePostgreSQLJava version
OS VersionDatabase versionAnt version
Product Version2.40SCM revision 
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
Summary

0011564: 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)
TagsNo tags attached.
Attached Filesjpg file icon 240InitialClientSetup.JPG [^] (165,565 bytes) 2009-12-01 10:10

- Relationships [ Relation Graph ] [ Dependency Graph ]
related to backport 00113692.40MP12 closedvinothbabu Modification in the Account is not reflected in the combination's name 
depends on backport 0011566 closedvinothbabu Initial client setup process fails due to SQLException 

-  Notes
(0022287)
arunkumar (viewer)
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 (viewer)
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 (developer)
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 (viewer)
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 (viewer)
2009-12-08 10:52

 Tested working fine able to create a client with out any trouble

- Issue History
Date Modified Username Field Change
2009-12-01 10:10 arunkumar New Issue
2009-12-01 10:10 arunkumar Assigned To => rafaroda
2009-12-01 10:10 arunkumar File Added: 240InitialClientSetup.JPG
2009-12-01 10:10 arunkumar OBNetwork customer => No
2009-12-01 10:17 arunkumar Status new => scheduled
2009-12-01 10:17 arunkumar fix_in_branch => pi
2009-12-01 11:29 arunkumar Note Added: 0022287
2009-12-01 11:42 psarobe Assigned To rafaroda => dalsasua
2009-12-01 11:42 psarobe fix_in_branch pi =>
2009-12-01 11:43 psarobe Status scheduled => feedback
2009-12-01 11:43 psarobe Status feedback => scheduled
2009-12-01 11:43 psarobe fix_in_branch => pi
2009-12-01 12:58 vmromanos Note Added: 0022300
2009-12-01 15:03 vmromanos Relationship added related to 0011369
2009-12-02 05:58 vinothbabu Assigned To dalsasua => vinothbabu
2009-12-02 06:51 hgbot Checkin
2009-12-02 06:51 hgbot Note Added: 0022342
2009-12-02 06:51 hgbot Status scheduled => resolved
2009-12-02 06:51 hgbot Resolution open => fixed
2009-12-02 06:51 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/4b50da253e7ddfe136df11df7d40d4613902c7f2 [^]
2009-12-04 09:14 hudsonbot Checkin
2009-12-04 09:14 hudsonbot Note Added: 0022437
2009-12-08 10:52 sureshbabu Note Added: 0022541
2009-12-08 10:52 sureshbabu Status resolved => closed
2009-12-08 10:52 sureshbabu Fixed in Version => 2.50MP10
2009-12-09 00:00 anonymous sf_bug_id 0 => 2911055

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker