Focal Point Banner


As of December 1, 2020, Focal Point is retired and repurposed as a reference repository. We value the wealth of knowledge that's been shared here over the years. You'll continue to have access to this treasure trove of knowledge, for search purposes only.

Join the TIBCO Community
TIBCO Community is a collaborative space for users to share knowledge and support one another in making the best use of TIBCO products and services. There are several TIBCO WebFOCUS resources in the community.

  • From the Home page, select Predict: WebFOCUS to view articles, questions, and trending articles.
  • Select Products from the top navigation bar, scroll, and then select the TIBCO WebFOCUS product page to view product overview, articles, and discussions.
  • Request access to the private WebFOCUS User Group (login required) to network with fellow members.

Former myibi community members should have received an email on 8/3/22 to activate their user accounts to join the community. Check your Spam folder for the email. Please get in touch with us at community@tibco.com for further assistance. Reference the community FAQ to learn more about the community.


Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     WF Maintain -- MNTCON call does not pass MRE variables to edasprof?

Read-Only Read-Only Topic
Go
Search
Notify
Tools
WF Maintain -- MNTCON call does not pass MRE variables to edasprof?
 Login/Join
 
Virtuoso
posted
I'm invoking Maintain from a dashboard page via a javascript MNTCON call and all is rosy save for one little detail -- the &IBIMR_user and &IBIMR_domain variables are not available in edasprof. edasprof runs but the amper variables (I've set them to pass to the Reporting Server) throw an error -- (FOC295) A VALUE IS MISSING FOR: &IBIMR_user.

My WF reports run like a dream, using those variables in the profile (and in a _site_profile that I use to set connections) but for MNTCON calls they seem to disappear.

Any insight on how to correct this problem?

J.



 
Posts: 1012 | Location: At the Mast | Registered: May 17, 2007Report This Post
Virtuoso
posted Hide Post
If you indeed use a javascript to call the maintain then you will have to provide all variables to pass to the maintain by means of the javascript. After all, you're building a URL (whether or not it uses a form) with your script and all that the called process needs to know has to be in that url or form.


GamP

- Using AS 8.2.01 on Windows 10 - IE11.
in Focus since 1988
 
Posts: 1961 | Location: Netherlands | Registered: September 25, 2007Report This Post
Master
posted Hide Post
I have been creating htm files that take passed values and assign them to amper variables to be passed into my Maintain procedure. This technique adds random variables to assure there is no caching.

Mark



<script language="JavaScript">
function launchMaintainProc()
{
var loc = document.location.search;
loc = loc.replace("?",'');
var nameandvalue = loc.split("=");
var XXX = nameandvalue[1];
//document.getElementById('PROGMMR_NAME_Edit').value = nameandvalue[1];
var getRandomNum = Math.random();
var launchURL = "/ibi_apps/WFServlet?IBIS_connect=on&IBIAPP_APP=gartner";
launchURL = launchURL + "&IBIC_server=EDASERVE&IBIC_user=anyone&IBIC_pass=anyone";
launchURL = launchURL + "&IBIF_cmd=MNTCON+APPPATH+gartner;MNTCON+EX+demo;";
launchURL = launchURL + "&MYPROSPECTS_ID_Edit=" + XXX;
launchURL = launchURL + "×tamp=" + getRandomNum;
var cmd = launchURL + "," + "_blank" + "," + "toolbar=no" + "," + "menubar=yes";
document.location.href=cmd;
}


 
Posts: 663 | Location: New York | Registered: May 08, 2003Report This Post
Virtuoso
posted Hide Post
This is for a security setup, so I need &IBIMR_user and &IBIMR_domain to be picked up off of the system internally.

I'm a bit confused -- the variables are available in the Maintain where I also use them, but my DB connection is to be assigned based upon user and domain, so the _site_profile or the edasprof profile needs to be able to see these variables.

The site profile and the profile are running -- I see them throw the error on the system log. It functions properly for reporting and it appears that site.wfs processes since the variables are available in the Maintain code, but they aren't available in the profile or the _site_profile routine prior to Maintain's invocation on the server.

