Why an event of type schedule is not triggered?

[junction123]

Hi

I am using CE 9.0 and Sybase 12.0.

I am in the process of doing a couple of tests to be alerted when a report instance either does not run or fails.

I have two reports, Reports A and Report B. Report A generates a file in PDF with data. Report B is a dummy report and generates an empty text file that will be sent via FTP to a server only when Report A completes successfully.

Report A

Run at a specific time with events (ONCE)

Parameter ALS

Format PDF

Wait For Event ALS.txt

Destination e-mail

Under Schedule Tab: Events To Trigger On Completion
ALS.FTP Complete (on success)



Report B (Will run after Report A ran successfully)


Run at a specific time with events (ONCE)

Events to Wait For ALS.FTP Complete (on success)

Destination FTP

Format Plain Text

Report A and B are scheduled to run at the same time. Report A runs fine and I get the e-mail. Report B never runs and is always in a PENDING state. Why does the event that is supposed to get triggered after the successful running of Report A never triggered? I could not find any help on CMC help menu.

Thanks in advance!!!

junction123

 

[techie2]

Is your event server enabled and running. Go to Enable/Disable under CCM and make sure it is enabled.

 

[junction123]

I am not sure how to check this. I went to the event server and under the metrics tab found the successful generation of the file for the Report A whicha has a file-based event that it waits for before it can run.

But what about Report B? It waits for the event ALS.FTP Complete that is of type schedule. Not sure how this is different from a a file-based event?

Thanks in advance!!!
junction123



d:\Flags\GlobalEquityBuysideResearch\APM_Packets\ALS.txt 2005-12-29 18:25:44

 

[techie2]

Refer to this article and make sure the event server is enabled and running.

http://support.businessobjects.com/library/kbase/articles/c2010626.asp

 

[KingfisherINC]

Schedule based events are managed by the CMS not the Event server. (not very intuitive, I know).

What does it say when you click on Pending for Report B?

Try setting the start time for Report B earlier than Report A - I'm just guessing that Report A is finishing before B has been queued.
(forcing Report A to run again with Sucess Event will provide the same proof).

Kingfisher

 

[junction123]

Kingfisher,

Thanks for your response.

I scheduled Report B to run once @9:43 AM on 12/30/05. I scheduled Report B to run once @9:48 AM. I manually put the txt file on the DEV server at 9:59 AM after the instance for Report A ran.

Report B is still in a Pending state.

This is what it says when I click on the Pending instance:

Status: Pending

Printer: The instance is not printed.

External Destination: FTP the instance with name " ALS.txt " to the directory: " ./ " on host " amaprd99 ".

Start Time:

End Time:



Recurrence Type: Run the report once.

Next Run Time: 12/30/2005 9:43:00 AM

Server Group: Can be scheduled to any server group

Waiting for Events : ALS.FTP Complete


Thanks in advance!!! junction123

 

[KingfisherINC]

Sorry now I'm more confused. You manually put the file on the server After Report A ran?

Is Report B dependent upon a file event or a schedule event? i.e. should Report B wait for ALS.txt file, or the successful completion of Report A.

Try simplifying the process; remove FTP, PDF, etc. just get two simple reports to run; one dependent upon the other.

It maybe as simple as missing an "Update" click on Report A's "on success" event. Double check that Report A has this set.

Or if Report B is really waiting for the ALS.txt file maybe the Event Server is looking on the wrong server?

Kingfisher

 

[junction123]

Kingfisher,

Sorry to be confusing.

Report B will run after the successful completion of Report A only.

Report A will run after I put the txt file manually(for my test). Eventually the file be put in automatically. Also, Report A should trigger an event ALS.FTP Complete. This event should trigger Report B. I have the event ALS.FTP Complete under "Wait For Events" for the Report B instance.

Let me check the cases you mentioned as well.

Also, the ceadmin is able to have Report B run and I am doing the exact same steps as him: Could it be my permissions? His response:

Both reports ran successfully. I followed these steps:

1. Deleted ALS.txt from CEDEV.
2. Scheduled both report instances to run at the same time, 11:20am. 3. At 11:22am I placed ALS.txt on \\ac2kama0815\d$\Flags\GlobalEquityBuysideResearch\APM_Packets.



Events to wait for:
ALS.FTP Complete (on success)

Thanks in advance!!!
junction123

 

[KingfisherINC]

Ask your ceadmin to login as you to test if it is a permissions issue (I doubt it).

I have to bail on this now, good luck!

Happy New Year to all!

Kingfisher