Reporter cannot properly connect to the target database during extraction

Document ID : KB000086989
Last Modified Date : 14/04/2018
Show Technical Document Details
Issue:
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.
Environment:
OS: 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.
Resolution:
With Reporter v3.0.09, the required ojdbc driver is ojdbc5.jar.

Fix Status: No Fix
 
Additional Information:
Workaround :
N/A