Focal Point Banner


As of December 1, 2020, Focal Point is retired and repurposed as a reference repository. We value the wealth of knowledge that's been shared here over the years. You'll continue to have access to this treasure trove of knowledge, for search purposes only.

Join the TIBCO Community
TIBCO Community is a collaborative space for users to share knowledge and support one another in making the best use of TIBCO products and services. There are several TIBCO WebFOCUS resources in the community.

  • From the Home page, select Predict: WebFOCUS to view articles, questions, and trending articles.
  • Select Products from the top navigation bar, scroll, and then select the TIBCO WebFOCUS product page to view product overview, articles, and discussions.
  • Request access to the private WebFOCUS User Group (login required) to network with fellow members.

Former myibi community members should have received an email on 8/3/22 to activate their user accounts to join the community. Check your Spam folder for the email. Please get in touch with us at community@tibco.com for further assistance. Reference the community FAQ to learn more about the community.


Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [SOLVED] MAINTAIN: Multiple Paths errors

Read-Only Read-Only Topic
Go
Search
Notify
Tools
[SOLVED] MAINTAIN: Multiple Paths errors
 Login/Join
 
Gold member
posted
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
 
Posts: 89 | Registered: March 19, 2011Report This Post
Virtuoso
posted Hide Post
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
 
Posts: 1451 | Location: Portugal | Registered: February 07, 2007Report This Post
Gold member
posted Hide Post
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
 
Posts: 89 | Registered: March 19, 2011Report This Post
Virtuoso
posted Hide Post
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
 
Posts: 1451 | Location: Portugal | Registered: February 07, 2007Report This Post
Gold member
posted Hide Post
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
 
Posts: 89 | Registered: March 19, 2011Report This Post
Master
posted Hide Post
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
 
Posts: 663 | Location: New York | Registered: May 08, 2003Report This Post
Gold member
posted Hide Post
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
 
Posts: 89 | Registered: March 19, 2011Report This Post
Gold member
posted Hide Post
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
 
Posts: 89 | Registered: March 19, 2011Report This Post
  Powered by Social Strata  

Read-Only Read-Only Topic

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [SOLVED] MAINTAIN: Multiple Paths errors

Copyright © 1996-2020 Information Builders