Security Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Need Help for OIM errors (urgent)

Rebecca_IndiaAug 13 2013

Hi all

Thanks for reply in advance, i have got one error in OIM log, could some one please help me to understand and how to fix this issue ?

This is the user who is disabling every day and that too after the ADp file runs in 4 hours enterval. I want to know how to figure out what creates the root cause? Thanks for all help

2013-08-08 03:50:40,182 INFO [STDOUT] The parameters are given below

2013-08-08 03:50:40,182 INFO [STDOUT] The employeeid is=======1051201

2013-08-08 03:50:40,182 INFO [STDOUT] The BadgeNumber is=======32854

2013-08-08 03:50:40,182 INFO [STDOUT] The AreaID is=======222

2013-08-08 03:50:40,182 ERROR [XELLERATE.SERVER] Class/Method: tcTableDataObj/recordExists encounter some problems: Data Access Error

com.thortech.xl.dataaccess.tcDataSetException: Data Access Error

at com.thortech.xl.dataaccess.tcDataSet.executeQuery(Unknown Source)

at com.thortech.xl.dataobj.tcDataSet.executeQuery(Unknown Source)

at com.thortech.xl.dataaccess.tcDataSet.executeQuery(Unknown Source)

at com.thortech.xl.dataobj.tcDataSet.executeQuery(Unknown Source)

at com.thortech.xl.dataobj.tcTableDataObj.recordExists(Unknown Source)

at com.thortech.xl.dataobj.tcKeylessDataObj.runInitialSelect(Unknown Source)

at com.thortech.xl.dataobj.tcTableDataObj.initialize(Unknown Source)

at com.thortech.xl.dataobj.tcOSI.initialize(Unknown Source)

at com.thortech.xl.dataobj.tcOSI.<init>(Unknown Source)

at com.thortech.xl.dataobj.tcScheduleItem.initialize(Unknown Source)

at com.thortech.xl.dataobj.tcScheduleItem.<init>(Unknown Source)

at com.thortech.xl.adapterfactory.events.tcAdpEvent.updateSchItem(Unknown Source)

at com.thortech.xl.adapterGlue.ScheduleItemEvents.adpGEOFFREYCREATEUSER.implementation(adpGEOFFREYCREATEUSER.java:81)

at com.thortech.xl.client.events.tcBaseEvent.run(Unknown Source)

at com.thortech.xl.dataobj.tcDataObj.runEvent(Unknown Source)

at com.thortech.xl.dataobj.tcScheduleItem.runMilestoneEvent(Unknown Source)

at com.thortech.xl.dataobj.tcScheduleItem.eventPostInsert(Unknown Source)

at com.thortech.xl.dataobj.tcDataObj.insert(Unknown Source)

at com.thortech.xl.dataobj.tcDataObj.save(Unknown Source)

at com.thortech.xl.dataobj.tcOrderItemInfo.eventPostUpdate(Unknown Source)

at com.thortech.xl.dataobj.tcDataObj.update(Unknown Source)

at com.thortech.xl.dataobj.tcDataObj.save(Unknown Source)

at com.thortech.xl.dataobj.tcTableDataObj.save(Unknown Source)

at com.thortech.xl.adapterfactory.events.tcAdpEvent.updateDataSetValuePost(Unknown Source)

at com.thortech.xl.adapterfactory.events.tcAdpEvent.updateProcessFormFieldValue(Unknown Source)

at com.thortech.xl.adapterfactory.events.tcAdpEvent.finalizeProcessAdapter(Unknown Source)

at com.thortech.xl.adapterfactory.events.tcAdpEvent.finalizeAdapter(Unknown Source)

at com.thortech.xl.adapterGlue.ScheduleItemEvents.adp1199COPYSTRING.implementation(adp1199COPYSTRING.java:52)

at com.thortech.xl.client.events.tcBaseEvent.run(Unknown Source)

at com.thortech.xl.dataobj.tcDataObj.runEvent(Unknown Source)

at com.thortech.xl.dataobj.tcScheduleItem.runMilestoneEvent(Unknown Source)

at com.thortech.xl.dataobj.tcScheduleItem.eventPostInsert(Unknown Source)

at com.thortech.xl.dataobj.tcDataObj.insert(Unknown Source)

at com.thortech.xl.dataobj.tcDataObj.save(Unknown Source)

at com.thortech.xl.client.events.tcTriggerUserProcesses.insertMileStones(Unknown Source)

at com.thortech.xl.client.events.tcTriggerUserProcesses.trigger(Unknown Source)

at com.thortech.xl.client.events.tcUSRTriggerUserProcesses.implementation(Unknown Source)

at com.thortech.xl.client.events.tcBaseEvent.run(Unknown Source)

at com.thortech.xl.dataobj.tcDataObj.runEvent(Unknown Source)

at com.thortech.xl.dataobj.tcDataObj.eventPostUpdate(Unknown Source)

at com.thortech.xl.dataobj.tcUSR.eventPostUpdate(Unknown Source)

