ITCanopy

Steps: IO with two ICs as parent child,  trying to query using business service "EAI Siebel Adapter" method "Query" in child IC. Behavior: Workflow keep executing until application crashed. Reason: This usually occurs when try to query in Child IC and exclude the Parent IC in search spec. Error: Error invoking service 'EAI Siebel Adapter', method 'Query' at step 'Query IO'.(SBL-BPR-00162)--Method 'NextRecord' of business component 'Child BC' (integration component 'Child IC') returned the following error:"There were more rows than could be returned.  Please refine your query to bring back fewer rows(SBL-DAT-00500)"(SBL-EAI-04376)  Solution: Added parent IC in serarch spec as well. "[ParentIC.Case Num] = '" + [&CaseNumber] + "' AND [ChildIC.Id] = '" + [&RowNum] + "'"

[1]Wrong field values or value types detected in field Street. Please re-enter your field values. If you need additional assistance, please refer to the documentation.(SBL-UIF-00299) [2]An error occurred while attempting to look up the transcode for the value 'Value-10' in table 'S_LST_OF_VAL' and of type 'LOV_TYPE' with language 'ENU'.(SBL-DAT-00592) [3]There were more rows than could be returned.  Please refine your query to bring back fewer rows(SBL-DAT-00500) See Also: There were more rows than could be returned error occurs when executing LookupValue in an UI data map (Doc ID 1925807.1) Changing the cursor configuration parameter from the Application CFG file will only work for dedicated Web client. In order to set this parameter value for the Siebel Web Client (thin client) you need to set named subsystem parameter DSMaxFetchArraySize. This parameter controls the maximum number of records that can be returned by a business component in ForwardBackw...

APPLIES TO: Siebel CRM - Version 8.1.1.11 [IP2013] and later Information in this document applies to any platform. *** Checked for currency JUL-22-2016 *** SYMPTOMS Environment: ------------ Siebel CRM 8.1.1.11 [23030] Microsoft Windows (32-bit) 2003 Statement of Issue: ------------------- An external application sends a record to Siebel. An UI data map is used to convert the record. This includes the expression LookupValue("MSC_WARD",[MSC Ward]) to convert an incoming WARD code into the required value in Siebel. In Siebel there are 11400 List Of Value records where Type = MSC Ward, but there is only 1 record with the relevant Type and LIC combination. When the external application sends a record to Siebel, an error is occurring. Error: ------ Error invoking service 'EAI Data Transformation Engine', method 'Execute' at step 'DataMap'.(SBL-BPR-00162) -- An error occurred while attempting to look up the LOV value of '0512005' of type 'MSC_WAR...

APPLIES TO: Siebel CRM - Version 7.5.3 SIA [16157] to 18.8 [Release V7 to V17] Information in this document applies to any platform. Area(s):Client Functionality, System Administration Release(s):V7 (Enterprise), V7 (MidMarket), V7 (Professional) and Later (IP2013, IP2014, IP2015, IP2016 and IP2017) Database(s):All Supported Databases App Server OS(s):All Supported Platforms Latest release tested against:V7 (Enterprise) Keywords:crash, SBL-DAT-00500, fetch, 10000, DSMaxFetchArraySize, leak, exception DESCRIPTION This Alert applies to all versions. In Siebel 7 there are two cursor modes specified with the ExecuteQuery method, ForwardOnly and ForwardBackward. ForwardOnly: Selected records can be processed only from the first record to the last record. Focus cannot return to a record. ForwardBackward: Selected records can be processed from first to last or from last to first. This is the default if no value is specified. DSMaxFetchArraySize is a named subsystem parameter that controls the...