Database Connection Fail

[invoso.com]

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.

[SupportTeam]

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'

 

?

[invoso.com]

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

[SupportTeam]

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