Reset last "action":Lead overview filter creashes SuiteCRM each time

SuiteCRM Forum - English Language SuiteCRM General Discussion
1

In the list of all leads I filter by name where the prase seems to be to general. The result was that SuiteCRM crashed instead of showing the filtered leads.

Unfortunately SuiteCRM remembers what I filtered for so any time I try to list the leads it crashes.

Therefor I would like to “empty” the filter panel from somewhere without calling the leads page following the SuiteCRM to crash.

Is there somehow a way to reset the leads filter or anything else that might help?

(Suite CRM output: “The page you are looking for is temporarily unavailable. Please try again later.”;
Some version 7 of Suite CRM;
suitecrm.log: “[FATAL] Slow Query”
)

2

Hi,
did you have a look in the suitecrm.log-file? failed db queries are usually shown there.

3

suitecrm.log last entry:
Wed Apr 27 11:58:02 2022 [4760][1][FATAL] Slow Query (time:0.26157283782959
SELECT leads.id AS id FROM leads WHERE leads.campaign_id = ‘11f81061-d680-f80b-bd8e-60e6cdb85ac7’ AND DATE_FORMAT(leads.date_entered, ‘%Y-%m-%d %H:%i’) > DATE_FORMAT(DATE_ADD(UTC_TIMESTAMP(), INTERVAL + 1 minute), ‘%Y-%m-%d %H:%i’) AND NOT EXISTS (SELECT * FROM aow_processed WHERE aow_processed.aow_workflow_id=‘aa3bfb10-02ad-0321-c6a6-60fe6f34aaae’ AND aow_processed.parent_id=leads.id AND aow_processed.status = ‘Complete’ AND aow_processed.deleted = 0) AND leads.deleted = 0 )

4

That is just a slow query, are there any failed ones?

5

Try this to clear the existing filter:

6

No ‘fail’ exists in the log for the last few days. But many “…[FATAL] Slow Query…”.

In the browser Suite CRM responds
“The page you are looking for is temporarily unavailable. Please try again later.” followed by a looooong number/id.

My lay impression is that the database does not respond fast enough so the SuiteCRM ends this gathering of thounsands of leads. Or the server ends the database task to try to gather the information.

7

Dear @Adelheid , what happen if you increase the time the application wait for an answer from the DB on config.php ?
For instance you can set

'resource_management' => 
  array (
    'special_query_limit' => 5000000,
    'special_query_modules' => 
    array (
      0 => 'Reports',
      1 => 'Export',
      2 => 'Import',
      3 => 'Administration',
      4 => 'Sync',
      5 => 'AOR_Reports',
      6 => 'Leads'
    ),
    'default_limit' => 200000,
  ),

I also quote Matthew Lorimer:

8

Unfortunately both does (changing time limits and ‘populate:only’) not help. It seems that it doese not change anything.

However, the “list leads” process ends after exactly three minutes with the message

“The page you are looking for is temporarily unavailable. Please try again later.”

followed by three 32 byte hex values.

Calling the SuiteCRM home (/index.php?module=Home&action=index) also result in the error message stating three 32 bit hex values after ahaing, exactly three minutes.

It takes the system 11 1/2 Minutes to respone in a normal way. However trying the leads pages results in the situation decribed above.

It shows that the hex value triplets repeat themselves often:

933a457d2d56df44d94396aad128cf95 795929d4de1b94c1b1ad498a80b6e2dc 5704d6e3f6a1d66ba5ab07864d4b890b

0f37b4e280cdc71391b8452e02b376e5 7f6b717a6ce079787cb6d335e30536ca 1b6dfd4c529ec12ab3e025bfaf083c29

f406936900cb8b6a21ff6765836fc0d7 827979c740928f8153c4fd37d56051b7 fdf137d891a083315e86da9c05172775

0f37b4e280cdc71391b8452e02b376e5 7f6b717a6ce079787cb6d335e30536ca 1b6dfd4c529ec12ab3e025bfaf083c29

0f37b4e280cdc71391b8452e02b376e5 7f6b717a6ce079787cb6d335e30536ca 1b6dfd4c529ec12ab3e025bfaf083c29

0f37b4e280cdc71391b8452e02b376e5 7f6b717a6ce079787cb6d335e30536ca 1b6dfd4c529ec12ab3e025bfaf083c29

933a457d2d56df44d94396aad128cf95 795929d4de1b94c1b1ad498a80b6e2dc 5704d6e3f6a1d66ba5ab07864d4b890b

0f37b4e280cdc71391b8452e02b376e5 7f6b717a6ce079787cb6d335e30536ca 1b6dfd4c529ec12ab3e025bfaf083c29

My guess so far is that something cancels SuiteCRM tasks after three minutes but somehow the system keeps being busy fpr 11 1/2 minutes till it responds ok except the leads functionality.

What would help is getting SuiteCRM to forget the search query in the filter I entered so that it does not penetrate the database. How could I make SuiteCRM to forget/clear that filter/query without calling the leads page?

9

Have you seen my post above?

10

no, I have not ;-/!

pgr,

/index.php?action=index&module=Leads&searchFormTab=advanced_search&query=true&clear_query=true

did it!

Thanks a million,

Markus

2 Likes