Hi,

I'm having problems running a working FEX from WF716 in WF762.

TEST_MODIFY.FEX
-* File test_modify.fex
-SET ECHO=ALL;

-SET &YR = EDIT(&DATEYYMD,'9999') ;
-SET &MO = EDIT(&DATEYYMD,'$$$$$99') ;
-SET &DAY = EDIT(&DATEYYMD,'$$$$$$$$99') ;
-SET &TOX = &YR || &MO || &DAY ;
-SET &FROMX = AYMD(&TOX,-7,'I8') ;

-SET &YRX = EDIT(&FROMX,'9999') ;
-SET &MOX = EDIT(&FROMX,'$$$$99') ;
-SET &DAYX = EDIT(&FROMX,'$$$$$$99') ;
-SET &FROMDATE = &MOX || '/' || &DAYX || '/' || &YRX ;

-SET &TODATE = &MO || '/' || &DAY || '/' || &YR ;

-*=====================================================
-* Get the down time minutes
-*=====================================================

TABLE FILE RV_EFFECTIVEUPTIME_TEMP
SUM
MAX.FOCLIST1
ON TABLE SAVE
END
-RUN
-READ SAVE &MAXLIST1.I9

-TYPE &MAXLIST1


TABLE FILE RV_EFFECTIVEUPTIME_ETL
PRINT
COMPUTE CNT/I9 = CNT + 1 ;
COMPUTE FOCLIST1/I9=&MAXLIST1 + CNT ;
DAY

WEEK
MONTH
EQUIPMENT
EQUIPGROUP
TYPE
COMPUTE STATUS/A30 = 'DOWN';
COMPUTE MINUTES/P5 = DOWNMINUTES;
COMPUTE WAFERSFIN/P5 = IF MINUTES EQ 0 THEN 0 ELSE WAFERSFINISHED;

WHERE DAY GE DT(&FROMDATE);
WHERE DAY LE DT(&TODATE);

WHERE ((EQUIPGROUP LIKE 'APM%' AND EQUIPMENT LIKE 'APM101%') OR (EQUIPGROUP LIKE
'PCR%' AND EQUIPMENT LIKE 'PCR4C1%') OR (EQUIPGROUP LIKE 'MCD%' AND EQUIPMENT
LIKE 'MCD7H3%'));
ON TABLE HOLD AS TEMPHOLD
END

TABLE FILE TEMPHOLD
SUM
STATUS
MINUTES
WAFERSFIN
BY
FOCLIST1
BY
DAY
BY
WEEK
BY
MONTH
BY
EQUIPMENT
BY
EQUIPGROUP
BY
TYPE

ON TABLE HOLD AS HOLD1
END


USE
D:\ibi-dev\ibi\apps_srv\rv_equipment\rv_effectiveuptime_temp.foc
END

-TYPE AFTER THE USE COMMAND;

MODIFY FILE RV_EFFECTIVEUPTIME_TEMP
FIXFORM FROM HOLD1
MATCH FOCLIST1
ON NOMATCH INCLUDE
ON MATCH CONTINUE
DATA ON HOLD1
END
-RUN


TABLE FILE RV_EFFECTIVEUPTIME_TEMP
PRINT *
END


-EXIT

