JR53658: WHEN RUNNING IA COLUMN ANALYSIS ON MORE THAN 2000 COLUMNS, GETTING A MESSAGE THAT SQL QUERY HAS TOO MANY PARAMETERS.

APAR status

• Closed as program error.

Error description

• When performing IA column analysis on more than 2000 columns and
  when XMETA/IADB repositories on MS SQL Server, get the following
  message in WebSphere SystemOut logs and the CA task cannot be
  completed.
  
  [6/19/15 10:35:18:443 EDT] 0000006e PersistenceUt E
  [IBM][SQLServer JDBC Driver][SQLServer]The incoming request has
  too many parameters. The server supports a maximum of 2100
  parameters. Reduce the number of parameters and resend the
  request. - SQLSTATE: HY000 , Error code: 8003
  [6/19/15 10:35:18:444 EDT] 0000006e SandboxServic E   Error
  executing query: select distinct rid(x), rid(tam), tam.tamType,
  x.virtualColumn, x.Status, rid(df), df.ODBCType, df.typeCode
  from x in investigate::ColumnAnalysisMaster left outer join s in
  x->ColumnAnalysisStatus  left outer join df in x->DataField
  restrictExactlyTo(DataField)  left outer join tam in
  x->TableAnalysisMaster  where rid(x) in
  ("ec1481df.c862f974.18p4s1rg5.3avdubd.erq7ro.pclq52720bc41o4jh94
  07",
  "ec1481df.c862f974.18p4s1rg5.3avcsd7.g0v7lc.b82hvdld56hi0t737pml
  3",
  "ec1481df.c862f974.18p4s1rg5.3avco2c.87itpa.5hgsuak8bs8i0sfk1c4q
  3",
  "ec1481df.c862f974.18p4s1rg5.3avd6nm.pklta2.16j6t511cpiuv3qhhidh
  j",
  ....
  ....
  ....
  Caused by: java.sql.SQLException: [IBM][SQLServer JDBC
  Driver][SQLServer]The incoming request has too many parameters.
  The server supports a maximum of 2100 parameters. Reduce the
  number of parameters and resend the request.
      at com.ibm.isf.jdbc.sqlserverbase.ddcw.b(Unknown Source)
  
  [6/19/15 10:35:18:469 EDT] 0000006e SorcererServi E
  CDIIA0001E: ColumnAnalysisServiceBridge.java:362
  executeColumnAnalysis: Exception in process:
  An error occurred while accessing the service
  XMETAHelper.query()
  [6/19/15 10:35:18:477 EDT] 0000006e SorcererServi E
  CDIIA0001E: ColumnAnalysisServiceBridge.java:751
  setErrorStatus: Setting
  CAM(ec1481df.c862f974.18p4s1rg5.3avdubd.erq7ro.pclq52720bc41o4jh
  9407) to ERROR status
  

Local fix

• Perform IA column analysis for 2000 columns in a single task
  submission.
  

Problem summary

• Customer  had issues trying to run CA on a large number of
  columns:
  - CA jobs with a large number of columns were hanging or were
  not completing.
  - After upgrading to 11.3.1 FixPack2, they ran into an issue
  running a single CA job with 2100+ columns. As part of the CA
  job, IA was submitting an xmeta query that exceeded the maximum
  number parameters allowed in the where clause, when the xmeta
  database is SQL Server.
  

Problem conclusion

• Fix is availabe in 11.5,11.3.1.2rp2  hence  users should  apply
  this accordingly
  

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

  WIS INFORM ANAL

• Fixed component ID

  5724Q36IA

Applicable component levels

• RB50 PSY

     UP