Focal Point
[SOLVED] MAINTAIN: Multiple Paths errors

This topic can be found at:
http://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/9827046376

November 21, 2014, 02:53 PM
Deana
[SOLVED] MAINTAIN: Multiple Paths errors
Hello,
I have a maintain program that I am trying to add a new master (vwOffenderEquiv). As soon as I add the new master, I get an error indicating MASTRSTK has multiple paths. My program works correctly without the line 'AND vwOffenderEquiv'. I have not added the logic to use vwOffenderEquiv to the code. I am just adding the line 'AND vwOffenderEquiv' and then trying to compile. I have included the code to create MASTRSTK and the acx and mas files for both tables.

Any ideas?

MAINTAIN FILES
DCSOFNDR01 AND DCSOFNDR07 AND DCSSECUR02 AND vwExamLocation AND vwEquivalencyType AND vwEquivalencyFormat
AND vwOffenderEquiv
FROM MASTRSTK INTO MASTRSTK

INFER dcsofndr01.DCSOFNDR01.DOC_ID INTO MASTRSTK;

COMPUTE
MASTRSTK.PROG_NAME/A5 = ;
MASTRSTK.INMATE_NO/I5 = ;

DCSOFNDR01 acx
SEGNAME=DCSOFNDR01, TABLENAME=C080_WCIS.dbo.DCSOFNDR01, CONNECTION=CORR,
KEYS=1, $

