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 software consultant, specializing in automating transitions from legacy reporting applications into modern BI/Analytics to leverage Social, Cloud, Mobile, Big Data, Visualizations, and Predictive Analytics using Information Builders' WebFOCUS. Based on scores of successful engagements, I have assembled proven Best Practice methodologies, software tools, and templates.

I have been blessed to work with innovators from firms such as: Ford, 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, where I graduated summa cum laude. In 1990, I joined Information Builders and for over a dozen years served in regional pre- and post-sales technical leadership roles. Also, for several years I led the US technical services teams within Cincom Systems' ERP software product group and the Midwest 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. My experience with BI products include WebFOCUS (vendor certified expert), R, SAP Business Objects (WebI, Crystal Reports), Tableau, and others.