[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 491
  • Last Modified:

Report Scheduling Failing.?

We use Info Desktop version: 7.0.2.200
When Scheduling a report Many reports pass with success.

However there are a few with Failed Status: When checking properties it says: PEStartPrintJob : Cannot open SQL server

We use Oracle 8.17 Database and use never schedule the report in the same time. There's always a difference in the time for reports.

When ReScheduling the same failed report in InfoDesktop, that is with exact same parameters, It succeeds with Success!. I don't understand why does it fail at certain times.

Any help is really appreciated.

Thanks All
0
cyberonics
Asked:
cyberonics
  • 5
  • 3
  • 2
  • +2
1 Solution
 
DRRYAN3Commented:
cyberonics

Your error message is the one generally returned when CRW is unable to login.  Do you have licensing issues at play here?
0
 
DRRYAN3Commented:
cyberonics

Are you coming back to this question?

DRRYAN3
0
 
dick3425Commented:
If the reports are scheduled and E-Mailed to recipients, check the names.  If one of the recipients has been removed from the exchange server because the person has left the company this will cause this error.
0
Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

 
DRRYAN3Commented:
dick3425

Please see my comment to you here:  http://www.experts-exchange.com/jsp/qShow.jsp?qid=20159408

This is a case where a comment requesting clarification along with your suggestion would have been more appropriate.  Although Info Desktop can be incorporated into an Exchange environment, the user doesn't state that in his question.

Best Regards
DRRYAN3
0
 
cyberonicsAuthor Commented:
I'll look into this this evening.
0
 
dick3425Commented:
If the reports are scheduled and E-Mailed to recipients, check the names.  If one of the recipients
has been removed from the exchange server because the person has left the company this will cause this
error.
0
 
dick3425Commented:
Try rebuilding your report from scratch then try rescheduling.  This some times works.  Also, try switching your driver to OLEDB for Sequel in place of ODBC.  If you need help you can call me at (860) 616-4018 until 8/3/01 when my contract here ends.  Please let me know if it works.

RLaFrance@idmr.com
0
 
DRRYAN3Commented:
cyberonics,

On July 30 you stated "I'll look into this this evening".  Has your problem been resolved or do you require additional assitance?  Either way, please let me know the status of this question.

DRRYAN3
0
 
lanfieldCommented:
different schedules of an imported report can store a different password. info many times is set insert the default lan id of the machine scheduling the job. that id is not always the id used to access the data. many times the id may even be the same put the password may not and errors occure there. the error your getting is a password error to the database. its no email id error. im guessing yoru using the copy of info that was given out for free a year or so back with the 50 user license of info. it's deffinately the id to the database your accessing. good luck
0
 
ComTechCommented:
As before lanfield, rejected and returned to the Active Questions Listing.

ComTech
Community Support Moderator
0
 
DRRYAN3Commented:
This question has been open for some time now.  Please return and either
1.  Accept an answer
2.  Post a comment stating that you need more information
3.  Ask Community Support to delete the question if you feel the information here has no value to you or anyone else.
4.  Ask Community Support to PAQ the question because your question was not answered but you feel the information here may be of some value to others.

Community Support is here:  http://www.experts-exchange.com/jsp/qList.jsp?ta=commspt and you can leave a message by posting a zero point question.  Be sure to reference the question ID, found in the Address bar of your browser.

Thanks
DRRYAN3
0
 
ComTechCommented:
This question has been answered. And I accepted it.  

My apolgies for not returning to Crystal Reports sooner, but it seems I am all over the TA's now.  I have been cleaning is 12 now and 18 finished.

ComTech
Community Support Moderator
0

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 5
  • 3
  • 2
  • +2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now