DCSOFNDR01 mas
FILENAME=DCSOFNDR01, SUFFIX=SQLMSS , $
SEGMENT=DCSOFNDR01, SEGTYPE=S0, $
FIELDNAME=DOC_ID, ALIAS=DOC_ID, USAGE=A11, ACTUAL=A11, $
FIELDNAME=SSN, ALIAS=SSN, USAGE=A11, ACTUAL=A11,
MISSING=OFF, $
FIELDNAME=NAME, ALIAS=NAME, USAGE=A30, ACTUAL=A30,
MISSING=OFF, $
FIELDNAME=LAST_NAME, ALIAS=LAST_NAME, USAGE=A20, ACTUAL=A20,
MISSING=OFF, $
FIELDNAME=FIRST_NAME, ALIAS=FIRST_NAME, USAGE=A15, ACTUAL=A15,
MISSING=OFF, $
FIELDNAME=MIDDLE_NAME, ALIAS=MIDDLE_NAME, USAGE=A15, ACTUAL=A15,
MISSING=OFF, $
FIELDNAME=SUR_NAME, ALIAS=SUR_NAME, USAGE=A3, ACTUAL=A3,
MISSING=OFF, $
FIELDNAME=LOCATION, ALIAS=LOCATION, USAGE=A4, ACTUAL=A4,
MISSING=OFF, $
FIELDNAME=STATUS, ALIAS=STATUS, USAGE=A4, ACTUAL=A4,
MISSING=OFF, $
FIELDNAME=STATUS_DATE, ALIAS=STATUS_DATE, USAGE=MDYY, ACTUAL=DATE,
MISSING=OFF, $
FIELDNAME=STATUS_DESC, ALIAS=STATUS_DESC, USAGE=A4, ACTUAL=A4,
MISSING=OFF, $
FIELDNAME=STATE_FROM, ALIAS=STATE_FROM, USAGE=A2, ACTUAL=A2,
MISSING=OFF, $
FIELDNAME=DCI_NO, ALIAS=DCI_NO, USAGE=I7, ACTUAL=I4,
MISSING=OFF, $
FIELDNAME=FBI_NO, ALIAS=FBI_NO, USAGE=A9, ACTUAL=A9,
MISSING=OFF, $
FIELDNAME=SEX, ALIAS=SEX, USAGE=A1, ACTUAL=A1,
MISSING=OFF, $
FIELDNAME=RACE, ALIAS=RACE, USAGE=A1, ACTUAL=A1,
MISSING=OFF, $
FIELDNAME=BIRTH_DATE, ALIAS=BIRTH_DATE, USAGE=MDYY, ACTUAL=DATE,
MISSING=OFF, $
FIELDNAME=BIRTH_CITY, ALIAS=BIRTH_CITY, USAGE=A15, ACTUAL=A15,
MISSING=OFF, $
FIELDNAME=BIRTH_STATE, ALIAS=BIRTH_STATE, USAGE=A2, ACTUAL=A2,
MISSING=OFF, $
FIELDNAME=WY_RES_YRS, ALIAS=WY_RES_YRS, USAGE=I2, ACTUAL=I4,
MISSING=OFF, $
FIELDNAME=US_CITIZEN, ALIAS=US_CITIZEN, USAGE=A1, ACTUAL=A1,
MISSING=OFF, $
FIELDNAME=HEIGHT, ALIAS=HEIGHT, USAGE=A3, ACTUAL=A3,
MISSING=OFF, $
FIELDNAME=WEIGHT, ALIAS=WEIGHT, USAGE=A3, ACTUAL=A3,
MISSING=OFF, $
FIELDNAME=EYES, ALIAS=EYES, USAGE=A3, ACTUAL=A3,
MISSING=OFF, $
FIELDNAME=HAIR, ALIAS=HAIR, USAGE=A3, ACTUAL=A3,
MISSING=OFF, $
FIELDNAME=COMPLEXION, ALIAS=COMPLEXION, USAGE=A1, ACTUAL=A1,
MISSING=OFF, $
FIELDNAME=EDUCATION, ALIAS=EDUCATION, USAGE=A3, ACTUAL=A3,
MISSING=OFF, $
FIELDNAME=OCCUPATION, ALIAS=OCCUPATION, USAGE=A20, ACTUAL=A20,
MISSING=OFF, $
FIELDNAME=OCC_TYPE, ALIAS=OCC_TYPE, USAGE=A1, ACTUAL=A1,
MISSING=OFF, $
FIELDNAME=INCOME, ALIAS=INCOME, USAGE=A5, ACTUAL=A5,
MISSING=OFF, $
FIELDNAME=MARITAL_STAT, ALIAS=MARITAL_STAT, USAGE=A3, ACTUAL=A3,
MISSING=OFF, $
FIELDNAME=DEPENDNTS, ALIAS=DEPENDNTS, USAGE=I2, ACTUAL=I4,
MISSING=OFF, $
FIELDNAME=FAMILY_STAT, ALIAS=FAMILY_STAT, USAGE=A2, ACTUAL=A2,
MISSING=OFF, $
FIELDNAME=MILITARY, ALIAS=MILITARY, USAGE=A1, ACTUAL=A1,
MISSING=OFF, $
FIELDNAME=ADDRESS, ALIAS=ADDRESS, USAGE=A30, ACTUAL=A30,
MISSING=OFF, $
FIELDNAME=CITY, ALIAS=CITY, USAGE=A15, ACTUAL=A15,
MISSING=OFF, $
FIELDNAME=STATE, ALIAS=STATE, USAGE=A2, ACTUAL=A2,
MISSING=OFF, $
FIELDNAME=ZIP, ALIAS=ZIP, USAGE=A10, ACTUAL=A10,
MISSING=OFF, $
FIELDNAME=PRIOR_RESIDE, ALIAS=PRIOR_RESIDE, USAGE=A2, ACTUAL=A2,
MISSING=OFF, $
FIELDNAME=RELIGION, ALIAS=RELIGION, USAGE=A2, ACTUAL=A2,
MISSING=OFF, $
FIELDNAME=SEXO_REG_DT, ALIAS=SEXO_REG_DT, USAGE=MDYY, ACTUAL=DATE,
MISSING=OFF, $
FIELDNAME=SEXO_RISK, ALIAS=SEXO_RISK, USAGE=A1, ACTUAL=A1,
MISSING=OFF, $
FIELDNAME=VIOLENT_RISK, ALIAS=VIOLENT_RISK, USAGE=A1, ACTUAL=A1,
MISSING=OFF, $
FIELDNAME=SUICIDE_RISK, ALIAS=SUICIDE_RISK, USAGE=A1, ACTUAL=A1,
MISSING=OFF, $
FIELDNAME=ESCAPE_RISK, ALIAS=ESCAPE_RISK, USAGE=A1, ACTUAL=A1,
MISSING=OFF, $
FIELDNAME=MENTALLY_ILL, ALIAS=MENTALLY_ILL, USAGE=A1, ACTUAL=A1,
MISSING=OFF, $
FIELDNAME=FAM_IN_PRISN, ALIAS=FAM_IN_PRISN, USAGE=I1, ACTUAL=I4,
MISSING=OFF, $
FIELDNAME=ACQ_IN_PRISN, ALIAS=ACQ_IN_PRISN, USAGE=I1, ACTUAL=I4,
MISSING=OFF, $
FIELDNAME=GANG_MEMBER, ALIAS=GANG_MEMBER, USAGE=A2, ACTUAL=A2,
MISSING=OFF, $
FIELDNAME=PRIOR_CONV, ALIAS=PRIOR_CONV, USAGE=I2, ACTUAL=I4,
MISSING=OFF, $
FIELDNAME=PRIOR_COMM, ALIAS=PRIOR_COMM, USAGE=I2, ACTUAL=I4,
MISSING=OFF, $
FIELDNAME=PRIOR_ARREST, ALIAS=PRIOR_ARREST, USAGE=I2, ACTUAL=I4,
MISSING=OFF, $
FIELDNAME=PRIOR_ESCAPE, ALIAS=PRIOR_ESCAPE, USAGE=I2, ACTUAL=I4,
MISSING=OFF, $
FIELDNAME=PRIOR_DETAIN, ALIAS=PRIOR_DETAIN, USAGE=I2, ACTUAL=I4,
MISSING=OFF, $
FIELDNAME=PROB_VIOLATN, ALIAS=PROB_VIOLATN, USAGE=I2, ACTUAL=I4,
MISSING=OFF, $
FIELDNAME=PARO_VIOLATN, ALIAS=PARO_VIOLATN, USAGE=I2, ACTUAL=I4,
MISSING=OFF, $
FIELDNAME=RELEASES, ALIAS=RELEASES, USAGE=I2, ACTUAL=I4,
MISSING=OFF, $
FIELDNAME=JUV_OFFENSES, ALIAS=JUV_OFFENSES, USAGE=I2, ACTUAL=I4,
MISSING=OFF, $
FIELDNAME=ADT_MIS_CONV, ALIAS=ADT_MIS_CONV, USAGE=I2, ACTUAL=I4,
MISSING=OFF, $
FIELDNAME=ADT_FEL_CONV, ALIAS=ADT_FEL_CONV, USAGE=I2, ACTUAL=I4,
MISSING=OFF, $
FIELDNAME=JUV_PLACEMNT, ALIAS=JUV_PLACEMNT, USAGE=I2, ACTUAL=I4,
MISSING=OFF, $
FIELDNAME=JUV_INSTITUT, ALIAS=JUV_INSTITUT, USAGE=I2, ACTUAL=I4,
MISSING=OFF, $
FIELDNAME=MENTAL_COMIT, ALIAS=MENTAL_COMIT, USAGE=I2, ACTUAL=I4,
MISSING=OFF, $
FIELDNAME=PP_PERIODS, ALIAS=PP_PERIODS, USAGE=I2, ACTUAL=I4,
MISSING=OFF, $
FIELDNAME=SSN_VERIFIED, ALIAS=SSN_VERIFIED, USAGE=A1, ACTUAL=A1,
MISSING=OFF, $
FIELDNAME=ALERT_STATUS, ALIAS=ALERT_STATUS, USAGE=A1, ACTUAL=A1,
MISSING=OFF, $
FIELDNAME=IMAGE_FLAG, ALIAS=IMAGE_FLAG, USAGE=A1, ACTUAL=A1,
MISSING=OFF, $
FIELDNAME=PROTECTED, ALIAS=PROTECTED, USAGE=A1, ACTUAL=A1,
MISSING=OFF, $
FIELDNAME=CASE_WORKER, ALIAS=CASE_WORKER, USAGE=A7, ACTUAL=A7,
MISSING=OFF, $
FIELDNAME=CUSTODY_LVL, ALIAS=CUSTODY_LVL, USAGE=A3, ACTUAL=A3,
MISSING=OFF, $
FIELDNAME=ACCOUNT_BAL, ALIAS=ACCOUNT_BAL, USAGE=P11.2, ACTUAL=P8,
MISSING=OFF, $
FIELDNAME=DISABILITY, ALIAS=DISABILITY, USAGE=A1, ACTUAL=A1,
MISSING=OFF, $
FIELDNAME=HEALTH, ALIAS=HEALTH, USAGE=A15, ACTUAL=A15,
MISSING=OFF, $
FIELDNAME=GLASSES, ALIAS=GLASSES, USAGE=A1, ACTUAL=A1,
MISSING=OFF, $
FIELDNAME=MUSTACHE, ALIAS=MUSTACHE, USAGE=A1, ACTUAL=A1,
MISSING=OFF, $
FIELDNAME=BEARD, ALIAS=BEARD, USAGE=A1, ACTUAL=A1,
MISSING=OFF, $
FIELDNAME=HAIR_LENGTH, ALIAS=HAIR_LENGTH, USAGE=A1, ACTUAL=A1,
MISSING=OFF, $
FIELDNAME=SPEECH, ALIAS=SPEECH, USAGE=A3, ACTUAL=A3,
MISSING=OFF, $
FIELDNAME=TEETH, ALIAS=TEETH, USAGE=A3, ACTUAL=A3,
MISSING=OFF, $
FIELDNAME=BUILD, ALIAS=BUILD, USAGE=A1, ACTUAL=A1,
MISSING=OFF, $
FIELDNAME=PB_HEARG_LOC, ALIAS=PB_HEARG_LOC, USAGE=A4, ACTUAL=A4,
MISSING=OFF, $
FIELDNAME=I_GRIEVANCES, ALIAS=I_GRIEVANCES, USAGE=I2, ACTUAL=I4,
MISSING=OFF, $
FIELDNAME=F_GRIEVANCES, ALIAS=F_GRIEVANCES, USAGE=I2, ACTUAL=I4,
MISSING=OFF, $
FIELDNAME=ADDRESS2, ALIAS=ADDRESS2, USAGE=A30, ACTUAL=A30,
MISSING=OFF, $
FIELDNAME=WOLF_ALIAS, ALIAS=WOLF_ALIAS, USAGE=I2, ACTUAL=I4,
MISSING=OFF, $
FIELDNAME=REVIEW_PER, ALIAS=REVIEW_PER, USAGE=I2, ACTUAL=I4,
MISSING=OFF, $
FIELDNAME=NEXT_RECLASS, ALIAS=NEXT_RECLASS, USAGE=MDYY, ACTUAL=DATE,
MISSING=OFF, $
FIELDNAME=NEXT_NEEDS, ALIAS=NEXT_NEEDS, USAGE=MDYY, ACTUAL=DATE,
MISSING=OFF, $
FIELDNAME=NEXT_TEAM_DT, ALIAS=NEXT_TEAM_DT, USAGE=MDYY, ACTUAL=DATE,
MISSING=OFF, $
FIELDNAME=IQ_DATE, ALIAS=IQ_DATE, USAGE=MDYY, ACTUAL=DATE,
MISSING=OFF, $
FIELDNAME=IQ_SCORE, ALIAS=IQ_SCORE, USAGE=I3, ACTUAL=I4,
MISSING=OFF, $
FIELDNAME=GED_OR_HS, ALIAS=GED_OR_HS, USAGE=A1, ACTUAL=A1,
MISSING=OFF, $
FIELDNAME=CHILD_SUPPRT, ALIAS=CHILD_SUPPRT, USAGE=A1, ACTUAL=A1,
MISSING=OFF, $
FIELDNAME=DEDUCT_REST, ALIAS=DEDUCT_REST, USAGE=A1, ACTUAL=A1,
MISSING=OFF, $
FIELDNAME=DEDUCT_PCT, ALIAS=DEDUCT_PCT, USAGE=I2, ACTUAL=I4,
MISSING=OFF, $
FIELDNAME=TV, ALIAS=TV, USAGE=A1, ACTUAL=A1,
MISSING=OFF, $
FIELDNAME=NAME_CHANGED, ALIAS=NAME_CHANGED, USAGE=A1, ACTUAL=A1,
MISSING=OFF, $
FIELDNAME=PB_HEARG_DT, ALIAS=PB_HEARG_DT, USAGE=MTYY, ACTUAL=DATE,
MISSING=OFF, $
FIELDNAME=DETAINER_FLG, ALIAS=DETAINER_FLG, USAGE=A1, ACTUAL=A1,
MISSING=OFF, $
FIELDNAME=AGGRESS_CAT, ALIAS=AGGRESS_CAT, USAGE=A3, ACTUAL=A3,
MISSING=OFF, $
FIELDNAME=GED_HS_VDATE, ALIAS=GED_HS_VDATE, USAGE=MDYY, ACTUAL=DATE,
MISSING=OFF, $
FIELDNAME=OLD_SGT, ALIAS=OLD_SGT, USAGE=A1, ACTUAL=A1,
MISSING=OFF, $
FIELDNAME=EMPLOYEE_ID, ALIAS=EMPLOYEE_ID, USAGE=A10, ACTUAL=A10,
MISSING=OFF, $
FIELDNAME=PSI_FLAG, ALIAS=PSI_FLAG, USAGE=A1, ACTUAL=A1,
MISSING=OFF, $
FIELDNAME=PB_RPT_FLAG, ALIAS=PB_RPT_FLAG, USAGE=A1, ACTUAL=A1,
MISSING=OFF, $
FIELDNAME=LABEL_FLAG, ALIAS=LABEL_FLAG, USAGE=A1, ACTUAL=A1,
MISSING=OFF, $
FIELDNAME=NATIVE_LANG, ALIAS=NATIVE_LANG, USAGE=A3, ACTUAL=A3,
MISSING=OFF, $
FIELDNAME=LSA_SCHOOL, ALIAS=LSA_SCHOOL, USAGE=A20, ACTUAL=A20,
MISSING=OFF, $
FIELDNAME=LSA_CITY, ALIAS=LSA_CITY, USAGE=A15, ACTUAL=A15,
MISSING=OFF, $
FIELDNAME=LSA_STATE, ALIAS=LSA_STATE, USAGE=A2, ACTUAL=A2,
MISSING=OFF, $
FIELDNAME=LSA_YEAR, ALIAS=LSA_YEAR, USAGE=A4, ACTUAL=A4,
MISSING=OFF, $
FIELDNAME=MAIN_ED_GOAL, ALIAS=MAIN_ED_GOAL, USAGE=A1, ACTUAL=A1,
MISSING=OFF, $
FIELDNAME=SECD_ED_GOAL, ALIAS=SECD_ED_GOAL, USAGE=A1, ACTUAL=A1,
MISSING=OFF, $
FIELDNAME=CONF_INTAKE, ALIAS=CONF_INTAKE, USAGE=A1, ACTUAL=A1,
MISSING=OFF, $
FIELDNAME=CONF_VDATE, ALIAS=CONF_VDATE, USAGE=MDYY, ACTUAL=DATE,
MISSING=OFF, $
FIELDNAME=POD, ALIAS=POD, USAGE=A1, ACTUAL=A1,
MISSING=OFF, $
FIELDNAME=CELL, ALIAS=CELL, USAGE=A3, ACTUAL=A3,
MISSING=OFF, $
FIELDNAME=BED, ALIAS=BED, USAGE=A1, ACTUAL=A1,
MISSING=OFF, $
FIELDNAME=CURR_INO, ALIAS=CURR_INO, USAGE=I5, ACTUAL=I4,
MISSING=OFF, $
FIELDNAME=SSN_CARD, ALIAS=SSN_CARD, USAGE=A1, ACTUAL=A1,
MISSING=OFF, $
FIELDNAME=SSN_CARD_DT, ALIAS=SSN_CARD_DT, USAGE=MDYY, ACTUAL=DATE,
MISSING=OFF, $
FIELDNAME=SSN_CARD_ID, ALIAS=SSN_CARD_ID, USAGE=A7, ACTUAL=A7,
MISSING=OFF, $
FIELDNAME=BIRTH_CERT, ALIAS=BIRTH_CERT, USAGE=A1, ACTUAL=A1,
MISSING=OFF, $
FIELDNAME=BIRTH_CRT_DT, ALIAS=BIRTH_CRT_DT, USAGE=MDYY, ACTUAL=DATE,
MISSING=OFF, $
FIELDNAME=BIRTH_CRT_ID, ALIAS=BIRTH_CRT_ID, USAGE=A7, ACTUAL=A7,
MISSING=OFF, $
FIELDNAME=DLN_CARD, ALIAS=DLN_CARD, USAGE=A1, ACTUAL=A1,
MISSING=OFF, $
FIELDNAME=DLN_CARD_DT, ALIAS=DLN_CARD_DT, USAGE=MDYY, ACTUAL=DATE,
MISSING=OFF, $
FIELDNAME=DLN_CARD_ID, ALIAS=DLN_CARD_ID, USAGE=A7, ACTUAL=A7,
MISSING=OFF, $
FIELDNAME=LAST_UPDT_DT01, ALIAS=LAST_UPDT_DT01, USAGE=HMDYYs, ACTUAL=HYYMDs,
MISSING=OFF, $
FIELDNAME=LAST_UPDT_ID01, ALIAS=LAST_UPDT_ID01, USAGE=A7, ACTUAL=A7,
MISSING=OFF, $
FIELDNAME=DLN_EXPIRE_DT, ALIAS=DLN_EXPIRE_DT, USAGE=MDYY, ACTUAL=DATE,
MISSING=OFF, $
FIELDNAME=CRC_DATE, ALIAS=CRC_DATE, USAGE=MDYY, ACTUAL=DATE,
MISSING=OFF, $
FIELDNAME=CRC_TYPE, ALIAS=CRC_TYPE, USAGE=A1, ACTUAL=A1,
MISSING=OFF, $
FIELDNAME=DWS_PART_DT, ALIAS=DWS_PART_DT, USAGE=MDYY, ACTUAL=DATE,
MISSING=OFF, $
FIELDNAME=ECM_FLAG, ALIAS=ECM_FLAG, USAGE=A1, ACTUAL=A1,
MISSING=OFF, $
FIELDNAME=PERSONAL_ITEMS, ALIAS=PERSONAL_ITEMS, USAGE=A1, ACTUAL=A1,
MISSING=OFF, $
FIELDNAME=SPEC_STATUS, ALIAS=SPEC_STATUS, USAGE=A4, ACTUAL=A4,
MISSING=OFF, $
FIELDNAME=SPEC_STATUS_DT, ALIAS=SPEC_STATUS_DT, USAGE=MDYY, ACTUAL=DATE,
MISSING=OFF, $
FIELDNAME=VULNER_CAT, ALIAS=VULNER_CAT, USAGE=A5, ACTUAL=A5,
MISSING=OFF, $
FIELDNAME=TBISTATUSID, ALIAS=TBISTATUSID, USAGE=I3, ACTUAL=I4,
MISSING=OFF, $
FIELDNAME=DDISSTATUSID, ALIAS=DDISSTATUSID, USAGE=I3, ACTUAL=I4,
MISSING=OFF, $
FIELDNAME=LDISSTATUSID, ALIAS=LDISSTATUSID, USAGE=I3, ACTUAL=I4,
MISSING=OFF, $
FIELDNAME=JETSTATUSID, ALIAS=JETSTATUSID, USAGE=I3, ACTUAL=I4,
MISSING=OFF, $
FIELDNAME=RELIGIONDATEDECLARED, ALIAS=RELIGIONDATEDECLARED, USAGE=MDYY, ACTUAL=DATE,
MISSING=OFF, $

