Solved

Report Scheduling Failing.?

Posted on 2001-07-17
12
470 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
 
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
Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

 

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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

I hate sub reports and always consider them the last resort in any reporting solution.  The negative effect on performance and maintainability is just not worth the easy ride they give the report writer.  Nine times out of ten reporting requirements…
Hot fix for .Net Crystal Reports 10.2.3600.0 to fix problems with sub reports running on 64 bit operating systems ISSUE: Reports which contain subreports fail with error "Missing Parameter Value" DEPLOYMENT SERVER OS: Windows 2008 with 64 bi…
This tutorial gives a high-level tour of the interface of Marketo (a marketing automation tool to help businesses track and engage prospective customers and drive them to purchase). You will see the main areas including Marketing Activities, Design …
As a trusted technology advisor to your customers you are likely getting the daily question of, ‘should I put this in the cloud?’ As customer demands for cloud services increases, companies will see a shift from traditional buying patterns to new…

911 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

Need Help in Real-Time?

Connect with top rated Experts

24 Experts available now in Live!

Get 1:1 Help Now