Carlosdl   29820 pts.  |   May 22 2009  8:18PM GMT

Per the error code, we must assume you are using Oracle Reports. If that is correct, what version and patch level ?

Are you calling the report from a forms application ?
Did this report work before ?
Does this error occur with this report only ?

The more information you provide, the better chances to get useful responses.

Gkahler   45 pts.  |   May 22 2009  8:40PM GMT

Yes I am using reports builder 6i. I open the report then try to run it. It waits for a while then gives an error. I can open a older version of the report and run it OK. I am able to compile it and create a run time OK. The reports runtime gives me the same error but I can run it on my server OK.

Greg

Gkahler   45 pts.  |   May 22 2009  8:47PM GMT

oops forgot Report Builder 6.0.8.11.3

Carlosdl   29820 pts.  |   May 22 2009  9:36PM GMT

I have not encountered this error, but the first thing I would do is to apply the latest patchset available, which I think is patch 18.

Second, what is the difference between the old version and the new one ? I would try starting from the previous version and applying one change at a time, to see what is the change that generates the error.

Also, have you tried compiling the report in other machine, and run it in the machine where it is giving the error ?

Gkahler   45 pts.  |   May 23 2009  11:49PM GMT

OK thanks. The change was done last Feb. I will try my other PC in the office and the patch.

Gkahler   45 pts.  |   May 27 2009  9:52PM GMT

I found the issue. The parm form had a LOV that was too large. I guess this error is related to memory.

Thanks for your help Carlos.

Carlosdl   29820 pts.  |   May 28 2009  3:12PM GMT

Excellent.

Thanks for sharing.