cancel
Showing results for 
Search instead for 
Did you mean: 

File Event based scheduling

Former Member
0 Kudos

Hi,

I have scheduled a report with events. There are two events one is File and another Schedule.

When a text file is placed in a folder, a file based event is triggered and the report is run.

On successful completion of the report, schedule based event is triggered which will call a program file which deletes the text file. The text file is placed in a BO server folder on a daily basis.

For the report schedule options under events, I have given the file based event to wait for and schedule based event to trigger on completion.

For the program file schedule options under events, I have given the schedule based event to wait for the successful completion

of the report. This file is to delete the text file.

But the schedule based event is not triggering the program file and due to this the text file is not deleted. And the next day the text file is overwritten, as that file was not deleted yesterday. Due to this overwriting the event is not triggered the next day.

I am using BO XI 3.1.

Could anyone share their knowledge as why the schedule based event is not triggering the program file to run?

Thank you.

Accepted Solutions (0)

Answers (3)

Answers (3)

Former Member
0 Kudos

I suggest you use the Windows scheduler to use this batch file

Former Member
0 Kudos

If you are using windows why don't you try the scheduler task option to delete the file for file based event instead of using program job.

Otherwise try above option , if it works then the problem is with your program file...work on it.

Thanks,

Anil

DDortants
Product and Topic Expert
Product and Topic Expert
0 Kudos

Hello,

Using events to trigger and clean up etc can be tricky.

The thing to keep in mind that scheduling based on event is a pretty dumb process when it comes to our servers processing it.

What i mean here is that we do NOT check any processing outside of our own application (with own i mean XI 3.1).

So in other words, if you schedule an application to run; it simply means that we kick of the application, but do NOT check if it actually runs successfully or check the results of this 3th party app.

so when your schedule event gets triggered because of the file event success; XI 3.1 simply tells the app to run, and considers this a success no matter if the actually 3th party APP runs or not.

In your case the application is not doing what it suppose to, which is deleting the file.

Because of this, the file event is never being reset as the file is ALWAYS there and will never run again.

So what you could do or check is the following:

- either make sure the application is running or executing correctly.

- run a clean up of that file or folder on a certain time every day (external to XI 3.1). This would reset the file event every day.

- You could create a custom event by creating a script that would do all of this. But it would involve custom coding.

Hope this helps you,

Regards,

Duncan

Former Member
0 Kudos

Hi Duncan,

Thanks for your reply.

either make sure the application is running or executing correctly.

Actually the program is a batch file, which is deleting the text file when run manually from the operating system.

run a clean up of that file or folder on a certain time every day (external to XI 3.1). This would reset the file event every day.

I would like the batch file to delete the text file as soon as the Report is run successfully. Not sure why that is not triggering even though the time is within the schedule window.

You could create a custom event by creating a script that would do all of this. But it would involve custom coding.

I donu2019t have knowledge about custom coding and would rather not consider this option.

Do you have any other inputs?

DDortants
Product and Topic Expert
Product and Topic Expert
0 Kudos

Hello,

What might be the issue is that the batch file is executed by a service that is running most likely using the windows system account. You could try to alter the service account to run under a user account (the user account for example that you used to run the batch manually) and see if it gives you better results.

Cheers,

Duncan