{"type":"doc","content":[{"type":"heading","attrs":{"level":2},"content":[{"text":"Usage Objective","type":"text"}]},{"type":"bulletList","content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Use of this operational flow in the environment","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"This maintenance process operates in the background to monitor events. It ensures timely detection of any stalled or delayed events, promptly notifying the relevant users via email.","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Guarantee prompt alerts for any events that are stuck to prevent delays.","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Mitigate process flow deadlocks to ensure smooth operations.","type":"text"}]}]}]},{"type":"heading","attrs":{"level":2},"content":[{"text":"Problem statement ","type":"text"}]},{"type":"paragraph","content":[{"text":"In Adeptia, activating a Trigger in sequence for any event triggers the process flow or transaction sequentially. As a result, when a transaction enters a running state, the event will pause until the first process is completed. This scenario may result in a deadlock, where the event is awaiting the transaction to execute while the transaction is at a standstill. To mitigate this issue, a solution has been devised to send an email notification to the user, ensuring prompt awareness and resolution.","type":"text"}]},{"type":"heading","attrs":{"level":2},"content":[{"text":"Introduction","type":"text"}]},{"type":"paragraph","content":[{"text":"This guide provides a detailed step-by-step process for deploying the Adeptia event monitoring process. This includes configuring backend database information, setting misfire and hour parameters, updating email credentials, and scheduling the calendar event for regular execution.","type":"text"}]},{"type":"heading","attrs":{"level":2},"content":[{"text":"Prerequisites","type":"text"}]},{"type":"paragraph","content":[{"text":"Before you begin, ensure you have the following:","type":"text"}]},{"type":"bulletList","content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Adeptia Connect installed","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Email server details","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Backend database details","type":"text"}]}]}]},{"type":"heading","attrs":{"level":2},"content":[{"text":"How to Deploy","type":"text"}]},{"type":"heading","attrs":{"level":3},"content":[{"text":"Step 1: Download Package ZIP","type":"text"}]},{"type":"bulletList","content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Download the deployment package ZIP from the provided location. ","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Click here to download ","type":"text","marks":[{"type":"link","attrs":{"href":"https://drive.google.com/file/d/1WIPBtPj8-AXGv_RUm0xVHVLpOyWaHNaD/view?usp=drive_link"}}]}]}]}]},{"type":"heading","attrs":{"level":3},"content":[{"text":"Step 2: Deploy Package Using Migration Utility","type":"text"}]},{"type":"orderedList","attrs":{"order":1},"content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Run ","type":"text"},{"text":"MigrationUtility.exe","type":"text","marks":[{"type":"code"}]},{"text":".","type":"text"}]}]}]},{"type":"mediaSingle","attrs":{"layout":"align-start","width":442,"widthType":"pixel"},"content":[{"type":"media","attrs":{"width":1600,"id":"8429c41e-d555-427b-a0ee-d5417dfbe3ab","collection":"contentId-338329675","type":"file","height":632},"marks":[{"type":"border","attrs":{"size":1,"color":"#172b4d"}}]},{"type":"caption","content":[{"text":"1.1","type":"text"}]}]},{"type":"mediaSingle","attrs":{"layout":"align-start","width":442,"widthType":"pixel"},"content":[{"type":"media","attrs":{"width":770,"alt":"image-20240723-101726.png","id":"6a1ccd1a-fe72-4e06-abb7-b626ae500c0a","collection":"contentId-338329675","type":"file","height":493},"marks":[{"type":"border","attrs":{"size":1,"color":"#172b4d"}}]},{"type":"caption","content":[{"text":"1.2","type":"text"}]}]},{"type":"mediaSingle","attrs":{"layout":"align-start","width":442,"widthType":"pixel"},"content":[{"type":"media","attrs":{"width":780,"alt":"image-20240723-101925.png","id":"a3889b9b-93c1-4404-aaa4-42198e0e36bc","collection":"contentId-338329675","type":"file","height":490},"marks":[{"type":"border","attrs":{"size":1,"color":"#172b4d"}}]},{"type":"caption","content":[{"text":"1.3","type":"text"}]}]},{"type":"mediaSingle","attrs":{"layout":"align-start","width":442,"widthType":"pixel"},"content":[{"type":"media","attrs":{"width":792,"alt":"image-20240723-102110.png","id":"d1f6cf0f-fe46-4d99-a921-c214524f8064","collection":"contentId-338329675","type":"file","height":501},"marks":[{"type":"border","attrs":{"size":1,"color":"#172b4d"}}]},{"type":"caption","content":[{"text":"1.4","type":"text"}]}]},{"type":"mediaSingle","attrs":{"layout":"align-start","width":447,"widthType":"pixel"},"content":[{"type":"media","attrs":{"width":791,"alt":"image-20240723-102323.png","id":"a7779edf-dc07-4e09-bc18-2fbe7f3a7eb4","collection":"contentId-338329675","type":"file","height":505},"marks":[{"type":"border","attrs":{"size":1,"color":"#172b4d"}}]},{"type":"caption","content":[{"text":"1.5","type":"text"}]}]},{"type":"mediaSingle","attrs":{"layout":"align-start","width":447,"widthType":"pixel"},"content":[{"type":"media","attrs":{"width":793,"alt":"image-20240723-102439.png","id":"9071a6e6-b136-49e0-9930-b61a9238ea20","collection":"contentId-338329675","type":"file","height":512},"marks":[{"type":"border","attrs":{"size":1,"color":"#172b4d"}}]},{"type":"caption","content":[{"text":"1.6","type":"text"}]}]},{"type":"mediaSingle","attrs":{"layout":"align-start","width":449,"widthType":"pixel"},"content":[{"type":"media","attrs":{"width":776,"alt":"image-20240723-102547.png","id":"b17c97ca-5e7e-4a70-8d66-1b417e44d30a","collection":"contentId-338329675","type":"file","height":482},"marks":[{"type":"border","attrs":{"size":1,"color":"#172b4d"}}]},{"type":"caption","content":[{"text":"1.7","type":"text"}]}]},{"type":"mediaSingle","attrs":{"layout":"align-start","width":447,"widthType":"pixel"},"content":[{"type":"media","attrs":{"width":787,"alt":"image-20240723-102743.png","id":"835551f5-72e9-4829-87c7-03b0aae6cfa3","collection":"contentId-338329675","type":"file","height":493},"marks":[{"type":"border","attrs":{"size":1,"color":"#172b4d"}}]},{"type":"caption","content":[{"text":"1.8","type":"text"}]}]},{"type":"mediaSingle","attrs":{"layout":"align-start","width":447,"widthType":"pixel"},"content":[{"type":"media","attrs":{"width":793,"alt":"image-20240723-102900.png","id":"b6f9453a-6a66-406d-873b-e977548aec14","collection":"contentId-338329675","type":"file","height":506},"marks":[{"type":"border","attrs":{"size":1,"color":"#172b4d"}}]},{"type":"caption","content":[{"text":"1.9","type":"text"}]}]},{"type":"heading","attrs":{"level":2},"content":[{"text":"How to Use it?","type":"text"}]},{"type":"heading","attrs":{"level":3},"content":[{"text":"Step 1: Update Backend Database Credentials","type":"text"}]},{"type":"orderedList","attrs":{"order":1},"content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Navigate to ","type":"text"},{"text":"Configure > Accounts > Database Info","type":"text","marks":[{"type":"code"}]},{"text":".","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Update the database configuration with the following details:","type":"text"}]},{"type":"bulletList","content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Database URL","type":"text","marks":[{"type":"strong"}]},{"text":": ","type":"text"},{"text":"jdbc:your_database_url","type":"text","marks":[{"type":"code"}]}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Username","type":"text","marks":[{"type":"strong"}]},{"text":": ","type":"text"},{"text":"your_db_username","type":"text","marks":[{"type":"code"}]}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Password","type":"text","marks":[{"type":"strong"}]},{"text":": ","type":"text"},{"text":"your_db_password","type":"text","marks":[{"type":"code"}]}]}]}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Click on ","type":"text"},{"text":"Test Database Connection","type":"text","marks":[{"type":"code"}]},{"text":" and ensure the connection is successful.","type":"text"}]}]}]},{"type":"mediaSingle","attrs":{"layout":"align-start","width":473,"widthType":"pixel"},"content":[{"type":"media","attrs":{"width":473,"alt":"image-20240723-103110.png","id":"235e738a-3422-4f15-b0e1-b7d99c2552ef","collection":"contentId-338329675","type":"file","height":330},"marks":[{"type":"border","attrs":{"size":2,"color":"#172b4d"}}]}]},{"type":"heading","attrs":{"level":3},"content":[{"text":"Step 2: Update Email Credentials","type":"text"}]},{"type":"orderedList","attrs":{"order":1},"content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Navigate to ","type":"text"},{"text":"Configure > Target > Mail Target","type":"text","marks":[{"type":"code"}]},{"text":".","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Edit ","type":"text"},{"text":"ADP_MD_sendEventDataInfo","type":"text","marks":[{"type":"code"}]},{"text":".","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Update the email server details with your SMTP server information.","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Update sender and receiver configuration in Mail Target.","type":"text"}]}]}]},{"type":"heading","attrs":{"level":3},"content":[{"text":"Step 3: Set Miss Fire and Hour Parameter","type":"text"}]},{"type":"orderedList","attrs":{"order":1},"content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Go to the ","type":"text"},{"text":"Process Flow","type":"text","marks":[{"type":"code"}]},{"text":" section.","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Open ","type":"text"},{"text":"ADP_PF_EventMonitoringProcessFlow","type":"text","marks":[{"type":"code"}]},{"text":".","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Set the ","type":"text"},{"text":"Miss Fire","type":"text","marks":[{"type":"code"}]},{"text":" parameter to the minimum time you want the event to misfire based on your requirement.","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Set the ","type":"text"},{"text":"Hour","type":"text","marks":[{"type":"code"}]},{"text":" parameter to the desired value (e.g., 2 if the event should be stuck for at least 2 hours).","type":"text"}]}]}]},{"type":"mediaSingle","attrs":{"layout":"align-start","width":473,"widthType":"pixel"},"content":[{"type":"media","attrs":{"width":1262,"id":"99e2f6b8-63e3-4a91-9d57-c4cae80ca7b5","collection":"contentId-338329675","type":"file","height":796},"marks":[{"type":"border","attrs":{"size":1,"color":"#172b4d"}}]}]},{"type":"heading","attrs":{"level":3},"content":[{"text":"Step 4: Update Database Query in Mapper","type":"text"}]},{"type":"orderedList","attrs":{"order":1},"content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Edit mapping ","type":"text"},{"text":"ADP_DM_convertEventInfoToMail","type":"text","marks":[{"type":"code"}]},{"text":".","type":"text"}]}]}]},{"type":"mediaSingle","attrs":{"layout":"align-start","width":473,"widthType":"pixel"},"content":[{"type":"media","attrs":{"width":1386,"id":"0bcec2e7-b895-4d06-bb67-e4f7700892bb","collection":"contentId-338329675","type":"file","height":686},"marks":[{"type":"border","attrs":{"size":1,"color":"#172b4d"}}]}]},{"type":"orderedList","attrs":{"order":2},"content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Edit variable ","type":"text"},{"text":"VarQuery","type":"text","marks":[{"type":"code"}]},{"text":" according to your database:","type":"text"}]},{"type":"bulletList","content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"For SQL Server","type":"text","marks":[{"type":"strong"}]},{"text":":","type":"text"}]},{"type":"paragraph","content":[{"text":"Copy code","type":"text"}]},{"type":"codeBlock","attrs":{"language":"sql"},"content":[{"text":"concat('select *,DATEDIFF_BIG(MILLISECOND, ',$apos,'19700101',$apos,', SYSDATETIMEOFFSET()) AS currentEpochTime from ABPM_TRIGGERS with(nolock)') \nconcat('SELECT *, TIMESTAMPDIFF(MICROSECOND ',',', $apos,'1970-01-01 00:00:00',$apos,',',' NOW()) / 1000 AS currentEpochTime FROM ABPM_TRIGGERS')","type":"text"}]},{"type":"paragraph","content":[{"text":"For Oracle","type":"text","marks":[{"type":"strong"}]},{"text":":","type":"text"}]},{"type":"paragraph","content":[{"text":"Copy code","type":"text"}]},{"type":"codeBlock","attrs":{"language":"sql"},"content":[{"text":"concat('SELECT a.*,(CAST(SYS_EXTRACT_UTC(SYSTIMESTAMP) AS DATE) - TO_DATE(',$apos,'1970-01-01',$apos,$apos, 'YYYY-MM-DD',$apos,')) * 86400000 AS currentEpochTime FROM ABPM_TRIGGERS a');","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"For MySQL","type":"text","marks":[{"type":"strong"}]},{"text":":","type":"text"}]},{"type":"paragraph","content":[{"text":"Copy code","type":"text"}]},{"type":"codeBlock","attrs":{"language":"sql"},"content":[{"text":" 'SELECT *, UNIX_TIMESTAMP(NOW()) * 1000 AS currentEpochTime FROM ABPM_TRIGGERS","type":"text"}]}]}]}]}]},{"type":"heading","attrs":{"level":3},"content":[{"text":"Step 5: Update Calendar Event to Run Flow Every 2 Hours","type":"text"}]},{"type":"orderedList","attrs":{"order":1},"content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Navigate to ","type":"text"},{"text":"Configure > Event > Calendar Event","type":"text","marks":[{"type":"code"}]},{"text":".","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Select the event ","type":"text"},{"text":"ADP_CE_eventMonitoringFlow","type":"text","marks":[{"type":"code"}]},{"text":".","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Update the event to trigger every 2 hours.","type":"text"}]}]}]},{"type":"heading","attrs":{"level":2},"content":[{"text":"Process Flow Activities Description: ","type":"text"}]},{"type":"orderedList","attrs":{"order":1},"content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Navigate to ","type":"text"},{"text":"Configure > Process flow > ADP_PF_EventMonitoringProcessFlow ","type":"text","marks":[{"type":"code"}]}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Edit Process Flow ","type":"text"},{"text":"ADP_PF_EventMonitoringProcessFlow","type":"text","marks":[{"type":"code"}]},{"text":".","type":"text"}]}]}]},{"type":"mediaSingle","attrs":{"layout":"align-start","width":862,"widthType":"pixel"},"content":[{"type":"media","attrs":{"width":1173,"alt":"image-20240724-054502.png","id":"3d194bed-d48f-4860-a3a8-f5c693044f0c","collection":"contentId-338329675","type":"file","height":352},"marks":[{"type":"border","attrs":{"size":2,"color":"#172b4d"}}]}]},{"type":"paragraph","content":[{"text":"This Process flow contains the following activities: ","type":"text"}]},{"type":"orderedList","attrs":{"order":1},"content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Data Mapping and Query","type":"text","marks":[{"type":"strong"}]},{"text":": The data mapping is utilized to query the backend database for a list of events that have been blocked for a duration exceeding the time specified in the process flow variable.","type":"text"}]}]}]},{"type":"mediaSingle","attrs":{"layout":"align-start","width":820,"widthType":"pixel"},"content":[{"type":"media","attrs":{"width":1203,"alt":"image-20240724-052245.png","id":"2e6e9f0c-9252-44c8-a6e7-9e9fa8dc14b2","collection":"contentId-338329675","type":"file","height":295},"marks":[{"type":"border","attrs":{"size":2,"color":"#172b4d"}}]}]},{"type":"paragraph","content":[{"text":"DataMapping ForEach Description: ","type":"text"}]},{"type":"codeBlock","attrs":{"language":"xml"},"content":[{"text":"$varExecuteQuery//Root/Record[(number(format-number(number(currentEpochTime ) - number( PREV_FIRE_TIME),'#')) > $varComparison and normalize-space(substring-after( TRIGGER_NAME,':' )) != '' and number(format-number(number(NEXT_FIRE_TIME ) - number( PREV_FIRE_TIME),'#')) < $varComparison) or (number(format-number(number(NEXT_FIRE_TIME ) - number( PREV_FIRE_TIME),'#')) > $varComparison and ((format-number(number(currentEpochTime ) - number( PREV_FIRE_TIME),'#') div format-number(number(NEXT_FIRE_TIME ) - number( PREV_FIRE_TIME),'#')) > (number($vargetMissFire) + 1)))]","type":"text"}]},{"type":"orderedList","attrs":{"order":2},"content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Gateway Condition","type":"text","marks":[{"type":"strong"}]},{"text":": A gateway condition is implemented to verify if there is at least one event that satisfies the specified condition.","type":"text"}]}]}]},{"type":"mediaSingle","attrs":{"layout":"align-start","width":120,"widthType":"pixel"},"content":[{"type":"media","attrs":{"width":93,"alt":"image-20240725-090558.png","id":"d0309f9a-92ef-4861-a947-02965ccb7d11","collection":"contentId-338329675","type":"file","height":82},"marks":[{"type":"border","attrs":{"size":1,"color":"#172b4d"}}]}]},{"type":"orderedList","attrs":{"order":3},"content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Text Layout for Mail Notification","type":"text","marks":[{"type":"strong"}]},{"text":": A structured text layout is utilized to encompass all necessary fields for the email notification. This layout is selected for its adaptability, facilitating the inclusion of additional fields as required in the future.","type":"text"}]}]}]},{"type":"mediaSingle","attrs":{"layout":"align-start","width":632,"widthType":"pixel"},"content":[{"type":"media","attrs":{"width":1033,"alt":"image-20240724-052636.png","id":"7bc171d3-9687-4273-9aa2-495995fbb76e","collection":"contentId-338329675","type":"file","height":648},"marks":[{"type":"border","attrs":{"size":1,"color":"#172b4d"}}]}]},{"type":"orderedList","attrs":{"order":4},"content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Custom Plugin for XML to HTML Conversion: ","type":"text","marks":[{"type":"strong"}]},{"text":"A custom plugin is employed to transform the XML stream into HTML format, enabling seamless integration with the mail notification system.","type":"text"}]}]}]},{"type":"mediaSingle","attrs":{"layout":"align-start","width":640,"widthType":"pixel"},"content":[{"type":"media","attrs":{"width":1048,"alt":"image-20240724-052747.png","id":"13959505-491b-4e4a-b2c3-1282bad9eeda","collection":"contentId-338329675","type":"file","height":588},"marks":[{"type":"border","attrs":{"size":1,"color":"#172b4d"}}]}]},{"type":"paragraph","content":[{"text":"Custom code: ","type":"text","marks":[{"type":"strong"}]}]},{"type":"codeBlock","attrs":{"language":"java"},"content":[{"text":"import java.io.BufferedReader;\nimport java.io.File;\nimport java.io.FileInputStream;\nimport java.io.InputStreamReader;\nimport java.util.ArrayList;\nimport java.util.Iterator;\nimport java.util.List;\nimport com.adeptia.indigo.services.ServiceException;\n \n \ntry \n\t{ \n String hour = (String)context.get(\"hour\");\n\t\tBufferedReader reader = new BufferedReader(new InputStreamReader(inputStream));\n\t\t StringBuffer sb = new StringBuffer();\n\t sb.append(\"Hi,

This email is to notify you that some events have not been triggering for the past \" + hour +\" Hours.

The following events are currently stuck:

\");\n\t sb.append(\"\");\n\t sb.append(\"\"\n\t + \"\"+ \"\");\n\t sb.append(\"\");\n\n String line = reader.readLine();\n while(line != null){\n String []str=line.split(\",\");\n\t\t\tif(str.length != 0){\n sb.append(\"\");\n\t\t\t}\n line = reader.readLine();\n } \n sb.append(\"

Event Name	Last Fire Time	Action
\");\n sb.append(str[0]);\n sb.append(\"	\");\n \n sb.append(str[1] );\n sb.append(\"	\");\n\t\t\t\n\t\t\tsb.append(str[2] );\n sb.append(\"	\");\n\n sb.append(\"

\");\n sb.append(\"
Thanks,
Adeptia Monitoring
\");\n\t // System.out.println(sb.toString());\n service.write(sb.toString().getBytes(), \"default\");\n\t}catch(Exception e) { \n\t\t\te.printStackTrace();\n\t\t\tthrow new ServiceException(e);\n\t}","type":"text"}]},{"type":"orderedList","attrs":{"order":6},"content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Mail Target for Email Notification: ","type":"text","marks":[{"type":"strong"}]},{"text":"A mail target is configured to dispatch the email notification to the intended recipient efficiently and reliably.","type":"text"}]}]}]},{"type":"mediaSingle","attrs":{"layout":"align-start","width":561,"widthType":"pixel"},"content":[{"type":"media","attrs":{"width":1031,"alt":"image-20240724-052955.png","id":"32d9f032-c132-4621-bdab-7723c37f7a10","collection":"contentId-338329675","type":"file","height":613},"marks":[{"type":"border","attrs":{"size":1,"color":"#172b4d"}}]}]},{"type":"heading","attrs":{"level":2},"content":[{"text":"Conclusion","type":"text"}]},{"type":"paragraph","content":[{"text":"Following these steps will allow you to successfully deploy and configure the Adeptia process flow for sending email notifications for stuck events. For further assistance, please reach out to the Adeptia support team.","type":"text"}]},{"type":"paragraph"}],"version":1}

Browser not supported