Reporter cannot properly connect to the target database during extraction
Article ID: 86989
Updated On:
Products
CA Automic Dollar Universe
Issue/Introduction
Affects Release version(s): 5
Error Message :
The error message in server.log:
##########################
[ERROR] 10 Dec 2012 14:47:46 [pool-1-thread-2] com.orsyp.reppub.server.manager.db.rep.RepExtSourceStatusPMImpl -
org.springframework.dao.InvalidDataAccessApiUsageException: The given object has a null identifier: com.orsyp.reppub.common.status.ExtractionSourceStatus; nested exception is org.hibernate.TransientObjectException: The given object has a null identifier: com.orsyp.reppub.common.status.ExtractionSourceStatus
Caused by:
org.hibernate.TransientObjectException: The given object has a null identifier: com.orsyp.reppub.common.status.ExtractionSourceStatus
at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.getUpdateId(DefaultSaveOrUpdateEventListener.java:228)
at org.hibernate.event.def.DefaultUpdateEventListener.getUpdateId(DefaultUpdateEventListener.java:46)
at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.entityIsDetached(DefaultSaveOrUpdateEventListener.java:215)
at org.hibernate.event.def.DefaultUpdateEventListener.performSaveOrUpdate(DefaultUpdateEventListener.java:33)
at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.onSaveOrUpdate(DefaultSaveOrUpdateEventListener.java:70)
at org.hibernate.impl.SessionImpl.fireUpdate(SessionImpl.java:564)
at org.hibernate.impl.SessionImpl.update(SessionImpl.java:552)
at org.hibernate.impl.SessionImpl.update(SessionImpl.java:544)
at org.springframework.orm.hibernate3.HibernateTemplate$14.doInHibernate(HibernateTemplate.java:647)
at org.springframework.orm.hibernate3.HibernateTemplate.execute(HibernateTemplate.java:362)
at org.springframework.orm.hibernate3.HibernateTemplate.update(HibernateTemplate.java:644)
at org.springframework.orm.hibernate3.HibernateTemplate.update(HibernateTemplate.java:640)
at com.orsyp.reppub.server.manager.db.rep.RepExtSourceStatusPMImpl.update(RepExtSourceStatusPMImpl.java:320)
at com.orsyp.reppub.server.manager.db.rep.RepExtSourceStatusPMImpl.update(RepExtSourceStatusPMImpl.java:27)
at com.orsyp.reppub.server.reporter.etl.ExtractionSourceETL.setStatusToAborted(ExtractionSourceETL.java:175)
at com.orsyp.reppub.server.reporter.etl.ExtractionSourceETL.runETL(ExtractionSourceETL.java:85)
at com.orsyp.reppub.server.process.ReporterExtractExtractionSource.call(ReporterExtractExtractionSource.java:71)
at java.util.concurrent.FutureTask$Sync.innerRun(Unknown Source)
at java.util.concurrent.FutureTask.run(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
at java.lang.Thread.run(Unknown Source)
[ERROR] 10 Dec 2012 14:47:46 [pool-1-thread-2] com.orsyp.reppub.server.reporter.etl.ExtractionSourceETL -
com.orsyp.reppub.common.exception.PersistenceException: Database communication error.
at com.orsyp.reppub.server.manager.db.rep.RepExtSourceStatusPMImpl.update(RepExtSourceStatusPMImpl.java:331)
at com.orsyp.reppub.server.manager.db.rep.RepExtSourceStatusPMImpl.update(RepExtSourceStatusPMImpl.java:27)
at com.orsyp.reppub.server.reporter.etl.ExtractionSourceETL.setStatusToAborted(ExtractionSourceETL.java:175)
at com.orsyp.reppub.server.reporter.etl.ExtractionSourceETL.runETL(ExtractionSourceETL.java:85)
at com.orsyp.reppub.server.process.ReporterExtractExtractionSource.call(ReporterExtractExtractionSource.java:71)
at java.util.concurrent.FutureTask$Sync.innerRun(Unknown Source)
at java.util.concurrent.FutureTask.run(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
at java.lang.Thread.run(Unknown Source)
Caused by: org.springframework.dao.InvalidDataAccessApiUsageException: The given object has a null identifier: com.orsyp.reppub.common.status.ExtractionSourceStatus; nested exception is org.hibernate.TransientObjectException: The given object has a null identifier: com.orsyp.reppub.common.status.ExtractionSourceStatus
at org.springframework.orm.hibernate3.SessionFactoryUtils.convertHibernateAccessException(SessionFactoryUtils.java:643)
at org.springframework.orm.hibernate3.HibernateAccessor.convertHibernateAccessException(HibernateAccessor.java:408)
at org.springframework.orm.hibernate3.HibernateTemplate.execute(HibernateTemplate.java:367)
at org.springframework.orm.hibernate3.HibernateTemplate.update(HibernateTemplate.java:644)
at org.springframework.orm.hibernate3.HibernateTemplate.update(HibernateTemplate.java:640)
at com.orsyp.reppub.server.manager.db.rep.RepExtSourceStatusPMImpl.update(RepExtSourceStatusPMImpl.java:320)
... 9 more
Caused by: org.hibernate.TransientObjectException: The given object has a null identifier: com.orsyp.reppub.common.status.ExtractionSourceStatus
at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.getUpdateId(DefaultSaveOrUpdateEventListener.java:228)
at org.hibernate.event.def.DefaultUpdateEventListener.getUpdateId(DefaultUpdateEventListener.java:46)
at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.entityIsDetached(DefaultSaveOrUpdateEventListener.java:215)
at org.hibernate.event.def.DefaultUpdateEventListener.performSaveOrUpdate(DefaultUpdateEventListener.java:33)
at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.onSaveOrUpdate(DefaultSaveOrUpdateEventListener.java:70)
at org.hibernate.impl.SessionImpl.fireUpdate(SessionImpl.java:564)
at org.hibernate.impl.SessionImpl.update(SessionImpl.java:552)
at org.hibernate.impl.SessionImpl.update(SessionImpl.java:544)
at org.springframework.orm.hibernate3.HibernateTemplate$14.doInHibernate(HibernateTemplate.java:647)
at org.springframework.orm.hibernate3.HibernateTemplate.execute(HibernateTemplate.java:362)
... 12 more
##########################
Patch level detected:Reporter 3.0.0
Product Version: Dollar.Universe 5.6.0 FX25010
Description :The validation of connection from Reporter to the target database works correctly, but during the extraction, Reporter can not properly connect to the target database.
Error Message :
The error message in server.log:
##########################
[ERROR] 10 Dec 2012 14:47:46 [pool-1-thread-2] com.orsyp.reppub.server.manager.db.rep.RepExtSourceStatusPMImpl -
org.springframework.dao.InvalidDataAccessApiUsageException: The given object has a null identifier: com.orsyp.reppub.common.status.ExtractionSourceStatus; nested exception is org.hibernate.TransientObjectException: The given object has a null identifier: com.orsyp.reppub.common.status.ExtractionSourceStatus
Caused by:
org.hibernate.TransientObjectException: The given object has a null identifier: com.orsyp.reppub.common.status.ExtractionSourceStatus
at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.getUpdateId(DefaultSaveOrUpdateEventListener.java:228)
at org.hibernate.event.def.DefaultUpdateEventListener.getUpdateId(DefaultUpdateEventListener.java:46)
at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.entityIsDetached(DefaultSaveOrUpdateEventListener.java:215)
at org.hibernate.event.def.DefaultUpdateEventListener.performSaveOrUpdate(DefaultUpdateEventListener.java:33)
at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.onSaveOrUpdate(DefaultSaveOrUpdateEventListener.java:70)
at org.hibernate.impl.SessionImpl.fireUpdate(SessionImpl.java:564)
at org.hibernate.impl.SessionImpl.update(SessionImpl.java:552)
at org.hibernate.impl.SessionImpl.update(SessionImpl.java:544)
at org.springframework.orm.hibernate3.HibernateTemplate$14.doInHibernate(HibernateTemplate.java:647)
at org.springframework.orm.hibernate3.HibernateTemplate.execute(HibernateTemplate.java:362)
at org.springframework.orm.hibernate3.HibernateTemplate.update(HibernateTemplate.java:644)
at org.springframework.orm.hibernate3.HibernateTemplate.update(HibernateTemplate.java:640)
at com.orsyp.reppub.server.manager.db.rep.RepExtSourceStatusPMImpl.update(RepExtSourceStatusPMImpl.java:320)
at com.orsyp.reppub.server.manager.db.rep.RepExtSourceStatusPMImpl.update(RepExtSourceStatusPMImpl.java:27)
at com.orsyp.reppub.server.reporter.etl.ExtractionSourceETL.setStatusToAborted(ExtractionSourceETL.java:175)
at com.orsyp.reppub.server.reporter.etl.ExtractionSourceETL.runETL(ExtractionSourceETL.java:85)
at com.orsyp.reppub.server.process.ReporterExtractExtractionSource.call(ReporterExtractExtractionSource.java:71)
at java.util.concurrent.FutureTask$Sync.innerRun(Unknown Source)
at java.util.concurrent.FutureTask.run(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
at java.lang.Thread.run(Unknown Source)
[ERROR] 10 Dec 2012 14:47:46 [pool-1-thread-2] com.orsyp.reppub.server.reporter.etl.ExtractionSourceETL -
com.orsyp.reppub.common.exception.PersistenceException: Database communication error.
at com.orsyp.reppub.server.manager.db.rep.RepExtSourceStatusPMImpl.update(RepExtSourceStatusPMImpl.java:331)
at com.orsyp.reppub.server.manager.db.rep.RepExtSourceStatusPMImpl.update(RepExtSourceStatusPMImpl.java:27)
at com.orsyp.reppub.server.reporter.etl.ExtractionSourceETL.setStatusToAborted(ExtractionSourceETL.java:175)
at com.orsyp.reppub.server.reporter.etl.ExtractionSourceETL.runETL(ExtractionSourceETL.java:85)
at com.orsyp.reppub.server.process.ReporterExtractExtractionSource.call(ReporterExtractExtractionSource.java:71)
at java.util.concurrent.FutureTask$Sync.innerRun(Unknown Source)
at java.util.concurrent.FutureTask.run(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
at java.lang.Thread.run(Unknown Source)
Caused by: org.springframework.dao.InvalidDataAccessApiUsageException: The given object has a null identifier: com.orsyp.reppub.common.status.ExtractionSourceStatus; nested exception is org.hibernate.TransientObjectException: The given object has a null identifier: com.orsyp.reppub.common.status.ExtractionSourceStatus
at org.springframework.orm.hibernate3.SessionFactoryUtils.convertHibernateAccessException(SessionFactoryUtils.java:643)
at org.springframework.orm.hibernate3.HibernateAccessor.convertHibernateAccessException(HibernateAccessor.java:408)
at org.springframework.orm.hibernate3.HibernateTemplate.execute(HibernateTemplate.java:367)
at org.springframework.orm.hibernate3.HibernateTemplate.update(HibernateTemplate.java:644)
at org.springframework.orm.hibernate3.HibernateTemplate.update(HibernateTemplate.java:640)
at com.orsyp.reppub.server.manager.db.rep.RepExtSourceStatusPMImpl.update(RepExtSourceStatusPMImpl.java:320)
... 9 more
Caused by: org.hibernate.TransientObjectException: The given object has a null identifier: com.orsyp.reppub.common.status.ExtractionSourceStatus
at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.getUpdateId(DefaultSaveOrUpdateEventListener.java:228)
at org.hibernate.event.def.DefaultUpdateEventListener.getUpdateId(DefaultUpdateEventListener.java:46)
at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.entityIsDetached(DefaultSaveOrUpdateEventListener.java:215)
at org.hibernate.event.def.DefaultUpdateEventListener.performSaveOrUpdate(DefaultUpdateEventListener.java:33)
at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.onSaveOrUpdate(DefaultSaveOrUpdateEventListener.java:70)
at org.hibernate.impl.SessionImpl.fireUpdate(SessionImpl.java:564)
at org.hibernate.impl.SessionImpl.update(SessionImpl.java:552)
at org.hibernate.impl.SessionImpl.update(SessionImpl.java:544)
at org.springframework.orm.hibernate3.HibernateTemplate$14.doInHibernate(HibernateTemplate.java:647)
at org.springframework.orm.hibernate3.HibernateTemplate.execute(HibernateTemplate.java:362)
... 12 more
##########################
Patch level detected:Reporter 3.0.0
Product Version: Dollar.Universe 5.6.0 FX25010
Description :The validation of connection from Reporter to the target database works correctly, but during the extraction, Reporter can not properly connect to the target database.
Environment
OS: All
OS Version: ALL
OS Version: ALL
Cause
Cause type:
Configuration
Root Cause: The known root cause is that the ojdbc driver version used by the Reporter is not the correct one.
Configuration
Root Cause: The known root cause is that the ojdbc driver version used by the Reporter is not the correct one.
Resolution
With Reporter v3.0.09, the required ojdbc driver is ojdbc5.jar.
Fix Status: No Fix
Fix Status: No Fix
Additional Information
Workaround :
N/A
N/A
Feedback
Yes
No
Powered by
