Hey guys,

I am exporting the report in Excel format, but in our TEST env, it works fine, however in our UAT and PROD env, it errors out.

Here are the error messages.

(FOC227) THE FOCEXEC PROCEDURE CANNOT BE FOUND: tmp_cmd
(FOC227) THE FOCEXEC PROCEDURE CANNOT BE FOUND: tmp_cols
.
.
.
(FOC205) THE DESCRIPTION CANNOT BE FOUND FOR FILE NAMED: NEWFILE
0 ERROR AT OR NEAR LINE 1 IN PROCEDURE tmp_colsFOCEXEC *
(FOC003) THE FIELDNAME IS NOT RECOGNIZED: COL000000001
BYPASSING TO END OF COMMAND
(FOC009) INCOMPLETE REQUEST STATEMENT


Here is the area of code where its erroring out.

TABLE FILE HOLD
PRINT
COMPUTE SEQ/A9 = EDIT(LIST); NOPRINT
COMPUTE COLNAME/A255= 'COL' | SEQ;
BY LIST NOPRINT
ON TABLE NOTOTAL
ON TABLE SET HOLDLIST PRINTONLY
ON TABLE HOLD AS tmp_cols
END

-* Looks like this: -WRITE NEWFILE FIELDNAME=COL000000008, TITLE='Mar, 2011', USAGE=I11, ACTUAL=A11,$
TABLE FILE HOLD
PRINT
COMPUTE SEQ/A9 = EDIT(LIST); NOPRINT
COMPUTE CMDLINE/A255= '-WRITE NEWFILE FIELDNAME=COL' | SEQ |', TITLE=''' | DAT4_TITLE | ''', USAGE=I11, ACTUAL=A11,$';
BY LIST NOPRINT
ON TABLE NOTOTAL
ON TABLE SET HOLDLIST PRINTONLY
ON TABLE HOLD AS tmp_cmd
END
-Run

-* create MFD for transposed data structure called NEWFILE.
-SET &MAS_File = '&IBI_APP_ROOT.EVAL/NEWFILE.mas';
APP FILEDEF NEWFILE DISK &MAS_File.EVAL
-RUN

-WRITE NEWFILE FILENAME=NEWFILE, SUFFIX=FIX,$
-WRITE NEWFILE SEGNAME=ONE, SEGTYPE=S0,$
-WRITE NEWFILE FIELDNAME=SubjectStatus, TITLE='Subject Status', USAGE=A50, ACTUAL=A50,$
-INCLUDE tmp_cmd
FILEDEF NEWFILE CLEAR
-RUN

-* create transposed data file.
TABLE FILE MONTHLY_DATA
SUM TOTALCOUNT/I11
BY SubjectStatus
ACROSS DAT3YY NOPRINT ACROSS DAT1M NOPRINT
ACROSS DAT4_TITLE
ON TABLE SET ASNAMES ON
ON TABLE SET HOLDLIST PRINTONLY
ON TABLE SAVE AS NEWFILE
END

-RUN

I can't seem to figure out the cause of the issue.
Any help is appreciated.

This message has been edited. Last edited by: <Kathryn Henning>,

It sounds like a write-permissions issue.

I would suggest changing -Run to -RUN as a start.

Also if you break the flow at the creation of tmp_cols and check to see if the file is created.

e.g.
-RUN
! DIR
-EXIT

Are you using APP HOLD ?

So I've narrowed down on the location of the error.

When I comment out -INCLUDE temp_cols and -INCLUDE tmp_cmd,
then it works (and obviously with less data outputed)

So as j.gross said, it might not be writing the temp master files.
To Waz, I am not running App hold.

Where does the temp master files get written to so I can check if it gets created or not?

Thanks for help.

That depends on your settings.

Default is for the mas and ftm files to be created in the edatemp tsnnnnnnn directory.

But this can be overridden with APP HOLD.

So this is what I get Waz,

? HOLD tmp_cols
! DIR
-EXIT
0 NUMBER OF RECORDS IN TABLE= 65 LINES= 13
0 NUMBER OF RECORDS IN TABLE= 13 LINES= 13
0 NUMBER OF RECORDS IN TABLE= 13 LINES= 13
0DEFINITION OF HOLD FILE: tmp_cols
0FIELDNAME ALIAS FORMAT
COLNAME E01 A255
sh: DIR: not found.

so the hold "tmp_cols" does get created,
but when using -INCLUDE tmp_cols, it does not find it.
I don't have in depth knowledge with WebFocus, do you guys know what the cause might be?

Are you on Linux or Unix ?

Your signature states Windows

Our Reporting Server is on AIX
Managed Reporting is on Windows

OK, then use ! ls -al instead of ! DIR

This will list the contents of the edatemp location, the default locations for temporary files.

Okay, this is what I got. It seems like the files are there in the temp location.
So I guess -INCLUDE is not looking at the right location?
hmm..

ON TABLE HOLD AS tmp_cols
END
? HOLD tmp_cols
! ls -al
-EXIT
0 NUMBER OF RECORDS IN TABLE= 65 LINES= 13
0 NUMBER OF RECORDS IN TABLE= 13 LINES= 13
0 NUMBER OF RECORDS IN TABLE= 13 LINES= 13
0DEFINITION OF HOLD FILE: tmp_cols
0FIELDNAME ALIAS FORMAT
COLNAME E01 A255
total 256
drwxr-xr-x 2 webfocus oinstall 4096 10 Jul 23:50 .
drwxrwxrwt 28 webfocus oinstall 4096 10 Jul 23:50 ..
-rw-r--r-- 1 webfocus oinstall 208 10 Jul 23:50 hold.ftm
-rw-r--r-- 1 webfocus oinstall 184 10 Jul 23:50 hold.mas
-rw-r--r-- 1 webfocus oinstall 24752 10 Jul 23:50 spdata.ftm
-rw-r--r-- 1 webfocus oinstall 1116 10 Jul 23:50 spdata.mas
-rwxr-xr-x 1 webfocus oinstall 0 10 Jul 23:50 stderr.log
-rwxr-xr-x 1 webfocus oinstall 0 10 Jul 23:50 stdout.log
-rw-r--r-- 1 webfocus oinstall 51 10 Jul 23:50 studynm.ftm
-rw-r--r-- 1 webfocus oinstall 0 10 Jul 23:50 sysh.tmp
-rw-r--r-- 1 webfocus oinstall 3328 10 Jul 23:50 tmp_cols.ftm
-rw-r--r-- 1 webfocus oinstall 133 10 Jul 23:50 tmp_cols.mas

The next step is to start moving the break point down the code and see what happens.

Also after the creation of the master NEWFILE, add a ! cat &MAS_File, and see what was written.

In my experience, -INCLUDE is not able to use files from EDATEMP. I don't know why.

Perhaps it's just a matter of setting the correct PATH env. variable somewhere.
Perhaps you need to specify the full path for -INCLUDE to use such a file.
Or perhaps dialog manager is just too simple and you need to store the files within the APP directory that you're working in (which breaks concurrency for such files, BTW) before dialog manager can use them.

Most likely, we're both missing a relevant piece of information to make dialog manager work correctly with files in EDATEMP. It would be nice if WF was set up like that by default, though...