(This is Baan 5c) I have a job that contains a query. When the job tried to run queued, I get a session message saying that the report is not present. When I activate the job within my bshell, it appears to run correctly and find the report. I have already checked to make sure that the PVRC on the user associated with the job matches that of the report (per another post). Any other ideas on how to track this down?

In Baan IV there was a weird security measure where one user couldn't run another users's Easy SQL reports. The fix was to blank out the "Owner" field of the report so that everyone could use it.. could that be the case here? I'm not that familiar Easy SQL in Baan 5.

Dave

The owner is blank for the query. Thanks, though.

Any other thoughts???

Do you have any form fields / selection data?

The default range could be a problem if it is not able to run for the desired range.

Another trial could be to build the query as the "job" user and try running it
both manually ( logged in as job user) and in job.

if it is the problem with the report object itself, may be a compile might help????

Try doing a trace put

-- -dbgobj -keeplog -logfile dbg.job

in your jobd bwc file. maybe that will tell you something.

Dave