Tuesday, December 23, 2008

Tracing BI Dashboard Activity

Turning on traces for the WebFOCUS BI Dashboard involves tinkering with an XML configuration file on the Java application server. Like the WebFOCUS server traces, use caution -- play with a test server before trying this in production.

On a Windows box running WebFOCUS 7, you will find this BID configuration file at drive:\ibi\webfocus7x\worp\conf\bid-config.xml. It contains a parameter telling WebFOCUS whether or not to trace dashboard activity.

Within < > brackets, you will see:

trace-option trace-flag="false" trace-level="DEBUG"/


To start tracing, change the "false" to "true" and restart the Java app server. WebFOCUS will then create trace files for each person logging into the dashboard. On a Windows box, WebFOCUS 7 stores the logs in a folder called: drive:\ibi\webfocus7x\logs.

WebFOCUS names the output log files with a prefix of a unique number and "DashboardTracing." It also adds a suffix of the userid and date-time stamp. The naming format is: #####_DashboardTracing_userid_yymmdd_hhmmss.trace.

When you are done tracing BID activity, change the configuration setting back to "false" and restart the app server.



Below is an example of a Windows WebFOCUS BI Dashboard log-in failure:

**********************************C:/ibi/WebFOCUS76/logs\00101_DashboardTracing_doug_071126_112944.trace
Gen Date: Mon Apr 2 16:31:57 EDT 2007
Gen Number: 4
Gen Label: branch761
Server Info: Apache Tomcat/5.5.17
2 11/26/2007 11:29:44:937 INFO WORP_RM.logDefaultTraceInfo
2 11/26/2007 11:29:44:937 INFO WORP_RM.logDefaultTraceInfo ###########################################
2 11/26/2007 11:29:44:937 INFO WORP_RM.logDefaultTraceInfo Request type: WORP_LOGIN
2 11/26/2007 11:29:44:937 INFO WORP_RM.logDefaultTraceInfo Is valid session: false
2 11/26/2007 11:29:44:937 INFO WORP_RM.logDefaultTraceInfo ************************************
2 11/26/2007 11:29:44:937 DEBUG WORP_RM.logDefaultTraceInfo Request Parameters:
2 11/26/2007 11:29:44:937 DEBUG WORP_RM.logDefaultTraceInfo WORP_REQUEST_TYPE=WORP_LOGIN
2 11/26/2007 11:29:44:937 DEBUG WORP_RM.logDefaultTraceInfo IBIWF_language=en
2 11/26/2007 11:29:44:937 DEBUG WORP_RM.logDefaultTraceInfo WORP_USER=doug
2 11/26/2007 11:29:44:937 DEBUG WORP_RM.logDefaultTraceInfo WORP_PASS=******
2 11/26/2007 11:29:44:937 DEBUG WORP_RM.logDefaultTraceInfo ************************************
2 11/26/2007 11:29:44:937 DEBUG WORP_RM.logDefaultTraceInfo Request Attributes:
2 11/26/2007 11:29:44:937 DEBUG WORP_RM.logDefaultTraceInfo ************************************
2 11/26/2007 11:29:44:937 DEBUG SignonAdapter.createWFMRSession Created WFMRSession
2 11/26/2007 11:29:44:937 DEBUG WORP_SignonManager.singon() Signing on to Dashboard
2 11/26/2007 11:29:44:937 DEBUG WORP_SignonManager.singon() Doing form authentication: doug
2 11/26/2007 11:29:44:937 DEBUG WORP_SignonManager.singon() Doing single signon
2 11/26/2007 11:29:44:937 ERROR WORP_RM.doPost Exception
ibi.worp.util.WORP_Exception: (19105) Invalid user ID or password. Please try again.
at ibi.worp.mrapi.WORP_SignonAdapter.signon(WORP_SignonAdapter.java:383)
at ibi.worp.WORP_SignonManager.signon(WORP_SignonManager.java:449)
at ibi.worp.WORP_RM.doPost(WORP_RM.java:1655)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:709)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:869)
at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:664)
at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527)
at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684)
at java.lang.Thread.run(Unknown Source)
Caused by: ibi.webfoc.wfmre.mrutil.WFMRError: The User ID or Password you have entered is incorrect.
at ibi.webfoc.wfmre.mrutil.WFMRUtil.throwMRError(WFMRUtil.java:1691)
at ibi.webfoc.wfmre.repos.htm_bd.WFMRFileUserHandler.getAuthenticatedUser(WFMRFileUserHandler.java:1104)
at ibi.webfoc.wfmre.repos.core_bd.WFMRRouterUserHandler.getAuthenticatedUser(WFMRRouterUserHandler.java:212)
at ibi.webfoc.wfmre.repos.WFMRUserHandlerProxy.getAuthenticatedUser(WFMRUserHandlerProxy.java:454)
at ibi.webfoc.wfmre.mrobj.WFMRRepository.getAuthenticatedUser(WFMRRepository.java:650)
at ibi.webfoc.wfmre.WFMRSession.getAuthenticatedUser(WFMRSession.java:478)
at ibi.webfoc.wfmre.WFMRSession.authenticateUser(WFMRSession.java:825)
at ibi.worp.mrapi.WORP_SignonAdapter.signon(WORP_SignonAdapter.java:380)
... 18 more
2 11/26/2007 11:29:44:937 DEBUG WORP_SessionUtil.doDispatch forwarding to: /bid-login
2 11/26/2007 11:29:44:937 DEBUG ibi.worp.xml.WORP_DocumentBuilder.open Opening file for reading=C:/ibi/WebFOCUS76\config\basedir-config.xml



No comments:

About Me

My photo

I am a project-based consultant, helping data-intensive firms use agile methods and automation tools to replace legacy reporting and bring in modern BI/Analytics to leverage Social, Cloud, Mobile, Big Data, Visualizations, and Predictive Analytics. For several world-class vendors, I led services teams specializing in providing software implementation and custom application development. Based on scores of successful engagements, I have assembled proven methodologies and automated software tools.

During twenty years of technical consulting, I have been blessed to work with smart people from some of the world's most respected organizations, including: FedEx, Procter & Gamble, Nationwide, The Wendy's Company, The Kroger Co., JPMorgan Chase, MasterCard, Bank of America Merrill Lynch, Siemens, American Express, and others.

I was educated at Valparaiso University and the University of Cincinnati, graduating summa cum laude. In 1990, I joined Information Builders, the vendor of WebFOCUS BI and iWay enterprise integration products, and for over a dozen years served in branch leadership roles. For several years, I also led technical teams within Cincom Systems' ERP software product group and the custom software services arm of Xerox.

Since 2007, I have provided enterprise BI services such as: strategic advice; architecture, design, and software application development of intelligence systems (interactive dashboards and mobile); data warehousing; and automated modernization of legacy reporting.