vwoffenderequiv acx
SEGNAME=VWOFFENDEREQUIV, TABLENAME=C080_WCIS.dbo.vwOffenderEquiv, CONNECTION=CORR,
KEYS=0, $

vwoffenderequiv mas
FILENAME=VWOFFENDEREQUIV, SUFFIX=SQLMSS , $
SEGMENT=VWOFFENDEREQUIV, SEGTYPE=S0, $
FIELDNAME=OFFENDEREDEQUIVALENCYID, ALIAS=OffenderEdEquivalencyID, USAGE=I11, ACTUAL=I4, $
FIELDNAME=DOCID, ALIAS=DocID, USAGE=A11, ACTUAL=A11, $
FIELDNAME=EDEQUIVALENCYTYPEID, ALIAS=EdEquivalencyTypeID, USAGE=I11, ACTUAL=I4, $
FIELDNAME=EDEQUIVALENCYVERSIONSUBJECTID, ALIAS=EdEquivalencyVersionSubjectID, USAGE=I11, ACTUAL=I4, $
FIELDNAME=EDEQUIVALENCYVERSIONID, ALIAS=EdEquivalencyVersionID, USAGE=I11, ACTUAL=I4, $
FIELDNAME=EDEQUIVALENCYSUBJECTID, ALIAS=EdEquivalencySubjectID, USAGE=I11, ACTUAL=I4, $
FIELDNAME=EDEQUIVALENCYFORMID, ALIAS=EdEquivalencyFormID, USAGE=I11, ACTUAL=I4, $
FIELDNAME=EDEQUIVALENCYFORMATID, ALIAS=EdEquivalencyFormatID, USAGE=I11, ACTUAL=I4, $
FIELDNAME=EDEQUIVALENCYEXAMSTATUSID, ALIAS=EdEquivalencyExamStatusID, USAGE=I11, ACTUAL=I4, $
FIELDNAME=FACILITYID, ALIAS=FacilityID, USAGE=I11, ACTUAL=I4,
MISSING=ON, $
FIELDNAME=TYPENAME, ALIAS=TypeName, USAGE=A50V, ACTUAL=A50V, $
FIELDNAME=VERSIONNAME, ALIAS=VersionName, USAGE=A50V, ACTUAL=A50V, $
FIELDNAME=SUBJECTNAME, ALIAS=SubjectName, USAGE=A20V, ACTUAL=A20V, $
FIELDNAME=FORMNAME, ALIAS=FormName, USAGE=A20V, ACTUAL=A20V, $
FIELDNAME=FORMATDESCRIPTION, ALIAS=FormatDescription, USAGE=A20V, ACTUAL=A20V, $
FIELDNAME=FORMATCODE, ALIAS=FormatCode, USAGE=A4V, ACTUAL=A4V, $
FIELDNAME=OFFICIALPRACTICETEST, ALIAS=OfficialPracticeTest, USAGE=A3V, ACTUAL=A3V, $
FIELDNAME=EXAMSTATUSCODE, ALIAS=ExamStatusCode, USAGE=A4V, ACTUAL=A4V, $
FIELDNAME=EXAMSTATUSDESC, ALIAS=ExamStatusDesc, USAGE=A20V, ACTUAL=A20V, $
FIELDNAME=TESTDATE, ALIAS=TestDate, USAGE=MDYY, ACTUAL=DATE, $
FIELDNAME=TESTFACILITYCODE, ALIAS=TestFacilityCode, USAGE=A10V, ACTUAL=A10V,
MISSING=ON, $
FIELDNAME=LOCATION, ALIAS=Location, USAGE=A50V, ACTUAL=A50V,
MISSING=ON, $
FIELDNAME=SCORE, ALIAS=Score, USAGE=I11, ACTUAL=I4, $
FIELDNAME=EQUIVALENCYRANK, ALIAS=EquivalencyRank, USAGE=I11, ACTUAL=I4,
MISSING=ON, $
FIELDNAME=CREATEDDATE, ALIAS=CreatedDate, USAGE=HMDYYs, ACTUAL=HYYMDs, $
FIELDNAME=CREATEDBY, ALIAS=CreatedBy, USAGE=A7, ACTUAL=A7, $
FIELDNAME=MODIFIEDDATE, ALIAS=ModifiedDate, USAGE=HMDYYs, ACTUAL=HYYMDs, $
FIELDNAME=MODIFIEDBY, ALIAS=ModifiedBy, USAGE=A7, ACTUAL=A7, $

