May 28, 2008, 11:18 AM
Prariequote:
self service app to a .fex on devstudio?
self service app to a .fex on devstudio?
Do you mean Self Sevice to MRE?
| In Focus since 1993. WebFOCUS 7.7.03 Win 2003 |
May 28, 2008, 11:27 AM
GinnyJakesI have a sneaky suspicion that he means a fex on his desktop. If that is the case, RSquared, then the answer is no unless you have a full funtioning version of WebFOCUS running on your PC.
Ginny
---------------------------------
Prod: WF 7.7.01 Dev: WF 7.6.9-11
Admin, MRE,self-service; adapters: Teradata, DB2, Oracle, SQL Server, Essbase, ESRI, FlexEnable, Google
May 28, 2008, 11:49 AM
RSquaredNope, not on the desktop, but on a server. The user signs on to a Launch page that is DevStudio. The Launch page then executes an Html file that has the Webfocus in it. When I try to drill down to a .fex that is in the same project folder. I get an error message.
(FOC227) THE FOCEXEC PROCEDURE CANNOT BE FOUND:
SEC-DailyNewCasesSummaryReportCasetype
(FOC227) THE FOCEXEC PROCEDURE CANNOT BE FOUND:
SEC-DailyNewCasesSummaryReportCasetype
WF 7.6.11
Oracle
WebSphere
Windows NT-5.2 x86 32bit
May 28, 2008, 02:01 PM
Darin LeeIt's not exactly clear how you're environment is working. Users don't sign on to launch pages in DevStudio. Is every user running their own version of DevStudio pointing to a shared project on a network? Normally the launch page and fex files are either in a WF server application directory or within an MRE environment - both of which can be accessed through DevStudio, but are not in nor part of DevStudio. In any case, the fex name that you are searching for is probably a property of the fex (you can call them whatever you want) but is not the actual name of the fex. WF does not like dashes in fex names. and they are usually shorter names. Fexes you've created via DevStudio are given an eight character name. The actual name can be seen by right clicking the fex and selecting properties.
Regards,
Darin
In FOCUS since 1991
WF Server: 7.7.04 on Linux and Z/OS, ReportCaster, Self-Service, MRE, Java, Flex
Data: DB2/UDB, Adabas, SQL Server Output: HTML,PDF,EXL2K/07, PS, AHTML, Flex
WF Client: 77 on Linux w/Tomcat
May 28, 2008, 02:19 PM
RSquaredDarin,
Sorry, I left out or typed over a line. The user signs on to the server using a javascript process that executes the launch page. BTW when I click on the properties, the name is
SEC-DailyNewCasesSummaryReportCasetype.fex and the locations is
IBFS:/PCFNASCENT/DEV/secretaryreports/
WF 7.6.11
Oracle
WebSphere
Windows NT-5.2 x86 32bit
May 28, 2008, 02:50 PM
GinnyJakesIf you are getting procedure not found, that is because the focexec you are drilling to is not in the default path. You can add the IBIAPP_app parameter to the stylesheet syntax to point to the directory where the program is. Then your URL will be generated correctly.
There are lots of examples of how to do this on this forum. Please search for IBIAPP_app.
Ginny
---------------------------------
Prod: WF 7.7.01 Dev: WF 7.6.9-11
Admin, MRE,self-service; adapters: Teradata, DB2, Oracle, SQL Server, Essbase, ESRI, FlexEnable, Google
May 28, 2008, 02:55 PM
GinnyJakesDarin,
The 8-character limit for focexec names is strictly for MRE and I think has been lifted in 764. R is trying to run a self-service focexec.
But your point about the launch pages being in the web server path is well taken.
R, are you doing remote development either through Projects or Data Servers? Please explain your archtecture further.
Ginny
---------------------------------
Prod: WF 7.7.01 Dev: WF 7.6.9-11
Admin, MRE,self-service; adapters: Teradata, DB2, Oracle, SQL Server, Essbase, ESRI, FlexEnable, Google
June 02, 2008, 04:19 PM
RSquaredGinny,
All the .fexs and .htms are in the same DevStudio Project tree. The way we are trying to work things around here is to have all the bureaus sign on the same way. The cick on an icon that invokes a Java process that validates the User and then sends them to the appropriate Launc page, which resides in the DevStudio project HTML files folder. The Launch Page then executes other HTML pages, which contain the WF code. These part work OK. We only have a problem when we try to drill down from one of these HTML reports. The message if FOC227.
Thanks
RR
WF 7.6.11
Oracle
WebSphere
Windows NT-5.2 x86 32bit
June 02, 2008, 05:58 PM
GinnyJakesRR, If you are getting a FOC227 then my original post states the problem. WebFOCUS cannot find the focexec it is looking for. When you do a drill, it starts up another agent and if that agent doesn't know the path or location of the child report because you didn't specify it on the stylesheet syntax or it is not in the profile of the server or the user, then it will not be able to find the program.
Please check into this.
Ginny
---------------------------------
Prod: WF 7.7.01 Dev: WF 7.6.9-11
Admin, MRE,self-service; adapters: Teradata, DB2, Oracle, SQL Server, Essbase, ESRI, FlexEnable, Google
June 03, 2008, 06:31 PM
Darin LeeI probably don't understand your whole environment, but from what you describe, what you are trying to do does not fall within what a Dev Studio license allows. Dev Studio is intended for single, local user development and running of procedures. Multiple users should not be "logging" in to a devStudio environment to run reports. What you are able to do and what you are allowed to do are two separate things.
Regards,
Darin
In FOCUS since 1991
WF Server: 7.7.04 on Linux and Z/OS, ReportCaster, Self-Service, MRE, Java, Flex
Data: DB2/UDB, Adabas, SQL Server Output: HTML,PDF,EXL2K/07, PS, AHTML, Flex
WF Client: 77 on Linux w/Tomcat
June 04, 2008, 10:23 AM
Chuck BLet's be clear. If the fex is in the local projects tree of Developer Studio, the fex resides on an individuals desktop or a shared drive. As Darrin says, the licensing for Developer Studio doesn't allow for this as it is intended for single user development only. If the fex resides in the WebFOCUS Environments tree, then if in the Data Servers area, the fex resides on the WebFOCUS Reporting Server. The caveat, is if the fex is in the localhost (or individual's machine name) data server, then again, it is local to that PC. It is odd that any customer would drill back to an individuals workstation. If the fex is in the localhost tree, just move it to a WFRS that is not on the local machine and ensure that the application is in the app path and the fex should be found. MRE is a different story. If you're trying to drill to MRE, there is an MR cookie that gets loaded when you authenticate to MRE. You cannot drill from Self service to MRE, as you've not authenticated. I'm sure that there are ways with custom security programs, but it seems like entirely too much work for the benefit received.
WebFOCUS 7.6.4 on Windows XP Professional
June 05, 2008, 02:21 PM
RSquaredHey Folks,
After working with IBI Tech Support, I was able to get this Beastie going. Yes, it was a APPPATH issue and we came up with 2 solutions, first was to move all the drill down fex to baseapp, and the other is to add a line to the first WF code,
APP PREPENDPATH seclaunch
Thanks All
WF 7.6.11
Oracle
WebSphere
Windows NT-5.2 x86 32bit
June 05, 2008, 04:02 PM
GinnyJakesI knew it!
Ginny
---------------------------------
Prod: WF 7.7.01 Dev: WF 7.6.9-11
Admin, MRE,self-service; adapters: Teradata, DB2, Oracle, SQL Server, Essbase, ESRI, FlexEnable, Google
June 05, 2008, 04:45 PM
RSquaredGinny,
I kinda knew it too, but I just couldn't find a way to make it work, until today. BTW IB is still trying to find out why the other solutions, such as the one you suggested, does not work.
WF 7.6.11
Oracle
WebSphere
Windows NT-5.2 x86 32bit