CVP Call Studio Database Element

Unanswered Question
Jul 15th, 2014
User Badges:

Hi all,

I got the below error when I tried to use the Database element in CVP Call Studio to connect to a MSSQL database.

touch111_24-7_Database,07/08/2014 13:52:31.724, The error was: A built-in element encountered an exception of type com.audium.server.AudiumException. There was a problem looking up the JNDI data source 'ivr1'. The root cause was: javax.naming.NameNotFoundException: Name ivr1 is not bound in this Context.

I have added the below to the context.xml file :

<Resource
name="jdbc/ivr1"
auth="Container"
type="javax.sql.DataSource"
driverClassName="com.microsoft.sqlserver.jdbc.SQLServerDriver"
url="jdbc:sqlserver://x.x.x.x:1433;databaseName=TestCallStudio;user=xxxx;password=xxxx"
/>

In the Database element settings in Call Studio, I put ivr1 in the JNDI Name field.

Can someone help me to know what could be causing this error to appear?

Thank you in advance.

Lara

  • 1
  • 2
  • 3
  • 4
  • 5
Overall Rating: 0 (0 ratings)
Loading.
Chintan Gajjar Tue, 07/15/2014 - 03:15
User Badges:
  • Blue, 1500 points or more

change jndi name in call studio from "ivr1" to "jdbc/ivr1"

and check if it is working or not.

 

regards

chintan

Ritesh Desai Wed, 02/10/2016 - 00:47
User Badges:

Hi team,


Manually this to be added under "Resource" tab...?




regards,

Ritesh Desai

Chintan Gajjar Wed, 02/10/2016 - 02:05
User Badges:
  • Blue, 1500 points or more

Hi Ritesh,

Please elaborate more.


regards

Chintan

Ritesh Desai Wed, 02/10/2016 - 03:18
User Badges:

Hi Chintan,

Am looking for this solution URL: https://supportforums.cisco.com/discussion/12885431/transfer-calls-call-...

I have client requirement, client will be sharing us store procedure which will return me Language of the customers calling from the ANI. Am doing Research on it. Also, I have to transfer to Language based Skill groups.


regards,

Ritesh Desai.

Chintan Gajjar Wed, 02/10/2016 - 03:36
User Badges:
  • Blue, 1500 points or more

Hi Ritesh,

you can setup db lookup in 2 ways.

1. in ICM, you can do db lookup in ICM script.

2. in CVP VXML application


if you opt to do that with cvp, you have to first configure JNDI.

there many documents available on internet on how to configure JNDI for VXML server.


once the JNDI is setup, you can use that in your DB element in VXML application for the lookup.



manojkumar.vunnava Tue, 12/20/2016 - 14:40
User Badges:

Hi Chintan,


I'm having similar problem. I did change the jdbc name as you suggested but still no difference. Any other suggestions?


This is the first time I'm configuring Database element, so I'm pretty new with configuring JNDI/JDBC. But I did go through the CVP document and configured the JNDI as suggested.


I would appreciate your inputs on this.

Chintan Gajjar Wed, 12/21/2016 - 02:56
User Badges:
  • Blue, 1500 points or more

Did you try restarting VXML server service after updating the context.xml?

And also please disregard my previous comment.


If the resource name in context file is defined as jdbc/ivr1 then the use "ivr1" as your JNDI name in database element.

manojkumar.vunnava Wed, 12/21/2016 - 08:58
User Badges:

Thanks for the quick reply Chintan. I got it working. The problem was with JDBC driver. I replace the existing one with sqljdbc4.jar.

Actions

This Discussion