Report when scheduled fails, but runs on demand

Hi,

I have a crystal report, which is scheduled to run every day and runs successfully.
I modified it recently, and manually replaced the existing copy in the Input FRS with the new one.
I then refreshed the report in CMC and added back the parameters etc.
But since then, it has been failing to run in the recurring schedule.But when i do a "Run Now", it runs perfectly fine..

Did anyone face this before or know about the cause? Please help.

The error i'm getting is :

Failed to open the connection. C:\Program Files\Business Objects\BusinessObjects Enterprise 11.5\Data\procSched\S026.reportjobserver\~tmpcf061db292948d.rpt
pvsbandiAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

tickettCommented:
What changes did you make to the report? Did you add any tables/fields?

How is the report connecting to the database (user/password or integrated authentication?)

I often find if i:
-fire up the report in crystal
-set datasource location
-highlight table in the top pane, and the corresponding table in the bottom pane and hit update (do this for every table)

Things magically start working again...
0
pvsbandiAuthor Commented:
Thanks! The change has been minor.. i had commented out a filter condition on the report..that's all
0
LinInDenverCommented:
I would suggest running the report manually and paging through to the end. It is possible by changing this filter you have introduced a calculated error.

The InfoView viewer will not tell you a report has an error until you hit the page that contains the actual error - giving you the false impression that it is running okay.

A scheduled report basically pages through an entire report to generate the saved format and will fail.

I also recommend replacing the report from inside Crystal Reports - Save To Enterprise (then browse to your existing report and save over it) - rather than going into the FRS and replacing files there.
0
Become a Certified Penetration Testing Engineer

This CPTE Certified Penetration Testing Engineer course covers everything you need to know about becoming a Certified Penetration Testing Engineer. Career Path: Professional roles include Ethical Hackers, Security Consultants, System Administrators, and Chief Security Officers.

pvsbandiAuthor Commented:
Thanks! I couldn't figure out any error on the report.
 My company didn't give access to the production server(remote) from my local machine.
 The only ways i connect ot it is as a web browser(CMC,Infoview etc) or as a remote desktop.
 That's way, i don't have a choice but to replace the file in the FRS system.
 
0
LinInDenverCommented:
okay - in my past experience placing/replacing files directly into the FRS can cause errors - you might want to check out on the SAP forums about that.

One test you can try - publish the report as a new one from CMC (Add file - put in your database credentials, etc.). If it still fails, you will know it is not a result of placing the file directly into the FRS.
0
mlmccCommented:
Can you just schedule the new report rather than trying to update the old report?

mlmcc
0
pvsbandiAuthor Commented:
Users need all those old instances...that's why, it's such a pain
0
LinInDenverCommented:
were you able to complete a test as I described by posting a new report?
0
oliffCommented:
Silly question, but does it ask you for the connection parameters when you initially run the report on demand? Or, after adding the report back in did you then re-set your connection settings including the password?
0
pvsbandiAuthor Commented:
Hi LinInDenver:

  Sorry for the delayed reply. I deployed it as a new report and scheduled it and it ran fine..
  So, i realized,it's something with the replacement in the FRS.So, i replaced the file again, in the FRS, but it still didn't work.
  This is what i do, when replacing the file in the input Filestore.
 > Replace the existing report in the Filestore, with the modified report.
 > Go to that report in CMC and click on refresh options and do a refresh report,with all checked in(except for the repository objects etc).
 > Re-enter the database credentials and the prompts and update.

do i need to do anything in addition to/ other than the above procedure? Please advise.
0
LinInDenverCommented:
Hi pvsbandi,

It sounds like you really need to have the ability to save over the existing from Inside Crystal Reports. I believe Business Objects has always frowned upon saving directly to the FRS, and this is probably one of the reasons why!

Have you actually tried to save it from inside Crystal Reports? I thought it went through web protocol of some kind anyhow, which means you might have permissions to "production."

From inside Crystal Reports go to File | Save As - click ENTERPRISE. It should prompt you for the same credentials that you use when logging into the CMC.

If you can get that far you should be able to browse to the folder and report, and save over it. Just make sure you then log into the CMC and re-type the password.
0
pvsbandiAuthor Commented:
Unfortunately we are not given access to the production server from our local machines.We need to deploy new reports through CMC as add new objects and for any modifications to the existing objects, we need to replace the files in the Filestore, as i mentioned in my original post.
0
LinInDenverCommented:
Is the FRS on your actual server (I think this is the default)? If so, how are you placing the files there?

Will they allow you to remote desktop into the server? If so, I would open the report in Crystal Reports on the actual server and publish as described above.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
pvsbandiAuthor Commented:
Thanks Much! That helps!
0
LinInDenverCommented:
Oh good! I would keep working on them to allow you access from your desktop machine! I would sure prefer that over having people RMD onto my server!
0
pvsbandiAuthor Commented:
I agree.The only glitch is that the production people are not ready to even negotiate on giving access..i wish they yield to our request..but thanks again for that simple yet insightful idea.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
DB Reporting Tools

From novice to tech pro — start learning today.