We help IT Professionals succeed at work.
Get Started

How to solve 'Max processing time or Max records limit reached---- Error code:-2147482991 Error'?

1,650 Views
Last Modified: 2013-11-15
Hello everyone,
I have a report to generate which would contain around 25000 records and i am facing the ''Max processing time or Max records limit reached' error when generating it. Please help me solve this.

FYI: I have already gone through the EE database and have tried all the following things which has not solved it.

1) Click Start, point to Programs, point to Crystal Enterprise 9, and then click Crystal Configuration Manager.
Stop the Page Server service.
Right-click Crystal Page Server, click Properties, and then examine the Command field.
If maxDBResultRecords 0 is not included in the command, add the following to the end of this command text:
-maxDBResultRecords 0
Restart Crystal Page Server.

2) Going to the registry of crystal reports and increasing the max records entry of page server or making it -1(unlimited).

Please help me with a solution.

Thank you.

Comment
Watch Question
Commented:
This problem has been solved!
Unlock 1 Answer and 1 Comment.
See Answer
Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

  • Troubleshooting
  • Research
  • Professional Opinions
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE