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

Openbravo Issue Tracking System - Openbravo ERP

View Issue Details

Project

Category

View Status

Date Submitted

Last Update

0008244

Openbravo ERP

A. Platform

public

2009-03-24 10:29

2009-03-25 00:00

Reporter

iperdomo

Assigned To

rafaroda

Priority

normal

Severity

major

Reproducibility

always

Status

closed

Resolution

no change required

Platform

OS Version

2.6.25-gentoo-r9

Product Version

2.40

Target Version

Fixed in Version

Merge Request Status

Review Assigned To

OBNetwork customer

Web browser

Modules

Core

Support ticket

Regression level

Regression date

Regression introduced in release

Regression introduced by commit

Triggers an Emergency Pack

Summary

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

Proposed Solution

Additional Information