cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
1576
Views
0
Helpful
8
Replies

CVP Call Studio Database Element

ln33147
Level 4
Level 4

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

8 Replies 8

Chintan Gajjar
Level 8
Level 8

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

and check if it is working or not.

 

regards

chintan

Hi team,

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

regards,

Ritesh Desai

*** Please rate helpful post. Please mark as answer if it solves your problem/query.
regards, Ritesh Desai

Hi Ritesh,

Please elaborate more.

regards

Chintan

Hi Chintan,

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

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.

*** Please rate helpful post. Please mark as answer if it solves your problem/query.
regards, Ritesh Desai

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.

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.

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.

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

Getting Started

Find answers to your questions by entering keywords or phrases in the Search bar above. New here? Use these resources to familiarize yourself with the community: