Data Analytics - Ask The Expert Recurring Series Monarch &Monarch Server(Automator) focus. July 27th Session reviewed Model & Workspace Verify Objects in Monarch Server(Automator) before going into LIVE Q/A.
Ask The Expert Series on July 27, 2021
Monarch & Monarch Server(Automator)
The Session began with a brief overview of Model & Workspace Verify Objects in Monarch Server(Automator) before diving into the LIVE Questions.
Question & Answer:
1. Is there a way or a script that could be added to an Automator project? I have an monitored project that runs so fast it cannot move the file fast enough at the end before trying to start a second time. If I could get the Automator to pause 10 seconds after the Move Step, I believe it would keep me from getting an error from the monitored job when it tries a second time.
- Normally monitoring will not pick up files with the same name if it is within a certain time frame.
2. What purpose/role does the HUB paly in a process?
- The HUB can be used to connect objects that normally cannot be joined directly. It is also used for handling multiple input files and how they should be grouped for exporting. More info can be found in the Monarch Server Help Guide.
3. Why do you have to put a HUB between Workspace and Verify Workspace?
- You need the HUB element because you cannot connect the workspace directly to the Verify Workspace Node. To expand, the only nodes that a Workspace Node can connect to are a HUB or a DataPrep Export Node. The Verify Workspace only takes a HUB as an Input Node.
4. In follow-up to question 3, I have several processes that utilize Verify Workspace without a HUB and they work correctly. We're not on the newest version; is that a factor?
- Where in the flow does the Verify reside?: Looking at one of mine, the Verify is after the Export- That must be the difference. Normally, the Verify is used to verify the Monarch Tables being created prior to exporting data so you can decide if you should Export the data or not. Using it after the Export Option to determine which distribution path to follow(which email to send).
5. For a Workspace that uses a Data Connection, can you set up Verify Workspace for the connection and if it fails, wait 5 minutes to try again? We sometimes have an issue with the database connector failing, but if you set off the process again, it works fine.
- Depending on the error, you might be able to use a Timer Node. For more information See Advanced Settings.
6. Is there a way to force a row with a certain value in a field if the filter does not produce any row? If the Verify Model does not find any rows were produced, can the Input File be changed to another File Input file?
- Yes. You can add another File Input ->model -> Export for the Failed Path.
7. What is the benefit to clicking APPLY before clicking OK in the Right Pane?
- APPLY will save and keep the Node Properties Open. OK will Save and Close the Node Properties Window.
Additional Resources:
-
Monarch Server Help Guide- Verify Workspaces
-
Automator Administrator Guide
- See Attachment for Example of 'Verify Workspace'