We recently upgraded to WF 7.6.11. When you do a drill down on a self-service report it normally opens as a pdf document in a browser window. Now, it is opening in adobe and when you drill down you receive the following error: The document is tryng to connect to file:///ibi_apps/WFServlet?IBIF_webapp=/ibi_apps&IBIC_server=edaserve&IBIWF_msfviewer=OFF&&IBIMR_drill=X......
Adobe is set-up to Display PDF's in the browser & the redirection settings (Admin Console) are set to 'NO' for PDF.This message has been edited. Last edited by: LAW,
July 27, 2010, 02:30 PM
Tom Flynn
-************************************** -* CHANGE TO YOUR SERVER IP ADDRESS * -************************************** -SET &SERVER = 'AAA.YYY.xx.XXX:8080';
SET GRAPHSERVURL = 'http://' || '&SERVER.EVAL' || '/ibi_apps/IBIGraphServlet' SET FOCEXURL = 'http://' || '&SERVER.EVAL' || '/ibi_apps/WFServlet' -RUN
SET FOCEXURL = 'http://' || '&SERVER.EVAL' || '/ibi_apps/WFServlet'
I am unable to get this to work for me. I have too many fexes to add the SET FOCEXURL in each one. Why in Version 7.6.11 did this change? Prior to the upgrade when I drill down in a report my output would automatically open in a browser window. With 7.6.11 it automatically opens in PDF which causes the error that I am getting. I think this is a bug with 7.6.11.
July 28, 2010, 11:43 AM
Tom Flynn
Go into any FEX and do this at the very top:
-? & -EXIT
You will see a bunch of ampere variables, this is what we have:
ADOBE does not know where the program is to excute, which is exactly what your URL is using in your 1st post. It is missing the HTTP://SERVER_IP/
WebFOCUS now uses the FOCEXURL for PDF drilling(7.6.7, I think) So, to rectify this, we did the following:
-**************************************
-* CHANGE TO YOUR SERVER IP ADDRESS *
-**************************************
-SET &SERVER = 'AAA.YYY.xx.XXX:8080';
-SET &PDF_URL = 'http://' || '&SERVER.EVAL' || &FOCEXURL;
SET FOCEXURL = &PDF_URL
-RUN
So, here is an example of valid code; Create a focexec called CAR_RPT and copy the code below in and SAVE it:
APP PREPENDPATH IBISAMP
-RUN
-SET &ECHO=ALL;
-DEFAULTS &COUNTRY = 'FOC_NONE'
-**************************************
-* CHANGE TO YOUR SERVER IP ADDRESS *
-**************************************
-SET &FMT = 'PDF';
-SET &SERVER = 'ABC.ABC.11.123:8080'; <----- CHANGE THIS
-SET &PDF_URL = 'http://' || '&SERVER.EVAL' || &FOCEXURL;
SET FOCEXURL = &PDF_URL
-RUN
TABLE FILE CAR
PRINT
RETAIL_COST
DEALER_COST
COMPUTE PROFIT/P13.2MC = RETAIL_COST - DEALER_COST;
BY COUNTRY
BY CAR
WHERE COUNTRY EQ '&COUNTRY';
ON TABLE PCHOLD FORMAT &FMT
ON TABLE SET STYLE *
-IF &COUNTRY NE 'FOC_NONE' GOTO END_STYLE;
TYPE=DATA,
COLUMN = N1, TARGET='_blank',
FOCEXEC=CAR_RPT(FMT='&FMT' COUNTRY=N1), $
-END_STYLE
ENDSTYLE
END
-RUN
CHANGE the "REPORTING SERVER" IP address to your sites server. This works, for me...
TomThis message has been edited. Last edited by: Tom Flynn,
BTW, After some thought, edasprof.prf is probably the best place to put the ampere variable, reason being, you probably have only 1 Client, but, in Dev Studio, you can access multiple environments/servers, PROD, DEV, QA, etc...
That is why &FOCEXURL does NOT contain the IP address or the HTTP/HTTPS...
So, adding this to edasprof:
-SET &SERVER = 'HTTP://AAA.YYY.xx.XXX:8080'; or -SET &SERVER = 'HTTPS://AAA.YYY.xx.XXX:8080';