IT07717: CANNOT START CONNECT:DIRECT SERVER ADAPTOR FOLLOWING PURGEALL.SH-T

APAR status

• Closed as program error.

Error description

• After running a PurgeAll.sh -t customer is unable to start
  the CD Server adaptors (in a clustered setup) and can see an
  error: [2015-02-27 12:15:07.297] ALL 000000000000 GLOBAL_SCOPE
  java.sql.
  SQLException: [ServicesController.runStartup.
  TB_CD_Server_Node1_CDSERVER_ADAPTER_node11425039302422/1788]
  RepositoryStepDB.newCheckpointFrom(con, rsSelect) - Could not
  restore:
  CD_STEP_INFO(237865, SFGWPPD, TBCDSIMSDC, TBCDSIMSDC, REMOTE,
  28101,
  '2015056 15595300, 36485814bc6ad8482node2,
  44608414bc6ad8482node2);
  cause: java.sql.SQLException - [ServicesController.runStartup.
  TB_CD_Server_Node1_CDSERVER_ADAPTER_node11425039302422/1788]
  RepositoryStepDB.newCheckpointFrom(con, rsSelect) - Could not
  restore:
  CD_STEP_INFO(237865, SFGWPPD, TBCDSIMSDC, TBCDSIMSDC, REMOTE,
  28101,
  '2015056 15595300, 36485814bc6ad8482node2,
  44608414bc6ad8482node2);
  cause: Null Object returned by getBlobObject; the serialized
  blob data
  could not be restored from
  com.sterlingcommerce.woodstock.util.frame.
  jdbc.JDBCBlobTable@5acd6ce table.; the serialized blob data
  could not
  be restored.
  [2015-02-27 12:15:07.297] ALL 000000000000 GLOBAL_SCOPE
  

Local fix

• STRRTC - #458057
  GM / GM
  Circumvention:
  Clean up and add CD_STEP_INFO info table to the
  files purge_all.properties and purge_all.properties.in.
  

Problem summary

• Users Affected:
  Any customers using the Connect:DIrect Server adapter.
  
  Problem Description:
  After running a PurgeAll.sh -t customer is unable to start
  the CD Server adaptors (in a clustered setup) and can see and
  error: [2015-02-27 12:15:07.297] ALL 000000000000 GLOBAL_SCOPE
  java.sql.SQLException: [ServicesController.runStartup.
  TB_CD_Server_Node1_CDSERVER_ADAPTER_node11425039302422/1788]
  RepositoryStepDB.newCheckpointFrom(con, rsSelect) - Could not
  restore: CD_STEP_INFO(237865, SFGWPPD, TBCDSIMSDC, TBCDSIMSDC,
  REMOTE, 28101, '2015056 15595300, 36485814bc6ad8482node2,
  44608414bc6ad8482node2)
  
  Platforms affected:
  All
  

Problem conclusion

• Resolution Summary:
  The PurgeAll.sh script truncates rows in the TRANS_DATA table
  creating dangling references in the CD_STEP_INFO table (if the
  STEP table contained entries prior to running PurgeAll.sh).
  This prevents the CDSA from starting up when it is configured
  in COLD Start mode.  The CD_STEP_INFO table should also be
  truncated when PurgeAll.sh is run.  The following tables have
  been added to purge_all.properties to also be truncated when
  PurgeAll.sh is run: CD_CKPT_INFO, CD_CKPT_REST,
  CD_SHSL_ACTIVE_SESSIONS, CD_SHSL_GROUPS, CD_SHSL_LOCAL_NODES,
  CD_SHSL_REMOTE_NODES, CD_SHSL_SUSPEND_QUEUE, CD_STEP_INFO.
  
  Delivered In:
  5020500_4
  

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

  STR B2B INTEGRA

• Fixed component ID

  5725D0600

Applicable component levels

• R525 PSY

     UP