Here is the log from EDAPRINT.LOG:
01/31/2008 11:12:55 accepting cmrpip012158 tcp=131.241.63.231:4426
01/31/2008 11:12:55 request by cmrpip012158 for explicit connect to agent
(DEFAULT)
01/31/2008 11:12:55 connecting cmrpip012158 tscomid=203,sesid=12410
01/31/2008 11:12:55 processing cmrpip012158 u=webfocus,l=SRV
01/31/2008 11:12:55 (FOC1676) UNRECOGNIZED SET COMMAND FOR ORACLE INTERFACE
01/31/2008 11:12:55 (FOC1400) SQLCODE IS -1 (HEX: FFFFFFFF)
01/31/2008 11:12:55 (FOC1414) EXECUTE IMMEDIATE ERROR.
01/31/2008 11:12:55 (FOC1261) PHYSICAL INTERFACE NOT FOUND FOR SUFFIX SQLINF.
MODULE NAME : INFFOC
01/31/2008 11:12:55 (FOC1262) THE FOLLOWING NATIVE ERROR MESSAGE(S) CAPTURED :
01/31/2008 11:12:55 (FOC1260) SearchPath: failed to find
D:\ibi-dev\ibi\srv76\home\bin\inffoc.dll
01/31/2008 11:12:55 (FOC1261) PHYSICAL INTERFACE NOT FOUND FOR SUFFIX SQLINF.
MODULE NAME : INFFOC
01/31/2008 11:12:55 (FOC1262) THE FOLLOWING NATIVE ERROR MESSAGE(S) CAPTURED :
01/31/2008 11:12:55 (FOC1260) SearchPath: failed to find
D:\ibi-dev\ibi\srv76\home\bin\inffoc.dll
01/31/2008 11:12:55 (FOC1261) PHYSICAL INTERFACE NOT FOUND FOR SUFFIX SQLINF.
MODULE NAME : INFFOC
01/31/2008 11:12:55 (FOC1262) THE FOLLOWING NATIVE ERROR MESSAGE(S) CAPTURED :
01/31/2008 11:12:55 (FOC1260) SearchPath: failed to find
D:\ibi-dev\ibi\srv76\home\bin\inffoc.dll
01/31/2008 11:12:55 (FOC1400) SQLCODE IS -1 (HEX: FFFFFFFF)
01/31/2008 11:12:55 accepting FDS connection tcp=127.0.0.1:3367
01/31/2008 11:12:57 TCP session aborted by client
01/31/2008 11:12:57 request by edapmon to notify agent has crashed (tscomid=203)
01/31/2008 11:12:57 disconnect FDS
01/31/2008 11:12:57 agent started (tscomid=204, pid=5736, svc=DEFAULT)
01/31/2008 11:12:57 request by t3rp5736 to notify agent is ready (tscomid=204)


If I put a -EXIT before the MODIFY command, it works. But when I run the whole thing with the MODIFY, it fails. Any insights?

Also, I opened a case with IBI techsupport.

Dan

Dan,

That INFFOC error message really bothers me. Have you looked into that?

Also, hold your HOLD1 file as FORMAT ALPHA.

If you are doing all includes, you don't need MATCH logic.

Have you tried doing an ON TABLE HOLD FORMAT FOCUS from the input file?

Do you have write privileges to that directory and file that you are trying to update?

Sorry for the stream of consciousness....

Ginny,

I can't find any info on INFFOC message in techsupport.

Let me try your suggestions. I was able to replicate the error using the CAR file.

-SET ECHO=ALL;

APP HOLD DAN_TEST

-SET &MAXLIST = 0;

TABLE FILE CAR
PRINT
COMPUTE CNT/I9 = CNT + 1 ;
COMPUTE FOCLIST1/I9=&MAXLIST + CNT ;
COUNTRY
CAR
RETAIL_COST
WHERE COUNTRY EQ 'ITALY'
ON TABLE HOLD AS TEMPHOLD
END

TABLE FILE TEMPHOLD
SUM
RETAIL_COST
BY
FOCLIST1
BY
COUNTRY
BY
CAR

ON TABLE HOLD AS MODIFYTEST FORMAT FOCUS INDEX FOCLIST1 COUNTRY CAR
END

APP HOLD


TABLE FILE MODIFYTEST
SUM
MAX.FOCLIST1
ON TABLE SAVE
END
-RUN
-READ SAVE &MAXLIST1.I9.

-TYPE &MAXLIST1


TABLE FILE CAR
PRINT
COMPUTE CNT/I9 = CNT + 1 ;
COMPUTE FOCLIST1/I9=&MAXLIST1 + CNT ;
COUNTRY
CAR
RETAIL_COST
WHERE COUNTRY EQ 'GERMANY'
ON TABLE HOLD AS TMPHOLD1
END

TABLE FILE TEMPHOLD
SUM
RETAIL_COST
BY
FOCLIST1
BY
COUNTRY
BY
CAR

ON TABLE HOLD AS HOLD1
END

USE
D:\ibi-dev\ibi\apps_srv\dan_test\modifytest.foc
END


MODIFY FILE MODIFYTEST
FIXFORM FROM HOLD1
MATCH FOCLIST1
ON NOMATCH INCLUDE
ON MATCH CONTINUE
DATA ON HOLD1
END
-RUN