J.

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



 
Posts: 1012 | Location: At the Mast | Registered: May 17, 2007Report This Post
Expert
posted Hide Post
Mark, isn't it true that when you use IBIF_cmd, you don't get the variables set. ?

In the past I've used cookies to get variables, as these are availabe at the maintain level, and can be retrieved with IWC.cgiAppParms, assuming this still exists, as I haven't used Maintain for 5 years.


Waz...

Prod:WebFOCUS 7.6.10/8.1.04Upgrade:WebFOCUS 8.2.07OS:LinuxOutputs:HTML, PDF, Excel, PPT
In Focus since 1984
Pity the lost knowledge of an old programmer!

 
Posts: 6349 | Location: 33°49'23.0"S, 151°11'41.0"E | Registered: October 31, 2006Report This Post
Virtuoso
posted Hide Post
I can get them in the Maintain, but I don't need them in the Maintain. I need them in the edasprof or the _site_profile focexec.

J.



 
Posts: 1012 | Location: At the Mast | Registered: May 17, 2007Report This Post
Expert
posted Hide Post
Sorry John, my misunderstanding.

I wonder if you turned on tracing, if you can see the variables being passed around.

Perhaps it may give you a direction to look into.


Waz...

Prod:WebFOCUS 7.6.10/8.1.04Upgrade:WebFOCUS 8.2.07OS:LinuxOutputs:HTML, PDF, Excel, PPT
In Focus since 1984
Pity the lost knowledge of an old programmer!

 
Posts: 6349 | Location: 33°49'23.0"S, 151°11'41.0"E | Registered: October 31, 2006Report This Post
Platinum Member
posted Hide Post
Passed variables are not pulled in until the reporting server profiles are passed. As a result I don't think that will work.

You can however include a FEX in the _site_profile which sets up a Reporting Server connection. The variables will be populated at that time.


WF 71.x, 76.x, 7701, 8.0 Beta OS: Linux, Win2k3, Win2k, Win2k8, WinXP


 
Posts: 203 | Registered: November 19, 2007Report This Post
Virtuoso
posted Hide Post
quote:
You can however include a FEX in the _site_profile which sets up a Reporting Server connection. The variables will be populated at that time.


No they won't. That's exactly what I've described above and it's not working.

One more time with feeling and dramatic music:

-- I have a _site_profile focexec. In my _site_profile focexec I have code that looks at the &IBIMR_user and &IBIMR_domain and decides which connection strings to apply for the run.

-- This works perfectly for reporting. Dashboard screens that call for reports apply the connection correctly and all works as expected.

-- It fails for WF Maintain.

-- Specifically, when a call to MNTCON occurs, the _site_profile focexec executes as expected, but it throws an error -- (FOC295) A VALUE IS MISSING FOR: &IBIMR_user. This error appears in the system log. The Maintain screen pukes on startup. The variables should be there -- it works for reporting.

The url being call is running through WFServlet.

 http;//10.1.5.4:8080/ibi_apps/WFServlet?IBIF_cmd=MNTCON RUN madp_app_inf
&IBIS_passthru=on&IBIS_connect=on&IBIAPP_app=mdp&IBIC_server=MDP&App_Key=100&Appl_Key=00000100000&Action=ed_curr&RandomNum=0.01506543335626681
 


Any insight?

J.



 
Posts: 1012 | Location: At the Mast | Registered: May 17, 2007Report This Post
Platinum Member
posted Hide Post
Try adding the following to your site.wfs to get the MR userid:

httpsession=_USERID_VAL
<IF> IBIMR_action EQ "MR_SIGNON"
<CALL> CopyWFVarToSessionVar(IBIMR_user,httpsession)
<ELSE>
wfvar=IBIMR_user
<CALL> CopySessionVarToWFVar(httpsession,wfvar)
<ENDIF>
<SET> IBIMR_user (pass)



If that works, try the following for the domain:
httpsession=_domain_val
<IF> IBIMR_domain NE "" AND IBIMR_domain NE null 
<CALL> CopyWFVarToSessionVar(IBIMR_domain,httpsession)
<ELSE>
wfvar=IBIMR_domain
<CALL> CopySessionVarToWFVar(httpsession,wfvar)
<ENDIF>
<SET> IBIMR_domain (pass)

