Bug Blog 11: Analytics doesn’t export Document Details

We’ve discussed WCI Analytics many times in these posts, and have covered quite a few bugs and patches. This post has all of that drama; so join me! You’ll laugh, you’ll cry. You’ll buy the book.

Every now and then, products in the WebCenter Interaction stack have a bug. And occasionally, Oracle releases a fix for said bug, and things are right with the universe again. But, once in a blue moon, that patch disappears when then the next version of the product is introduced. Such is the case with the “WebCenter Analytics Documents Report Export May Return Different Report [ID 783591.1]” issue.  The patch addresses this problem:

If you choose to “Export User Detail” for the “Other Metrics” section, “Documents” tab report, the results from a different report will be exported.

Or, more succinctly: if you export the User Detail report in Analytics for Collab Documents, it will not actually include document details.  The feature worked in the Aqualogic days, so what’s the deal now?  Well, the story is that you used to be able to export that report properly, then it was broken in ALI Analytics 2.5.  Oracle released a hotfix in 2.5 to repair the issue last year, and their release notes for the patch say to install patch 8198674, or upgrade to Analytics 10.3.

Problem is: the patch that worked for Analytics 2.5 isn’t applicable to 10.3, and 10.3 doesn’t include the patch.

Solution?  I’ll spare you the details of this pretty complicated trick, but at a high level, you need to:

  1. Download this fixed version of BaseCollabServerDataProvider.class, add it to analytics-webui.jar, and put that back into analytics.war.
  2. Add this line to the ptanalytics\10.3.0\settings\config\wrapper.conf file:

    wrapper.java.additional.21=-Dcom.bea.analytics.CollabInfoAtDocumentLevel=true

  3. Reinstall the service (see the patch release notes)

As shown in this source code diff, this class just defines the original “dimensions” in Analytics that include the document details:

This will cause your “export user details” report to change from this:

… to this:

Release notes for the patch after the break…

WebCenter Analytics Documents Report Export May Return Different Report [ID 783591.1]

Modified 28-OCT-2009     Type PROBLEM     Status PUBLISHED

In this Document
Symptoms
Cause
Solution
References


Applies to:

Oracle WebCenter Analytics – Version: 2.5 to 10.3
This problem can occur on any platform.

Symptoms

If you choose to “Export User Detail” for the “Other Metrics” section, “Documents” tab report, the results from a different report will be exported.

Cause

An unpublished bug is the root cause of this problem.

Solution

Download and install Patch 8198674 or upgrade to Analytics 10.3.0.1.

References


 

Related 


Products


  • Middleware > Enterprise 2.0 and Portals > Oracle WebCenter Interaction Products > Oracle WebCenter Analytics

 

Patches

 

README for 8198674
Patch Details

Readme for AquaLogic Interaction Analytics 2.5 MP1 Patch 343287, February 13, 2009
Copyright © 2009 Oracle, Inc. All Rights Reserved.

Contents

Issues Resolved in the Patch
Installing the Patch

Uninstalling the Patch

Issues Resolved in the Patch

This patch provides an update to Analytics 2.5 MP1 to fix bugs 7826985 and 8198674

Installing the Patch

This Patch is based on Analytics 2.5 MP1 and involves an update to the AL Analytics service.

1. Stop the AL Analytics service

2. Rename or move the existing analytics.war file stored in:

<bea root>\alui\ptanalytics\2.5\webapp

3. Copy the new analytics.war file contained in this fix to:

<bea root>\alui\ptanalytics\2.5\webapp

4. To enable document level detail for exported Document Views report, add this line to wrapper.conf file:

wrapper.java.additional.21=-Dcom.bea.analytics.CollabInfoAtDocumentLevel=true

To disable document level detail for exported Document Views report, comment previous line

5. After changing wrapper.conf file, run the following commands from <bea root>\alui\ptanalytics\2.5\bin

analyticsd.bat remove

analyticsd.bat install

6. Start the AL Analytics service

Uninstalling the Patch

To uninstall the Patch, replace the original analytics.war file saved in step 2, comment line added in step 4, and run commands detailed in step 5 above.

 

Tags: , ,

Leave a Reply