Genesys CTI User Forum

Genesys CTI User Forum => Genesys CTI Technical Discussion => Topic started by: arnaudcoquelet on June 14, 2007, 07:38:11 PM

Title: Inbound strategy with DB connection
Post by: arnaudcoquelet on June 14, 2007, 07:38:11 PM

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

Title: Re: Inbound strategy with DB connection
Post by: René on June 14, 2007, 07:46:06 PM

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é

Title: Re: Inbound strategy with DB connection
Post by: cavagnaro on June 14, 2007, 08:48:29 PM

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

Title: Re: Inbound strategy with DB connection
Post by: arnaudcoquelet on June 14, 2007, 08:54:17 PM

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

Title: Re: Inbound strategy with DB connection
Post by: cavagnaro on June 14, 2007, 09:50:23 PM

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)

Title: Re: Inbound strategy with DB connection
Post by: arnaudcoquelet on June 14, 2007, 10:01:15 PM

Thanks for the screenshoots.

Did you add the DAP to the URS connection Tab? YES
Is the DBServer running?                                  YES

Title: Re: Inbound strategy with DB connection
Post by: Eugene on June 15, 2007, 12:30:48 AM

cavagnaro -  Off topic question, but what kind of windows theme is that?  Pretty cool looking dialog boxes =)

eugene

Title: Re: Inbound strategy with DB connection
Post by: cavagnaro on June 15, 2007, 01:54:36 AM

;D yeah isn't it? It's Windows Blind 5
Very nice software hehe

Title: Re: Inbound strategy with DB connection
Post by: Kevin S on June 15, 2007, 01:27:53 PM

Did you define your Fields , Format, and Table Access objects within CME?

Title: Re: Inbound strategy with DB connection
Post by: cavagnaro on June 15, 2007, 04:08:30 PM

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.