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 number
IT33280
Reported component name
STR B2B INTEGRA
Reported component ID
5725D0600
Reported release
526
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2020-06-22
Closed date
2021-04-08
Last modified date
2021-05-21
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
[{"Line of Business":{"code":"LOB59","label":"Sustainability Software"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SS3JSW","label":"IBM Sterling B2B Integrator"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"5.2.6"}]
Document Information
Modified date:
22 May 2021