JR59774: THE PIVOT TABLE DATALOAD SCRIPT FAILS WITH A TRUNCATED DATA ERROR

workflow.18002.delta.repository

APAR status

• Closed as program error.

Error description

• The pivot table download script fails with a truncated data
  error because the SchemaGenerator tool doesn't read the actual
  column size from the LSW_BPD_INSTANCE_VARIABLES table. Instead,
  it uses a hard-coded 512 column size when creating the
  LSW_BPD_INSTANCE_VARS_PIVOT table so that the script will cause
  the DataLoad tool to fail if the size of the value inserted into
   the column exceeds 512 characters when the DataLoad tool runs
  to populate the pivot table.
  
  You see this stack trace:
  Jul 10, 2018 6:21:51 PM FINE:
  com.microsoft.sqlserver.jdbc.SQLServerException - ***
  SQLException: com.microsoft.sqlserver.jdbc.SQLServerException:
  String or binary data would be truncated. Msg 8152, Level 16,
  State 13, String or binary data would be truncated.
  Jul 10, 2018 6:21:51 PM SEVERE:
  com.lombardisoftware.tools.optimization.search.DataLoad - Error
  while processing 81787
  com.microsoft.sqlserver.jdbc.SQLServerException: String or
  binary data would be truncated.
   at
  com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabase
  Error(SQLServerException.java:216)
   at
  com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQ
  LServerStatement.java:1515)
   at
  com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.doExecut
  ePreparedStatement(SQLServerPreparedStatement.java:404)
   at
  com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement$PrepStmt
  ExecCmd.doExecute(SQLServerPreparedStatement.java:350)
  . . .
  
  PRODUCTS AFFECTED
  IBM Business Process Manager (BPM) Advanced
  IBM BPM Standard
  IBM BPM Express
  IBM Business Automation Workflow
  

Local fix

• Increase the size of the generated column in
  LSW_BPD_INSTANCE_VARS_PIVOT to match the size in
  lsw_bpd_instance_variables.
  Run SQL command ALTER TABLE bpmadmin.LSW_BPD_INSTANCE_VARS_PIVOT
  ALTER COLUMN [variableName] NVARCHAR(newSize)  where
  variableName is the instance variable with value in
  "STRING_VALUE" column which exceeds 512 characters and newSize
  is the size that will accommodate the instance variable (ie.
  1024).
  

Problem summary

• No additional information is available.
  

Problem conclusion

• A fix that ensures the SchemaGenerator tool reads the actual
  column size of the string values from LSW_BPD_INSTANCE_VARIABLES
   table instead of using a hard-coded 512 size will be available
  in a future release of IBM Business Automation Workflow.
  

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

• RI00 PSY

     UP