IT33280: DOC_NURSERY_LIFESPAN RECORDS ARE BEING ORPHANED IN THE DOCUMENT_LIFESPAN TABLE WHEN LISTSTAGEDDOCUMENTS=TRUE

APAR status

• Closed as program error.

Error description

• Make sure that sftp.listStagedDocuments=true in the
  customer_overrides.properties.
  
  Open two SFTP Sessions to the
  same mailbox in B2Bi using the same User Account.
  
  
  With the first Winscp SFTP Session upload a
  large file maybe over 1gb so you have time to run the test.
  Then while the upload is ongoing start uploading the same
  document with the other Winscp SFTP session. You will be
  prompted to resume the file upload. Answer yes to resume.
  Once
  the resume starts in the second session open Windows Task
  Manager and End the Task on the still active first SFTP
  Session.
  Then let the second SFTP Session completely upload the
  file.
  
  Once finished you can run the following query and find
  the orphaned document in the document_lifespan table.
  
  select *
  from DOCUMENT_LIFESPAN where USER_KEY ='DOC_NURSERY_LIFESPAN'
  and DOC_ID not in (select DOCUMENT_ID from
  DOCUMENT_NURSERY)
  
  You will see that the DOCUMENT_LIFESPAN
  record will have a LIFE_SPAN = 5256000 which will not allow
  associateBpToDocs to pick up this document and purge it from
  the system.
  
  There is not any mechanism that will clean out these
  orphaned record.
  For Linux, use run control_extpurge.sh script and make sure that
   above created orphan records in DOCUMENT_LIFESPAN table are
  removed.
  For Windows, use startExternalPurgeWindowsService.cmdand make
  sure that above created orphan records in DOCUMENT_LIFESPAN
  table are removed.
  

Local fix

• STRRTC - L3REQ-188
  JN / JN
  Circumvention: None / workaround
  

Problem summary

• Users Affected:
  
  All
  
  
  
  Problem Description:
  
  DOC_NURSERY_LIFESPAN records are being orphaned in the
  DOCUMENT_LIFESPAN table when listStagedDocuments=truePlatforms.
  
  
  
  Platforms Affected:
  
  All
  

Problem conclusion

• Resolution Summary:
  A code fix is provided.
  Fix has been made in control_extpurge script such that by
  running control_extpurge script, it will remove/delete the
  orphan records of DOCUMENT_LIFESPAN table with user key
  DOC_NURSERY_LIFESPAN and not having an entry in DOCUMENT_NURSERY
  table.
  
  
  
  Delivered in:
  
  5020603_16
  5020605_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