cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
848
Views
0
Helpful
0
Comments
cdnadmin
Community Member

Subject: RE: addTransPattern problem?!
Replied by: Stefan Schallmeiner on 30-03-2011 07:05:10 AM
Hi Cristina!
 
Unfortunately I have no solution for your problem. However i noticed that there is no setter-function for this in my generated java classes. For the Urgency-Flag there is one but for the Outside-Dial-Tone none. That probably implies that there is some bug/failure/mistake in the wsdl and/or axl-interface itself. I'd suggest to do it over SQL if you really have a large amount of Translation-Patterns.
 
kind regards
 - Stefan

Subject: Re: New Message from Cristina Petre in Administration XML (AXL) - Administr
Replied by: Sascha Monteiro on 30-03-2011 07:26:24 AM
Hi,

Are you using the DB-version header? If not, ver6 schema will be applied!..please test with db ver 7.1 in the header if not already
Following the above, the <addTransPattern> should have <newPattern> as next element...

I have seen issues with this element, but only in older versions..(4.x if I recall correctly)

Can you post the header and body please?

regards
Sascha

Subject: RE: addTransPattern problem?!
Replied by: Cristina Petre on 30-03-2011 07:57:04 AM
Hi all,

thanks for answering so quick. I´m usind the DB-version header 7.1. I´ve tried it also with <addTransPattern> and <newPattern> as next element like in document http://www.cisco.com/en/US/docs/voice_ip_comm/hucs/7.1a/provision/appd.html#wp1015176 suggested but i get an exception.

<?xml version="1.0" encoding="utf-8" ?>
<CCMParameter>

<addTransPattern>
<newPattern>
<pattern>00090.!</pattern>
<description>%Marktsystemname%-national</description>
<usage>Translation</usage>
<routePartitionName>%Marktsystemname%-national</routePartitionName>
<blockEnable>false</blockEnable>
<calledPartyTransformationMask></calledPartyTransformationMask>
<callingPartyTransformationMask></callingPartyTransformationMask>
<callingPartyPrefixDigits></callingPartyPrefixDigits>
<useCallingPartyPhoneMask>On</useCallingPartyPhoneMask>
<dialPlanWizardGenId></dialPlanWizardGenId>
<digitDiscardInstructionName>PreDot</digitDiscardInstructionName>
<messageWaiting>Lamp Off</messageWaiting>
<networkLocation>OnNet</networkLocation>
<provideOutsideDialtone>true</provideOutsideDialtone>
<patternUrgency>TRUE</patternUrgency>
<patternUrgencySpecified>true</patternUrgencySpecified>
<callingSearchSpaceName>%Marktsystemname%-national</callingSearchSpaceName>
<prefixDigitsOut>00</prefixDigitsOut>
</newPattern>
</addTransPattern>
</CCMParameter>

