#16 Client Setup results in error

X_Unsupported
closed-fixed
5
2001-11-05
2001-11-03
No

First of all, thank you for Compiere. Second, I am
trying to start "implementing" it (enter invoices,
sales leads, etc.) and I've run into a error that I
will explain:
"
DBExecuteError ORA-02291: integrity constraint
(ACCORTO.C_REGION_LO
CATION) violated - parent key not found
"
Here are the steps I followed to reproduce the problem:

(System is a Win2k, 512MB RAM, Oracle 8.1.7 enterprise
+ followed installation instructions)

Login:
role: system administrator
client: system
organization: *

- Menu
- General Rules
- Client-Rules
- Initial Client Setup

new screen: "Clinent Initial Setup"
- I put in test names/data (client name: test_name)
- client org: test_org
- Username - Client: test_username
- Username - Organization: test_usernameorg
- Load accounts: NaturalAccountsUS.csv (downloaded
from website)
- click OK

(I get this in the -debug window: right after I click
OK)

Compiere (tm) Version 2.4 @ 2001-08-14 Powered by
Compiere (tm) Copyright (c)
1999-2001 Jorg Janke
Log.setTraceLevel - 0
===========> SQL Exception: DB.executeUpdate
SQL=INSERT INTO C_Location
(C_Location_ID,AD_Client_ID,AD_Org_ID,IsActive,Create
d,CreatedBy,Updated,UpdatedBy,City,C_Country_ID,C_Regio
n_ID) VALUES (1000006,100
0003,0,'Y',SysDate,0,SysDate,0,'city',100,0)
===========> ORA-02291: integrity constraint
(ACCORTO.C_REGION_LOCATION) violate
d - parent key not found
; State=23000; ErrorCode=2291
===========> DBExecuteError ORA-02291: integrity
constraint (ACCORTO.C_REGION_LO
CATION) violated - parent key not found

===========> SQL Exception: DB.executeUpdate
SQL=UPDATE AD_OrgInfo SET C_Location_ID=1000006 WHERE
AD_Org_ID=1000003
===========> ORA-02291: integrity constraint
(ACCORTO.C_LOCATION_AD_ORGINFO) vio
lated - parent key not found
; State=23000; ErrorCode=2291
===========> DBExecuteError ORA-02291: integrity
constraint (ACCORTO.C_LOCATION_
AD_ORGINFO) violated - parent key not found

===========> MSetup.createEntities - Location NOT
inserted
===========> SQL Exception: DB.executeUpdate
SQL=INSERT INTO M_Warehouse
(M_Warehouse_ID,AD_Client_ID,AD_Org_ID,IsActive,Crea
ted,CreatedBy,Updated,UpdatedBy,Value,Name,C_Location_I
D,Separator) VALUES (1000
003,1000003,0,'Y',SysDate,0,SysDate,0,'Standard','Stand
ard',1000006,'-')
===========> ORA-02291: integrity constraint
(ACCORTO.C_LOCATION_WAREHOUSE) viol
ated - parent key not found
; State=23000; ErrorCode=2291
===========> DBExecuteError ORA-02291: integrity
constraint (ACCORTO.C_LOCATION_
WAREHOUSE) violated - parent key not found

===========> MSetup.createEntities - Warehouse NOT
inserted
===========> SQL Exception: DB.executeUpdate
SQL=INSERT INTO M_Locator
(M_Locator_ID,AD_Client_ID,AD_Org_ID,IsActive,Created,
CreatedBy,Updated,UpdatedBy,Value,M_Warehouse_ID,X,Y,Z,
PriorityNo,IsDefault) VAL
UES
(1000003,1000003,0,'Y',SysDate,0,SysDate,0,'Standard',1
000003,0,0,0,50,'Y')
===========> ORA-02291: integrity constraint
(ACCORTO.M_WAREHOUSE_LOCATOR) viola
ted - parent key not found
; State=23000; ErrorCode=2291
===========> DBExecuteError ORA-02291: integrity
constraint (ACCORTO.M_WAREHOUSE
_LOCATOR) violated - parent key not found

===========> MSetup.createEntities - Locator NOT
inserted
===========> SQL Exception: DB.executeUpdate
SQL=INSERT INTO C_Location
(C_Location_ID,AD_Client_ID,AD_Org_ID,IsActive,Create
d,CreatedBy,Updated,UpdatedBy,City,C_Country_ID,C_Regio
n_ID) VALUES (1000007,100
0003,0,'Y',SysDate,0,SysDate,0,'city',100,0)
===========> ORA-02291: integrity constraint
(ACCORTO.C_REGION_LOCATION) violate
d - parent key not found
; State=23000; ErrorCode=2291
===========> DBExecuteError ORA-02291: integrity
constraint (ACCORTO.C_REGION_LO
CATION) violated - parent key not found

===========> SQL Exception: DB.executeUpdate
SQL=INSERT INTO C_BPartner_Location
(C_BPartner_Location_ID,AD_Client_ID,AD_Org_
ID,IsActive,Created,CreatedBy,Updated,UpdatedBy,Name,C_
BPartner_ID,C_Location_ID
) VALUES
(1000003,1000003,0,'Y',SysDate,0,SysDate,0,'city',10000
09,1000007)
===========> ORA-02291: integrity constraint
(ACCORTO.CLOCATION_CBPLOCATION) vio
lated - parent key not found
; State=23000; ErrorCode=2291
===========> DBExecuteError ORA-02291: integrity
constraint (ACCORTO.CLOCATION_C
BPLOCATION) violated - parent key not found

===========> MSetup.createEntities - BP_Location NOT
inserted

Discussion

  • Kathy Pink

    Kathy Pink - 2001-11-04
    • assigned_to: kmpink --> jjanke
     
  • Jorg Janke

    Jorg Janke - 2001-11-04
    • assigned_to: jjanke --> nobody
    • milestone: 143825 -->
    • labels: 362040 -->
     
  • Jorg Janke

    Jorg Janke - 2001-11-04

    Logged In: YES
    user_id=87038

    Sorry, a sequence probelem (bug)

     
  • Jorg Janke

    Jorg Janke - 2001-11-04
    • milestone: --> X_Unsupported
    • labels: --> 364562
     
  • Jorg Janke

    Jorg Janke - 2001-11-05

    Logged In: YES
    user_id=87038

    ** Fixed in R2.4 **

     
  • Jorg Janke

    Jorg Janke - 2001-11-05
    • assigned_to: nobody --> jjanke
    • labels: 364562 --> Application Dictionary
    • status: open --> closed-fixed
     

Log in to post a comment.

Get latest updates about Open Source Projects, Conferences and News.

Sign up for the SourceForge newsletter:





No, thanks