Failed to open rowset error

[organickarma]

I created a CR in version 9 off a oracle 10g stored procedure. I am using the odbc oracle driver v 5.1 I run the report in crystal and I face no problems. When I schedule it to run on e portfolio it gives me this error

"Failed to open a rowset. File ~tmp12404ca9d46bdb0.rpt."

Any ideas why this happens only on publishing

 

[Tatertot45]

The only time i have recieved this erroe is when i had an issue in a formula. Writing the report was OK, becuase the data set was small and it worked out fine. When i deployed it, i got this error becuase of something in a formula that was not suntioning correctly. An example would be, but is not limited to, division by zero, occurrences of null values when a value is needed, and Multipass issues, needing a value from a second pass formul in a first pass situation. Again, i have only gotten this error once or twice. Check your formulas. I like to suppress all the other sections except the details, then load my dritical fields in tothe detail and see what populates. That is how i found my division by zero errors.

Good luck