Focal Point Banner


As of December 1, 2020, Focal Point is retired and repurposed as a reference repository. We value the wealth of knowledge that's been shared here over the years. You'll continue to have access to this treasure trove of knowledge, for search purposes only. Moving forward, myibi is our community platform to learn, share, and collaborate. We have the same Focal Point forum categories in myibi, so you can continue to have all new conversations there. If you need access to myibi, contact us at myibi@ibi.com and provide your corporate email address, company, and name.


Connect to myibi
Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [SOLVED] Report runs in Dev Studio, not in ReportCaster

Read-Only Read-Only Topic
Go
Search
Notify
Tools
[SOLVED] Report runs in Dev Studio, not in ReportCaster
 Login/Join
 
Master
posted
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
 
Posts: 674 | Location: Guelph, Ontario, Canada ... In Focus since 1985 | Registered: September 28, 2010Report This Post
Platinum Member
posted Hide Post
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
 
Posts: 242 | Location: Minneapolis | Registered: February 16, 2006Report This Post
Master
posted Hide Post
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
 
Posts: 542 | Location: Dearborn, MI | Registered: June 03, 2009Report This Post
Master
posted Hide Post
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
 
Posts: 674 | Location: Guelph, Ontario, Canada ... In Focus since 1985 | Registered: September 28, 2010Report This Post
  Powered by Social Strata  

Read-Only Read-Only Topic

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [SOLVED] Report runs in Dev Studio, not in ReportCaster

Copyright © 1996-2020 Information Builders