Project:
| View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||
| ID | ||||||||
| 0008244 | ||||||||
| Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||
| defect | [Openbravo ERP] A. Platform | major | always | 2009-03-24 10:29 | 2009-03-25 00:00 | |||
| Reporter | iperdomo | View Status | public | |||||
| Assigned To | rafaroda | |||||||
| Priority | normal | Resolution | no change required | Fixed in Version | ||||
| Status | closed | Fix in branch | pi | Fixed in SCM revision | ||||
| Projection | none | ETA | none | Target Version | ||||
| OS | Linux 32 bit | Database | PostgreSQL | Java version | 1.6.0_07 | |||
| OS Version | 2.6.25-gentoo-r9 | Database version | 8.3.5 | Ant version | 1.7.0 | |||
| Product Version | 2.40 | SCM revision | 2872b2b7a68e | |||||
| Review Assigned To | ||||||||
| Web browser | ||||||||
| Modules | Core | |||||||
| Regression level | ||||||||
| Regression date | ||||||||
| Regression introduced in release | ||||||||
| Regression introduced by commit | ||||||||
| Triggers an Emergency Pack | No | |||||||
| 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 [^] | |||||||
| Tags | No tags attached. | |||||||
| Attached Files | ||||||||
 Relationships [ Relation Graph ]
[ Dependency Graph ]
|
||||||||
|
||||||||
 Relationships |
|
Notes |
|
| There are no notes attached to this issue. |
|
Notes |
|
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 | 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 |
|
Issue History |
| Copyright © 2000 - 2009 MantisBT Group |
 |