IBM Support

Is query.BPHistoryStart.DB parameter needed for Control Center connectivity in Sterling B2B Integrator 5.2.6?

Question & Answer


Question

Is query.BPHistoryStart.DB parameter needed for Control Center connectivity in Sterling B2B Integrator 5.2.6?

 

In the past, Control Center support recommended this parameter to be added to customer_overrides.properties for installations using Oracle for the database:

jdbcService.query.BPHistoryStart.oracle=SELECT * FROM (SELECT WFD.NAME AS WFD_NAME, WFC.WFD_ID, WFC.WFD_VERSION, WFC.WORKFLOW_ID, WFC.STEP_ID, WFC.NEXT_AI_ID, WFC.ACTIVITYINFO_ID, WFC.SERVICE_NAME, WFC.DOC_ID, WFC.BASIC_STATUS, WFC.ADV_STATUS, WFC.START_TIME, WFC.END_TIME, WFC.STATUS_RPT, WFC.WFE_STATUS, WFC.CONTRACT_ID, WFC.NODEEXECUTED, WFC.CONTENT FROM WORKFLOW_CONTEXT WFC, WFD WHERE WFC.END_TIME >= TO_DATE(? , 'mm/dd/yyyy hh24:mi:ss') AND
jdbcService.query.BPHistoryEnd.oracle=WFD.TYPE < 100 AND WFC.WFD_ID = WFD.WFD_ID AND WFC.WFD_VERSION = WFD.WFD_VERSION ORDER BY END_TIME, STEP_ID) WHERE ROWNUM < 5000
jdbcService.query.FG_ARRIVEDFILE.oracle=SELECT ARRIVEDFILE_KEY,MESSAGE_ID,FILE_NAME,FILE_SIZE,MAILBOX_PATH,DATA_FLOW_ID,PROD_ORG_KEY,STATE,DOCUMENT_ID,WFID,REVIEWED,REPLAY_AF_KEY,REPLAY_COMMENT,ROUTES_REMAIN FROM FG_ARRIVEDFILE WHERE MODIFYTS >= TO_DATE(? , 'mm/dd/yyyy hh24:mi:ss') AND MODIFYTS < SYSDATE - 5/86400 AND ROWNUM < 5000
jdbcService.query.FG_ROUTE.oracle=SELECT ROUTE_KEY,DATA_FLOW_ID,ARRIVEDFILE_KEY,ROUTCHAN_KEY,CONS_ORG_KEY,P_FSTRUCT_KEY,STATE,START_TIME,COMPLETE_TIME,DELIVS_REMAIN FROM FG_ROUTE WHERE MODIFYTS >= TO_DATE(? , 'mm/dd/yyyy hh24:mi:ss') AND MODIFYTS < SYSDATE - 5/86400 AND ROWNUM < 5000
jdbcService.query.FG_DELIVERY.oracle=SELECT DELIVERY_KEY,ROUTE_KEY,DATA_FLOW_ID,STATE,DELIVCHAN_KEY,CONSUMER_DOCID,CONSUMER_MSGID FROM FG_DELIVERY WHERE MODIFYTS >= TO_DATE(? , 'mm/dd/yyyy hh24:mi:ss') AND MODIFYTS < SYSDATE - 5/86400 AND ROWNUM < 5000
jdbcService.query.FG_ROUTE_EVENTS.oracle=SELECT * FROM (SELECT E.EVENT_KEY, E.ARRIVEDFILE_KEY, E.ENTITY_KEY, E.ENTITY_TYPE, E.DATA_FLOW_ID, E.TIME, E.EVENT_CODE,E.COUNTER, E.MODIFYTS, EA.ORDINAL, EA.NAME, EA.VALUE FROM FG_EVENT E LEFT OUTER JOIN FG_EVENTATTR EA ON E.EVENT_KEY = EA.EVENT_KEY WHERE E.MODIFYTS >= TO_DATE(? , 'mm/dd/yyyy hh24:mi:ss') AND E.MODIFYTS < SYSDATE - 5/86400 ORDER BY E.MODIFYTS) WHERE ROWNUM < 5000

 

[{"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SS3JSW","label":"IBM Sterling B2B Integrator"},"Component":"","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF010","label":"HP-UX"},{"code":"PF012","label":"IBM i"},{"code":"PF016","label":"Linux"},{"code":"PF027","label":"Solaris"},{"code":"PF033","label":"Windows"}],"Version":"5.2.6","Edition":"","Line of Business":{"code":"LOB77","label":"Automation Platform"}}]

Log InLog in to view more of this document

This document has the abstract of a technical article that is available to authorized users once you have logged on. Please use Log in button above to access the full document. After log in, if you do not have the right authorization for this document, there will be instructions on what to do next.

Document Information

Modified date:
14 November 2019

UID

ibm10744817