Solved

Report Scheduling Failing.?

Posted on 2001-07-17
12
474 Views
Last Modified: 2008-02-01
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
Comment
Question by:cyberonics
  • 5
  • 3
  • 2
  • +2
12 Comments
 
LVL 12

Expert Comment

by:DRRYAN3
ID: 6301067
cyberonics

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

Expert Comment

by:DRRYAN3
ID: 6325186
cyberonics

Are you coming back to this question?

DRRYAN3
0
 

Expert Comment

by:dick3425
ID: 6329114
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: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

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

 
LVL 12

Accepted Solution

by:
DRRYAN3 earned 50 total points
ID: 6329195
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
 

Author Comment

by:cyberonics
ID: 6336003
I'll look into this this evening.
0
 

Expert Comment

by:dick3425
ID: 6344378
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
 

Expert Comment

by:dick3425
ID: 6344397
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
 
LVL 12

Expert Comment

by:DRRYAN3
ID: 6370859
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
 

Expert Comment

by:lanfield
ID: 6390077
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
 

Expert Comment

by:ComTech
ID: 6390240
As before lanfield, rejected and returned to the Active Questions Listing.

ComTech
Community Support Moderator
0
 
LVL 12

Expert Comment

by:DRRYAN3
ID: 6523817
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
 

Expert Comment

by:ComTech
ID: 6524007
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.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

There have always been a lot of questions related to when Crystal Reports evaluates report components (such as formulas, summaries, cross-tabs, charts, to name a few examples). Crystal Reports uses a two-pass reporting process to provide greater …
Hello everyone, Hope you find this as helpful as we did. We have on the company I work for an application built in Delphi V with Crystal Reports 8. We all know that Crystal & Delphi can be temperamental sometimes and the worst thing is, nearly…
In a recent question (https://www.experts-exchange.com/questions/29004105/Run-AutoHotkey-script-directly-from-Notepad.html) here at Experts Exchange, a member asked how to run an AutoHotkey script (.AHK) directly from Notepad++ (aka NPP). This video…
I've attached the XLSM Excel spreadsheet I used in the video and also text files containing the macros used below. https://filedb.experts-exchange.com/incoming/2017/03_w12/1151775/Permutations.txt https://filedb.experts-exchange.com/incoming/201…

809 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question