-EXIT

Hi Ginny,

I took your suggestion of removing the MATCH condition since I will be adding all. The thing that bothers me is the code works in WF716 and not in WF762. We might have to put out small fires since we just upgrade to 762.

Anyways, I will contact IBI about that INFFOC message.

Thanks,
Dan

I do modifies in 762.

Try making your FOCUS file name 8 characters or less. If that doesn't work, by all means, open a case.

dballest

The problem is that you should be matching on all the keys of a segment in MODIFY

Thus
MATCH FOCLIST1 COUNTRY CAR
ON NOMATCH etc

Matching on a partial key has ALWAYS been unpredictable, thus it should not be a bug that 716 works and 762 does not.

btw Removing the keys match and relying on the default behaviour activates the full key match as well.

The motto is always, always MATCH on the full keys of a segment. With NEXT you only need one, but with MATCH it is simple logic that you need all values to identify a unique instance.

Thanks Ginny and hammo1j.

I will give your suggestions a try.

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

Never mind about the INFFOC thing. It is just the name of the sqlinf interface, which you do not have installed on your system. At least, the reporting server seems to think so. It tries to load the module INFFOC because there is a command for the SQLINF interface, probably in your edasprof.

Thanks for the info GamP.

Just to give a update, IBI is still working on my issue with the MODIFY command.

As a temporary fix, I created my temp table using SQL pass-thru. Ideally, we would want FOCUS code to create this.

Dan,

A little aside, your -TYPE commands are DM and as such get executed as the code is parsed. Therefore your -TYPE &MAXLIST1 and -TYPE AFTER THE USE COMMAND; will be output together as there is no -RUN to force to execution of the stack built between them. To get the -TYPE AFTER .... to be ouptut after the USE command, and not before as it currently is, then add -RUN after the END component of the USE syntax.

T

Agent crashes may happen for the weirdest of reasons.
In your case I wonder what the reason may be.
Could it be that the use statement is seemingly unneccesary. Since TABLE apparently can find the file without the use statement in effect, I wonder what the result would be if you take the statement out entirely.
If that does not have the desired effect, consider to code the use as:
USE
dan_test/modifytest.foc
END
If this also does not have the desired effect then there is one more thing I would change in your modify code. It is the ON MATCH CONTINUE. Usually the CONTINUE means to go on with the next MATCH or NEXT down the chain. Which is not there. I would change it to ON MATCH GOTO TOP.

Hope this helps ...

GamP may have your answer, but I would change the continue to either ON MATCH REJECT or ON MATCH UPDATE depending on which you want to do. As it is written now, there is no case logic for it to continue to and it doesn't know what to do with the matched record.

Thank you all for your inputs. I'll give it a shot.

Another thing I noticed that in our DEV we set it up to have 10 agents available. When I run my tests and fails 10 times, I check the monitor data services from the console and I have 10 agents crashed and 0 active. It looks like it is not releasing the crashed agents and not keeping 10 active agents all the time.

It never releases crashed agents; you must kill them manually. As for why it is not starting new agents, please check the other parms like max and number ready.

I modified the report a bit and it still fails. I will post the trace file in the next tread.

-SET ECHO=ALL;

APP HOLD DAN_TEST

-SET &MAXLIST = 0;

TABLE FILE CAR
PRINT
COMPUTE CNT/I9 = CNT + 1 ;
COMPUTE FOCLIST1/I9=&MAXLIST + CNT ;
COUNTRY
CAR
RETAIL_COST
WHERE COUNTRY EQ 'ITALY'
ON TABLE HOLD AS TEMPHOLD
END

TABLE FILE TEMPHOLD
SUM
COUNTRY
CAR
RETAIL_COST
BY
FOCLIST1

ON TABLE HOLD AS MODIFYTEST FORMAT XFOCUS INDEX FOCLIST1
END

APP HOLD

-*========================================================

TABLE FILE MODIFYTEST
SUM
MAX.FOCLIST1
ON TABLE SAVE
END
-RUN
-READ SAVE &MAXLIST1.I9.


TABLE FILE CAR
PRINT
COMPUTE CNT/I9 = CNT + 1 ;
COMPUTE FOCLIST1/I9=&MAXLIST1 + CNT ;
COUNTRY
CAR
RETAIL_COST
WHERE COUNTRY EQ 'W GERMANY'
ON TABLE HOLD AS TMPHOLD1
END

