Hello,

After many tried, I have now the collection process that runs with IDM
4.5.4 + RBPM 4.5.4 and reporting server 4.5.3.

So, when I start a collection , I can see the status "running
collection" but after a while there is an error in the catalina out and
the collection state becomes "supsended".

The error in catalina.out is :

2016-08-16 11:23:16,874 [pool-8-thread-1] TRACE
com.novell.idm.rpt.core.server.dc.MsAccount- [RPT-CORE] Unique not
found
2016-08-16 11:23:16,875 [pool-8-thread-1] TRACE
com.novell.idm.rpt.core.server.dc.MsAccount- [RPT-CORE] Get unique row:
data object class:class
com.novell.idm.rpt.core.server.persist.rptdata.Idm rptMsIdentity,
FiltermsUuid=8ad6293351d5481f9142de84d318c43c)(acctIdVal ue=CN=Administrator,CN=Users,DC=test,DC=tst,DC=tst )
2016-08-16 11:23:16,893 [pool-8-thread-1] TRACE
com.novell.idm.rpt.core.server.dc.MsAccount- [RPT-CORE] Unique row
found, values:
(firstName=)(identityId=3b7e33277b0d4402a23374527c 3879e8)(msUuid=8ad6293351d5481f9142de84d318c43c)(a cctIdValue=CN=Administrator,CN=Users,DC=test,DC=ts t,DC=tst)(fullName=Administrator
test)(emailAddress=postmaster@tst.tst)(idmrptValid From=2015-11-05
18:45:40.818)(managerFlag=false)(identityDesc=Buil t-in account for
administering the
computer/domain)(idmrptSynState=1)(idmrptDeleted=false)
2016-08-16 11:23:16,911 [pool-8-thread-1] DtstG
com.novell.idm.rpt.core.server.dc.MsAccount- [RPT-CORE] DCS: Failed to
add Account: VAL:admintstMS: 8ad6293351d5481f9142de84d318c43c, account
id type is: sAMAccountName
com.netiq.persist.PersistenceException: Battst entry 0 insert into
idm_rpt_data.idmrpt_ms_acct (identity_id, acct_id_type,
ms_acct_global_identifier, acct_id_value, acct_status, acct_type,
idmrpt_valid_from, ms_id, ms_ent_type_id, idmrpt_deleted, idv_managed,
idv_sync, idv_ms_app_name, idv_association, idv_acct_id,
ms_idv_acct_status, idmrpt_syn_state, ms_acct_id) values
('3b7e33277b0d4402a23374527c3879e8', 'sAMAccountName',
'CN=Administrator,CN=Users,DC=test,DC=tst,DC=tst', 'admintst', 'A',
NULL, '2016-08-16 11:23:16.857000 +02:00:00',
'8ad6293351d5481f9142de84d318c43c', 'd42e6bb40f9248fca09d1c3ba2b2c103',
'0', '0', '0', NULL, '7f72b49daa78f44d8afe166a920e87a4', NULL, 'U', 1,
'767b3167b03f4188b1c8a5a3bd8ec559') was aborted. Call getNextException
to see the cause.
ERROR: duplicate key value violates unique constraint "uk_ms_acct"

at com.netiq.persist.HibernateUtil.commit(HibernateUt il.java:249)
at
com.novell.idm.rpt.core.server.dc.MsAccount.procce ss(MsAccount.java:237)
at
com.novell.idm.rpt.core.server.dc.PDCQueryResult.p roccesstRecords(PDCQueryResult.java:91)
at
com.novell.idm.rpt.core.server.dc.BasePDCService.p rocessResultRecords(BasePDCService.java:329)
at
com.novell.idm.rpt.core.server.dc.BasePDCService.e xecuteCollection(BasePDCService.java:171)
at
com.novell.idm.rpt.core.server.service.DataCollect MgrService$DataCollectionTask.call(DataCollectMgrS ervice.java:815)
at
com.novell.idm.rpt.core.server.service.DataCollect MgrService$DataCollectionTask.call(DataCollectMgrS ervice.java:767)
at java.util.concurrent.FutureTask.run(FutureTask.jav a:266)
at
java.util.concurrent.StsteduledThreadPoolExecutor$ StsteduledFutureTask.access$201(StsteduledThreadPo olExecutor.java:180)
at
java.util.concurrent.StsteduledThreadPoolExecutor$ StsteduledFutureTask.run(StsteduledThreadPoolExecu tor.java:293)
at
java.util.concurrent.ThreadPoolExecutor.runWorker( ThreadPoolExecutor.java:1142)
at
java.util.concurrent.ThreadPoolExecutor$Worker.run (ThreadPoolExecutor.java:617)
at java.lang.Thread.run(Thread.java:745)
Caused by: org.hibernate.exception.ConstraintViolationExcepti on: Could
not execute JDBC battst update
at
org.hibernate.exception.SQLStateConverter.convert( SQLStateConverter.java:96)
at
org.hibernate.exception.JDBCExceptionHelper.conver t(JDBCExceptionHelper.java:66)
at
org.hibernate.jdbc.AbstractBattster.executeBattst( AbstractBattster.java:275)
at
org.hibernate.engine.ActionQueue.executeActions(Ac tionQueue.java:268)
at
org.hibernate.engine.ActionQueue.executeActions(Ac tionQueue.java:184)
at
org.hibernate.event.def.AbstractFlushingEventListe ner.performExecutions(AbstractFlushingEventListene r.java:321)
at
org.hibernate.event.def.DefaultFlushEventListener. onFlush(DefaultFlushEventListener.java:51)
at org.hibernate.impl.SessionImpl.flush(SessionImpl.j ava:1216)
at org.hibernate.impl.SessionImpl.managedFlush(Sessio nImpl.java:383)
at
org.hibernate.transaction.JDBCTransaction.commit(J DBCTransaction.java:133)

Any idea ?

thanks a lot.

Regards

Sylvain


--
sma
------------------------------------------------------------------------
sma's Profile: https://forums.netiq.com/member.php?userid=174
View this thread: https://forums.netiq.com/showthread.php?t=56439