Direct links to fixes
APAR status
Closed as program error.
Error description
When the customer goes into the user interface under "Business Process", "Monitor", "Advanced Search" and "Data Flows" some data flows appear in the list but you cannot view the detail tracking information. In the ui.log there is: [2016-10-19 15:51:54.575] ERROR [1476885114575] No document with ID =301654157d84d9f46node1 [2016-10-19 15:51:54.575] ERRORDTL [1476885114575]com.sterlingcommerce.woodstock.workflow.DocumentN otFoundException: No document with ID = 301654157d84d9f46node1 This occurs when an XML Notification is sent to the HTTP Server Adapter to trigger a business process. The notification contains the path and filename of a document that is collected using a File System Adapter and placed in a mailbox. The Data Flow records in the database have linked the XML Notification to the Document collected. Once the retention period is reached the XML Notification gets removed by the AssociateBpsToDocs process and creates the situation.
Local fix
You can circumvent the behavior by adding the following line in the customer_overrides.properties file: jdbcService.query.getUnassociatedDocsWithDocLifespan.oracle=SELE CT distinct D.DOC_ID, D.BODY, D.ENC_IV, D.ENC_KEY, D.ENC_IV, D.ENC_KEY FROM DOCUMENT D, DOCUMENT_LIFESPAN DL WHERE D.DOC_ID=DL.DOC_ID(+) and not exists (select * from document_lifespan dl2 where dl2.doc_id=d.doc_id and (dl2.workflow_id > 0 or (D.CREATE_TIME + (DL2.LIFE_SPAN / 1440)) >= SYSDATE)) AND (D.WORKFLOW_ID=-1 OR D.WORKFLOW_ID=0 OR D.WORKFLOW_ID=-2) and ((D.CREATE_TIME + (DL.LIFE_SPAN / 1440)) < SYSDATE OR dl.DOC_ID IS NULL) and D.CREATE_TIME < ? AND NOT EXISTS(SELECT * FROM WORKFLOW_CONTEXT WC WHERE WC.DOC_ID=D.DOC_ID) and NOT EXISTS(select * from DATA_FLOW DF where DF.ROOT_DOCUMENT=D.DOC_ID) This wil prevent the AssociateBpsToDocs service to remove any documents that are still referenced in the DATA_FLOW table.
Problem summary
USERS AFFECTED: All PROBLEM DESCRIPTION: Schedule_AssociateBpsToDocs prematurely removes documents that still have a row in DATA_FLOW table. PLATFORMS AFFECTED: All
Problem conclusion
RESOLUTION SUMMARY: A code fix is provided. DELIVERED IN: 5020603_2
Temporary fix
Comments
APAR Information
APAR number
IT18261
Reported component name
STR B2B INTEGRA
Reported component ID
5725D0600
Reported release
525
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2016-12-06
Closed date
2017-06-07
Last modified date
2017-06-22
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
[{"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SS3JSW","label":"Sterling B2B Integrator"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"5.2.5","Line of Business":{"code":"LOB59","label":"Sustainability Software"}}]
Document Information
Modified date:
11 September 2024