Vg Outbound Call Module Lost Database Connetion

[invoso.com]

After long time (few hours) without any activity VG lost database connection to make outbound call (callque table).

 

 

vgEngine log:

 

071610.285 10 dial ex Stage1_AnyPort.ExecuteReader complete

071611.298 10 ERROR v0.0.0.0 (2013-02-01 1:02:15.57) DoWorkFindCall Stage1_AnyPort.ExecuteReader : The Connection is broken.

System.IO.IOException: Nie można zapisać danych do połączenia transportowego: Istniejące połączenie zostało gwałtownie zamknięte przez zdalnego hosta. ---> System.Net.Sockets.SocketException: Istniejące połączenie zostało gwałtownie zamknięte przez zdalnego hosta

w System.Net.Sockets.Socket.Send(Byte[] buffer, Int32 offset, Int32 size, SocketFlags socketFlags)

w System.Net.Sockets.NetworkStream.Write(Byte[] buffer, Int32 offset, Int32 size)

--- Koniec śladu stosu wyjątków wewnętrznych ---

w System.Net.Sockets.NetworkStream.Write(Byte[] buffer, Int32 offset, Int32 size)

w System.IO.BufferedStream.FlushWrite()

w System.IO.BufferedStream.Flush()

w Npgsql.NpgsqlQuery.WriteToStream(Stream outputStream)

w Npgsql.NpgsqlReadyState.QueryEnum(NpgsqlConnector context, NpgsqlCommand command)

w Npgsql.NpgsqlConnector.QueryEnum(NpgsqlCommand queryCommand)

w Npgsql.NpgsqlCommand.GetReader(CommandBehavior cb)

w Npgsql.NpgsqlCommand.GetReader(CommandBehavior cb)

w Npgsql.NpgsqlCommand.ExecuteReader(CommandBehavior cb)

w Npgsql.NpgsqlCommand.ExecuteDbDataReader(CommandBehavior behavior)

w System.Data.Common.DbCommand.ExecuteReader(CommandBehavior behavior)

w ktlib.vgDb.vgDb_ProviderInvariant.DbProcessQueue_DoQueuedWork_FindCall(Object sender, ProcessingQueueEventArgs`1 args)

071611.298 10 dial ex Stage1_AnyPort.ExecuteReader complete

071612.313 10 ERROR v0.0.0.0 (2013-02-01 1:02:15.57) DoWorkFindCall Stage1_AnyPort.ExecuteReader : The Connection is broken.

 

How to fix this?

 

I added tasks with Outbound Call Loader without any problems.

 

After restart VG working properly and done all tasks.

[SupportTeam]

Could you please post a vgEngine log excerpt that captures system startup.

[invoso.com]

attached

vgEngine.zip

[SupportTeam]

Please update your system to this version of VoiceGuide:

 

[old link removed]

This version should automatically restart the connection to your Progress database if the "The Connection is broken" error is encountered while calling "ExecuteReader".

This is the latest version with all updates/fixes released to data and supports ProgreSQL as the 'outdial' database.

If you still encounter any issues pleases post traces as before.

[invoso.com]

log file showing something like:

 

090907.303 10 ERROR v0.0.0.0 (2013-02-01 1:02:15.57) DoWorkFindCall Stage1_AnyPort.ExecuteReader : The Connection is broken.

System.IO.IOException: Nie można zapisać danych do połączenia transportowego: Istniejące połączenie zostało gwałtownie zamknięte przez zdalnego hosta. ---> System.Net.Sockets.SocketException: Istniejące połączenie zostało gwałtownie zamknięte przez zdalnego hosta

w System.Net.Sockets.Socket.Send(Byte[] buffer, Int32 offset, Int32 size, SocketFlags socketFlags)

w System.Net.Sockets.NetworkStream.Write(Byte[] buffer, Int32 offset, Int32 size)

--- Koniec śladu stosu wyjątków wewnętrznych ---

w System.Net.Sockets.NetworkStream.Write(Byte[] buffer, Int32 offset, Int32 size)

w System.IO.BufferedStream.FlushWrite()

w System.IO.BufferedStream.Flush()

w Npgsql.NpgsqlQuery.WriteToStream(Stream outputStream)

w Npgsql.NpgsqlReadyState.QueryEnum(NpgsqlConnector context, NpgsqlCommand command)

w Npgsql.NpgsqlConnector.QueryEnum(NpgsqlCommand queryCommand)

w Npgsql.NpgsqlCommand.GetReader(CommandBehavior cb)

w Npgsql.NpgsqlCommand.GetReader(CommandBehavior cb)

w Npgsql.NpgsqlCommand.ExecuteReader(CommandBehavior cb)

w Npgsql.NpgsqlCommand.ExecuteDbDataReader(CommandBehavior behavior)

w System.Data.Common.DbCommand.ExecuteReader(CommandBehavior behavior)

w ktlib.vgDb.vgDb_ProviderInvariant.DbProcessQueue_DoQueuedWork_FindCall(Object sender, ProcessingQueueEventArgs`1 args)

