System Does Not Start Anymore

[mehdi_h]

Hi,

 

I have experienced something that I never get before.

My VG system connected on externat mysql database does not start anymore. When I look at the logs I see :

 

"ERROR v7.1.3699.20074 (2010-02-16 11:09:08.70) DoWorkFindCall stage1 : The SELECT would examine more than MAX_JOIN_SIZE rows; check your WHERE and use SET SQL_BIG_SELECTS=1 or SET SQL_MAX_JOIN_SIZE=# if the SELECT is okay"

 

 

 

Please could have a loog and let me know what's the probleme?

 

Tkx

Mh

0312_1928_vgEngine.txt

[mehdi_h]

Hi,

 

any help please,

 

 

Thank you

[SupportTeam]

How many entries do you have loaded in the PortToUse ad OutDialQue tables?

 

Have you tried adding SET SQL_BIG_SELECTS=1; to the OutDialQue_SqlPrefix field, making OutDialQue_SqlPrefix:

 

OutDialQue_SqlPrefix=SET SQL_BIG_SELECTS=1; SELECT

[mehdi_h]

Hi,

 

In the database I have arround 15OOO entries in the Callque table. As I have 30 lignes , in the Porttouse table is then 15000* 30 entries.

 

 

I have set that in the config.xml file :

 

<OutDialQue_SqlPrefix>SET SQL_BIG_SELECTS=1; SELECT</OutDialQue_SqlPrefix>

 

is this correct ?

Thk

 

MH

[SupportTeam]

I have set that in the config.xml file :

 

<OutDialQue_SqlPrefix>SET SQL_BIG_SELECTS=1; SELECT</OutDialQue_SqlPrefix>

 

is this correct ?

Yes. Is the dialer query now working? Can you post traces?

[mehdi_h]

Actually I don't know really what happens. as I have two issues logged for now and I don't know what is the conseuqnece of wich cause. For exmaple, I have experience that only 6 or 7 lines of my system were calling. All aothers were "waiting for call"

 

My other issue topic is : "Strange Behaviour In Line Status Panel"

anyway here are the last logs.

thank You

Mh

[SupportTeam]

No logs were attached.

 

If you still have any issues pleae start a new thread/topic.