Skip to main content

Posts

Showing posts with the label SBL-EAI-04376

There were more rows than could be returned Siebel SBL-EAI-04376

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] + "'"