TABLE FILE TMPHOLD1
SUM
COUNTRY
CAR
RETAIL_COST
BY
FOCLIST1

ON TABLE HOLD AS HOLD1
END

-*USE
-*D:\ibi-dev\ibi\apps_srv\dan_test\modifytest.foc
-*END
-RUN

-*-EXIT

MODIFY FILE MODIFYTEST
FIXFORM FROM HOLD1
DATA ON HOLD1
END
-RUN

-EXIT

Here's a snippet of the trace file. Why is it looking for a modifytest.acx file?

09.30.57 AS r1pathnm: result is
09.30.57 AS r1fopen: calling fopen( D:\ibi-dev\ibi\srv76\wfs\edatemp\ts000160\modifytest.acx, r )
09.30.57 AS r1fopen: fopen failed
09.30.57 AS r1trcerr: r1fopen: err#2, The system cannot find the file specified.
09.30.57 AS r1trcerr: iohfopen: err#2, The system cannot find the file specified.
09.30.57 AS ioherrop: name = "MODIFYTEST", : failed to open
09.30.57 AS iohfnam: __main: called for fname="@0000002" funcode=REMOVE
09.30.57 AS iohfnam: __free: new usage count 4
09.30.57 AS doopnIoh: "MODIFYTEST - file not found
09.30.57 AS propnh: "MODIFYTEST HOLDACC " file not found
09.30.57 AS iohfnam: __main: called for fname="@0000002" funcode=REMOVE
09.30.57 AS iohfnam: __free: new usage count 2
09.30.57 AS propnh: entered
09.30.57 AS prftl2c: iohft(3) ==> ACCESS
09.30.57 AS propnh: FILE: "MODIFYTEST" TYPE: ACCESS MODE: 00000201
09.30.57 AS iohfnam: __main: called for fname="MODIFYTEST" funcode=CREATE
09.30.57 AS iohfnam: __fnd: Matching Temp file found # = 2
09.30.57 AS iohfnam: __main: new usage count: 3
09.30.57 AS ioherrop: open name = "@0000002"
09.30.57 AS iohfnam: __main: called for fname="@0000002" funcode=CREATE
09.30.57 AS iohfnam: __main: new usage count: 5
09.30.57 AS ioherrop: open name = "MODIFYTEST"
09.30.57 AS iohfnam: __main: called for fname="@0000002" funcode=QUERY
09.30.57 AS iohfnam: __main: called for fname="@0000002" funcode=QUERY
09.30.57 AS iohfnam: __main: called for fname="@0000002" funcode=QUERY
09.30.57 AS r1pathnm: result is
09.30.57 AS r1fopen: calling fopen( D:\ibi-dev\ibi\srv76\wfs\edatemp\ts000160\modifytest.acx, r )
09.30.57 AS r1fopen: fopen failed
09.30.57 AS r1trcerr: r1fopen: err#2, The system cannot find the file specified.
09.30.57 AS r1pathnm: result is
09.30.57 AS r1fopen: calling fopen( D:\ibi-dev\ibi\apps_srv\dan_test\modifytest.acx, r )
09.30.57 AS r1fopen: fopen failed
09.30.57 AS r1trcerr: r1fopen: err#2, The system cannot find the file specified.
09.30.57 AS r1pathnm: result is
09.30.57 AS r1fopen: calling fopen( D:\ibi-dev\ibi\apps_srv\ibisamp\modifytest.acx, r )
09.30.57 AS r1fopen: fopen failed
09.30.57 AS r1trcerr: r1fopen: err#2, The system cannot find the file specified.
09.30.57 AS r1pathnm: result is
09.30.57 AS r1fopen: calling fopen( D:\ibi-dev\ibi\apps_srv\rv_equality\modifytest.acx, r )
09.30.57 AS r1fopen: fopen failed
09.30.57 AS r1trcerr: r1fopen: err#2, The system cannot find the file specified.
09.30.57 AS r1pathnm: result is
09.30.57 AS r1fopen: calling fopen( D:\ibi-dev\ibi\apps_srv\cbilski_test\modifytest.acx, r )
09.30.57 AS r1fopen: fopen failed
09.30.57 AS r1trcerr: r1fopen: err#2, The system cannot find the file specified.
09.30.57 AS r1pathnm: result is
09.30.57 AS r1fopen: calling fopen( D:\ibi-dev\ibi\apps_srv\gbt-allocation\modifytest.acx, r )
09.30.57 AS r1fopen: fopen failed

