WCI Analytics Group Sync Job Fails Unexpectedly

(Doc ID 1054670.1)

Last updated on NOVEMBER 18, 2016

Applies to:

Oracle WebCenter Analytics - Version 2.0 to 10.3.0.1
Information in this document applies to any platform.

Symptoms

When using custom Analytics reports the Analytics Group Sync fails with the following errors if any existing group has been modified (OOTB reports do not use the information gathered by the Group Sync) :

Job log:

Jan 27, 2010 4:06:53 PM- stdout>2010/01/27 16:06:53:367 PST [LOG] Starting AnalyticsRunJobs ...
Jan 27, 2010 4:06:54 PM- stderr>Exception in thread "Main Thread" org.hibernate.AssertionFailure: null id in entry (don't flush the Session after an exception occurs)
Jan 27, 2010 4:06:54 PM- stderr> at org.hibernate.event.def.DefaultFlushEntityEventListener.checkId(DefaultFlushEntityEventListener.java:49)
Jan 27, 2010 4:06:54 PM- stderr> at org.hibernate.event.def.DefaultFlushEntityEventListener.onFlushEntity(DefaultFlushEntityEventListener.java:82)
Jan 27, 2010 4:06:54 PM- stderr> at org.hibernate.event.def.AbstractFlushingEventListener.flushEntities(AbstractFlushingEventListener.java:190)
Jan 27, 2010 4:06:54 PM- stderr> at org.hibernate.event.def.AbstractFlushingEventListener.flushEverythingToExecutions(AbstractFlushingEventListener.java:70)
Jan 27, 2010 4:06:54 PM- stderr> at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:26)
Jan 27, 2010 4:06:54 PM- stderr> at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:730)
Jan 27, 2010 4:06:54 PM- stderr> at com.plumtree.analytics.job.AnalyticsJobBaseObject.flushCreateBuffer(AnalyticsJobBaseObject.java:204)
Jan 27, 2010 4:06:54 PM- stderr> at com.plumtree.analytics.job.AnalyticsJobBaseObject.flushBuffers(AnalyticsJobBaseObject.java:218)
Jan 27, 2010 4:06:54 PM- stderr> at com.plumtree.analytics.job.GroupSyncJob.run(GroupSyncJob.java:151)
Jan 27, 2010 4:06:54 PM- stderr> at com.plumtree.analytics.job.RunJobs.runJob(RunJobs.java:129)
Jan 27, 2010 4:06:54 PM- stderr> at com.plumtree.analytics.job.RunJobs.main(RunJobs.java:305)
Jan 27, 2010 4:06:55 PM- Operation completed with exit code 1
Jan 27, 2010 4:06:55 PM- Total Memory = 39260160 bytes, Free Memory = 0 bytes, Used Memory = 39260160 bytes.
Jan 27, 2010 4:06:55 PM- *** Job Operation #1 failed: Operation completed with exit code 1(282610)


Analytics Sync.log:

27 Jan 2010 15:28:05,742 INFO RunJobs - Group Sync started at Wed Jan 27 15:28:05 PST 2010
27 Jan 2010 15:28:05,742 INFO JDBCUtil - Validating connection info: jdbc:plumtree:sqlserver://<your DB Server>:1433;DatabaseName=<your DB name>
27 Jan 2010 15:28:05,867 WARN JDBCExceptionReporter - SQL Error: 2601, SQLState: 23000
27 Jan 2010 15:28:05,867 ERROR JDBCExceptionReporter - [plumtree][SQLServer JDBC Driver][SQLServer]Cannot insert duplicate key row in object 'dbo.ASDIM_GROUPS' with unique index 'IX_GROUPBYGROUPID'.
27 Jan 2010 15:28:05,867 WARN JDBCExceptionReporter - SQL Error: 3621, SQLState: HY000
27 Jan 2010 15:28:05,867 ERROR JDBCExceptionReporter - [plumtree][SQLServer JDBC Driver][SQLServer]The statement has been terminated.
27 Jan 2010 15:28:05,867 ERROR AnalyticsJobBaseObject - Exception in storeObject: org.hibernate.exception.ConstraintViolationException: could not insert: [com.plumtree.analytics.core.persist.Group]
27 Jan 2010 15:28:05,867 ERROR AnalyticsJobBaseObject - Object: com.plumtree.analytics.core.persist.Group@25698b
27 Jan 2010 15:28:05,867 ERROR GroupSyncJob - Cannot store new user with ID: <updated group ID>
27 Jan 2010 15:28:05,867 ERROR GroupSyncJob - UpdateFailedException while updating data sources: com.plumtree.analytics.job.exception.UpdateFailedException
27 Jan 2010 15:28:05,883 ERROR AssertionFailure - an assertion failure occured (this may indicate a bug in Hibernate, but is more likely due to unsafe use of the session)
org.hibernate.AssertionFailure: null id in entry (don't flush the Session after an exception occurs)
at org.hibernate.event.def.DefaultFlushEntityEventListener.checkId(DefaultFlushEntityEventListener.java:49)
at org.hibernate.event.def.DefaultFlushEntityEventListener.onFlushEntity(DefaultFlushEntityEventListener.java:82)
at org.hibernate.event.def.AbstractFlushingEventListener.flushEntities(AbstractFlushingEventListener.java:190)
at org.hibernate.event.def.AbstractFlushingEventListener.flushEverythingToExecutions(AbstractFlushingEventListener.java:70)
at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:26)
at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:730)
at com.plumtree.analytics.job.AnalyticsJobBaseObject.flushCreateBuffer(AnalyticsJobBaseObject.java:204)
at com.plumtree.analytics.job.AnalyticsJobBaseObject.flushBuffers(AnalyticsJobBaseObject.java:218)
at com.plumtree.analytics.job.GroupSyncJob.run(GroupSyncJob.java:151)
at com.plumtree.analytics.job.RunJobs.runJob(RunJobs.java:129)
at com.plumtree.analytics.job.RunJobs.main(RunJobs.java:305)


As a result, the 'Groups' option in the 'Group By' filter may not display an updated list.

Changes

Modifying the properties of an existing (and previously sync'd) portal group.

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