[Search for users]
[Overall Top Noters]
[List of all Conferences]
[Download this site]
| Title: | FOCUS, from INFORMATION BUILDERS |
|
| Moderator: | ZAYIUS::BROUILLETTE |
|
| Created: | Thu Feb 19 1987 |
| Last Modified: | Mon May 05 1997 |
| Last Successful Update: | Fri Jun 06 1997 |
| Number of topics: | 615 |
| Total number of notes: | 1779 |
307.0. "FOC errors 1469 and 1462 RDB Prepare Request Error" by KLO::LOGAN (DECkchair Attendant ) Thu Feb 01 1990 12:06
I've included the error message obtained when I execute the .FEX shown
below. I've also included the .MAS and .ACX files. I'd appreciate any
help on where I'm going wrong.
Regards,
Andy.
ERROR MESSAGE
+++++++++++++
>>>> JOININT CALLED TO READ DATA
NUMBER OF RECORDS IN TABLE= 1973 LINES= 85
HOLDING... FORMAT DOC
>>(FOC1469) ERROR IN ACCESSING : QUALDB/TEST
(FOC1462) RDB PREPARE REQUEST ERROR. RDBCODE IS : 01388122
%RDB-E-OBSOLETE_METADA, request references metadata objects that no longer exist
-RDMS-F-BAD_SYM, unknown field symbol - FAILURE_CODE
.FEX
++++
SET PRINT=OFFLINE
SET LINES=56
-*
-* This FOCEXEC calculates the Total number of boards tested, failed
-* and the Yield on a product basis. DAL 30-NOV-1989
-*
DEFINE FILE QUALDB
FC/A4 = EDIT(FAILURE_CODE,'9999');
FAIL/I3 = QUANTITY_FAI / 1;
END
-IF &WORKSTATION EQ 'ALL' GOTO ALL_WORK ELSE GOTO ONE_WORK;
-ALL_WORK
TABLE FILE QUALDB
HEADING CENTER
"</1"
"Yield / Product Basis <60 &DATE""
"</1"
SUM QUANTITY_TES AS '# Boards, Tested'
AND QUANTITY_FAI AS '# Boards, Failed'
AND COMPUTE YIELD/D8.2 = (QUANTITY_FAI/QUANTITY_TES) * 100;
AS '% Yield, Loss'
BY WORKSTATION_ AS 'STATION, ID'
BY PART_ID AS 'PRODUCT'
IF DATE_TIME IS-FROM &START_DATE TO &END_DATE
ON TABLE HOLD AS 'def_yie' FORMAT DOC
FOOTING
"</1"
"Total number of boards tested = <TOT.QUANTITY_TES"
"Total number of boards failed = <TOT.QUANTITY_FAI"
END
-RUN
TABLE FILE QUALDB
HEADING CENTER
"</1"
"Defects for Workstation ID &WORKSTATION <60 &DATE"
"</1"
SUM FAIL AS 'Fails,'
BY WORKSTATION_ AS 'STATION, ID'
BY PART_ID AS 'Product' COLUMN-TOTAL AS ' Total,Defects'
ACROSS FC AS 'Failure Code' ROW-TOTAL
IF DATE_TIME IS-FROM &START_DATE TO &END_DATE
ON TABLE HOLD AS 'def_yie' FORMAT DOC
END
-GOTO END_ALL
-ONE_WORK
TABLE FILE QUALDB
HEADING CENTER
"</1"
"Yield / Product Basis <60 &DATE""
"</1"
SUM QUANTITY_TES AS '# Boards, Tested'
AND QUANTITY_FAI AS '# Boards, Failed'
AND COMPUTE YIELD/D8.2 = (QUANTITY_FAI/QUANTITY_TES) * 100;
AS '% Yield, Loss'
BY PART_ID AS 'PRODUCT'
IF WORKSTATION_ CONTAINS '&WORKSTATION'
IF DATE_TIME IS-FROM &START_DATE TO &END_DATE
ON TABLE HOLD AS 'def_yie' FORMAT DOC
FOOTING
"</1"
"Total number of boards tested = <TOT.QUANTITY_TES"
"Total number of boards failed = <TOT.QUANTITY_FAI"
END
-RUN
TABLE FILE QUALDB
HEADING CENTER
"</1"
"Defects for Workstation ID &WORKSTATION <60 &DATE"
"</1"
SUM FAIL AS 'Fails,'
BY PART_ID AS 'Product' COLUMN-TOTAL AS ' Total,Defects'
ACROSS FC AS 'Failure Code' ROW-TOTAL
IF WORKSTATION_ CONTAINS '&WORKSTATION'
IF DATE_TIME IS-FROM &START_DATE TO &END_DATE
ON TABLE HOLD AS 'def_yie' FORMAT DOC
END
-END_ALL
.MAS
++++
FILE=QUALDB , SUFFIX=RDB,$
SEGMENT=TEST , SEGTYPE=S0,$
FIELD=PART_ID , ,A25 ,A25 ,,$
FIELD=GROUP_ID , ,A20 ,A20 ,,$
FIELD=SERIAL_NUM , ,A10 ,A10 ,,$
FIELD=PROCESS_KEY , ,I9 ,I4 ,,$
FIELD=OPERATION_CO, ,A6 ,A6 ,,$
FIELD=TDR_LOOP_COU, ,I9 ,I4 ,,$
FIELD=TEST_ID , ,I9 ,I4 ,,$
FIELD=WORKSTATION_, ,A10 ,A10 ,,$
FIELD=QUANTITY_TES, ,I9 ,I4 ,,$
FIELD=QUANTITY_FAI, ,I9 ,I4 ,,$
FIELD=RETRY_COUNT , ,I9 ,I4 ,,$
FIELD=RESOURCE_ID , ,A10 ,A10 ,,$
FIELD=MACHINE_ID , ,A10 ,A10 ,,$
FIELD=TEST_TYPE , ,I9 ,I4 ,,$
FIELD=DATE_TIME , ,A8YYMD ,A16 ,,$
SEGMENT=SUM_TEST, SEGTYPE=S0, PARENT=TEST,$
FIELD=TS_TEST_ID , ,I9 ,I4 ,,$
FIELD=TS_LOOP_COUN, ,I9 ,I4 ,,$
FIELD=FAILURE_CODE, ,A8 ,A8 ,,$
FIELD=DEFECT_QUANT, ,I9 ,I4 ,,$
SEGNAME=DIAGNOSE, SEGTYPE=S0,PARENT=SUM_TEST,$
FIELD=D_TEST_ID , ,I9 ,I4 ,,$
FIELD=D_LOOP_COU , ,I9 ,I4 ,,$
FIELD=OBSERVATION_, ,I9 ,I4 ,,$
FIELD=DIAGNOSIS_ID, ,I9 ,I4 ,,$
FIELD=D_PROCESS_KE, ,I9 ,I4 ,,$
FIELD=D_OPERATION , ,A6 ,A6 ,,$
FIELD=D_FAIL_CO , ,A8 ,A8 ,,$
FIELD=D_DATE_CODE , ,A6 ,A6 ,,$
FIELD=D_WORKSTATIO, ,A10 ,A10 ,,$
FIELD=D_REC_REP_CO, ,A4 ,A4 ,,$
FIELD=COMPONENT_PA, ,A25 ,A25 ,,$
FIELD=COMPONENT_SE, ,A10 ,A10 ,,$
FIELD=COMPONENT_TY, ,A10 ,A10 ,,$
FIELD=D_VENDOR_COD, ,A10 ,A10 ,,$
FIELD=D_RESOUR_ID , ,A10 ,A10 ,,$
FIELD=DIAGNOSTIC_C, ,A100 ,A100 ,,$
FIELD=D_DATE_TIME , ,A8YYMD ,A16 ,,$
FIELD=REF_DESIG_1 , ,A8 ,A8 ,,$
FIELD=REF_DESIG_2 , ,A8 ,A8 ,,$
SEGMENT=REP_QUAL , SEGTYPE=S0, PARENT=DIAGNOSE,$
FIELD=R_TEST_ID , ,I9 ,I4 ,,$
FIELD=R_TDR_LOOP_C, ,I9 ,I4 ,,$
FIELD=R_OBSERVATIO, ,I9 ,I4 ,,$
FIELD=R_DIAGNOS_ID, ,I9 ,I4 ,,$
FIELD=R_PROC_KEY , ,I9 ,I4 ,,$
FIELD=R_OPER_CO , ,A6 ,A6 ,,$
FIELD=R_RESOUR_ID , ,A10 ,A10 ,,$
FIELD=R_WORKST_ID , ,A10 ,A10 ,,$
FIELD=R_REPAIR_COD, ,A4 ,A4 ,,$
FIELD=R_REPAIR_COM, ,A100 ,A100 ,,$
FIELD=R_DATE_TIME , ,A8YYMD ,A16 ,,$
.ACX
++++
SEGNAME=TEST ,TABLENAME="TEST",$
FIELD=PART_ID , ALIAS=PART_ID ,$
FIELD=GROUP_ID , ALIAS=GROUP_ID ,$
FIELD=SERIAL_NUM , ALIAS=SERIAL_NUM ,$
FIELD=PROCESS_KEY , ALIAS=PROCESS_KEY ,$
FIELD=OPERATION_CO, ALIAS=OPERATION_CODE ,$
FIELD=TDR_LOOP_COU, ALIAS=TDR_LOOP_COUNT ,$
FIELD=TEST_ID , ALIAS=TEST_ID ,$
FIELD=WORKSTATION_, ALIAS=WORKSTATION_ID ,$
FIELD=QUANTITY_TES, ALIAS=QUANTITY_TESTED ,$
FIELD=QUANTITY_FAI, ALIAS=QUANTITY_FAILED ,$
FIELD=RETRY_COUNT , ALIAS=RETRY_COUNT ,$
FIELD=RESOURCE_ID , ALIAS=RESOURCE_ID ,$
FIELD=MACHINE_ID , ALIAS=MACHINE_ID ,$
FIELD=TEST_TYPE , ALIAS=TEST_TYPE ,$
FIELD=DATE_TIME , ALIAS=DATE_TIME ,$
SEGNAME=SUM_TEST ,TABLENAME="TEST_SUMMARY",
KEYFLD=TEST_ID/TDR_LOOP_COU, IXFLD=TS_TEST_ID/TS_LOOP_COUN,$
FIELD=TS_TEST_ID , ALIAS=TEST_ID ,$
FIELD=TS_LOOP_COUN, ALIAS=TDR_LOOP_COUNT ,$
FIELD=FAILURE_CODE, ALIAS=FAILURE_CODE ,$
FIELD=DEFECT_QUANT, ALIAS=DEFECT_QUANTITY,$
SEGNAME=DIAGNOSE,TABLENAME="DIAGNOSE",
KEYFLD=TS_TEST_ID/TS_LOOP_COUN/FAILURE_CODE, IXFLD=D_TEST_ID/D_LOOP_COU/D_FAIL_CODE,$
FIELD=D_TEST_ID ,ALIAS=TEST_ID ,$
FIELD=D_LOOP_COU ,ALIAS=TDR_LOOP_COU ,$
FIELD=OBSERVATION_,ALIAS=OBSERVATION_ID ,$
FIELD=DIAGNOSIS_ID,ALIAS=DIAGNOSIS_ID ,$
FIELD=D_PROCESS_KE,ALIAS=PROCESS_KEY ,$
FIELD=D_OPERATION ,ALIAS=OPERATION_CODE ,$
FIELD=D_FAIL_CO ,ALIAS=FAILURE_CODE ,$
FIELD=D_DATE_CODE ,ALIAS=DATE_CODE ,$
FIELD=D_WORKSTATIO,ALIAS=WORKSTATION_ID ,$
FIELD=D_REC_REP_CO,ALIAS=RECOMMENDED_REPAIR_CODE ,$
FIELD=COMPONENT_PA,ALIAS=COMPONENT_PART_ID ,$
FIELD=COMPONENT_SE,ALIAS=COMPONENT_SERIAL_NUM ,$
FIELD=COMPONENT_TY,ALIAS=COMPONENT_TYPE ,$
FIELD=D_VENDOR_COD,ALIAS=VENDOR_CODE ,$
FIELD=D_RESOUR_ID ,ALIAS=RESOURCE_ID ,$
FIELD=DIAGNOSTIC_C,ALIAS=DIAGNOSTIC_COMMENT ,$
FIELD=D_DATE_TIME ,ALIAS=DATE_TIME ,$
FIELD=REF_DESIG_1 ,ALIAS=COMPONENT_REF_DESIGNATOR_1,$
FIELD=REF_DESIG_2 ,ALIAS=COMPONENT_REF_DESIGNATOR_2,$
SEGNAME=REP_QUAL ,TABLENAME="REPAIR",
KEYFLD=D_TEST_ID/D_LOOP_COU/D_WORKSTATIO/D_OPERATION/D_RESOUR_ID/D_DATE_TIME,
IXFLD=R_TEST_ID/R_TDR_LOOP_C/R_WORKST_ID/R_OPER_CO/R_RESOUR_ID/R_DATE_TIME,$
FIELD=R_TEST_ID , ALIAS=TEST_ID ,$
FIELD=R_TDR_LOOP_C, ALIAS=TDR_LOOP_COUNT ,$
FIELD=R_OBSERVATIO, ALIAS=OBSERVATION_ID ,$
FIELD=R_DIAGNOS_ID, ALIAS=DIAGNOSIS_ID ,$
FIELD=R_PROC_KEY , ALIAS=PROCESS_KEY ,$
FIELD=R_OPER_CO , ALIAS=OPERATION_CODE ,$
FIELD=R_RESOUR_ID , ALIAS=RESOURCE_ID ,$
FIELD=R_WORKST_ID , ALIAS=WORKSTATION_ID ,$
FIELD=R_REPAIR_COD, ALIAS=REPAIR_CODE ,$
FIELD=R_REPAIR_COM, ALIAS=REPAIR_COMMENT ,$
FIELD=R_DATE_TIME , ALIAS=DATE_TIME ,$
| T.R | Title | User | Personal
Name | Date | Lines |
|---|
| 307.1 | What version?andy.logan
| PLOP::COYLE | | Thu Feb 01 1990 15:42 | 12 |
| Andy,
What version of FOCUS are you running? Has this FEX worked at
some time before or only after an upgrade? Is it failing on either route thru
the .FEX ? Have you tried it without the ON TABLE HOLD command?
I am running 5.2.2 and created a similar .FEX that seems to work
O.K. Maybe you can try to isolate the problem by limiting it to one
TABLE command and then trying it without the DEFINES..etc.
KC
|
| 307.2 | It worked before. | KLO::LOGAN | DECkchair Attendant | Fri Feb 02 1990 03:30 | 7 |
| This .FEX worked before, no problem. FOCUS version 5.2.
This seems to be an intermittent problem. It's not the first time that
I've come across it and not just with this particular .FEX either.
The .FEX goes through the first part of the program then bombs out with
the error message shown.
|
| 307.3 | Problem sorted, Thanks. | KLO::LOGAN | DECkchair Attendant | Fri Feb 02 1990 04:23 | 26 |
| <<< SHIRE::BEORN:[NOTES$LIBRARY]FOCUS.NOTE;1 >>>
-< European FOCUS Notes Conference >-
================================================================================
Note 199.3 FOC Errors 1469 and 1462 RDB Prepare Request Error 3 of 4
GVAADG::HASSINE 6 lines 2-FEB-1990 09:44
-< TAB in relation name >-
--------------------------------------------------------------------------------
I had sometimes 'OBSOLETE METADATA' error when in the ACX file,
I don't trim all irrelevant tabulations after RDB relation name.
Maybe this help ?
David.
================================================================================
Note 199.4 FOC Errors 1469 and 1462 RDB Prepare Request Error 4 of 4
KLO::LOGAN "DECkchair Attendant " 8 lines 2-FEB-1990 10:24
-< You've got it. >-
--------------------------------------------------------------------------------
BINGO
That seems to have sorted the problem out, David.
Thanks for your help.
Regards,
Andy.
|
| 307.4 | What's in FAILURE_CODE | ESSB::BROCKLEBANK | | Fri Feb 02 1990 09:18 | 6 |
| I can only suggest that you try Kevin's suggestion to break the
procedure into seperate Table file etc procedures and see which one
fails. It may be worth trying to reproduce the request in RDO to
check that the data is OK. The fact that FAILURE_CODE is mentioned
and that it is also part of the key of that relation, it may be
that there is some 'funny' data in that field.
|