[solved] GET /p2pd/servlet/gc HTTP/1.1

[sys2674]

Hi I am creating a report.It takes a long time to come back with result.
If i use crosstab this happen with one row and one column.
If i use list with only one qury item.results are displayed.

when i see error msg from crnserver.log
wrong</messageString></message><message><messageString>DPR-ERR-2002 Unable to execute the request because there was no process available within the configured time limit. The server may be busy.</messageString></message><message><messageString>DPR-ERR-2082 An error has occurred. Please contact your administrator. The complete error has been logged by CAF with SecureErrorID:2005-11-20-15:40:07.419-#9</messageString></message></messages>   <trace>xts.run</trace>

in localhost_access_log.2005-11-20.txt
127.0.0.1 - - [20/Nov/2005:17:36:16 -0500] "GET /p2pd/servlet/gc HTTP/1.1" 200 133

any idea

thanks

[sir_jeroen]

have you check your SQL code? Is there a cross join...? Is it as expected that the query takes a long time to run..?

[sys2674]

Hi,

I had to start freshly from building new project.As my suporvisor imported the data Using condition as primary and foreign key.
When i asked him actually it is just Matching column names.

My problem got solved.I was able to generate atleast two reports randomly.After creating bussiness view.

Thanks