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










תגובות

הוסף רשומת תגובה

פוסטים פופולריים מהבלוג הזה

FINS Data Transfer Utilities

תמונה
The best thing while working on siebel is you are never short of options. Recently we had requirement of updating a Service request from contact. Finally we did that using "EAI Siebel Adapter" business service. However during that time i came across another business service "FINS Data Transfer Utilities" popularly known as DTU business service. As i was not having prior knowledge of it going by the rule of not learning swimming lessons while drowning i decided not to go for it. Lately i have tried to explore this service and trust me it can do wonders. Here is a sample example update of Service Request from contact. We need to follow below steps in order to understand strength of this business service. 1 - Navigate to Site Map. Go to Administration - Application -> Data Map Administration tab. Create a new Record with following options: Name: Service Request Test Source Business Object: Contact Destination Business Object: Service Request Here the source business
המשך לקרוא

SBL-BPR-00191: The rowId of the active row of the primary buscomp '%1', '%2', does not match the Primary Id

Applies to: Product Release: V7 (Enterprise) Version: 7.5.3 [16157] ESN Database: Oracle 9.2.0.2 Application Server OS: Microsoft Windows 2000 Server SP 3 Database Server OS: Microsoft Windows 2000 Server SP 3 This document was previously published as Siebel SR 38-1386997031. Symptoms SBL-BPR-00191 We have a error with a workflow. This WF is excuted by policy when a particular activity is closed. The WF Business Object is 'Action'. Inside this WF, there is a subprocess that invokes a Business Service that creates a new activity. In a second subprocess, the region Id of this new activity is updated using the standar update method funcionality of Siebel workflow process. Error processing Siebel Operation for: Business Object 'Action' Business Component 'Action' Primary Id ''1-5NEI6' Operation 'Insert'(SBL-BPR-00100) -- The rowId of the active row of the primary buscomp 'Action', '1-4SNCV', does not match the Prima
המשך לקרוא

Profile Attributes and Open UI

תמונה
Yes, Profile Attributes! As the ever attentive, up-to-date Siebel CRM expert that you are when you read this, you know that in Siebel Open UI (since version 15), it is no longer allowed/supported to  set  Profile Attributes from browser-side script. But  getting  them is not a problem, since the  GetProfileAttr  function works perfectly fine. Recently I found a few vanilla Profile Attributes that came quite handy in my work in Open UI JavaScript: Navigation Type : stores the navigation type such as "NAVIGATION_TAB" ActiveViewName : does what it says on the tin IsOpenUI : returns "1" when the application runs in Open UI Is SUI Theme : when "TRUE", the application theme is Synergy (aka SUI) Position:  returns the currently active position Primary Responsibility Name : guess what this one is… Profile Image : returns the URL of the user's profile image Org.Name : returns the name of the user's organization Here's a sample line of
המשך לקרוא