Anyone seen this error?

Jodin

I have a certain report that has a sporadic error when it is published. The report will work fine for two, three, or more runs and then suddenly get a stack overflow error with the following message:<br />
<br />
<img src='http://img801.imageshack.us/img801/9506/capturewp.png' alt='Posted Image' class='bbc_img' /><br />
<br />
Has anyone seen an error like this before? If so, what can I do to correct it.<br />
<br />
Thanks,<br />
<br />
Jodin

Jodin

I determined what the error was. It had to do with the dates being pulled in my SQL. I was using the DATE function on some dates that had a zero value. For some reason, this caused the SQL to bomb. It was a sporadic error that would only show up after several runs of the report, never on any initial runs. When I added some logic to handle the dates, the error stopped showing up in my testing. Here is an example of what I wrote to correct the issue:

CASE
WHEN efeedt > 0 THEN
DATE ( SUBSTR ( DIGITS (efeedt),1,4) || '-' || SUBSTR ( DIGITS (efeedt),5,2) || '-' ||
SUBSTR ( DIGITS (efeedt),7,2))
END AS expdate