Error message Enterprise 9 2

[3dthies]

When I start a report with a larger amount of datas from the enterprise server I get the following error message:

The limit value for the maximum processing time or high number of data records is achieved.

The same report with a lower amount of datas functions very well.

Any ideas?

Thies

 

[Turkbear]

Hi,
By default, CE limits the # of records returned ( I forget the number, however) - you can change this behavior with a command line option of the pageserver service:

	Command Line: &quot;\\<YOURSERVER>\<YOURDRIVE>\Program Files\Crystal Decisions\WCS\pageserver.exe&quot; -service -name <servername>.pageserver -ns YOURAPSSERVER -restart - maxDBResultRecords 0

The -maxDBResultRecords 0 disables the limit entirely.

 

[ghansham21]

Hi, I am using Crystal Enterprise 9.0 with JAVA SDK, in the architecture diagram, i saw there is one web server which calls web connector and then web connector takes care of everything using WCS,So
Can Anybody tell me, how exactly Web Server (Weblogic) calls web connector.
Thanks in Advance.

 

[danrab]

Question to Turkbear :

Within the crystal management console/server information there's the RAS-server (crystal report application server). Within the properties of this server, there's a database tab which displays the max. number of records.
Does the statement you gave here alter this property ? What if this property is already set to unlimited ? Do you need to run this statement as well ?

Thanks for you reply !!

 

[Turkbear]

Hi,
I do not know..I don't use the RAS, but, I suspect that the Pageserver still will need to have the command-line altered to allow unlimited records as well.

 

[secondguess]

Yes RAS and Pageserver have separate settings.

You can increase or even switch off the maxDBResultRecords setting, but I have found that the view on demand fails sometimes with rowsets that are larger than the default setting (e.g. just 40000 rows). Has anyone else experienced this?