BHD Is Not Processing Any Bounce Email Messages, bhd.log Shows "com.siebel.sem.common.db.DataProcessor$PartialFailureException: Bad Rows"

(Doc ID 2021628.1)

Last updated on SEPTEMBER 22, 2017

Applies to:

Siebel Email Marketing Server - Version 8.1.1.10 [23021] and later
Information in this document applies to any platform.

Symptoms

On : 8.1.1.10 [23021] version, Email Marketing Server

When BHD attempt to process a bounce email message it fails and the following error occurs.

2015-06-11 13:47:55,328 [QueueReader-0-queueDir] DEBUG3 BounceProcessor Error for RowID: 1-2MI0OI8
2015-06-11 13:47:55,328 [QueueReader-0-queueDir] ERROR QueueReader Partial failure processing file dataq.0000000001
com.siebel.sem.common.db.DataProcessor$PartialFailureException: Bad Rows
at com.siebel.sem.bhd.integrated.BounceProcessor.process(BounceProcessor.java:115)
at com.siebel.sem.common.db.QueueReader.run(QueueReader.java:135)
at java.lang.Thread.run(Thread.java:662)

The issue can be reproduced at will with the following steps:
1. Start BHD
2. BHD received some bounces
3. Siebel Database is not updated.
4. The bhd.log shows:

2015-06-11 13:47:55,328 [QueueReader-0-queueDir] DEBUG3 BounceProcessor Error for RowID: 1-2MI0OI8
2015-06-11 13:47:55,328 [QueueReader-0-queueDir] ERROR QueueReader Partial failure processing file dataq.0000000001
com.siebel.sem.common.db.DataProcessor$PartialFailureException: Bad Rows
at com.siebel.sem.bhd.integrated.BounceProcessor.process(BounceProcessor.java:115)
at com.siebel.sem.common.db.QueueReader.run(QueueReader.java:135)
at java.lang.Thread.run(Thread.java:662)

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms