Only some crystal reports fail in scheduling

Only some crystal reports are failing while scheduled with errror.

Error in File C:\Program Files\Business Objects\BusinessObjects Enterprise 11.5\Data\procSched\puma-orarep0009.reportjobserver~tmpxxxxxxxjju5f.rpt: Database Connector Error

checked ODBC. tests fine.
any suggestions.

BOPXIR2
Crystal XI
WebI XI
Oracle 10g


matthew (BOB member since 2005-04-08)

How do these SCHEDULED reports run when you VIEW-ON-DEMAND or SCHEDULE NOW?


MJRBIM :canada: (BOB member since 2007-03-23)

the reports are schedule now.


matthew (BOB member since 2005-04-08)

Do they work (or give a more explicit error) when you View-On-Demand…?


MJRBIM :canada: (BOB member since 2007-03-23)

On view on demand they are displaying result with no error.
Only when I schedule I am getting the error for specific reports.


matthew (BOB member since 2005-04-08)

Are you on a clustered multi-server environment?

Do your page servers, RAS servers and job servers reside on the same physical servers?


MJRBIM :canada: (BOB member since 2007-03-23)