Tagged with Scheduler_Watchfolder - Visokio Forums

Scheduler: Running 5 Scheduler instances, which executes watchfolder actions?

Alexander — Wed, 25 Feb 2015 07:19:51 -0500

Hi All,

We have 5 Schedulers running on one server. When I drop a XML task into the Watchfolder, more then 1 Scheduler executes the task.

Is this the expected behaviour?

Parameters: On-demand parametric data set delivery

Veaceslav — Fri, 12 Dec 2014 06:55:27 -0500

Generate custom dashboards on demand

Scenario/Problem

You have an Omniscope server (2.9 or higher) installed and publicly available at your-omniscope.your-domain.com

In addition, you have another web server (Apache, Jetty, etc) providing services or any useful information to your customers/users. For the purpose of this post I'll consider that you have an apache web server at your-apache.your-domain.com, even though you can achieve this with most web servers.

On a particular page on your Apache web server you have a list of links that you want to open different dashboards based on some particular parameter (e.g. user id)
A link might look like this: http://your-apache.your-domain.com/users?userid=5

Clicking that link the user should see a dashboard page having data that concerns him/her, the dashboard would be generated on the fly.

You have a dashboard/IOK file configured to load data from a particular SQL database.

You want to load data that matches a parameter for a particular user. E.g.
SELECT * FROM [dbo].[bigtable] WHERE [somefield]={{Userid}}

Solution

IOK File

1. Open the IOK file, DataManager tab and add a parameter. E.g. Name: Userid, Type: Fixed value, Data type: Integer, Value: 3

2. Open database source block and add your custom SQL query. E.g.
SELECT * FROM [dbo].[bigtable] WHERE [Liq Cat]={{Userid}}

3. Save your file

Your apache web server

1. Implement a request handler to deal with your special GET requests http://your-apache.your-domain.com/users?userid=5 and read user id value. The server will not send a response unless all next steps finish executing (either successfully or not)

2. Generate an action file (e.g. Action.xml) that:

Sets data manager parameter value (for Userid parameter)
Refreshes from source, this sub-action will execute the SQL query again and load records matching the new user id
Save IOK file to a new unique location in mobile folder. E.g. mobile/custom-dashboards/12345.iok

3. Execute the new action
E.g. On windows (same parameters on Linux -executeAction /some-path/Action.xml)
OmniscopeEnterprise.exe -executeAction "some-path\Action.xml"

4. Once the scheduler action is executed successfully, your Apache web server will return a redirect response to the client

The client/browser will be redirected to your-omniscope.your-domain.com/custom-dashboards/12345.iok

You may want to set up a proper back-end configuration, hardware load balancer + software load balancer, caching requests, etc. Also, you may want to make sure your paths are randomly generated, to prevent other users from viewing other dashboards.

Idea: Scheduler watchfolder - process files in copied order?

alec_webliquid — Thu, 19 Sep 2013 05:06:00 -0400

Hi Visokio,

Would it be possible to implement functionality to process scheduler XML files in the order that they are copied to the watch folder? I have my processes set up in a sequential, multi-file structure, similar to the way you advise for the .iok files themselves. I would love to be able to copy all my XML files to the watch folder at once and trust that they will be processed in the correct order. Currently, I have to do it in two lots as there is no guarantee it will happen this way.

I am aware I could write more XML files which deal with all of my .iok files at once, and I may do so in the short term, but this is still something I would very much like to see if possible.

Is this request feasible?

Cheers

Scheduler: event-driven automation via watchfolder?

davedunckley — Wed, 06 Feb 2013 10:13:40 -0500

Hi Guys - I would like my Omniscope IOK file to run not from on a time schedule, but from a file drop. I have found the 'wait for file' command, but can't work out how I make this a chain reaction?

Any help would be great.- Dave

Scheduler: Running from a 3rd party application?

kattasureshkumar — Fri, 11 Jan 2013 08:41:35 -0500

We are trying to run Omniscope Scheduler from a 3rd party application by giving the path "C:\Program Files\Visokio Omniscope\OmniscopeEnterprise.exe" . We had prepared a schedule to run certain IOK files to process the data and publish them to tables. But do we have any facility to stop the scheduler once the data processing & publishing is over.

Actually our requirement is , when we have got new flat files, Our front end application will submit a request , this will trigger Omniscope Scheduler as we had provided the Omniscope Scheduler path. Once all the files are submitted, Omniscope Scheduler should stop and should close. Again if the front end application sends a request then Omniscope Scheduler should rerun and process the data and the Scheduler should stop after data is published.

Please let us know if we are doing it in a wrong way.

Thanks, Suresh.

Scheduler: Setting Task Time-outs?

benjamin — Fri, 20 Jan 2012 04:37:38 -0500

Is there any way on the Omniscope Scheduler to stop XMLs droppped into the Scheduler if they take longer then a fixed time period to run?

I know there is an option in the Scheduler that automates the XML Actions file, however if you drop the xml into the Scheduler manually or through a separate automated file writing process.. Is there a piece of code I can add to the XML Actions file itself to stop the task if it takes longer than a fixed time? Thanks - Ben