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     How to identify the user ID who submitted the query

Read-Only Read-Only Topic
Go
Search
Notify
Tools
How to identify the user ID who submitted the query
 Login/Join
 
Member
posted
Hello

Our WebFOCUS applications is used by multiple users.
Does anybody know how to identify the user ID of the deferred query? Is any a specific file or data on the server which would show userID of the running query/report?

Thank you, Mila


WebFOCUS 7.1
UNIX
 
Posts: 18 | Registered: May 15, 2008Report This Post
Platinum Member
posted Hide Post
Mila,

You can see the user who is executing a WF program in the WF console
(http://servername:port/cgiatt.exe)

This is under Workspace->Monitor->Data Services(Agents) in WF 7.6.2.

You will need to have IBI_REPORT_USER = &IBIMR_user in your ../client/wfc/etc/cgivars.wfs file. If it is not set currently, you will need to restart your Web server and WF processes after making the update.

Also, Resource Analyser tracks information about the reports that were run, who ran them, and other info. There are a series of SM* tables used to store this data.

Sean

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


------------------------------------------------------------------------
PROD: WebFOCUS 7.6.2 on Unix AIX/Tomcat/Servlet Mode
TEST: WebFOCUS 7.6.2 on Unix AIX/Tomcat/Servlet Mode
 
Posts: 210 | Location: Ottawa | Registered: November 03, 2005Report This Post
Member
posted Hide Post
Thak you, Sean


WebFOCUS 7.1
UNIX
 
Posts: 18 | Registered: May 15, 2008Report This Post
Member
posted Hide Post
Thank you Sean

We have the following issue which sometimes causes our environment to collapse – one of the reports eats up all the space. Currently, Report Analyzer is not an option.
How to identify the user ID by just looking on the report files on the server? I believe the Console shows user by report name, but in these cases the report name is unknown. Can the console display the size of the hold files by report name and user? This would be helpfull.

Thank you, Mila


WebFOCUS 7.1
UNIX
 
Posts: 18 | Registered: May 15, 2008Report This Post
Platinum Member
posted Hide Post
Mila,

I don't know what's available in 7.1, but in the 7.6 console, there is a column labelled State. I can right-click on the text in that column, then select View Statistics, and there is a window that displays. In that window, one of the items is Last MasterFile Name. This might tell you what you need to know.

Other than that, maybe someone else knows more info that will help.

Sean


------------------------------------------------------------------------
PROD: WebFOCUS 7.6.2 on Unix AIX/Tomcat/Servlet Mode
TEST: WebFOCUS 7.6.2 on Unix AIX/Tomcat/Servlet Mode
 
Posts: 210 | Location: Ottawa | Registered: November 03, 2005Report This Post
Expert
posted Hide Post
Hold files are stored in EDATEMP and deleted when the report is done. The best you can do is monitor the agents and if you see one running a long time, log onto your Unix box and go to the directory under EDATEMP that has the agent id in it. You will be able to see the hold file being created.

If you were running self-service and the users logged on, the directory would be owned by the user but based on this post from you and another post, I think you are doing MRE. If that is the case and you are running a reporting server with OPSYS security and a default Unix id, all edatemp directories will be owned by that user.

I would do what smiths said and try to capture the MRE id so that you can track that back to the MRE user.


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
 
Posts: 2723 | Location: Ann Arbor, MI | Registered: April 05, 2006Report This Post
Member
posted Hide Post
Thank you, Sean, very much

have a nice weekend, Mila


WebFOCUS 7.1
UNIX
 
Posts: 18 | Registered: May 15, 2008Report This Post
Virtuoso
posted Hide Post
You could also just look back through the edaprint and you would be able to see which user(s) have connected just before the time when the problem occurs. Then give them 50 lashes. Smiler


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
 
Posts: 2298 | Location: Salt Lake City, Utah | Registered: February 02, 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     How to identify the user ID who submitted the query

Copyright © 1996-2020 Information Builders