I have this fex that I run in Dev Studio and it works fine.

When I try to run it in Reportcaster it runs fine and produces a report but with no data.

Any Help

Dan Moyer

You didn't mention your environment and it would be great if you added this to your signature.

I deal with this issue all the time and it is most often related to pathing. Since I don't know your environment or the kind of file you are trying to access, I can only give you some suggestions as to where to look.

When you run a report from Dev Studio, you are logged in as you. Dev Studio will look in your development directory, any directory specified in your global path (edasprof.prf) or your user profile, or in any directory APP PATH'd in your focexec.

The question is, when you run from Report Caster, what execution id are you using? What is the path for that id? Is it a default id that doesn't have a profile. Or maybe you don't have an APP PREPENDPATH in the focexec.

It always seems that if something can't be found, it is almost always a pathing issue.

Give us more info and maybe we can narrow it down for you.

We are using Webfocus 7.1.1.

The execution ID Im using in Dev studio is my Windows NT account.

I believe the execution id in report caster is the one they setup for me in report caster. It has the same userid but I have to sync the password manually when my NT password changes.

Where would I find the path for the report caster ID?

I do not have app prependpath in my fex.

Dan

Hi,

Go to the webconsole and then to application and check if the application path is containning the location of your fex file. if not append it.

Majid

Try putting APP PREPENDPATH in your focexec pointing to the directory where the master is. That is probably the quickest way.

Also, please tell us what kind of data you are trying to retrieve, relational, fixed, FOCUS?

Regarding Majid's comment, you will find that under My Console. If you are a basic user, your admin would have had to have given you permission to change your user profile.

We are using VSAM.

MAJID, I went into Webconsole but did not find a application link. Just the following

Data Adapters
Remote Servers

--------------------------------------------------------------------------------
Metadata
Procedures
Resource Management

--------------------------------------------------------------------------------
Workspace

Monitor

Statistics
Agents
Sessions
Connections
Web Sessions
Deferred List

Diagnostics

Traces

Version

--------------------------------------------------------------------------------
User Information

One other bit of info is that I am able to run fex's that have no joins in them in report caster. It is some of the ones with joins that seem to be giving me the problems.


Dan

You should be able to find it under My Console. You can also do it from Procedures. Click on the hierarchy/explorer tree icon. Find your profile and see what is in it.

Also, please let us know the platform. Update your signature to give us that information. It will be easier to help you that way.

I have updated my profile dont know why it isnt showing

Try putting it in your signature.

Are any of our ideas working for you?

Hi,

In the webconsole click on MetaData near data adapters from the manu. Then Right Click on Application Directories then append to path and there you can add the application directory containning your fex file.

Majid.

Thanks for All your help.

It looks like there was something wrong with th join.

The original join was done in focus, and tries to assign a virtual field to the third part of the join. So I joined the two parts and then did a hold file joined the last part.

I remembered talking to IBI about this and they said this is an illegal join in WF.

Dan