I have a report I need to scheudle to run every week and email user as excel file. report is running well in Devloper studio. however when I scheudled it and run it in report castor. I got below errir and report stop running right away. does anyone know what does the error mean and how to pass that?

thank you


The number of messages returned by the Reporting Server exceeds the value of the MAX MESSAGES setting, 1000

This message has been edited. Last edited by: <Kathryn Henning>,

Try setting echo to off, Report Caster doesn't like ECHO.

-SET &ECHO=OFF;

I guess there is some LOOP happening when you do schedule.

Thank you Francis !! I've been battling this same issue for weeks - report runs fine in Dev Studio but fails when run under ReportCaster. Removing the &ECHO fixed it ...

George,
Francis provided you with a bit of "castor oil"...

Things running smoothly is greatly to be desired, but when they run out of control things can get very messy ... which reminds me I'm due for a colonoscopy soon ...

Ouch!

Francis 's suggestion really worked. once I took off the Echo, it run well in my devlopment enviroment. howeverm when I move it into our production enviroment. I got a differnt error below:" Task error: Invalid type of argument #1 for user function DATECVT". I don't know what to do now. I did not got that error when I run it in Dev

Compare the field definition/format/type between Dev and Prod for the one used in DATECVT function.

You'll probably found the solution around that...

I did not use DATECVT function in my report. I asked our administrator to check any settings and did not find anything different bewteen Dev and Prod. any more suggestion?

Do you have any date parameter somewhere ?

Set the tracing and the ECHO on and then look at your schedule log. That may help finding from where the error comes from.

... also check for defines in the synonyms accessed by the fex.

T

I have to set the ECHO off to make the report run in report castor. if I turn it on, it won't run. correct one thing I said. I DO use the DATECVT in my report code.

I figured it out. I forgot to update the meta data. thanks all for the help!