But there are an exception: ERROR: Command addTransPattern - Ein Aufrufziel hat einen Ausnahmefehler verursacht. (System.Web.Services.Protocols.SoapException: Cannot have an empty pattern when no Partition is specified

To do it over sql is an alternative, i never done it before over sql, maybe u have suggestions where i can read somethig about it?!

many thanks and regards,
cristina

Subject: Re: New Message from Cristina Petre in Administration XML (AXL) - Administr
Replied by: Sascha Monteiro on 30-03-2011 08:05:24 AM
first, remove the CCMParameter element...
This document was generated from CDN thread

Created by: Cristina Petre on 30-03-2011 06:39:43 AM
Hi all,
 
i have an issue to add translation pattern to CUCM 7.1.5 with AXL SOAP Interface. I use following xml file
 
<addTransPattern>
   <pattern>00090.!</pattern>  
   <description>%Marktsystemname%-national</description>
   <usage>Translation</usage>
   <routePartitionName>%Marktsystemname%-national</routePartitionName>
   <blockEnable>false</blockEnable>
   <calledPartyTransformationMask></calledPartyTransformationMask>
   <callingPartyTransformationMask></callingPartyTransformationMask>
   <callingPartyPrefixDigits></callingPartyPrefixDigits>
   <useCallingPartyPhoneMask>On</useCallingPartyPhoneMask>
   <dialPlanWizardGenId></dialPlanWizardGenId>
   <digitDiscardInstructionName>PreDot</digitDiscardInstructionName>
   <messageWaiting>Lamp Off</messageWaiting>
   <networkLocation>OnNet</networkLocation>
   <provideOutsideDialtone>true</provideOutsideDialtone>
   <patternUrgency>TRUE</patternUrgency>
   <patternUrgencySpecified>true</patternUrgencySpecified>
   <callingSearchSpaceName>%Marktsystemname%-national</callingSearchSpaceName>
   <prefixDigitsOut>00</prefixDigitsOut>
 </addTransPattern>
 
Translation pattern generated without any exception but the box <provideOutsideDialtone> is NOT checked. All other boxes like <patternUrgency> or <useCallingPartyPhoneMask> are cheked only box <provideOutsideDialtone>  is not checked.
I´ve tried it with <provideOutsideDialtone>true</provideOutsideDialtone>, <provideOutsideDialtone>false</provideOutsideDialtone> no changes. I´ve also tried it with <provideOutsideDialtone>Defaut</provideOutsideDialtone> and <provideOutsideDialtone></provideOutsideDialtone> then i get a excaption that object is boolean and i cannot use a string with it, that makes sense.
 
I also read documentations and developers forum but i found nothig. Has anybody an idea to solve this problem?? Many thanks in advance.
 
Also the same problem on addRoutePattern, box <provideOutsideDialtone> is not checked.
 
best regards,
cristina

Subject: RE: addTransPattern problem?!
Replied by: Stefan Schallmeiner on 30-03-2011 09:23:06 AM
Hi Cristina,

To execute a Sql-Query on Cucm you can either log on via cli and run "run sql <sql-query>" or automated per Axl with the (in your case) executeSQLUpdate command.

For information about Informix-SQL i always refer to this guide:

http://www.cs.uoi.gr/~pitoura/informix-doc/Informix_Guide_to_SQL-Syntax.pdf

And for the Database Scheme you can look up the Cucm-Database-Dictionary which can be found here:

http://www.cisco.com/en/US/docs/voice_ip_comm/cucm/datadict/7_1_2/datadictionary.pdf


The outsidedialtone seems to be in the numplan-table, but be carefull in the numplan-table are translationpatterns, dirns everything mixed together,...

Heres a small example:

admin:run sql select dnorpattern,alertingname, outsidedialtone from numplan where dnorpattern like '21784'
dnorpattern alertingname                outsidedialtone
=========== =========================== ===============
21784       Schallmeiner Stefan         f

Subject: RE: addTransPattern problem?!
Replied by: Cristina Petre on 30-03-2011 09:07:16 AM
Hi Cristina!
 
Unfortunately I have no solution for your problem. However i noticed that there is no setter-function for this in my generated java classes. For the Urgency-Flag there is one but for the Outside-Dial-Tone none. That probably implies that there is some bug/failure/mistake in the wsdl and/or axl-interface itself. I'd suggest to do it over SQL if you really have a large amount of Translation-Patterns.
 
kind regards
 - Stefan


Hi Stefan,
 
thanks for your quick response. To do it over sql is an alternative, i never done it before over sql, maybe u have suggestions where i can read somethig about it?!

many thanks and regards,
cristina

Subject: RE: addTransPattern problem?!
Replied by: Cristina Petre on 03-04-2011 01:43:12 PM
Hi Cristina,

To execute a Sql-Query on Cucm you can either log on via cli and run "run sql <sql-query>" or automated per Axl with the (in your case) executeSQLUpdate command.

For information about Informix-SQL i always refer to this guide:

http://www.cs.uoi.gr/~pitoura/informix-doc/Informix_Guide_to_SQL-Syntax.pdf

And for the Database Scheme you can look up the Cucm-Database-Dictionary which can be found here:

http://www.cisco.com/en/US/docs/voice_ip_comm/cucm/datadict/7_1_2/datadictionary.pdf


The outsidedialtone seems to be in the numplan-table, but be carefull in the numplan-table are translationpatterns, dirns everything mixed together,...

Heres a small example:

admin:run sql select dnorpattern,alertingname, outsidedialtone from numplan where dnorpattern like '21784'
dnorpattern alertingname outsidedialtone
=========== =========================== ===============
21784 Schallmeiner Stefan f


 
Hi Stefan,
 
thanks a lot for your help, it works without any problems over sql statements.
 
many thanks a lot & regards, cristina
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:

Quick Links