Has anyone else experienced performance problems when querying the APS? We've written some csp code to look for instances of reports that meet certain criteria, so we don't have to drill into each report looking for things like failed instances. This often puts the CrystalAPS service into a death spiral consuming over 1.5G of memory. The only way to clean up is to kill and restart the service.
We have over 3800 instances. We're okay until we send a query that causes the aps to pull the ci_data column from ci_runtimeimage table. This is a blob column that holds things like parameters and values the report instance ran with.
Here's an example - From Launch pad, go to the Developer samples, then CSP Query Builder. Use this query:
Let me know how many instance you have and if this query works. To find out number of instances, go to your database admin tool like sqlplus and SELECT COUNT(*) FROM CI_RUNTIMEIMAGE;
Thanks for the help.
We have over 3800 instances. We're okay until we send a query that causes the aps to pull the ci_data column from ci_runtimeimage table. This is a blob column that holds things like parameters and values the report instance ran with.
Here's an example - From Launch pad, go to the Developer samples, then CSP Query Builder. Use this query:
Code:
SELECT SI_ID, SI_RECURRING, SI_UISTATUS, SI_NEXTRUNTIME, SI_OWNER, SI_OBTYPE, SI_ENDTIME, SI_PROCESSINFO.SI_PROMPTS, SI_NAME
from FROM CI_INFOOBJECTS WHERE SI_UISTATUS = 3Let me know how many instance you have and if this query works. To find out number of instances, go to your database admin tool like sqlplus and SELECT COUNT(*) FROM CI_RUNTIMEIMAGE;
Thanks for the help.