Dev: WebFOCUS 7.6.10, Data Migrator 7.6.10
QA: WebFOCUS 7.6.10, Data Migrator 7.6.10
Prod: WebFOCUS 7.6.2, Data Migrator 7.6.8
Windows 2K3, Tomcat 5.5.17, IIS 6
Usage: HTML, PDF, Excel, Self-serve, BID and MRE

Ginny,

I had the default data service configured at maximum 10 and number ready 10. The rest are default.

Dan

quote:

-SET ECHO=ALL;

APP HOLD DAN_TEST

-SET &MAXLIST = 0;

TABLE FILE CAR
PRINT
COMPUTE CNT/I9 = CNT + 1 ;
COMPUTE FOCLIST1/I9=&MAXLIST + CNT ;
COUNTRY
CAR
RETAIL_COST
WHERE COUNTRY EQ 'ITALY'
ON TABLE HOLD AS TEMPHOLD
END

TABLE FILE TEMPHOLD
SUM
COUNTRY
CAR
RETAIL_COST
BY
FOCLIST1

ON TABLE HOLD AS MODIFYTEST FORMAT XFOCUS INDEX FOCLIST1
END

APP HOLD

-*========================================================

TABLE FILE MODIFYTEST
SUM
MAX.FOCLIST1
ON TABLE SAVE
END
-RUN
-READ SAVE &MAXLIST1.I9.


TABLE FILE CAR
PRINT
COMPUTE CNT/I9 = CNT + 1 ;
COMPUTE FOCLIST1/I9=&MAXLIST1 + CNT ;
COUNTRY
CAR
RETAIL_COST
WHERE COUNTRY EQ 'W GERMANY'
ON TABLE HOLD AS TMPHOLD1
END

TABLE FILE TMPHOLD1
SUM
COUNTRY
CAR
RETAIL_COST
BY
FOCLIST1

ON TABLE HOLD AS HOLD1
END

-*USE
-*D:\ibi-dev\ibi\apps_srv\dan_test\modifytest.foc
-*END
-RUN

-*-EXIT

MODIFY FILE MODIFYTEST
FIXFORM FROM HOLD1
DATA ON HOLD1
END

These are the results of me running your code. The only thing I changed was the app hold directory.

Here is what is in the file:

FOCLIST1 COUNTRY CAR RETAIL_COST
1 ITALY ALFA ROMEO 5,925
2 ITALY ALFA ROMEO 6,820
3 ITALY ALFA ROMEO 6,820
4 ITALY MASERATI 31,500
5 W GERMANY AUDI 5,970
6 W GERMANY BMW 5,940
7 W GERMANY BMW 6,355
8 W GERMANY BMW 13,752
9 W GERMANY BMW 14,123
10 W GERMANY BMW 9,097
11 W GERMANY BMW 9,495


Why are you creating an XFOCUS file?

I don't know why you are getting that error on modifytest.acx. Can you please check to see if you have another master file by that name somewhere in your path.

The search for an acx file will always happen, WF will search your APP PATH for an ACX equal to the MFD. It actually, for FOCUS files, doesn't matter if it finds one or not.

