0008246: Initial Client Setup fails - ERROR: null value in column "c_currency_id" violates not-null constraint

Description

I tried to execute the Initial Client setup without success.

This is the errors in the log file

10:18:28 [http-8880-Processor20] ERROR org.openbravo.erpCommon.ad_forms.InitialClientSetupData - SQL error in query: INSERT INTO AD_Client(AD_Client_ID,AD_Org_ID,IsActive,Created,CreatedBy,Updated,UpdatedBy,Value,Name,Description) VALUES (TO_NUMBER(?),0,'Y',now(),0,now(),0,?, ?, ?)Exception:org.postgresql.util.PSQLException: ERROR: null value in column "c_currency_id" violates not-null constraint
10:18:28 [http-8880-Processor20] WARN org.openbravo.erpCommon.ad_forms.InitialClientSetup - java.sql.SQLException: Connection is closed.
10:18:28 [http-8880-Processor20] ERROR org.openbravo.erpCommon.ad_forms.InitialClientSetupData - SQL error in query: INSERT INTO C_Calendar(AD_Client_ID,AD_Org_ID,IsActive,Created,CreatedBy,Updated,UpdatedBy,C_Calendar_ID,Name) VALUES ( TO_NUMBER(?),0,'Y',now(),0,now(),0,TO_NUMBER(?),?)Exception:org.postgresql.util.PSQLException: ERROR: insert or update on table "c_calendar" violates foreign key constraint "c_calendarclient"
  Detail: Key (ad_client_id)=(1000002) is not present in table "ad_client".
10:18:28 [http-8880-Processor20] WARN org.openbravo.erpCommon.ad_forms.InitialClientSetup - javax.servlet.ServletException: @CODE=0@ERROR: insert or update on table "c_calendar" violates foreign key constraint "c_calendarclient"
  Detail: Key (ad_client_id)=(1000002) is not present in table "ad_client".
10:18:28 [http-8880-Processor20] ERROR org.openbravo.erpCommon.ad_forms.InitialClientSetupData - SQL error in query: INSERT INTO GL_Category (GL_Category_ID,AD_Client_ID,AD_Org_ID,IsActive,Created,CreatedBy,Updated,UpdatedBy,Name ,CategoryType,IsDefault) VALUES (TO_NUMBER(?),TO_NUMBER(?),0,'Y',now(),0,now(),0,?,?,?)Exception:org.postgresql.util.PSQLException: ERROR: insert or update on table "gl_category" violates foreign key constraint "adclient_glcategory"
  Detail: Key (ad_client_id)=(1000002) is not present in table "ad_client".
10:18:28 [http-8880-Processor20] WARN org.openbravo.erpCommon.ad_forms.InitialClientSetup - javax.servlet.ServletException: @CODE=@@CODE=0@ERROR: insert or update on table "gl_category" violates foreign key constraint "adclient_glcategory"
  Detail: Key (ad_client_id)=(1000002) is not present in table "ad_client".
10:18:28 [http-8880-Processor20] ERROR org.openbravo.erpCommon.ad_forms.InitialClientSetupData - SQL error in query: INSERT INTO C_Channel (C_Channel_ID,Name,AD_Client_ID,AD_Org_ID,IsActive,Created,CreatedBy,Updated,UpdatedBy) VALUES (TO_NUMBER(?),?,TO_NUMBER(?),0,'Y',now(),0,now(),0)Exception:org.postgresql.util.PSQLException: ERROR: insert or update on table "c_channel" violates foreign key constraint "adclient_cchannel"
  Detail: Key (ad_client_id)=(1000002) is not present in table "ad_client".
10:18:28 [http-8880-Processor20] WARN org.openbravo.erpCommon.ad_forms.InitialClientSetup - javax.servlet.ServletException: @CODE=@@CODE=0@ERROR: insert or update on table "c_channel" violates foreign key constraint "adclient_cchannel"
  Detail: Key (ad_client_id)=(1000002) is not present in table "ad_client".

Steps To Reproduce

* Go to: General Setup > Client > Initial Client Setup
* Download the US Accounting file [1]
* Fill all the required fields:
  - Client: MyClient
  - Organization: MyOrg
  - Client Username: MyClientUsername
  - Organization Username: MyOrgUsername
  - Country: United States
  - State: FL
  - City: Miami
  - Currency: US Dollars
  - Accounting Dimensions: Business Partner, Project, Product
* Select the downloaded accounting file
* Click OK

[1] http://downloads.sourceforge.net/openbravo/AccountsSimplifiedUS06v5.csv [^]

Tags

No tags attached.

Attached Files

Relationships [ Relation Graph ] [ Dependency Graph ]

related to	backport	0007957		closed	rafaroda	Multi currency issues in some processes and tables
blocks	defect	0008244		closed	rafaroda	Initial Client Setup fails - ERROR: null value in column "c_currency_id" violates not-null constraint

Notes
(0014903) rafaroda (viewer) 2009-03-24 15:00	Fix for trunk was done in https://dev.openbravo.com/websvn/openbravo/?op=comp&compare[]=%2F@1170&compare[]=%2F@1171 [^]

(0014914) hgbot (developer) 2009-03-24 22:39	Repository: erp/stable/2.40 Changeset: f7aa3d4e5e5592382445dc7d6cca70212bdb834d Author: Ainhoa Pagola <ainhoa.pagola <at> openbravo.com> Date: Tue Mar 24 22:37:08 2009 +0100 URL: http://code.openbravo.com/erp/stable/2.40/rev/f7aa3d4e5e5592382445dc7d6cca70212bdb834d [^] Fixes bug 0008246 Initial client setup fails: null in c_currency_id --- M src/org/openbravo/erpCommon/ad_forms/InitialClientSetup.java M src/org/openbravo/erpCommon/ad_forms/InitialClientSetup_data.xsql ---

(0016214) arunkumar (viewer) 2009-05-11 07:59	This issue has been fixed.

Issue History
Date Modified	Username	Field	Change
2009-03-24 10:52	iperdomo	Type	defect => backport
2009-03-24 10:52	iperdomo	fix_in_branch	=> 2.40
2009-03-24 11:00	psarobe	Priority	normal => immediate
2009-03-24 11:00	psarobe	Severity	major => critical
2009-03-24 11:00	rafaroda	Relationship added	related to 0007957
2009-03-24 11:00	psarobe	Priority	immediate => urgent
2009-03-24 15:00	rafaroda	Note Added: 0014903
2009-03-24 15:00	rafaroda	Assigned To	rafaroda => AinhoaPagola
2009-03-24 22:39	hgbot	Checkin
2009-03-24 22:39	hgbot	Note Added: 0014914
2009-03-24 22:39	hgbot	Status	scheduled => resolved
2009-03-24 22:39	hgbot	Resolution	open => fixed
2009-03-24 22:39	hgbot	Fixed in SCM revision	=> http://code.openbravo.com/erp/stable/2.40/rev/f7aa3d4e5e5592382445dc7d6cca70212bdb834d [^]
2009-05-10 19:37	psarobe	Fixed in Version	=> 2.40MP4
2009-05-11 07:59	arunkumar	Status	resolved => closed
2009-05-11 07:59	arunkumar	Note Added: 0016214