Originally created using Dev Studio and WF 7.1.04.
I used WF 8.1.04M to modify, but is not backward compatible. Problems happening in first 5 or so lines. Hope someone can help me. Have broken access to the old site. Please see code snippet below:

-* File: IBFS:/Development/WFC/Repository/training/std_reports/jackieo1s6bm/ProfessionalVistatReport.fex Created by WebFOCUS AppStudio
-*WHENCE JO_HOLD1 MASTER

SET NODATA = NV
FI JO_HOLD1 DISK JO_HOLD1.FTM (APPEND
-SET &ACAD_YEAR_DISPLAY = EDIT(&ACADEMIC_YEAR, '9999-$$99');
JOIN
PROFESSIONAL_STAFF_DATA_ELEM_8.PROFESSIONAL_STAFF_DATA_ELEM_8.INSTITUTION_CODE
IN professional_staff_data_elem_8 TO MULTIPLE
INSTITUTION.INSTITUTION.INSTITUTION_CODE IN institution TAG J0 AS J0
END

DEFINE FILE PROFESSIONAL_STAFF_DATA_ELEM_8
CAT1/I2=1;
CAT1_DESC/A52=
IF CAT1 EQ 1 THEN 'GRAND TOTAL'
ELSE IF CAT1 EQ 2 THEN 'SUB-POPULATIONS: '
ELSE IF CAT1 EQ 3 THEN 'BY ACADEMIC RANK WITH MULTIPLE MANPOWER (SEE NOTE*)'
ELSE IF CAT1 EQ 4 THEN 'BY MANPOWER RESOURCE'
ELSE IF CAT1 EQ 5 THEN 'BY ACADEMIC RANK (SEE NOTE*)'
ELSE IF CAT1 EQ 6 THEN 'BY MANPOWER RESOURCE WITH MULTIPLE ACADEMIC RANK'
ELSE ' ';
GRP1/I2=0;
GRP1_DESC/A40=' ';
GRP2/I2=0;
GRP2_DESC/A30=' ';
GRP3/I2=0;
GRP3_DESC/A15=' ';
MALE/I5S=0;
FEMALE/I5S=0;
END

TABLE FILE PROFESSIONAL_STAFF_DATA_ELEM_8
SUM
MALE
FEMALE
CNT.SOCIAL_SECURITY_NUMBER/I7C AS 'L_TOTAL'
COMPUTE SUB_TOTAL/A1 = 'N';
BY ACADEMIC_YEAR AS 'YEAR'
BY LOWEST INSTITUTION_CODE
BY LONG_NAME
BY LOWEST CAT1
BY LOWEST CAT1_DESC
BY LOWEST GRP1
BY LOWEST GRP1_DESC
BY LOWEST GRP2
BY LOWEST GRP2_DESC
BY LOWEST GRP3
BY LOWEST GRP3_DESC
WHERE ACADEMIC_YEAR EQ &ACADEMIC_YEAR.(FIND PROFESSIONAL_STAFF_DATA_ELEM_8.PROFESSIONAL_STAFF_DATA_ELEM_8.ACADEMIC_YEAR IN PROFESSIONAL_STAFF_DATA_ELEM_8|FORMAT=A8).ACADEMIC_YEAR:.QUOTEDSTRING;
WHERE INSTITUTION_CODE EQ &INSTITUTION_CODE.(FIND PROFESSIONAL_STAFF_DATA_ELEM_8.PROFESSIONAL_STAFF_DATA_ELEM_8.INSTITUTION_CODE IN PROFESSIONAL_STAFF_DATA_ELEM_8|FORMAT=A3).INSTITUTION_CODE:.QUOTEDSTRING;
ON TABLE SET PAGE-NUM NOLEAD
ON TABLE SET ASNAMES ON
ON TABLE NOTOTAL
ON TABLE HOLD AS JO_HOLD1
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
INCLUDE = ok,
$
ENDSTYLE
END

This message has been edited. Last edited by: FP Mod Chuck,

FOC205 means WF didn't find the master file. Which master file is it complaining about? Is it in your path?

I did look up the error code. I also googled looking for the answer. I have two Snippet files to send as attachments, but don't see how to do that here. The first error message states:

The following error has occurred while processing this form:
0 ERROR AT OR NEAR LINE 5 IN PROCEDURE ADHOCRQ FOCEXEC*
Please contact your administrator for assistance.

The second error states:

The Following error has occurred while processing this form:
(FOC205) THE DESCRIPTION CANNOT BE FOUND FOR FILE NAMED:
Please contact your administrator for assistance.

The problem file named is not given to me. I believe it has everything to do with the reference to FI...(APPEND. Was this even available in WF 7.1.04/Developer Studio? I had made changes using WF 8.2.01M/App Studio, but then I copied this to the old 7.1.04 environment. We are in the process
of re-accomplishing this, but my users need to still get to the old site.

Jackie

I am pretty sure that it can't find the master file for PROFESSIONAL_STAFF_DATA_ELEM_8 or INSTITUTION. Make sure the application folder these files exist in are in the APP PATH.

You will notice that there was A LOT of code tightening from v7 to v8.

Try changing the FI to FILEDEF and you may need to fully qualify the hold file with the app folder

 FILEDEF JO_HOLD1 DISK [AppFolder/]JO_HOLD1.FTM (APPEND 

.

Docs: Syntax: How to Assign a Logical Name With a FILEDEF Command

quote:

Originally posted by FP Mod Chuck:
I am pretty sure that it can't find the master file for PROFESSIONAL_STAFF_DATA_ELEM_8 or INSTITUTION. Make sure the application folder these files exist in are in the APP PATH.

And/or you can include an APPPATH command at the beginning of the code, that tells WF where to look for the master files.

Docs: Search Path Management Commands

Thank you every one!!! I will certainly try these suggestions.

FP Mod Chuck,

I am only able to get to our production side of WF 7.1.04. I looked in the synonyms and you are correct in that the PROFESSIONAL_STAFF_DATA_ELEM_8 synonym is not there. Tried to add it but couldn't because of versioning. Is there any way at this point to add this synonym? I have no access to development using this Dev Studio version.

quote:

Is there any way at this point to add this synonym?

Can you create the synonym using the WebFOCUS Console ?

Jackie

Sounds like you will have to get your admin to create the synonym on your dev environment using the Reporting Server console.