0008244: 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 [^]

Issue History
Date Modified	Username	Field	Change
2009-03-24 10:29	iperdomo	New Issue
2009-03-24 10:29	iperdomo	Assigned To	=> rafaroda
2009-03-24 10:29	iperdomo	OBNetwork customer	=> No
2009-03-24 10:29	iperdomo	Regression testing	=> No
2009-03-24 10:52	iperdomo	Status	new => scheduled
2009-03-24 10:52	iperdomo	fix_in_branch	=> pi
2009-03-24 10:53	iperdomo	Status	scheduled => closed
2009-03-24 10:53	iperdomo	Resolution	open => no change required
2009-03-25 00:00	anonymous	sf_bug_id	0 => 2710566

Notes
There are no notes attached to this issue.