The Purge on Publisher extraction fails.

Document ID : KB000085691
Last Modified Date : 14/04/2018
Show Technical Document Details
Issue:
Affects Release version(s): 5

Error Message :
The error message in the server.log:
#################
ERROR] 29 Apr 2013 11:39:32 [pool-1-thread-3] com.orsyp.reppub.server.process.pub.PublisherPurgeExtractionsProcess - 
java.sql.SQLException: ORA-02292: integrity constraint (PUBADMIN.fk_EXT_PROCEDURE_TYPE) violated - child record found

    at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112) 
    at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331) 
    at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288) 
    at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:745) 
    at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:210) 
    at oracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.java:961) 
    at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1190) 
    at oracle.jdbc.driver.OracleStatement.executeInternal(OracleStatement.java:1726) 
    at oracle.jdbc.driver.OracleStatement.execute(OracleStatement.java:1696) 
    at com.mchange.v2.c3p0.impl.NewProxyStatement.execute(NewProxyStatement.java:1006) 
    at com.orsyp.reppub.server.publisher.purge.PurgePublisherExtraction.purge(PurgePublisherExtraction.java:478) 
    at com.orsyp.reppub.server.process.pub.PublisherPurgeExtractionsProcess.purge(PublisherPurgeExtractionsProcess.java:67) 
    at com.orsyp.reppub.server.process.pub.PublisherPurgeExtractionsProcess.call(PublisherPurgeExtractionsProcess.java:42) 
    at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303) 
    at java.util.concurrent.FutureTask.run(FutureTask.java:138) 
    at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886) 
    at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908) 
    at java.lang.Thread.run(Thread.java:662)
#################

Patch level detected:Publisher 3.1.0
Product Version: Dollar.Universe 5.6.0 FX25010

Description :The Purge on Publisher extraction fails.
Environment:
OS: Windows
OS Version: ALL
Cause:
Cause type:
Other
Root Cause: The Publisher schema is corrupted.
Resolution:
It is necessary to delete Publisher schema and recreate it. Please ask you database administrator to perform the deletion and recreation of the Publisher schema.

Fix Status: Released

Fix Version(s):
Component: Publisher
Version: Dollar.Universe 5.6.0 FX25010
Additional Information:
Workaround :
N/A