Database connector error In CMC

hi,

  We got this error on 3 of the reports that are scheduled to run today.
   We have around 300 reports running today and these 3 failed with the "Database Connector Error message."
   but when i reran them, they ran fine and so, for sure, not a code issue ( We use DB2 stored procedures). What could be the other reason? Could this be because of the reports timing out?
  If that'[s the case, where can we increase the time-out option, to not happen again?
Please advise.
pvsbandiAsked:
Who is Participating?
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.

mlmccCommented:
It could be a time out issue.   Though I would think you would get that as the error.

Another issue may be a number of connections issue.  Crystal limits the number of connections you can have open simultaneously.  The default is 5.  You can purchase additional licenses or connections in groups of 5.  A report can require more than 1 connection so if you have 6 or more reports scheduled at the same time you could have some of them wait for a connection to free up and if they wait too long, they could generate that error.

I don't use the CMC so I don't know where the time out is.  You might look at how many reports are scheduled at a given time or how many users try to generate reports and just explain that an error like that just means they need to rerun.

mlmcc
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:
Thank You!
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
Crystal Reports

From novice to tech pro — start learning today.