NOTE: The above by default will set a blank value for the variable if for some reason its not populated. This happens whenever you put a
"<SET> VARNAME (pass)".


WF 71.x, 76.x, 7701, 8.0 Beta OS: Linux, Win2k3, Win2k, Win2k8, WinXP


 
Posts: 203 | Registered: November 19, 2007Report This Post
Virtuoso
posted Hide Post
I tried adding that material to my site.wfs and I see no change.

So I did some serious digging this evening and it appears that the error in the log appears regardless of whether it's a Maintain call or a WF call. Odd that the &IBIMR_user variable can't be seen there.

My _site_profile focexec CAN see the &IBIMR_user variable, and it clearly runs for the WF calls. My guess is that it does not run for the Maintain call. That may be how it's designed.

This is going to sound like an incredibly simple question, but I'd like to hear your answers -- if I'm passing the MR variables via site.wfs, SHOULD they be available in the edasprof? I've been doing this for years and it seems to me the answer has always been yes, but that's not what I'm seeing. Maybe I've just always assumed the profile could see it.

J.



 
Posts: 1012 | Location: At the Mast | Registered: May 17, 2007Report This Post
Virtuoso
posted Hide Post
John

_site_profile is NOT called when issuing an IBIF_cmd, only using IBIF_ex.

To get around this create a focexec:
-INCLUDE my_site_profile
MNTCON RUN mymaintain

in the url use
...WFServlet?IBIF_cmd=EX the_above_focexec&...

Also the _site_profile is NOT called when running an EXEC or call from the maintain. If you want to exec:
.
.
.
EXEC my_site_profile KEEP ...
.
.
.
EXEC a_table_request KEEP ...
.
.
.


Alan.
WF 7.705/8.007
 
Posts: 1451 | Location: Portugal | Registered: February 07, 2007Report This Post
Virtuoso
posted Hide Post
That's big news right there. Thank you very much for explaining how the system works.

Can anyone speak to the &IBIMR variables not being defined in the edasprof? Is this to be expected?

J.



 
Posts: 1012 | Location: At the Mast | Registered: May 17, 2007Report This Post
Platinum Member
posted Hide Post
Unless they've changed the processing, no amper variables are pulled in from a request until after the Reporting Server has processed all its profiles (including edasprof.prf). As a results &IBIMR variables will not be available to the edasprof.prf.

The reason why including something in the _site_profile passed from the WebFOCUS Client is different is because that basically acts like a -INCLUDE in the front of the FEX. By the time the actual FEX is processed, the amper variables HAVE been pulled in, and are available for processing.


WF 71.x, 76.x, 7701, 8.0 Beta OS: Linux, Win2k3, Win2k, Win2k8, WinXP


 
Posts: 203 | Registered: November 19, 2007Report This Post
Virtuoso
posted Hide Post
This is remarkably bad news. Exceptionally clear and concise and I thank you for providing such a detailed description, but still bad news.

I need to figure out a way to define connection strings for Maintain calls (about 100 different ones) based upon userid and domain. This could be interesting.

J.



 
Posts: 1012 | Location: At the Mast | Registered: May 17, 2007Report This Post
Virtuoso
posted Hide Post
John

If you use the process I mentioned above, then all connection strings can be set up in the _site_profile. This, IMHO, is a better place to have dynamic connection strings than EDASPROF, AND the variables you need will be there.

Use EDASPROF for everything fixed, _site_profile for everything dynamic.


Alan.
WF 7.705/8.007
 
Posts: 1451 | Location: Portugal | Registered: February 07, 2007Report This Post
Virtuoso
posted Hide Post
I like it, but it means a lot of retrofitting to make it work.

J.



 
Posts: 1012 | Location: At the Mast | Registered: May 17, 2007Report This Post
  Powered by Social Strata  

Read-Only Read-Only Topic

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     WF Maintain -- MNTCON call does not pass MRE variables to edasprof?

Copyright © 1996-2020 Information Builders