VikrantYou have mentioned REMOTE SQL 2008 DB. That might be the cause. Setting
a remote DB is not recommended for ARS setup.
There are more than 10-12 known issues and defects on reporting for SP1 and SP2
Using report cause CPU spike, Does not account maxGetList, large report
generation cause out of memory error, Null pointer exception, downloading
report is very slow etc etc list is very big..... You might want to check the
Release doc specifically around reports.
Thanks
Ravi Rai
> Date: Thu, 1 Nov 2012 02:38:17 -0400
> From: vkulka...@columnit.com
> Subject: ARS 7604 Custom App and Reporting Issues
> To: arslist@ARSLIST.ORG
>
> hi Everyone,
>
> We are facing some issues in crystal report for one of our client. The
> crystal report is a call details report with about 30 fields in it which
> included about 10 formula fields.
>
> The issue we are facing is that it takes a lot of time to extract a single
> report and at a time we can only extract report for a time span of 30 days if
> we increase the time span it just gets stuck and we get nothing the user tool
> just gets stuck.
>
> The application is a complete custom application and we are not using
> anything OOTB apart from foundation part(people form, user form etc).
> The AR architecture is such that we have only 1 application server (ARS
> 7.6.0.4 SP2) which is our reporting server as well. Then we have a remote SQL
> 2008 DB and a stand alone MT ARS 7.6.0.4.
>
> The configurations of the above servers is as below
>
> ARS/Reporting Server = 32GB RAM 100Gb HDD 2.6Ghz dual core 2 processors.
> SQL or DB server = 16GB RAM 500GB HDD 2.6Ghz dual core 2 processors.
> MT Server = 16GB RAM 100GB HDD 2.6Ghz dual core 2 processors.
>
> Now there are few things that we plan to configure to improve performance on
> the system and would like some opinion on the same from you guys so as to
> what more can be done on the same.
>
> Things we plan to do :
>
> 1) Threads and queues to be configured : Gradually increase the number of
> threads from the default value (not sure about the number)
> 2) Indexes : To set 6-7 fields as indexes on the form on which the reports
> runs.
> 3) Disable unwanted escalation : Don't know if this will help but will try to
> disable most of the unwanted OOTB escalations which we do not use.
> 4) MT JVM memory check : Its already set to max = 1024 MB not sure how much
> can we increase it more.
> 5) Check for DB side configuration : This is something new we are trying to
> find out things that we can configure on DB side to get better performance.
>
> Also we think this all infrastructure being on cloud would make a difference
> as well am I right?
>
> Thanks in advance for the replies.
>
> Regards,
> Vikrant
>
> _______________________________________________________________________________
> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
> attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"
