Home » Developer & Programmer » Designer » How to debug "Error: Child Recod Found"
How to debug "Error: Child Recod Found" [message #90451] Wed, 08 October 2003 12:25
Muhammad Waqas Shabir
Messages: 26
Registered: April 2003
Junior Member
I have Made following tables:
Create TABLE WING(
W_CodV35Pk VARCHAR2(35),
W_DescV100 VARCHAR2(100),
CONSTRAINT W_PK PRIMARY KEY (W_CodV35Pk)
);

Create TABLE THEMATIC_AREA(
TA_CodV35Pk VARCHAR2(35),
TA_W_CodV35PkFk VARCHAR2(35),
TA_DescriptionV50 VARCHAR2(50),
CONSTRAINT TA_PK PRIMARY KEY (TA_CodV35Pk,TA_W_CodV35PkFk),
CONSTRAINT TA_FK1 FOREIGN KEY (TA_W_CodV35PkFk) REFERENCES WING(W_CodV35Pk)
);

Create TABLE SYSTEM_ROLE(
SR_CodV35Pk VARCHAR2(35),
SR_DescV50 VARCHAR2(50),
CONSTRAINT SR_PK PRIMARY KEY (SR_CodV35Pk)
);

Create TABLE DESIGNATION(
Des_CodV35Pk VARCHAR2(35),
des_W_CodV35PkFk VARCHAR2(35),
Des_DescV50 VARCHAR2(50),
CONSTRAINT Des_PK PRIMARY KEY (Des_CodV35Pk,des_W_CodV35PkFk),
CONSTRAINT Des_FK1 FOREIGN KEY (Des_W_CodV35PkFk) REFERENCES WING(W_CodV35Pk)
);
------------------------------------
Create TABLE SYSTEM_USER(
SU_NameV50Pk VARCHAR2(50),
SU_PwdV35Pk VARCHAR2(35),
SU_W_CodV35PkFk VARCHAR2(35),
SU_TitleV35 VARCHAR2(35),
SU_Des_CodV35Fk VARCHAR2(35),
SU_EmailV35 VARCHAR2(35),
SU_QualificationV300 VARCHAR2(300),
SU_SpecializationV300 VARCHAR2(300),
SU_JobDescV300 VARCHAR2(300),
SU_ExpV300 VARCHAR2(300),
SU_SecQuestV100 VARCHAR2(100),
SU_SecAnsV100 VARCHAR2(100),
SU_SessTimeoutV2 VARCHAR2(2),
SU_Statusv1 VARCHAR2(1),
CONSTRAINT SU_PK PRIMARY KEY (SU_NameV50Pk,SU_PwdV35Pk,SU_W_CodV35PkFk),
CONSTRAINT SU_FK1 FOREIGN KEY (SU_W_CodV35PkFk) REFERENCES WING(W_CodV35Pk),
CONSTRAINT SU_FK2 FOREIGN KEY (SU_Des_CodV35Fk,SU_W_CodV35PkFk) REFERENCES DESIGNATION(Des_CodV35Pk,Des_W_CodV35PkFk)
);

Create TABLE ROLE_ASSIGNMENT(
RA_SU_NameV50PkFk VARCHAR2(50),
RA_SU_PwdV35PkFk VARCHAR2(35),
RA_TA_CodV35PkFk VARCHAR2(35),
RA_W_CodV35PkFk VARCHAR2(35),
RA_SR_CodV35PKFk VARCHAR2(35),
CONSTRAINT RA_PK PRIMARY KEY (RA_SU_NameV50PkFk,RA_SU_PwdV35PkFk,RA_TA_CodV35PkFk,RA_SR_CodV35PKFk),
CONSTRAINT RA_FK1 FOREIGN KEY (RA_SU_NameV50PkFk,RA_SU_PwdV35PkFk,RA_W_CodV35PkFk) REFERENCES SYSTEM_USER(SU_NameV50Pk,SU_PwdV35Pk,SU_W_CodV35PkFk),
CONSTRAINT RA_FK2 FOREIGN KEY (RA_TA_CodV35PkFk,RA_W_CodV35PkFk) REFERENCES THEMATIC_AREA(TA_CodV35Pk,TA_W_CodV35PkFk),
CONSTRAINT RA_FK4 FOREIGN KEY (RA_SR_CodV35PKFk) REFERENCES SYSTEM_ROLE(SR_CodV35Pk)
);
------------------------------------

When i update the values of primary key[[RA_SU_NameV50PkFk]] in master table[[System_user]], i get this error "Error: Child Recod Found" which says that i am violating RA_FK1. Despite of the fact that children should be automatically be updated.

So i can not do update operation on my site.

What is causing this & How to eliminate this?

Thanks in anticipation.
Previous Topic: Installing Repository Instance(Designer6i)
Next Topic: DBA init.ora file clarification
Goto Forum:
  


Current Time: Fri Mar 29 04:33:41 CDT 2024