SBL-SVR-01054

Applies to:

Siebel Enterprise Integration Manager - Version 8.0.0.2 [20412] and later
Information in this document applies to any platform.
***Checked for relevance on 04-Dec-2012***

Symptoms

The EIM DELETE task does not complete successfully when deleting rows from S_CON_ADDR using EIM_ADDR_PER. The following errors are seen in the Server Manager Command line window when the EIM task is executed from the same:

SBL-ADM-60070: Error reported one server “SIEBEIM8” follows:
SBL-SVR-01054: The task exited without sending has response.
In attachment, a file log, a print screen and an ifb.

Cause

The following entry in the EIM-Log file is relevant:

"...
* [Del MyDelete] batch 100, step 2, pass 107: locate by user key
* (started at 6/9/08 3:03)
*/

UPDATE dbo.EIM_ADDR_PER
SET T_CON_ADDR__RID =
(SELECT MIN(BT.ROW_ID)
FROM dbo.S_CON_ADDR BT
WHERE (BT.RELATION_TYPE_CD = IT.CONADDR_RELATIONTY AND
(BT.START_DT = IT.CONADDR_START_DT OR
(BT.START_DT IS NULL AND IT.CONADDR_START_DT IS NULL)) AND
BT.ADDR_PER_ID = IT.T_CON_ADDR_ADDRPE AND
(BT.ACCNT_ID = IT.T_CON_ADDR_ACCNTI OR
(BT.ACCNT_ID IS NULL AND IT.T_CON_ADDR_ACCNTI IS NULL)) AND
(BT.CONTACT_ID = IT.T_CON_ADDR_CONTAC OR
(BT.CONTACT_ID IS NULL AND IT.T_CON_ADDR_CONTAC IS NULL)) AND
(BT.ORG_GROUP_ID = IT.T_CON_ADDR_ORGGRO OR
(BT.ORG_GROUP_ID IS NULL AND IT.T_CON_ADDR_ORGGRO IS NULL))))
FROM dbo.EIM_ADDR_PER IT
WHERE (CONADDR_RELATIONTY IS NOT NULL AND
T_CON_ADDR_ADDRPE IS NOT NULL AND
IF_ROW_BATCH_NUM = ? AND
IF_ROW_STAT_NUM = 0 AND
T_CON_ADDR__STA = 0)
?1: 100
go
..."

The problem is that the UPDATE statement from above is also checking for
S_CON_ADDR.ACCNT_ID/EIM_ADDR_PER.T_CON_ADDR_ACCNTI
and
S_CON_ADDR.START_DT/EIM_ADDR_PER.CONADDR_START_DT
respectively.

If those columns are not considered for the EIM_ADDR_PER load then the DELETE EXACT operation is failing as seen in the EIM-Log file:

"...Process [Del MyDelete] had 1 row fail
on EIM_ADDR_PER for batch 100 in step 2, pass 107:
Exact specification of rows were not found. (severity 4, row eliminated)

Rows which were specfied using exact deletion were not found by the user keys
specified in the interface table. Check that the key values specified in the IF
table exactly match a row in only one base table.

The rows were eliminated from further processing in this IF table. Processing
will continue for other rows in this interface table..."

Solution

Considering the S_CON_ADDR.ACCNT_ID and S_CON_ADDR.START_DT columns via their respective EIM_ADDR_PER columns resolves the behaviour. A sample script and IFB-File is shown below:

INSERT INTO EIM_ADDR_PER
(ROW_ID,
IF_ROW_BATCH_NUM,
IF_ROW_STAT,

AP_ADDR_NAME, -- S_ADDR_PER
AP_ALIGNMENT_FLG,
AP_DISACLEANSE_FLG,
AP_NAME_LOCK_FLG,
AP_PREMISE_FLG,

CONADDR_RELATIONTY, --S_CON_ADDR
CONADDR_START_DT,
CONADDR_ACTIVE_FLG,
CONADDR_BLADDR_FLG,
CONADDR_FRAUD_FLG,
CONADDR_MAINADDRFL,
CONADDR_SHIPADDRFL,

CONADDR_ACCNT_BU, -- S_CON_ADDR.ACCNT_ID
CONADDR_ACCNT_LOC,
CONADDR_ACCNT_NAME
)
VALUES
(1,
100,
'FOR_DELETE',

'MyAccntStreetAddress1, MyAccntCity1', -- S_ADDR_PER
'N',
'N',
'N',
'N',

'ContactPointUsage',
'2008-06-09',
'Y','N','N','N','N',

'Default Organization',
NULL,
'MyAccnt1'
)

