Debug of DB connection on call qualification

[joao.carlos]

Try #1. Attached.

VisualDBServer logs:

Build on 'i686-winnt-vs8-64'
+0048 Connection to multiserver created, host 'gce-rq', port '64407', socket '236'
+0049 MSG_STARTDB status='noDeleter'
Oracle: id='16.1' req='60' Protocols versions: dbclient='00010004' dbserver='00010004' dblib='00010004'
+0000 Database Access Point in TKVList:
+0000 Open DB: username = 'jcr', database = 'CM', dbserver = 'CM/rqrescm.rqr.com.br'
+18196 dbstatus: 8 ocierror(12154): ORA-12154: TNS:não foi possível resolver o identificador de conexão especificado

+18196 MSG_ERROR status='dbNotOpened' msg='ORA-12154: TNS:não foi possível resolver o identificador de conexão especificado
'

16:00:16.772 Dbg 10749 Forwarding response '60.1' from 'Oracle: 16.1' to 'App (UniversalRoutingServer,GCE-RQ,0)'
16:00:16.773 Dbg 10734 Send message 'MSG_DISCONNECTED' to 'Oracle: 16.1', request id '-1'
/Statistics
name = Oracle: 16.1
app_name = App (UniversalRoutingServer,GCE-RQ,0)
req_rcvd = 4
req_sent = 3
data_rcvd = 1103
data_sent = 133
msg_error = 1
msg_log = 1
Client Oracle: 16.1 is being closed. Current numofclients=0
16:00:16.773 Dbg 10734 Send message 'MSG_DBCLOSED' to 'App (UniversalRoutingServer,GCE-RQ,0)', request id '61'
16:00:16.773 Std 04523 Connection to client 'App (UniversalRoutingServer,GCE-RQ,0)' closed, reason ''client disconnected''
Listener (port id = internal-0-0 fd = 420) is being closed. Checking for clients on listener...
Listener with port id = internal-0-0 has been closed and deleted from list of current ports. Number of db app connections affected: 0
Client App (UniversalRoutingServer,GCE-RQ,0) is being closed. Current numofclients=4
16:00:16.831 Std 05023 Process './dbclient_oracle' stopped


I will try without the service name.

[cavagnaro]

Yes, I know...but again, in both cases were Oracle?
Are you 100% sure the tsnames.ora file was configured exactly the same?
Can you post also screenshot of the General tab of ORACLE_MCR to see which DBServer it is using?

[joao.carlos]

Try #2. Works VisualDBServer:

Build on 'i686-winnt-vs8-64'
+0038 Connection to multiserver created, host 'gce-rq', port '64501', socket '236'
+0038 MSG_STARTDB status='cantCreate'
Oracle: id='24.1' req='92' Protocols versions: dbclient='00010004' dbserver='00010004' dblib='00010004'
+0000 Database Access Point in TKVList:
+0000 Open DB: username = 'jcr', database = 'CM', dbserver = 'CM'
+0209 MSG_DBOPENED status='DBM_SUCCESS' msg='Open DB success'

16:02:47.253 Dbg 10743 'Oracle: 24.1' is spare
16:02:47.253 Dbg 10739 Oracle: id='24.1' req='0' Chmode to extended packet on sock 236


But on URS:

16:08:20.339 Int 22000 #### - 006f021b36a3ab66 - IxnRouting - Qualifying - VisualIvrGroup - AutoAttendant - DBLookUp - SqlStatment : Select RAMAL from CLIENTEMARCA where CPF='12345678900'; calltype : 2

16:08:20.339 Int 22000 #### - 006f021b36a3ab66 - IxnRouting - Qualifying - VisualIvrGroup - AutoAttendant - DBLookUp - SqlStatementStart : SELECT.
16:08:20.339_I_I_006f021b36a3ab66 [07:38] HERE IS XDATA
_I_E_006f021b36a3ab66 [09:04] error in strategy: 0014 Unknown server
_I_I_006f021b36a3ab66 [09:04] ASSIGN: DBResult(LOCAL) <- STRING: ""

16:08:20.339 Int 22000 #### - 006f021b36a3ab66 - IxnRouting - Qualifying - VisualIvrGroup - AutoAttendant - DBLookUp - DB result : () error : ( Unknown server )
_I_I_006f021b36a3ab66 [09:04] ASSIGN: DBErrorCode(LOCAL) <- STRING: "14"

16:08:20.339 Int 22000 #### - 006f021b36a3ab66 - IxnRouting - Qualifying - VisualIvrGroup - AutoAttendant - DBLookUp - update of the DB_ERROR_CODE data
_I_I_006f021b36a3ab66 [09:04] ASSIGN: outError(LOCAL) <- INTEGER: -3

16:08:20.339 Int 22000 #### - 006f021b36a3ab66 - IxnRouting - Qualifying - VisualIvrGroup - AutoAttendant - DBLookUp - DB result bad script or unkown request error : 14
request to 65200(--) message RequestUpdateUserData
AttributeReferenceID 55544
AttributeUserData [32] 00 02 00 00..
'RAMAL' ''
'DB_ERROR_CODE' '14'

[joao.carlos]

See attached ORACLE_CRM General Tab.

[cavagnaro]

I meant the screenshot from CME

[joao.carlos]

That's it.

[joao.carlos]

Yes, I know...but again, in both cases were Oracle?
Are you 100% sure the tsnames.ora file was configured exactly the same?
Can you post also screenshot of the General tab of ORACLE_MCR to see which DBServer it is using?

Question 1. I have it working on MSSQL Databases. But, in this client that it's not working, i tried to use the same TABLE they have in Oracle, in a MSSQL server and the error is exactly the same. This means, at least i think, that the problem is in GCE itself. It does not work neither with Oracle or MSSQL.

Question 2. I have no tsname.ora in more than one place. Only in the place that does not work. But it does not work either with MSSQL, that does not use it.

Question 3. I've posted.

Thanks!

[cavagnaro]

Damn...I don't know...would need to be connected to understand a little bit more...or do some tests

[cavagnaro]

Last thing to try is a restart of the URS...who knows,...that version you have installed is the first one of 8.1...so many bugs on it

[joao.carlos]

Unfortunately, no. I've rebooted the entire server several times (it's not a 24x7 callcenter).
I'm afraid to upgrade indeed. Last time i was upgrading from 1.0 to 1.1, I lost everything and had to reconfigure everything.