When you say the process fails, what are the symptoms?

 APP HOLD c758760
 -SET &MAXLIST = 0;
 TABLE FILE CAR
 PRINT
 COMPUTE CNT/I9 = CNT + 1 ;
 COMPUTE FOCLIST1/I9=0 + CNT ;
 COUNTRY
 CAR
 RETAIL_COST
 WHERE COUNTRY EQ 'ITALY'
 ON TABLE HOLD AS TEMPHOLD
 END
 TABLE FILE TEMPHOLD
 SUM
 COUNTRY
 CAR
 RETAIL_COST
 BY
 FOCLIST1
 ON TABLE HOLD AS MODIFYTEST FORMAT XFOCUS INDEX FOCLIST1
 END
 APP HOLD
 -*========================================================
 TABLE FILE MODIFYTEST
 SUM
 MAX.FOCLIST1
 ON TABLE SAVE
 END
 -RUN
 0 NUMBER OF RECORDS IN TABLE=        4  LINES=      4
 0 NUMBER OF RECORDS IN TABLE=        4  LINES=      4
 0 NUMBER OF RECORDS IN TABLE=        4  LINES=      1
 ALPHANUMERIC RECORD NAMED  SAVE
 0 FIELDNAME                         ALIAS         FORMAT        LENGTH
 FOCLIST1                          E01           I9              9
 TOTAL                                                           9
 -READ SAVE &MAXLIST1.I9.
 TABLE FILE CAR
 PRINT
 COMPUTE CNT/I9 = CNT + 1 ;
 COMPUTE FOCLIST1/I9=        4 + CNT ;
 COUNTRY
 CAR
 RETAIL_COST
 WHERE COUNTRY EQ 'W GERMANY'
 ON TABLE HOLD AS TMPHOLD1
 END
 TABLE FILE TMPHOLD1
 SUM
 COUNTRY
 CAR
 RETAIL_COST
 BY
 FOCLIST1
 ON TABLE HOLD AS HOLD1
 END
 -*USE
 -*D:\ibi-dev\ibi\apps_srv\dan_test\modifytest.foc
 -*END
 -RUN
 0 NUMBER OF RECORDS IN TABLE=        7  LINES=      7
 0 NUMBER OF RECORDS IN TABLE=        7  LINES=      7
 -*-EXIT
 MODIFY FILE MODIFYTEST
 FIXFORM FROM HOLD1
 DATA ON HOLD1
 END
 0 TRANSACTIONS:         TOTAL =     7  ACCEPTED=     7  REJECTED=     0
 SEGMENTS:             INPUT =     7  UPDATED =     0  DELETED =     0

I forgot to paste this before. I don't get any errors.

Ginny,

I though I'd try XFOCUS since my hold name is greater than 8.

Allan,
I get an "Unknown error occurred. Agent on reporting server EDASERVE may have crashed. Please investigate reporting server log. " message and the agent status is crashed.

I ran the report you post and changed back the app hold directory to dan_test and it ran the 1st time. When I run it again, then it errors out. Looks like there is nothing wrong with the code but just the inconsistencies. Let me wait for a while and run it again.

D,

Comment out all the code below the where you are holding the xfocus file. You need to narrow down where it is failing. Then add the code back one block at a time.

I am running the same code that you are in the same release, different platform, and didn't have a bit of trouble with your code.

Also check the write permissions on the MODIFYTEST file after you first create it but before you try to modify it the second time.

Ginny,

I tried putting a -EXIT on each segment of code and works fine. I placed a -EXIT right before the modify and ran the fex at least 10 times and it ran fine. Now when I include the MODIFY, it ran fine about 4 times then back to the error again. Looks like the fex is okay but a component somewhere fails.

Dan

Dan,

I'm stumped. You show errors from EDAPRINT. What are you getting in the html output? Look at my post from yesterday at 3:38 CST for an example. Are you getting errors there? If yes, what are they?

Also, try putting a table request after the modify to PRINT * what is in the file.

Since you are running on Windows, and I don't know if this is localhost, can you turn traces on the reporting server? Or do you have lots of people using it which makes that not a good thing to do.

If you are localhost, maybe I can try this on my Dev Studio installation to see if I can get the error.

Let's keep plugging away a little bit longer before we raise the white flag and have you open a case.

Dan

My guess is that it is this

There's a couple of other MODIFY agent killers in there as well!

John,

I ran his exact same code except for the app hold directory and mine worked just fine.

We appear to be running almost the same release but not the same platform.

I would think that pointed to an environmental issue.

Hi Ginny,

We have a report running in DEV, QA and PROD. The report is exactly the same except for the directory location used in the USE command (dev is D:, qa is E: and prod is F. It continues to fail/crash in DEV and QA but is okay in PROD. Just need where to start looking.

Dan

dballest: On one of the posts above you mentioned that your agents do not get cleaned up. You need to set crashed_cleanup=on in the edaserve.cfg configuration file. That way, as soon as an agent crashes, it gets cleaned up. No manual cleanup needed.