VoiceGuide IVR Software Main Page
Jump to content

Database Connection Fail

Recommended Posts

We are preparing new test server and copy actual working scripts into but VG not connecting to postgresql database returning :

 

 

160623.446 7 2 1 RunModule start Database Query, [vg_polaczenia_update_error], iModuleIdx=293, previous: vgm=293, vgs=3:3
160623.446 7 2 1 state [vg_polaczenia_update_error] DB Query
160623.446 7 2 1 rv replace start [$RV[connection_string]]
160623.447 7 2 1 rv replace end [ODBC; Driver=PostgreSQL Unicode; Server=ID; Port=5432; Database=manager11;UID=user;PWD=pass;]
160623.447 7 2 1 rv replace start
------------------------------
SELECT id FROM polaczenia WHERE session_id='$RV[session_id]'

------------------------------
160623.447 7 2 1 rv replace end [sELECT id FROM polaczenia WHERE session_id='ID20141216160623161'
]
160623.447 7 2 1 db strDatabaseName=[] strDbConnectString=[ODBC; Driver=PostgreSQL Unicode; Server=192.168.1.101; Port=5432; Database=manager11;UID=postgres;PWD=sisti;] sAdoNetFactoriesAvailable=[|System.Data.Odbc|System.Data.OleDb|System.Data.OracleClient|System.Data.SqlClient|System.Data.SQLite|Npgsql|]
160623.447 7 2 1 db did not find ado.net data provider :
160623.447 7 2 1 db PlayOnHoldFile
160623.447 7 2 1 moh file not specified
160623.447 7 2 1 db using ado.net ODBC data provider : OdbcConnection/OdbcCommand/etc
160623.447 7 2 1 db suggested ODBC connect string format if System DSN defined: DSN=ddd;Uid=xxx;Pwd=yyy;
160623.447 7 2 1 db odbc RunQuery_Odbc [vg_polaczenia_update_error], db=[], connect=[ Driver=PostgreSQL Unicode; Server=ID; Port=5432; Database=manager11;UID=postgres;PWD=sisti;], sql=[sELECT id FROM polaczenia WHERE session_id='1234'
]
160623.447 7 2 1 db odbc thread init (threadpool)
160623.447 7 2 1 db odbc thread started (threadpool)
160623.447 5 2 1 db odbc connection create call. m_strOdbcConnectString= Driver=PostgreSQL Unicode; Server=192.168.1.101; Port=5432; Database=manager11;UID=user;PWD=pass;
160623.448 5 2 1 db odbc connection open call.
160623.448 7 2 1 t timer set 5 sec : EV_TIMEOUT_GOTOMODULE
160623.455 5 2 1 db odbc connection open returned.
160623.455 5 2 1 db odbc m_strSQL=[sELECT id FROM polaczenia WHERE session_id='1234'
]
160623.455 5 2 1 db odbc DataAdapter.Fill init.
160623.455 5 2 1 db odbc DataAdapter.Fill call.
160623.463 5 2 1 db odbc DataAdapter.Fill returned. tsFillTime=00:00:00.0080004
160623.464 5 2 1 rv add vg_polaczenia_update_error_RowCount|0
160623.464 5 2 1 db completed. SqlQueryType=READER, RowsCount=0, sRv=
160623.464 5 2 1 db completed. iRunWait=1, WavPlayWasStarted=0, WavPlayHasNowFinished=0
160623.464 5 2 1 db completed. iRowsAffected=0

 

 

We have postgresql odbc drivers instaled.

Share this post


Link to post

The trace shows that connection to PostgreSQL database was made, and that the SQL SELECT query was ran, but PostgreSQL replied that no rows matched the SQL query request.

 

Have you tried running this SQL query within PostgreSQL's pgAdmin to check if any data is returned when that query is ran from there?

 

Also, in posted trace excerpt did you manually modify:

 

session_id='ID20141216160623161'

 

to:

 

session_id='1234'

 

?

Share this post


Link to post

Sorry I solve problem. It was evaluation version after 1 hour. Maybe this version should to block all lines or indicated end of activity?

Share this post


Link to post

Evaluation version will not answer the calls once evaluation time expires. Once the call is answered the script will behave normally.

Share this post


Link to post

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×