Webfocus, Release R720521B

I was handed support of the WebFocus reporting and do not know too much about it. One report was not working correctly and I modified the FEX file changing how a field was formatted.

I then copied this FEX file into the reporting directory on our QA server. This corrected the problem.

I then wanted to move this to our production server, so I copied the same FEX file to the reporting directory on the production server. I went into the web admin interface for Webfocus and checked that I was copying into the correct directory, I was.

Now, I don't see any corrected changes on the production server. I copied over an existing FEX file of the same name when I moved it to production. I even went so far as to do an iisreset on the web server and restarted the WebFocus services, nothing helps.

How do I go about tracking this down and fixing it?

Even though you put the fex in the correct directory, I would verify that this directory is the first one that the WebFOCUS server found the program in.

To do this, run the WHENCE command - this will tell you which directory the WF server found the program in first.

Go here: http://server_name/ibi_html/

(I don't have WebFOCUS 7, so I'm not sure if the specified page is still provided.)

Select "Run an Ad Hoc request"

Clear the WF commands text area and enter this:

WHENCE pgm_name FOCEXEC

(e.g. WHENCE CRMREP1 FOCEXEC)

Click Run.

The result should look something like this:
D:\ibi\apps\eidw\crmrep1.fex

If the displayed directory is NOT the one you migrated the updated program to, then there is another version of the program being found and run - this one should be deleted. Then try the WHENCE command again.

If it is the correct directory, then it may simply be a web browser cache issue. Clear the cache and try running the program again.

It could sound silly but... Caouln't be a Cache problem?

If not, in your production server, have you mapped correctly the directories from WebFocus console?

What server are you running? Unix, Linux...? Try a global search into your app directory of the fex you're currently executing to see if there are several files with the same name.

Waiting answer

This is a Windows 2000 Server. The place where I copied the FEX is c:\ibi\apps\reporting. This is where WebFocus is configured for the reports. I did a global search and the only other place where this FEX is c:\ibi\apps\reporting\old. I guess this is where backups are kept.

This has been this way for several days, so I doubt this is still cached in the browser.

This message has been edited. Last edited by: Nick K.,

quote:

Run an Ad Hoc request

Does anyone know how to run an Ad Hoc Request in WebFocus 7?

Use the URL http://yourservername/ibi_html and then choose Run an adhoc request.

check your edasprof.prf where you specify the order of folders to look for Fex file. You will have similar to this,

APP MAP reporting old test

If you have,

APP MAP old reporting test

then your production server will take the fex from the first folder.

Did my post not make any sense?

cache , i agree with Ruben, might be the first and simplest place to check; i have my browser set to clear cache on exit, and have no cache tags in all my launch pages...and STILL its not enough, when i'm testing a fex change. Even right-click-refresh doesn't always work. Can make u crazy ; logoff and log back on to mre for me does the trick, at wits end;

I've faced that same issue and have 'fixed it' in IE in the tools by saying delete files then check delete all offline content.

I was able to get to the web app that runs the ad hoc query (it wants default.htm after that link)

When I use the default server (EDASERV) it asks for a user id and password. I use the Admin user id and password and it will not log on. When I log on the WebFocus server, this User id works there.

I'm also not clear on what I should put in the Application Path.

On the Ad Hoc query screen, type the following command to display the list of defined application directories. The order the application directories are listed in is the program search order.

APP LIST

I have followed all these suggestions and I still have the problem.

I cleared the cache in the browser and verified that the location of the report files is where WebFocus expects them to be.

I modifed the FEX file to change "AMOUNT/D12.2CB" to "AMOUNT/D12.2CB AS 'AMOUNT'"

As I mentioned, this corrected the problem when I deployed the FEX to the QA server, but I deployed the FEX to the production server, I still get this error, like it was never corrected:

-RUN
0 ERROR AT OR NEAR LINE 31 IN PROCEDURE CUSTBILLWEBBTN
(FOC003) THE FIELDNAME IS NOT RECOGNIZED: AMOUNT/D12.2CB
BYPASSING TO END OF COMMAND
(FOC009) INCOMPLETE REQUEST STATEMENT
-IF 0 NE 0 THEN GOTO ADIOS;
-IF WEB NE 'WEB' THEN GOTO NOT_WEB;
-INCLUDE NO_RECS
-* File NO_RECS.FEX
-HTMLFORM BEGIN

Are you 100 percent sure what you moved to production was what you changed. We had an issue where we had a fex that we thought had one name, but it wasn't the one being executed.

If you have it on an 'MRE' tree check properties on it to see the fex name.

I am sure and I have checked and double checked it. The error list the FEX, Procedure CUSTBILLWEBBTN, and that is the name of the FEX that I changed.

Perhaps the Master for the table being accessed by the fex is different on the two servers - verify that they're the same and that there's only one master (*.mas) and that it is in the expected directory.

Meanwhile, what are you attempting to do with

quote:

AMOUNT/D12.2CB AS 'AMOUNT'

?

Would you mind posting a little more of the code around the line you're having trouble with?

The other option is, is there a fex with the same name in the app path somewhere. I remember when we were converting to the Web we couldn't figure out why in MRE it worked, but if we used dstrun (don't know if I spelled that correctly) we were picking up another copy of the report. Took us forever to find the problem.

TABLE FILE CUSTBILL
SUM
AMOUNT/D12.2CB AS 'AMOUNT'
CUSTOMER_ID NOPRINT
VENDOR_ID NOPRINT
-* ALTERNATE LINE COLOR
COMPUTE LN/I1 = IF LAST LN NE 1 OR 2 THEN
1
ELSE IF LAST LN EQ 1 THEN
2
ELSE IF LAST LN EQ 2 THEN
1
ELSE 3; NOPRINT
BY
BTN
BY
TERM1 AS 'TERM'

So, is AMOUNT a column in the table CUSTBILL on both servers?

Yes

Can you run the following code from that ad hoc screen:

TABLE FILE CUSTBILL
SUM
AMOUNT
BY BTN
WHERE READLIMIT EQ 100
WHERE RECORDLIMIT EQ 100
END

If that works, try this:

TABLE FILE CUSTBILL
SUM
AMOUNT/D12.2CB
BY BTN
WHERE READLIMIT EQ 100
WHERE RECORDLIMIT EQ 100
END

Then try this:

TABLE FILE CUSTBILL
SUM
AMOUNT/D12.2CB AS 'AMOUNT'
BY BTN
WHERE READLIMIT EQ 100
WHERE RECORDLIMIT EQ 100
END