[SupportTeam]

Trace shows that the system has not been updated to the provided version.

 

Please stop the VoiceGuide service and exit all VoiceGuide programs, before starting the install for the update.

 

If the applications have not been exited then then they cannot be updated.

 

To make sure that VoiceGuide service has stopped, delete the files vgEngine.dll and ktlibOutDialDb.dll from VoiceGuide directory, and then run the install of new version.

[invoso.com]

Error

 

101426.670 32 50 17 ERROR v0.0.0.0 (2013-03-30 21:24:51.06) ConnectAndRun_AdoNetFactory : Timeout while getting a connection from pool.

 

w Npgsql.NpgsqlConnectorPool.RequestPooledConnector(NpgsqlConnection Connection)

w Npgsql.NpgsqlConnectorPool.RequestConnector(NpgsqlConnection Connection)

w Npgsql.NpgsqlConnection.Open()

w ..()

101426.670 32 50 17 db completed. SqlQueryType=ERROR, RowsCount=0, sRv=

101426.670 32 50 17 db completed. iRunWait=1, WavPlayWasStarted=0, WavPlayHasNowFinished=0

101426.670 32 50 17 db completed. strError=Timeout while getting a connection from pool.

101426.670 32 50 17 path {Timeout while getting a connection from pool.} not found

101426.670 32 50 17 path {ERROR} not found

101426.670 32 50 17 path {error} not found

101426.670 32 50 17 FindNextVgmTitleInPathList: next module title is=[Hangup the Call]

101426.670 32 50 17 RunModule_AddToTaskQueue [Hangup the Call,[Hangup the Call],723]

101426.670 32 50 17 q scr add evScriptEvent 9800 CMD_RUN_SAME_MODULE_AGAIN

101426.670 6 50 17 q scr run evScriptEvent sCode=[CMD_RUN_SAME_MODULE_AGAIN] iActionID=0, crn=0[0|0|0|0|0][|||||] 00:00:00 max:5|00:00:00.0780045

101426.670 6 50 17 scriptevent CMD_RUN_SAME_MODULE_AGAIN 0|0|0 || LineState=LS_DBQUERY

101426.670 6 50 17 t timer clear (force=False)

101426.670 6 50 17 RunModule start Hangup the Call, [Hangup the Call], iModuleIdx=723, previous: vgm=723, vgs=14:14

101426.670 6 50 17 HangupCall, source=Hangup Module, WorkModeScript=Running_BeforeAnswerCall, yLineStateAppPov=[Accepted], lPlayId=0, lRecId=0

101426.670 6 50 17 moduleTitle=[Hangup the Call]

101426.670 6 50 17 ScriptWorkingMode set Stopping, (called from HangupCall)

101426.670 6 50 17 ls set Disconnect_Pending (scriptstate=LS_ENDINGCALL)

101426.670 6 50 17 state Hanging up... [Hangup Module]

[SupportTeam]

Can you please post a full vgEngine trace (.ZIPed) so that we can see what events have led up to this "Timeout while getting a connection from pool." response.

 

Looks like this connection was attempted from a 'Databae Query' type module, and not from a the Dialers connection to the CallQue table.