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