Hi,

I have a fex that create an Excel template with 4 sheets.
It works fine when I'm running it from portal or when I schedule the fex directly.

When I -INCLUDE the fex into another one that is already scheduled, first three sheets are saved properly according to the log (0 XLSX FILE SAVED ...) but the last one end with error:

(FOC3289) TEMPLATE FILE: Error opening file

The template exist in the baseapp.

Can't find any differences from the tracing between the two schedules.
The only difference is that from the schedules that don't work the schedule first call a fex that then call the one that creates the report.

schedule 1 (working ok) task : call fex2 (which is IBFS:/WFC/Repository/Orders/Sales_Order/Sales_Order_XLS.fex)

schedule 2 (not working) task : call fex1

fex1 :

-IF &FOCFOCEXEC EQ 'RCASTER' THEN GOTO XLSCASTER;
...
-EXIT
-XLSCASTER
-INCLUDE IBFS:/WFC/Repository/Orders/Sales_Order/Sales_Order_XLS.fex

What could be the issue ? Any ideas ?

Thanks to help

This message has been edited. Last edited by: <Emily McAllister>,

Are RC and the included fex running in the same environment? Do both have permission to access all the relevant files?

You're including a fex from the WF Client in a fex that is in a place unknown to us (The WF reporting server, perhaps? That would explain the problem).

ReportCaster also looks in a certain location, probably that same client, but possibly in a different repository path and/or as a different user.

All fex exist under the same Content folder (IBFS:/WFC/Repository/Orders/Sales_Order/), both schedule also exist under the same Content folder (IBFS:/WFC/Repository/Orders/Sales_Order/) and everything seems to be called correctly since I can see all the proper code in both cases - it is what I'm expecting to see.

Also use the same execution id.

It seems that in one case RC can retrieve the template but in the other it can't.
But in both cases, the template is the same and located in baseapp.

baseapp is part of the apppath and no special rules on it except the default ones.

Martin,

If you set up a schedule just for the Sales_Order_XLS.fex does this work?


I believe this should work in WF8105M, since I have seen other cases that indicate as such.

Can you verify the following:
As a Caster admin, can you open the Caster Server Configuration tool,
then in the general tab, go to Schedule Format, and click on the
dropdown list - in this list, is EXL07 and EXL07 Template checked ?

Thank your for participating in the Focal Point Forum,
Tamra Colangelo
Focal Point Moderator
Information Builders