CTD Click Not Captured: ERROR QueueReader Partial failure processing file dataq.0000000001 (Doc ID 2008751.1)

Last updated on SEPTEMBER 22, 2017

Applies to:

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

Symptoms

On : 8.1.1.11 [23030] version, Email Marketing Server Siebel Financial application V8.1.1.11 with EMS 629.


The customer is implementing campaign management with email marketing daemons(ESD,BHD,CTD). They have done the setup for CTD and tried sending out a test email with link to www.google.com

When the user, clicks on the google link, they are able to see the google.com page loading up but the same click is not captured on Siebel side. In the CTD logs, they can see that request has reached CTD server but while processing it shows the below error.


ERROR
-----------------------

In the CTD log file the following error was seen:


2015-05-01 16:36:30,665 [QueueReader-2-clickQ] DEBUG3 ClickthroughProcessor Error for RowID: 1-PU13TN Error Message is: [0] Method 'WriteRecord' of business component 'Response' (integration component 'Response') returned the following error:
"'Feedback Reason' is a required field.Please enter a value for the field."(SBL-EAI-04376) (0x7c0097)

2015-05-01 16:36:30,665 [QueueReader-2-clickQ] ERROR QueueReader Partial failure processing file dataq.0000000002
com.siebel.sem.common.db.DataProcessor$PartialFailureException: Bad Rows
at com.siebel.sem.ctd.integrated.ClickthroughProcessor.process(ClickthroughProcessor.java:135)
at com.siebel.sem.common.db.QueueReader.run(QueueReader.java:135)
at java.lang.Thread.run(Thread.java:701)


In the EAIObjMgr log file the following was seen:

EAISiebAdpt EAISiebAdptTrcBusObj 4 0000076c55420012:0 2015-04-30 19:27:44 Value 'Clicked On URL' for business component field 'Response Type' couldn't be translated to a language dependent value
EAISiebAdpt EAISiebAdptTrcBusObj 4 0000076c55420012:0 2015-04-30 19:27:44 Set business component field: 'Response Type', Value: 'Clicked On URL'
EAISiebAdpt EAISiebAdptTrcBusObj 4 0000076c55420012:0 2015-04-30 19:27:44 Get business component field: 'Response Type', Value: ''
CchMgrLog CchMgrAcsInfo 4 0000076c55420012:0 2015-04-30 19:27:44 Accesses item [Response Type PickList.1-PQEG3R.ENU] in cache [LOV].
CchMgrLog CchMgrAcsInfo 4 0000076c55420012:0 2015-04-30 19:27:44 Item [Response Type PickList.1-PQEG3R.ENU] is in cache [LOV].
CchMgrLog CchMgrAcsInfo 4 0000076c55420012:0 2015-04-30 19:27:44 Accesses item [Response Type PickList.DO.ENU] in cache [LOV].
CchMgrLog CchMgrAcsInfo 4 0000076c55420012:0 2015-04-30 19:27:44 Item [Response Type PickList.DO.ENU] is in cache [LOV].
ObjMgrBusCompLog Error 1 0000076c55420012:0 2015-04-30 19:27:44 (buscomp.cpp (33498)) SBL-DAT-00225: The value entered in field Response Type of buscomp Response does not match any value in the bounded pick list Response Type PickList.
ObjMgrLog Error 1 0000076c55420012:0 2015-04-30 19:27:44 (adptutils.cpp (7083)) SBL-EAI-04376: Method 'SetFieldValue' of business component 'Response' (integration component 'Response') returned the following error:
"The value entered in field Response Type of buscomp Response does not match any value in the bounded pick list Response Type PickList.(SBL-DAT-00225)"

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