The Sad, Sordid Story of WCI Analytics 10.3.0.1 and Its Three Critical Fixes

Back in April, I wrote a WebCenter Interaction Patch and Hotfix Round-up. Since then, a couple of additional critical fixes have been released for Analytics. And you probably need them.

If, after upgrading to WCI Analytics 10.3.0.1, you’re not seeing any new events being recorded, check any one of your Analytics Views in your database. Chances are, you’re seeing a NULL value for VisitID:

Oracle has released three separate critical fixes trying to get this finally working, and from my experience you need to install the last two listed in the table below.

The real problem is, this isn’t just a matter of swapping out files, since for each month that passes before you notice this problem, more tables will continue to have these invalid values. And Oracle’s fix in the last patch set is FAR from ideal if you want to get those VISITIDs recreated. I won’t bore you with the details (trust me, you’ll be bored enough running this crazy fix), but suffice it to say that there are no less than 15 steps. And during those steps, potentially dozens of SQL scripts are generated (depending on how many months you need to created). For each month that you need to restore, you have to stop the collector, run a couple scripts, start the collector, then let it run a while to recreate everything. Wait a while, verify the number of untagged events you have, repeat:

How long does it take? Quoting from the Readme file: “Tagging old event data can take days or weeks to complete depending on the volume of your event records. Internal tests repaired the data at a rate of 150k to 300k events per hour.”. DAYS or WEEKS!?

In practice, I’ve run through each of these in about a day, going back about 6 months on moderately sized installations. But you should plan on getting these updates in there sooner than later, because the longer you wait, the longer it’s going to take you to repair all those busted tables.

Patch/Fix Files Affected Bugs Fixed
p8206841

4/8/2009

10.3.0 Critical-Fix 344949

analytics-common.jar
analytics-jobs.jar
8206841 – analytics disable_partition setting does not work.

7825372 – analyticspartition.bat does not generate monthly records for asdim_time

p8603381

6/29/2009

10.3.0 Patch 349008

analytics.war 8603381 – Collaboration project search throws JSF error.

8206841 – Analytics disable_partition setting does not work.

7825372 – Analyticspartition.bat does not generate monthly records for asdim_time

p8851900

9/30/2009

10.3.0 Patch 352463

analytics-jobs.jar 8851900 – Analytics user property sync job locks portal ptpropertydata table.

8206841 – analytics disable_partition setting does not work.

7825372 – analyticspartition.bat does not generate monthly records for asdim_time

p8891580

10/1/2009

10.3.0 Critical-Fix 353404

analytics-common.jar 8206841- Analytics disable_partition setting does not work.

7825372 – Analyticspartition.bat does not generate monthly records for asdim_time

8891580 – When updating tables Analytics25update.bat ORA-01000 exception.

8872597 – Analytics25update.bat runs scripts on collab items that do not work in Oracle DB

V17926-01

11/2009

WebCenter Analytics 10gR3 (10.3.0.1)

All (new install) 7822093 – Asian characters exported to a tsv file display as garbled question mark (?).
p9469037

4/14/2010

10.3.0.1 Critical-Fix 360755

analytics-common.jar
create_analytics_ schema.sql
9469037 – asavfact_* views incorrectly require visitid’s for managed events.

9488799 – The asvfact_ views of guest user events will not return any results.

p8764675

8/3/2010

10.3.0.1 Critical-Fix 364583

analytics-api.jar
analytics-common.jar
8764675 – JAVA.SQL.SQLEXCEPTION: NUMERIC OVERFLOW ERROR WHEN EXECUTING SEARCH REPORT

9469037 – ASAVFACT_* VIEWS INCORRECTLY REQUIRE VISITID’S FOR MANAGED EVENTS.

9488799 – THE ASVFACT_ VIEWS OF GUEST USER EVENTS WILL NOT RETURN ANY RESULTS.

7824943 – ANALYTICS GROUP SYNC FAILS WITH ERRORS IF ANY EXISTING GROUP IS MODIFIED

7824944 – RUN_AUTH_SOURCE_SYNC FOR ANALYTICSRUNJOBS.BAT FAILS IF AN AUTH SOURCE CREATED

8851900 – ANALYTICS USER PROPERTY SYNC JOB LOCKS PORTAL PTPROPERTYDATA TABLE

p8891580

9/20/2010

10.3.0 Critical-Fix 353404

analytics-collector.jar
analytics-common.jar
9632585 – COLLECTOR VISITMANAGER ERROR: DIFFERENCE OF TWO DATETIME COLUMNS CAUSED OVERFLOW

9632813 – COLLECTOR ASSIGNS EVENTS FROM MULTIPLE USERS, DAYS IN ONE VISIT

9796857 – COMMVISITID ARE DIFFERENT IN-SPITE OF SAME VISIT AND COMMUNITYID

9769048 – ANALYTICS COLLECTOR STOPS WRITING EVENTS TO THE DATABASE UNDER MODERATE LOAD

Tags: , ,

2 Responses to “The Sad, Sordid Story of WCI Analytics 10.3.0.1 and Its Three Critical Fixes”

  1. Geoff Garcia says:

    How do you stay on top of patch and hot fix releases?

    Also, where are the analytics hotfixes? I need to install 10.3.0.1 first then the rest of the patches/fixes you identified above.

    I went to edelivery and looked under the BEA Aqualogic media pack, but they only have analytics 2.5 MP1.
    Under Fusion/Fusion 11g (Windows 32) there is only Identity Analytics.

Leave a Reply