IT18261: SCHEDULE_ASSOCIATEBPSTODOCS REMOVES DOCUMENTS THAT ARE STILL REFERENCED IN THE DATA_FLOW TABLE

Media_IM_5020603_2
iSeries_Media_5020603_2.zip
iSeries_Media_5020603_2.zip
Media_IM_5020603_2

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 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