addTransPattern problem?!

Version 1

    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