Response Import based on Id fails on DB2 (Doc ID 1987164.1)

Last updated on JUNE 22, 2017

Applies to:

Siebel Marketing Automation - Version 8.1 [21039] and later
Information in this document applies to any platform.

Symptoms

ISSUE
=====
Response Import based on Id fails on DB2

ENVIRONMENT
==============
8.1.1.11 SIA [23030] version, Siebel Marketing, DB2

When attempting to import responses via an input file with contact IDs the following error occurs.

ERROR
-----------------------
The customer has got the following exception (in list import exception file):

Input Values: No Interest, 1-2DBNY, Response_Import_Test, 1-EDBQ, 1-3996784, Id: NO ID, Error: Required field 'First Name' is missing in integration component 'List Mgmt Prospective Contact'. Please enter a value for the field.
Input Values: Attended, 1-2DBO3, Response_Import_Test, 1-EDBA, 1-3996784, Id: NO ID, Error: Required field 'First Name' is missing in integration component 'List Mgmt Prospective Contact'. Please enter a value for the field.
Input Values: Gave Referral, 1-2DBO8, Response_Import_Test, 1-3AWL, 1-3996784, Id: NO ID, Error: Required field 'First Name' is missing in integration component 'List Mgmt Prospective Contact'. Please enter a value for the field.

In the log file it occurred as e.g.:
SBL-EAI-04389: Required field is missing in instance of Integration Component 'Account' with the user key '[Id] = "1-2CIN"': 'Name' is a required field. Please enter a value for the field.(SBL-DAT-00498)

The DB error in the logs is e.g.:
[IBM][CLI Driver][DB2/AIX64] SQL0206N "S_LEADPROD_IMPT.PROD_NAME" ist in dem verwendeten Kontext ungültig. SQLSTATE=42703
(in English:
SQL Warning, SQL State S0022, -206, [IBM][CLI Driver][DB2/NT] SQL0206N "S_LEADPROD_IMPT.PROD_NAME" is not valid in the context where it is used. SQLSTATE=42703

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Create import file with contact id
2. Setup import mapping for response
3. Activate the import job
=> See EAI errors and exception file in task log, no responses imported


BUSINESS IMPACT
-----------------------
Due to this issue, users cannot run response imports

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