How to delete an Event file?

security CMC
1

Hi All,

I am planning to schedule some reports based on File Event.

Report schedule is triggered on arrival of file. The file is created at the end of ETL process.

Can any body explain to me, How can i delete this file using some process automatically?

Environment is BOXI R2 on AIX 5.3.

Thanks in advance.

MightyBO :us: (BOB member since 2007-06-28)

2

Hi,

Have your ETL process to delete the file at the very beginning of the data processing/load.

Marek Chladny :slovakia: (BOB member since 2003-11-27)

3

Hi Marek,

Thanks for the reply.

Can you elobrate to me the process in ETL, how can we configure to delete the file.

We are using Informatica.

Thanks.

MightyBO :us: (BOB member since 2007-06-28)

4

Hi,

In fact, I don’t know. This is an Informatica-related question and not a BO-related one. You should ask the question in an Informatica forum/board.

Marek Chladny :slovakia: (BOB member since 2003-11-27)

5

Hi,

Or else you can Create program object to delete the files.

  1. Created a file based event “A” which is triggered up on the existence of the text file.
  2. Created a program object which runs the batch file located on local Drive
    (This batch file deletes the file placed by ETL)
  3. Scheduled the report with event wait as “A” and Event to be triggered on completion as “B” (B is a scheduled event created for success or failure)
  4. Scheduled the program object to wait for the Scheduled Event “B”

This way whenever the text file appears in the said location, Event A is fired and report schedule starts and up on completion of the report schedule(Success or failure) it fires a scheduled event B which will Schedule Program object which deletes the text file.

-Satish

forgotUN (BOB member since 2006-12-13)

6

Thank you Satish.

It is very good idea. Easy to implement in BO

Can anybody tell me how to do it in ETL?

MightyBO :us: (BOB member since 2007-06-28)

7

Hi All,

I have one question regarding this Event scheduling. Is Event server works for only text file or Any file in network drive, later kicks the File Event.

Thanks

MightyBO :us: (BOB member since 2007-06-28)

8

Hi,
The file type can be anything.
Event Server just monitors the file in directory (Can be Network Drive) that you specified. When the appropriate file appears in the monitored directory, the Event Server triggers your file-based event.
Sometimes the events will not trigger when the monitored file appears on a network drive.
This may be because the server is running as the default “Local System” ccount. To resolve this change the logon information to a domain account that has read access to the designated file share.

-Satish

forgotUN (BOB member since 2006-12-13)

9

Thank you very much Satish. It is good.

I have one new question regarding Event scheduling.

Is it possible to trigger from a table read?

Thanks in advance.

MightyBO :us: (BOB member since 2007-06-28)

10

Hi,
No, i haven’t seen any feature to trigger based on table read.
But i have come across an third party article which does talk about this.
Document Link

-Satish

forgotUN (BOB member since 2006-12-13)

11

Thanks Satish.

MightyBO :us: (BOB member since 2007-06-28)

12

I have few questions regarding Event file scheduling.

  1. Suppose i schedule a report with recurrence as every week on Tue and Sun with Events.

Start from Aug 28 2009 to Aug 27 2019.

So my event schedule look for a trigger file on Tue or Sun like 00:01 AM to 11:59PM. Am i right?

If it is wrong how long will my schedule monitor for file? what is the time frame.

  1. How can i control the report run only once.

Suppose if informatica push a file twice on the same day Tue or Sun between 00:01AM to 11:59PM. In this case my report runs twice, am i correct?
If it is the case, how could i stop second run from BO side?
From Informatica we can ask them create only once.

Thanks in advance.

MightyBO :us: (BOB member since 2007-06-28)

13

Any answers please.

MightyBO :us: (BOB member since 2007-06-28)

14

Yes, if you schedule time actually starts at 00:01AM. But the file needs to be created after this time. So if the file is already in place and the schedule starts then it doesnt see the file as a new file and will therefore ignore it. Not just overwrite it - it has to be gone for the timeinterval as specified in the CMC for the Event Server.

Not if you schedule the report to run daily on Tue and Sun. Because what you are really saying is to run the report on Tue and Sun whenever the file event is set for the first time. It will ignore subsequent file creations on those days.

Orange :netherlands: (BOB member since 2006-09-18)

15

Thanks Orange.

  1. So my scheduled job will neglect second time file triggers on the same day.

MightyBO :us: (BOB member since 2007-06-28)

16

indeed

Orange :netherlands: (BOB member since 2006-09-18)

17

Hi,

I have implemented my solution in exact same way. However, my bat file does not run when triggered by scheduled event.
Moreso, when I try to run the batch file (which is a Program object) in CMC → Objects > filename → Schedule → Run now, it gives an error “The Program Object reported an error while running, but no error code was provided.”
:hb:

Can u please advice.

Suup (BOB member since 2010-02-18)

18

The error code should be supplied by your batch file, so if you dont provide error trapping, then this makes sense.

Could you post the contents of the batch file here, so we can have a look?

Orange :netherlands: (BOB member since 2006-09-18)

19

I am attempting the same thing. The process fails when the BAT file is initiated with this error message:

“Running programs of this type has been disabled by the administrator.”

How do I enable it?

MarcW :us: (BOB member since 2006-08-01)

20

See this.

Joe

joepeters :us: (BOB member since 2002-08-29)