Hi,
We’re trying to setup an inbound strategy that read the ANI number of the incomming call, and compares it with a field (string type) in our DB (MS SQL Server).
The problem is that the inound strategy never found the value in the DB (even if the call number is in the DB).
How to debug the SQL request done by Genesys ? How to log the connection to the SQL Server?
Thanks
Arnaud
Hi Arnaud,
SQL Profile is the tool you’re looking for. That tool is part of SQL Server 2000 package but I’m not sure it is installed “by default”.
You can use Genesys DBServer logging as well. Change log to level to “debug”, add the key “verbose” with value “3” to “dbserver” section and restart the DB Server.
René
I believe your problem will be how the ANI is formatted, you will see that the ANI is like a 071250000 and in your DB you only have 7125000.
Try to capture the ANI and send it as attached data to an agent so you can see how it is masked or trace your PBX and see how the number comes in.
Check URS logs, TServer logs or DBServer logs as René mentioned
Regards
Cavagnaro, I already capture the ANI number thanks to the attach function and the number is the same as the number in my DB.
It seems my probem is from the connection to the DB but I can’t find where.
I’ll try to check with the logs.
Could anyone give me a working exemple of the configuration of the DB Server and Database Access Point.
Thanks.
Arnaud
A silly question,
Did you add the DAP to the URS connection Tab?
Is the DBServer running?
Here are some screenshots of DBServer and DAP configuration (for mssql)
Thanks for the screenshoots.
Did you add the DAP to the URS connection Tab? YES
Is the DBServer running? YES
cavagnaro - Off topic question, but what kind of windows theme is that? Pretty cool looking dialog boxes =)
eugene
;D yeah isn’t it? It’s Windows Blind 5
Very nice software hehe
Did you define your Fields , Format, and Table Access objects within CME?
Uh? That is if you want to access a DB that will execute a SQL Query, but if you run a SP there is no need to.