Focal Point
[SOLVED] Report runs in Dev Studio, not in ReportCaster

This topic can be found at:
https://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/6637052526

October 17, 2012, 06:12 PM
George Patton
[SOLVED] Report runs in Dev Studio, not in ReportCaster
Folks:

I have a number of procedures (reports and modifys) that run every day in ReportCaster with no problem.

I've recently created 3 versions of the same report (one for salesmen, one for Customer service Reps and one for Management) that fail every time I schedule them in ReportCaster.

However, they do run without a problem from Dev Studio. And if I simply run just one of the reports in Dev Studio and then switch over to ReportCaster they will run just fine.

The ReportCaster job logs say "Fieldname or computational element not recognised:[+fieldname]"

Now all the fieldnames in question are the result of a join. I'm guessing that the apppath or something like that isn't correct - or at least not correct enough for ReportCaster.

Note that there are no amper variables involved.

I welcome any suggestions...

This message has been edited. Last edited by: George Patton,


WebFOCUS 7.7.05 Windows, Linux, DB2, IBM Lotus Notes, Firebird, Lotus Symphony/OpenOffice. Outputs PDF, Excel 2007 (for OpenOffice integration), WP
October 17, 2012, 07:21 PM
Norb Eckert
If I'm running a task from Reportcaster that is calling a fex with masters from an application folder that is not in the normal application path - I've had to include a path command at the top of the fex such as:

APP PREPENDPATH SALESTAX

Otherwise I would get an error statement similar to the one you got. I reset the paths at the end of the fex also with: APP PATH


Norb

This message has been edited. Last edited by: Norb Eckert,


prod:7.6.9, win2k3 mre, caster, bid, devstudio 7.6.9
October 18, 2012, 08:49 AM
Ram Prasad E
Use WHENCE command to locate application folder of the master file and make sure that is as expected.
If there are multiple master files in the same name and that folder comes first in APP PATH search list, you will get similar error in Report Caster.

Hope this helps.

Thanks,
-Ram


WebFOCUS 8.1.05
Windows
http://ibiwebfocus.wordpress.com
https://www.facebook.com/groups/ibi.webfocus/
October 24, 2012, 12:36 PM
George Patton
I used Norb's suggestion and it seemed to work this morning on one of the reports - I've modified the others and we will see if everything runs smoothly tomorrow.


WebFOCUS 7.7.05 Windows, Linux, DB2, IBM Lotus Notes, Firebird, Lotus Symphony/OpenOffice. Outputs PDF, Excel 2007 (for OpenOffice integration), WP