JR64834: SAVED SEARCH FAILS WITH ERROR CODE 8003 WHEN USING MS SQL SERVER DATABASE

APAR status

• Closed as program error.

Error description

• You may see this error in BAW log file.
  
  SQL state [S0001]; error code [8003]; There are too many
  parameters for the incoming request. The server supports up to
  2100 parameters. Reduce the number of parameters and then
  resubmit the request. nested exception is
  com.microsoft.sqlserver.jdbc.SQLServerException: There are too
  many parameters for the incoming request. The server supports up
  to 2100 parameters. Reduce the number of parameters and then
  resubmit the request.
   at
  com.lombardisoftware.client.delegate.BusinessDelegateException.a
  sBusinessDelegateException(BusinessDelegateException.java:46)
   at
  com.lombardisoftware.client.delegate.ProcessSearchAPIDelegateDef
  ault.executeQuery(ProcessSearchAPIDelegateDefault.java:220)
   at
  com.lombardisoftware.server.ejb.psapi.SearchAPIFacadeCore.execut
  eSearch(SearchAPIFacadeCore.java:212)
   at sun.reflect.GeneratedMethodAccessor364.invoke(Unknown
  Source)
   at
  sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethod
  AccessorImpl.java:55)
   at java.lang.reflect.Method.invoke(Method.java:508)
   at
  org.springframework.aop.support.AopUtils.invokeJoinpointUsingRef
  lection(AopUtils.java:317)
   at
  org.springframework.aop.framework.ReflectiveMethodInvocation.inv
  okeJoinpoint(ReflectiveMethodInvocation.java:190)
   at
  org.springframework.aop.framework.ReflectiveMethodInvocation.pro
  ceed(ReflectiveMethodInvocation.java:157)
   at
  com.lombardisoftware.utility.spring.TransactionInterceptor$2.cal
  l(TransactionInterceptor.java:70)
   at
  com.lombardisoftware.utility.spring.ProgrammaticTransactionSuppo
  rt.executeInExistingTransaction(ProgrammaticTransactionSupport.j
  ava:859)
   at
  com.lombardisoftware.utility.spring.ProgrammaticTransactionSuppo
  rt.execute(ProgrammaticTransactionSupport.java:442)
   at
  com.lombardisoftware.utility.spring.TransactionInterceptor.invok
  e(TransactionInterceptor.java:68)
   at
  org.springframework.aop.framework.ReflectiveMethodInvocation.pro
  ceed(ReflectiveMethodInvocation.java:179)
   at
  com.lombardisoftware.utility.spring.CoreEntryInterceptor.invoke(
  CoreEntryInterceptor.java:44)
   at
  com.lombardisoftware.utility.spring.PSCoreEntryInterceptor.invok
  e(PSCoreEntryInterceptor.java:14)
   at
  org.springframework.aop.framework.ReflectiveMethodInvocation.pro
  ceed(ReflectiveMethodInvocation.java:179)
   at
  org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkD
  ynamicAopProxy.java:207)
   at com.sun.proxy.$Proxy125.executeSearch(Unknown Source)
   at
  com.lombardisoftware.client.delegate.SearchAPIFacadeDelegateDefa
  ult$13.execute(SearchAPIFacadeDelegateDefault.java:318)
   at
  com.lombardisoftware.client.delegate.SearchAPIFacadeDelegateDefa
  ult$13.execute(SearchAPIFacadeDelegateDefault.java:316)
   at
  com.lombardisoftware.server.ejb.EjbCallHandler.handleEjbCall(Ejb
  CallHandler.java:44)
   at
  com.lombardisoftware.server.ejb.EjbCallHandler$1.run(EjbCallHand
  ler.java:106)
   at
  java.security.AccessController.doPrivileged(AccessController.jav
  a:734)
   at
  com.lombardisoftware.server.ejb.EjbCallHandler.handleEjbCallInDe
  legateDefault(EjbCallHandler.java:104)
   at
  com.lombardisoftware.client.delegate.SearchAPIFacadeDelegateDefa
  ult.executeSearch(SearchAPIFacadeDelegateDefault.java:316)
   at
  com.ibm.bpm.rest.impl.task.TasksResource.getWleQueryResult(Tasks
  Resource.java:1174)
   at
  com.ibm.bpm.rest.impl.task.TasksResource.getWleQueryResult(Tasks
  Resource.java:921)
   at
  com.ibm.bpm.rest.impl.task.TasksResource.getTaskQueryResult(Task
  sResource.java:762)
   at
  com.ibm.bpm.rest.impl.task.TasksResource.access$500(TasksResourc
  e.java:115)
   at
  com.ibm.bpm.rest.impl.task.TasksResource$3.call(TasksResource.ja
  va:577)
   at
  com.ibm.bpm.rest.impl.task.TasksResource$3.call(TasksResource.ja
  va:519)
  
  PRODUCTS AFFECTED
  IBM Business Automation Workflow
  

Local fix

Problem summary

• No additional information is available.
  

Problem conclusion

• A fix is available or will be available that allows full-text
  search when there is a large amount of records in MS SQL Server
  database.
  

Temporary fix

Comments

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

Fix information

• Fixed component name

  BUS AUTO WORKFL

• Fixed component ID

  5737H4100

Applicable component levels