at com.thortech.xl.dataobj.tcDataObj.update(Unknown Source)

at com.thortech.xl.dataobj.tcDataObj.save(Unknown Source)

at com.thortech.xl.dataobj.tcTableDataObj.save(Unknown Source)

at com.thortech.xl.dataobj.tcRCE.updateUserRecord(Unknown Source)

at com.thortech.xl.dataobj.tcRCE.provisionObject(Unknown Source)

at com.thortech.xl.dataobj.tcRCE.linkToUser(Unknown Source)

at com.thortech.xl.dataobj.tcRCE.applyActionRules(Unknown Source)

at com.thortech.xl.dataobj.tcRCE.checkDataSorted(Unknown Source)

at com.thortech.xl.dataobj.tcRCE.eventPostUpdate(Unknown Source)

at com.thortech.xl.dataobj.tcDataObj.update(Unknown Source)

at com.thortech.xl.dataobj.tcDataObj.save(Unknown Source)

at com.thortech.xl.dataobj.tcTableDataObj.save(Unknown Source)

at com.thortech.xl.dataobj.tcRCE.finishDataReceived(Unknown Source)

at com.thortech.xl.schedule.jms.reconOffline.ProcessOfflineReconMessages.finishReconciliationEvent(Unknown Source)

at com.thortech.xl.schedule.jms.reconOffline.ProcessOfflineReconMessages.execute(Unknown Source)

at com.thortech.xl.schedule.jms.messagehandler.MessageProcessUtil.processMessage(Unknown Source)

at com.thortech.xl.schedule.jms.messagehandler.ReconMessageHandlerMDB.onMessage(Unknown Source)

at sun.reflect.GeneratedMethodAccessor254.invoke(Unknown Source)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)

at java.lang.reflect.Method.invoke(Method.java:597)

at org.jboss.invocation.Invocation.performCall(Invocation.java:359)

at org.jboss.ejb.MessageDrivenContainer$ContainerInterceptor.invoke(MessageDrivenContainer.java:495)

at org.jboss.resource.connectionmanager.CachedConnectionInterceptor.invoke(CachedConnectionInterceptor.java:158)

at org.jboss.ejb.plugins.MessageDrivenInstanceInterceptor.invoke(MessageDrivenInstanceInterceptor.java:116)

at org.jboss.ejb.plugins.CallValidationInterceptor.invoke(CallValidationInterceptor.java:63)

at org.jboss.ejb.plugins.AbstractTxInterceptor.invokeNext(AbstractTxInterceptor.java:121)

at org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxInterceptorCMT.java:350)

at org.jboss.ejb.plugins.TxInterceptorCMT.invoke(TxInterceptorCMT.java:181)

at org.jboss.ejb.plugins.RunAsSecurityInterceptor.invoke(RunAsSecurityInterceptor.java:109)

at org.jboss.ejb.plugins.LogInterceptor.invoke(LogInterceptor.java:205)

at org.jboss.ejb.plugins.ProxyFactoryFinderInterceptor.invoke(ProxyFactoryFinderInterceptor.java:138)

at org.jboss.ejb.MessageDrivenContainer.internalInvoke(MessageDrivenContainer.java:402)

at org.jboss.ejb.Container.invoke(Container.java:960)

at org.jboss.ejb.plugins.jms.JMSContainerInvoker.invoke(JMSContainerInvoker.java:1092)

at org.jboss.ejb.plugins.jms.JMSContainerInvoker$MessageListenerImpl.onMessage(JMSContainerInvoker.java:1392)

at org.jboss.jms.asf.StdServerSession.onMessage(StdServerSession.java:266)

at org.jboss.mq.SpyMessageConsumer.sessionConsumerProcessMessage(SpyMessageConsumer.java:906)

at org.jboss.mq.SpyMessageConsumer.addMessage(SpyMessageConsumer.java:170)

at org.jboss.mq.SpySession.run(SpySession.java:323)

at org.jboss.jms.asf.StdServerSession.run(StdServerSession.java:194)

at EDU.oswego.cs.dl.util.concurrent.PooledExecutor$Worker.run(PooledExecutor.java:761)

at java.lang.Thread.run(Thread.java:619)

Data AccessException:

com.thortech.xl.orb.dataaccess.tcDataAccessException: DB_READ_FAILEDDetail: SQL: select count(*) as RecordExists from osi where sch_key=542604Description: Got a null connectionSQL State: Vendor Code: 0Additional Debug Info:com.thortech.xl.orb.dataaccess.tcDataAccessException

at com.thortech.xl.dataaccess.tcDataAccessExceptionUtil.createException(Unknown Source)

at com.thortech.xl.dataaccess.tcDataBase.createException(Unknown Source)

at com.thortech.xl.dataaccess.tcDataBase.readPartialStatement(Unknown Source)

at com.thortech.xl.dataobj.tcDataBase.readPartialStatement(Unknown Source)