This message has been edited. Last edited by: Deana,


WebFOCUS 7.6.8 and 7.7.03; Windows Server 2003 R2 and Windows Server 2008 R2, respectively; Development environments - Windows Server 2003 R2 and Windows 7 Professional, respectively;
excel, html, pdf
November 21, 2014, 03:40 PM
Alan B
I've had this before, but cannot remember why!

I have noticed that the field LOCATION is in DCSOFNDR01 and vwoffenderequiv, and the field SCORE is also in DCSOFNDR01 and vwoffenderequiv; DCSOFNDR01 is also being inferred.

My first idea would be to just remove those fields from vwoffenderequiv and see if that makes any difference.


Alan.
WF 7.705/8.007
November 21, 2014, 04:08 PM
Deana
Alan,
Thank you for your response. Score and location in each table relates to different data. I renamed Score to ExamScore and Location to ExamLocation in vwoffenderequiv. This did not fix the problem.

The alpha fields in the underlying tables used to create the view are not define as variable 'A20V'. I tried removing the variable definitions, to no avail.

Another odd part of this message, is indicates the error occurs on the winform and MASTRSTK is not referred to anywhere on the winform.

Thanks again,
Deana


WebFOCUS 7.6.8 and 7.7.03; Windows Server 2003 R2 and Windows Server 2008 R2, respectively; Development environments - Windows Server 2003 R2 and Windows 7 Professional, respectively;
excel, html, pdf
November 21, 2014, 05:27 PM
Alan B
Ok. WINFORM and object binding comes to mind. I would take a backup of the .mnt and .wfm and then unbind objects on the WINFORM one by one.


