Vg Hangs During Query To Sql

[mikeraut]

Voic Guide 6.0.3377

The system was working fine and suddenly hangs while doing a query to the SQL database.

I run the same query using query analyzer and the result is returned immediately.

1205vgm.zip

[SupportTeam]

Not sure why all of a sudden this SQL query would not be returning.

 

Have you tried testing the connection to the database using simpler query? This may be a good approach to debug whether the problem is the query itself or the database connection.

 

Here is the query we can see from the traces that is being ran:

 

select cast(dir.budget as char (8)), dir.budget-CAST(ROUND(SUM(smdr.Cost),2) as char (8)) from smdr LEFT join dir on (dir.Site = smdr.site AND dir.Ext1 = smdr.extn) LEFT join auth on (auth.extn = dir.ext1) where smdr.CallTime >= DATEADD(mm, DATEDIFF(mm,0,getdate()), 0) and auth.code= '3149' group by dir.budget

 

We'd recommend using v7 of VoiceGuide for your project. v7 has better tracing of the database transactions and better handles situations where the database query takes a long time or does not return.

 

[mikeraut]

Not sure why all of a sudden this SQL query would not be returning.

 

Have you tried testing the connection to the database using simpler query? This may be a good approach to debug whether the problem is the query itself or the database connection.

 

Here is the query we can see from the traces that is being ran:

 

select cast(dir.budget as char (8)), dir.budget-CAST(ROUND(SUM(smdr.Cost),2) as char (8)) from smdr LEFT join dir on (dir.Site = smdr.site AND dir.Ext1 = smdr.extn) LEFT join auth on (auth.extn = dir.ext1) where smdr.CallTime >= DATEADD(mm, DATEDIFF(mm,0,getdate()), 0) and auth.code= '3149' group by dir.budget

 

We'd recommend using v7 of VoiceGuide for your project. v7 has better tracing of the database transactions and better handles situations where the database query takes a long time or does not return.

 

[mikeraut]

Not sure why all of a sudden this SQL query would not be returning.

 

Have you tried testing the connection to the database using simpler query? This may be a good approach to debug whether the problem is the query itself or the database connection.

 

Here is the query we can see from the traces that is being ran:

 

select cast(dir.budget as char (8)), dir.budget-CAST(ROUND(SUM(smdr.Cost),2) as char (8)) from smdr LEFT join dir on (dir.Site = smdr.site AND dir.Ext1 = smdr.extn) LEFT join auth on (auth.extn = dir.ext1) where smdr.CallTime >= DATEADD(mm, DATEDIFF(mm,0,getdate()), 0) and auth.code= '3149' group by dir.budget

 

We'd recommend using v7 of VoiceGuide for your project. v7 has better tracing of the database transactions and better handles situations where the database query takes a long time or does not return.

Log.zip

[mikeraut]

Not sure why all of a sudden this SQL query would not be returning.

 

Have you tried testing the connection to the database using simpler query? This may be a good approach to debug whether the problem is the query itself or the database connection.

 

Here is the query we can see from the traces that is being ran:

 

select cast(dir.budget as char (8)), dir.budget-CAST(ROUND(SUM(smdr.Cost),2) as char (8)) from smdr LEFT join dir on (dir.Site = smdr.site AND dir.Ext1 = smdr.extn) LEFT join auth on (auth.extn = dir.ext1) where smdr.CallTime >= DATEADD(mm, DATEDIFF(mm,0,getdate()), 0) and auth.code= '3149' group by dir.budget

 

We'd recommend using v7 of VoiceGuide for your project. v7 has better tracing of the database transactions and better handles situations where the database query takes a long time or does not return.

 

I have taken your advice and made a simple SQL query. The same result... The application hangs at the query and eventually the app terminates. I will include the results in the attachment. Upgrading to v7 is not an option as it involves spending more money.

Any other suggestion to resolve the problem would be appreciated.

Log.zip

[SupportTeam]

If the database connection was working before and it has stopped working all of a sudden, and you do not know what changes were made on the system around the time when the connectivity stopped working then probably the best approach would be to re-create the ODCBC connection and reinstall the database's drivers, and maybe reinstall VoiceGuide as well.

[mikeraut]

If the database connection was working before and it has stopped working all of a sudden, and you do not know what changes were made on the system around the time when the connectivity stopped working then probably the best approach would be to re-create the ODCBC connection and reinstall the database's drivers, and maybe reinstall VoiceGuide as well.

Thank you, I have reinstalled Voiceguide, redone the ODBC connection and rebooted the server. It's now working again.

1206vgm.zip