Web Analytics: Fact Population Program Fails With ORA-30926 (Doc ID 1310836.1)

Last updated on NOVEMBER 18, 2015

Applies to:

Oracle Web Analytics - Version 12.0.4 and later
Information in this document applies to any platform.

Symptoms


Release 12.0.4
When running the request set to load DBI data , the Web Analytics: Fact Population Program is failing with ORA-30926: unable to get a stable set of rows in the source tables.





Excerpts from the log -
IBW_FACT_POPULATION module: Web Analytics: Fact Population Program
+---------------------------------------------------------------------------+

Current system time is 22-MAR-2011 19:07:02

+---------------------------------------------------------------------------+

**Starts**22-MAR-2011 19:07:02
**Ends**22-MAR-2011 21:15:39
errbuf -30926-ORA-30926: unable to get a stable set of rows in the source tables





Starting Fact Population Concurrent Program
Getting Guest user id from GUEST_USER_PWD profile
Populating ibw_guest_party_table
Get last pat update date
Clean up Page views temp table
Processing Express Checkout cache stored in ibw_page_views_tmp
Migrating Display pageviews from PAT schema into temp table starting from 06-JUL-09
Migrating Processing iStore pageviews FROM PAT schema into temp table
Get all page views for visits split across offline engine runs
Creating pages
Cannot create a new page for visit_id :8022142 and seq num :1

Cannot create a new page for visit_id :8022142 and seq num :2
Cannot create a new page for visit_id :8022162 and seq num :5
Cannot create a new page for visit_id :8022163 and seq num :1
Cannot create a new page for visit_id :8022163 and seq num :2
Cannot create a new page for visit_id :8022186 and seq num :1
Cannot create a new page for visit_id :8022186 and seq num :2
Cannot create a new page for visit_id :8022088 and seq num :2
Cannot create a new page for visit_id :8022143 and seq num :2
Cannot create a new page for visit_id :8022143 and seq num :3
Cannot create a new page for visit_id :8022165 and seq num :1
...


Creating new Page instances
Getting Page views COUNT
Process login events into page views tmp table
Updating vistant Id,user_id,party_id for missing login events
Updating processing page events from cache
Updating processing page events from temp table

Changes

Upgrade from 11i to Release 12.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms