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
Log InLog in to view more of this document
Was this topic helpful?
Document Information
Modified date:
14 November 2019
UID
ibm10744817