Alan.
WF 7.705/8.007
November 21, 2014, 05:52 PM
Deana
I have looked at the bindings for all of the controls on the form and none of them are bound to MASTRSTK.

I was able to successfully manually define the stack that would be populated with data from vwoffenderequiv and then CALL another maintain that populates this stack. Since this is another call, it takes more resources than just within my initial maintain, but works.

I have run into another master that is giving me the same error, but with a different file.

I am appreciative of your suggestion and will try unbinding each of the controls one at a time, when I return to the office on Dec 1.

Thank you


WebFOCUS 7.6.8 and 7.7.03; Windows Server 2003 R2 and Windows Server 2008 R2, respectively; Development environments - Windows Server 2003 R2 and Windows 7 Professional, respectively;
excel, html, pdf
November 24, 2014, 08:56 AM
Maintain Wizard
Deana
Look at any fields in the WHERE clauses of your NEXT statements. If the field in the WHERE clause is in more than one Master file it MUST be prefaced by the MASTER name. For example:

For all next MOVIES.Moviecode into stk
where Movies.Category eq 'ACTION'

If you are getting the error in the WFM file then it could be in a binding or in code behind an event. If you are getting it in the MNT file then it is in the code. If you cannot find it, zip up the Masters and MNT file and send it to me!

Mark Derwin
Mark_Derwin@ibi.com
December 04, 2014, 10:05 AM
Deana
Mark,
I have looked at the code. I have fully qualified the fields in the INFER and NEXT Statements but not the where statements. I will give this a try. I am currently putting out other fires and have training the first part of next week so I may not be able to get to this until next Thursday (the 11th).

I am hopeful this will fix the problem.

Thanks,
Deana


WebFOCUS 7.6.8 and 7.7.03; Windows Server 2003 R2 and Windows Server 2008 R2, respectively; Development environments - Windows Server 2003 R2 and Windows 7 Professional, respectively;
excel, html, pdf
March 19, 2015, 09:56 AM
Deana
Mark,
Sorry for the delay in the response. Fully qualifying the WHERE statements fixed my problem. Thank you for your help.
Deana


WebFOCUS 7.6.8 and 7.7.03; Windows Server 2003 R2 and Windows Server 2008 R2, respectively; Development environments - Windows Server 2003 R2 and Windows 7 Professional, respectively;
excel, html, pdf