" /> Inbound strategy with DB connection - Genesys CTI User Forum
« previous next »
Pages: [1]   Go Down

Author Topic: Inbound strategy with DB connection  (Read 6789 times)

arnaudcoquelet

  • Guest
Inbound strategy with DB connection
« on: June 14, 2007, 07:38:11 PM »
Advertisement
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
Logged

Offline René

  • Administrator
  • Hero Member
  • *****
  • Posts: 1832
  • Karma: 62
Re: Inbound strategy with DB connection
« Reply #1 on: June 14, 2007, 07:46:06 PM »
  • Best Answer
    • 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é
    Logged

    Offline cavagnaro

    • Administrator
    • Hero Member
    • *****
    • Posts: 7641
    • Karma: 56330
    Re: Inbound strategy with DB connection
    « Reply #2 on: June 14, 2007, 08:48:29 PM »
  • Best Answer
    • 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
    Logged

    arnaudcoquelet

    • Guest
    Re: Inbound strategy with DB connection
    « Reply #3 on: June 14, 2007, 08:54:17 PM »
  • Best Answer
    • 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
    Logged

    Offline cavagnaro

    • Administrator
    • Hero Member
    • *****
    • Posts: 7641
    • Karma: 56330
    Re: Inbound strategy with DB connection
    « Reply #4 on: June 14, 2007, 09:50:23 PM »
  • Best Answer
    • 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)
    Logged

    arnaudcoquelet

    • Guest
    Re: Inbound strategy with DB connection
    « Reply #5 on: June 14, 2007, 10:01:15 PM »
  • Best Answer
    • Thanks for the screenshoots.

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


    Logged

    Eugene

    • Guest
    Re: Inbound strategy with DB connection
    « Reply #6 on: June 15, 2007, 12:30:48 AM »
  • Best Answer
    • cavagnaro -  Off topic question, but what kind of windows theme is that?  Pretty cool looking dialog boxes =)

    eugene
    Logged

    Offline cavagnaro

    • Administrator
    • Hero Member
    • *****
    • Posts: 7641
    • Karma: 56330
    Re: Inbound strategy with DB connection
    « Reply #7 on: June 15, 2007, 01:54:36 AM »
  • Best Answer
    • ;D yeah isn't it? It's Windows Blind 5
    Very nice software hehe
    Logged

    Offline Kevin S

    • Full Member
    • ***
    • Posts: 145
    • Karma: 4
    Re: Inbound strategy with DB connection
    « Reply #8 on: June 15, 2007, 01:27:53 PM »
  • Best Answer
    • Did you define your Fields , Format, and Table Access objects within CME?

    Logged

    Offline cavagnaro

    • Administrator
    • Hero Member
    • *****
    • Posts: 7641
    • Karma: 56330
    Re: Inbound strategy with DB connection
    « Reply #9 on: June 15, 2007, 04:08:30 PM »
  • Best Answer
    • 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.
    Logged
    Pages: [1]   Go Up
    « previous next »