-------

[Siebel Interface Manager]
USER NAME="SADMIN"
PASSWORD="SADMIN"
PROCESS = Del MyDelete

[Del MyDelete]
TYPE = DELETE
BATCH = 100
TABLE = EIM_ADDR_PER
DELETE EXACT = TRUE
ONLY BASE TABLES = S_CON_ADDR

Applies to:

Siebel Enterprise Integration Manager - Version: 8.0.0.1 SIA [20408] and later   [Release: V8 and later ]
Information in this document applies to any platform.
Product Release: V8 (Enterprise)
Version: 8.0.0.1 [20408] Life Sci
Database: Microsoft SQL Server 2005
Application Server OS: Microsoft Windows 2003 Server SP2
Database Server OS: Microsoft Windows 2003 Server SP2

This document was previously published as Siebel SR 38-3460398791.

Symptoms

I'm getting the following error when trying to run EIM. This .ifb used to work.

SBL-ADM-60070: Error reported on server 'SblCRMDev01' follows:
SBL-SVR-01054: The task exited without sending a response.

The only difference that I know of is that we have extended EIM_CONTACT several times. We didn't have a problem for the other ones, though.

I've attached the ifb file I'm using, the log file produced when logging was turned up and the crash file.

Let me know if you have any questions. Thanks.

Ken Ratzlaff
425-478-1951

Cause

Configuration/ Setup

Solution

Message 1

For the benefit of othere readers,

Customer experienced issues with columns created with the 'Case Insensitivity' wizard.

It has been determined that Customer ran the 'EIM Mapping Wizard' sometime after running the 'Case Insensitivity' wizard. For this reason the EIM mapper created eim columns and mappings for the case insensitive columns.

In order to avoid the above issue you should always make sure that the EIM Mapping wizard does not take such columns in account.

Additional Keywords: Case Insensitivity, EIM Mapping

Applies to:

Siebel CRM - Version 8.0.0.13 SIA [20448] and later
Information in this document applies to any platform.

Symptoms

On : 8.0.0.13 SIA [20448] version, ADM - App. Deployment Manager

When attempting to export data using ADM command line using ADMbatchProc component, the component crashes and the following error occurs:

ERROR
-----------------------
SBL-ADM-60070: Error reported on server 'WFMDEVAPP1' follows:
SBL-SVR-01054: The task exited without sending a response.
SBL-SCL-00131: Either the RC2 or the AES cryptography engine is not initialized.


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. login using srvrmgr
2. Execute following command to export LOV records using ADM.

run task for comp admbatchproc with admpath="C:\ADM\output_xml", admfilter='[Value] LIKE "SR_AREA*"', admdatatype=LOV, admeaimethod=upsert, admprefix=ADM_SR_AREA

Cause

Cause of the issue is identified as product defect.

Issue is replicated in-house and a product defect 14460219 - ADM BATCH PROC EXPORT FAILS WITH SBL-SCL-00131 ERROR is raised to address the issue.

Solution

Defect#14460219 is fixed by engineering and a QF is now available in My Oracle Support.Please find the details of the fix below:

Because 800x code line is in extended support, this QF is protected with a password.

Summary:

Patch ID: 14686221

Platform Available: SOLARIS, WINDOWS
Product Certified: SIA
Languages Certified: Language Independent
Base Required: FIX PACK 8.0.0.13[20448]

Patch Abstract:
8.0.0.13 20448 sba QF0D25 sebl_aru

QF Install Doc:

Doc is named README.html and is located under

p14686221_800_SOLARIS64_1of2.zip

p14686221_800_WINNT_1of2.zip