Reboots and "FILE EVENT" triggers. 1

[MJRBIM]

We have some PENDING report instances that are dependent upon TXT files that are created by an Oracle process on a different physical server - which is monitored by the BOE servers using a UNC-path.

This all works fine, except when the various servers are rebooted for monthly "Microsoft Security Patches".

Depending on the order that the various servers come back up - the PENDING report instances can be triggered when the server referenced in the UNC-path comes up.

As a workaround, we are PAUSING all the PENDING instances before the "Microsoft Security Patches" are deployed on the various servers - and then RELEASING them when they are completed.

Anyone else had this problem - and have a different / better solution...?

Senior Business Intelligence Consultant
Toronto, Canada

SeagateInfo 7 -> Crystal Enterprise -> BOE-XI (R2) / (R3.1) | Crystal ( 7 -> 2008) design | WebI design | Best practices for Java / .Net / Web Services

 

[hilfy]

What's happening is that the Event Server registers that the file is not there while the server is being rebooted then the Event Server sees that it is there when the reboot is completed. So, if you run a script to delete the files prior to the patch they wouldn't be there when the server comes back up and the Event Server wouldn't kick off the report.

-Dell

A computer only does what you actually told it to do - not what you thought you told it to do.

 

[MJRBIM]

Thanks for the suggestion.

Senior Business Intelligence Consultant
Toronto, Canada

SeagateInfo 7 -> Crystal Enterprise -> BOE-XI (R2) / (R3.1) | Crystal ( 7 -> 2008) design | WebI design | Best practices for Java / .Net / Web Services