My Oracle Support Banner

Receive ORA-01008 Fulfillment Error When Trying To Send Email Blast From Campaign Schedules (Doc ID 404869.1)

Last updated on DECEMBER 04, 2019

Applies to:

Oracle Marketing - Version 11.5.10.0 to 11.5.10.3 [Release 11.5]
Information in this document applies to any platform.

Symptoms

When trying to send email blast from a campaign schedule, receive ORA-01008 error in Fulfillment.

Steps To Reproduce
The issue can be reproduced at will with the following steps:

Fulfillment Log Errors.  (Errors.log)
-- <1.0> -- thread:MASS REQUEST Monitor for 5000
 
Note : unable to process batch segments
oracle.apps.jtf.fm.engine.request.WorkNotCompletedException: unable to get batch parties
at oracle.apps.jtf.fm.engine.processor.MassRequestMonitor.processBatches(MassRequestMonitor.java:602)
at oracle.apps.jtf.fm.engine.processor.MassRequestMonitor.processRequest(MassRequestMonitor.java:450)
at oracle.apps.jtf.fm.engine.processor.RequestMonitor.newRequest(RequestMonitor.java:403)
at oracle.apps.jtf.fm.engine.processor.RequestMonitor.dequeue(RequestMonitor.java:212)
at oracle.apps.jtf.fm.engine.processor.RequestMonitor.run(RequestMonitor.java:137)
at java.lang.Thread.run(Thread.java:534)

-- <1.1> -- thread:MASS REQUEST Monitor for 5000
java.sql.SQLException: ORA-01008: not all variables bound
at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java)
at oracle.jdbc.ttc7.Oall7.receive(Oall7.java)
at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java)
at oracle.jdbc.ttc7.TTC7Protocol.parseExecuteDescribe(TTC7Protocol.java)
at oracle.jdbc.driver.OracleStatement.doExecuteQuery(OracleStatement.java)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java)
at oracle.jdbc.driver.OracleStatement.executeQuery(OracleStatement.java)
at oracle.apps.jtf.fm.engine.processor.MassRequestMonitor.delegateBatches(MassRequestMonitor.java:1031)
at oracle.apps.jtf.fm.engine.processor.MassRequestMonitor.processBatches(MassRequestMonitor.java:598)
at oracle.apps.jtf.fm.engine.processor.MassRequestMonitor.processRequest(MassRequestMonitor.java:450)
at oracle.apps.jtf.fm.engine.processor.RequestMonitor.newRequest(RequestMonitor.java:403)
at oracle.apps.jtf.fm.engine.processor.RequestMonitor.dequeue(RequestMonitor.java:212)
at oracle.apps.jtf.fm.engine.processor.RequestMonitor.run(RequestMonitor.java:137)
at java.lang.Thread.run(Thread.java:534)
Error Code : 1008
SQL State : 72000

Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.