giving an error "No Handler found for ExecuteCCMSQLStatement"

Version 1
    This document was generated from CDN thread

    Created by: Chandar vr on 10-09-2009 12:57:17 PM
    Hi
    I am getting the following error
     
    No Handler found for ExecuteCCMSQLStatement
     
    the code is
     1
     2$client = new SoapClient('https://ipaddress:8443/realtimeservice/services/RisPort?wsdl',
     3                        array('trace'=>1,
     4                      'exceptions'=>1,
     5                      'location'=>"[url= ]https://ip:8443/axl[/url]",
     6                      'login'=>'user',
     7                      'password'=>'pwd',
     8                       ));
     9$response = $client->ExecuteCCMSQLStatement(array('ExecuteSQLInputData'=>"SELECT * FROM voicemessagingprofile"));
    10print_r ($response);

     
    Please help me on this..

    Subject: RE: giving an error "No Handler found for ExecuteCCMSQLStatement"
    Replied by: David Staudt on 10-09-2009 03:27:18 PM
    The Risport schema does include this ExecuteCCMSQLStatement, but I believe this a defect/oversight.  This function is not intended to work, is not ducumented or supported.  You will need to use the Admin AXL executeSQLQuery/Update requests for SQL interaction.

    Subject: RE: giving an error "No Handler found for ExecuteCCMSQLStatement"
    Replied by: Chandar vr on 11-09-2009 07:59:27 AM
    But even for other api's i get the same error
     
    The Php code is
     
     1
     2$client = new SoapClient('https://ipadd:8443/realtimeservice/services/RisPort?wsdl',
     3                        array('trace'=>1,
     4                      'exceptions'=>1,
     5                      'location'=>"[url= ]https://ipadd:8443/axl[/url]",
     6                      'login'=>'user',
     7                      'password'=>'pwd',
     8                       ));
     9print "<pre>";
    10print "Classes:  ";
    11$var = $client->__getFunctions();
    12print_r ($var);
    13$response = $client->SelectCmDevice(array('CmSelectionCriteria'=>'unknown'));
    14print_r ($response);

     
    The error i am getting in the page .....
     1
     2Classes:    Array
     3(
     4    [0] => list(SelectCmDeviceResult $SelectCmDeviceResult, string $StateInfo) SelectCmDevice(string $StateInfo, CmSelectionCriteria $CmSelectionCriteria)
     5    [1] => list(string $StateInfo, SelectCtiItemResult $SelectCtiItemResult) SelectCtiItem(string $StateInfo, CtiSelectionCriteria $CtiSelectionCriteria)
     6    [2] => ArrayOfColumnValues ExecuteCCMSQLStatement(string $ExecuteSQLInputData, ArrayOfGetColumns $GetColumns)
     7    [3] => ArrayOfServerInfo GetServerInfo(ArrayOfHosts $Hosts)
     8    [4] => list(SelectCmDeviceResultSIP $SelectCmDeviceResultSIP, string $StateInfo) SelectCmDeviceSIP(string $StateInfo, CmSelectionCriteriaSIP $CmSelectionCriteriaSIP)
     9)
    10
    11
    12[b]Fatal error[/b]:  Uncaught SoapFault exception: [SOAP-ENV:Client] No Handler found for SelectCmDevice in path/a.php
    13Stack trace:
    14#0 [internal function]: SoapClient->__call('SelectCmDevice', Array)
    15#1 path/a.php(25): SoapClient->SelectCmDevice(Array)
    162 {main}
    17  thrown in path/a.php on line [b]25[/b]

     
    Please help me on this ...

    Subject: RE: giving an error "No Handler found for ExecuteCCMSQLStatement"
    Replied by: Todd Carpenter on 11-09-2009 02:18:16 PM
    Hi David!  I'm getting the "No Handler found for parameters" error using your posted "getUser" example.  I am using PHP 5.3 and Apache 2.2 on Windows XP.  I also have the php, wsdl and xsd files in the same base wwwroot directory.  I am running CM 7.1.2.  Any thoughts?

    Subject: RE: giving an error "No Handler found for ExecuteCCMSQLStatement"
    Replied by: Todd Carpenter on 11-09-2009 03:30:54 PM
    Sorry... All set...  I just grabbed the AXIS wsdl/xsd files and it works.

    Subject: RE: giving an error "No Handler found for ExecuteCCMSQLStatement"
    Replied by: David Staudt on 11-09-2009 05:55:24 PM
    Thanks for the update, I made a note in the how-to to use the Axis versions.
     
    Are you still having issues with the Risport APIs?
     
    Note, Cisco formally tests/supports AXL at the SOAP level (XML messages.)  We do some sanity testing using the Axis and .NET WSDL compilers, but for others - such as PHP SOAPClient - you may need to modify the Cisco WSDLs (or the PHP code itself) to get things working in some scenarios.

    Subject: RE: giving an error "No Handler found for ExecuteCCMSQLStatement"
    Replied by: Chandar vr on 14-09-2009 07:34:03 AM
    Hi,
        I copied the wsdl and axd files specific to axis.I just tried to print all the functions supported by that wsdl,
    But i coudn't find the functions related to Risport .
     
    I am attaching the code below .
     
     1
     2 $client = new SoapClient("/path/AXLAPI.wsdl",
     3                array('trace'=>0,
     4                      'exceptions'=>0,
     5                      'location'=>"[url= ]https://ip:8443/axl[/url]",
     6                      'login'=>'uname',
     7                      'password'=>'pwd',
     8                       ));
     9$var = $client->__getFunctions();
    10print_r ($var);

     
    Here are the List of functions
     
      1
      2Classes:    Array
      3(
      4    [0] => StandardResponse addCommonPhoneConfig(AddCommonPhoneConfigReq $parameters)
      5    [1] => GetCommonPhoneConfigRes getCommonPhoneConfig(CommonPhoneConfigReq $parameters)
      6    [2] => StandardResponse updateCommonPhoneConfig(UpdateCommonPhoneConfigReq $parameters)
      7    [3] => StandardResponse removeCommonPhoneConfig(CommonPhoneConfigReq $parameters)
      8    [4] => StandardResponse addSIPRoutePattern(AddSIPRoutePatternReq $parameters)
      9    [5] => GetSIPRoutePatternRes getSIPRoutePattern(SIPRoutePatternReq $parameters)
     10    [6] => StandardResponse updateSIPRoutePattern(UpdateSIPRoutePatternReq $parameters)
     11    [7] => StandardResponse removeSIPRoutePattern(SIPRoutePatternReq $parameters)
     12    [8] => StandardResponse addDHCPServer(AddDHCPServerReq $parameters)
     13    [9] => GetDHCPServerRes getDHCPServer(DHCPServerReq $parameters)
     14    [10] => StandardResponse updateDHCPServer(UpdateDHCPServerReq $parameters)
     15    [11] => StandardResponse removeDHCPServer(DHCPServerReq $parameters)
     16    [12] => StandardResponse addAARGroup(addAARGroupReq $parameters)
     17    [13] => getAARGroupRes getAARGroup(NameAndGUIDRequest $parameters)
     18    [14] => StandardResponse updateAARGroup(updateAARGroupReq $parameters)
     19    [15] => StandardResponse updateAARGroupMatrix(updateAARGroupMatrixReq $parameters)
     20    [16] => StandardResponse removeAARGroup(NameAndGUIDRequest $parameters)
     21    [17] => StandardResponse addPhone(AddPhoneReq $parameters)
     22    [18] => StandardResponse removePhone(RemovePhoneReq $parameters)
     23    [19] => StandardResponse updatePhone(UpdatePhoneReq $parameters)
     24    [20] => GetPhoneRes getPhone(GetPhoneReq $parameters)
     25    [21] => StandardResponse addCallerFilterList(AddCallerFilterListReq $parameters)
     26    [22] => GetCallerFilterListRes getCallerFilterList(NameAndGUIDRequest $parameters)
     27    [23] => StandardResponse updateCallerFilterList(UpdateCallerFilterListReq $parameters)
     28    [24] => StandardResponse removeCallerFilterList(NameAndGUIDRequest $parameters)
     29    [25] => StandardResponse addCommonDeviceConfig(AddCommonDeviceConfigReq $parameters)
     30    [26] => GetCommonDeviceConfigRes getCommonDeviceConfig(NameAndGUIDRequest $parameters)
     31    [27] => StandardResponse removeCommonDeviceConfig(NameAndGUIDRequest $parameters)
     32    [28] => StandardResponse updateCommonDeviceConfig(UpdateCommonDeviceConfigReq $parameters)
     33    [29] => StandardResponse addDeviceMobility(AddDeviceMobilityReq $parameters)
     34    [30] => GetDeviceMobilityRes getDeviceMobility(NameAndGUIDRequest $parameters)
     35    [31] => StandardResponse removeDeviceMobility(NameAndGUIDRequest $parameters)
     36    [32] => StandardResponse updateDeviceMobility(UpdateDeviceMobilityReq $parameters)
     37    [33] => StandardResponse addDeviceMobilityGroup(AddDeviceMobilityGroupReq $parameters)
     38    [34] => GetDeviceMobilityGroupRes getDeviceMobilityGroup(NameAndGUIDRequest $parameters)
     39    [35] => StandardResponse removeDeviceMobilityGroup(NameAndGUIDRequest $parameters)
     40    [36] => StandardResponse updateDeviceMobilityGroup(UpdateDeviceMobilityGroupReq $parameters)
     41    [37] => StandardResponse addPhysicalLocation(AddPhysicalLocationReq $parameters)
     42    [38] => GetPhysicalLocationRes getPhysicalLocation(NameAndGUIDRequest $parameters)
     43    [39] => StandardResponse removePhysicalLocation(NameAndGUIDRequest $parameters)
     44    [40] => StandardResponse updatePhysicalLocation(UpdatePhysicalLocationReq $parameters)
     45    [41] => StandardResponse addApplicationToSoftkeyTemplate(AddApplicationToSoftkeyTemplateReq $parameters)
     46    [42] => StandardResponse removeApplicationToSoftkeyTemplate(removeApplicationToSoftkeyTemplateReq $parameters)
     47    [43] => StandardResponse addSoftKeyTemplate(AddSoftKeyTemplateReq $parameters)
     48    [44] => GetSoftKeyTemplateRes getSoftKeyTemplate(NameAndGUIDRequest $parameters)
     49    [45] => StandardResponse updateSoftKeyTemplate(UpdateSoftKeyTemplateReq $parameters)
     50    [46] => StandardResponse removeSoftKeyTemplate(NameAndGUIDRequest $parameters)
     51    [47] => StandardResponse updateSoftKeySet(UpdateSoftKeySetReq $parameters)
     52    [48] => GetSoftKeySetRes getSoftKeySet(NameAndGUIDRequest $parameters)
     53    [49] => StandardResponse addTranscoder(AddTranscoderReq $parameters)
     54    [50] => StandardResponse updateTranscoder(UpdateTranscoderReq $parameters)
     55    [51] => GetTranscoderRes getTranscoder(NameAndGUIDRequest $parameters)
     56    [52] => StandardResponse removeTranscoder(NameAndGUIDRequest $parameters)
     57    [53] => StandardResponse addMeetMe(AddMeetMeReq $parameters)
     58    [54] => StandardResponse updateMeetMe(UpdateMeetMeReq $parameters)
     59    [55] => GetMeetMeRes getMeetMe(GetMeetMeReq $parameters)
     60    [56] => StandardResponse removeMeetMe(RemoveMeetMeReq $parameters)
     61    [57] => StandardResponse addMOHServer(AddMOHServerReq $parameters)
     62    [58] => StandardResponse updateMOHServer(UpdateMOHServerReq $parameters)
     63    [59] => GetMOHServerRes getMOHServer(NameAndGUIDRequest $parameters)
     64    [60] => StandardResponse removeMOHServer(NameAndGUIDRequest $parameters)
     65    [61] => StandardResponse addConferenceBridge(AddConferenceBridgeReq $parameters)
     66    [62] => StandardResponse removeConferenceBridge(RemoveConferenceBridgeReq $parameters)
     67    [63] => StandardResponse updateConferenceBridge(UpdateConferenceBridgeReq $parameters)
     68    [64] => GetConferenceBridgeRes getConferenceBridge(GetConferenceBridgeReq $parameters)
     69    [65] => StandardResponse addAttendantConsoleUser(AddAttendantConsoleUserReq $parameters)
     70    [66] => StandardResponse removeAttendantConsoleUser(RemoveAttendantConsoleUserReq $parameters)
     71    [67] => StandardResponse updateAttendantConsoleUser(UpdateAttendantConsoleUserReq $parameters)
     72    [68] => GetAttendantConsoleUserRes getAttendantConsoleUser(GetAttendantConsoleUserReq $parameters)
     73    [69] => StandardResponse addAttendantConsoleHuntGroup(AddAttendantConsoleHuntGroupReq $parameters)
     74    [70] => StandardResponse updateAttendantConsoleHuntGroup(UpdateAttendantConsoleHuntGroupReq $parameters)
     75    [71] => StandardResponse removeAttendantConsoleHuntGroup(RemoveAttendantConsoleHuntGroupReq $parameters)
     76    [72] => GetAttendantConsoleHuntGroupRes getAttendantConsoleHuntGroup(GetAttendantConsoleHuntGroupReq $parameters)
     77    [73] => DeviceLoginResponse doDeviceLogin(DeviceLoginReq $parameters)
     78    [74] => DeviceLogoutRes doDeviceLogout(DeviceLogoutReq $parameters)
     79    [75] => DeviceResetRes doDeviceReset(DeviceResetReq $parameters)
     80    [76] => AuthenticateUserResponse doAuthenticateUser(AuthenticateUserReq $parameters)
     81    [77] => StandardResponse addLine(AddLineReq $parameters)
     82    [78] => StandardResponse removeLine(RemoveLineReq $parameters)
     83    [79] => StandardResponse updateLine(UpdateLineReq $parameters)
     84    [80] => GetLineRes getLine(GetLineReq $parameters)
     85    [81] => StandardResponse addUser(AddUserReq $parameters)
     86    [82] => StandardResponse removeUser(RemoveUserReq $parameters)
     87    [83] => StandardResponse updateUser(UpdateUserReq $parameters)
     88    [84] => GetUserRes getUser(GetUserReq $parameters)
     89    [85] => StandardResponse addAppUser(AddAppUserReq $parameters)
     90    [86] => StandardResponse updateAppUser(UpdateAppUserReq $parameters)
     91    [87] => GetAppUserRes getAppUser(GetUserReq $parameters)
     92    [88] => StandardResponse removeAppUser(RemoveUserReq $parameters)
     93    [89] => StandardResponse addDeviceProfile(AddDeviceProfileReq $parameters)
     94    [90] => StandardResponse removeDeviceProfile(RemoveDeviceProfileReq $parameters)
     95    [91] => StandardResponse updateDeviceProfile(UpdateDeviceProfileReq $parameters)
     96    [92] => GetDeviceProfileRes getDeviceProfile(GetDeviceProfileReq $parameters)
     97    [93] => StandardResponse addTimePeriod(AddTimePeriodReq $parameters)
     98    [94] => GetTimePeriodRes getTimePeriod(NameAndGUIDRequest $parameters)
     99    [95] => StandardResponse removeTimePeriod(NameAndGUIDRequest $parameters)
    100    [96] => StandardResponse updateTimePeriod(UpdateTimePeriodReq $parameters)
    101    [97] => StandardResponse addTimeSchedule(AddTimeScheduleReq $parameters)
    102    [98] => GetTimeScheduleRes getTimeSchedule(NameAndGUIDRequest $parameters)
    103    [99] => StandardResponse removeTimeSchedule(NameAndGUIDRequest $parameters)
    104    [100] => StandardResponse updateTimeSchedule(UpdateTimeScheduleReq $parameters)
    105    [101] => StandardResponse addTODAccess(AddTODAccessReq $parameters)
    106    [102] => GetTODAccessRes getTODAccess(NameAndGUIDRequest $parameters)
    107    [103] => StandardResponse updateTODAccess(UpdateTODAccessReq $parameters)
    108    [104] => StandardResponse removeTODAccess(NameAndGUIDRequest $parameters)
    109    [105] => StandardResponse addRoutePartition(AddRoutePartitionReq $parameters)
    110    [106] => StandardResponse updateRoutePartition(UpdateRoutePartitionReq $parameters)
    111    [107] => StandardResponse removeRoutePartition(RemoveRoutePartitionReq $parameters)
    112    [108] => GetRoutePartitionRes getRoutePartition(GetRoutePartitionReq $parameters)
    113    [109] => GetCSSRes getCSS(NameAndGUIDRequest $parameters)
    114    [110] => StandardResponse removeCSS(NameAndGUIDRequest $parameters)
    115    [111] => StandardResponse addCSS(AddCSSReq $parameters)
    116    [112] => StandardResponse updateCSS(UpdateCSSReq $parameters)
    117    [113] => GetTransPatternRes getTransPattern(GetTransPatternReq $parameters)
    118    [114] => StandardResponse removeTransPattern(RemoveTransPatternReq $parameters)
    119    [115] => StandardResponse addTransPattern(AddTransPatternReq $parameters)
    120    [116] => StandardResponse updateTransPattern(UpdateTransPatternReq $parameters)
    121    [117] => StandardResponse addTransformationPattern(AddTransformationPatternReq $parameters)
    122    [118] => GetTransformationPatternRes getTransformationPattern(GetTransformationPatternReq $parameters)
    123    [119] => StandardResponse updateTransformationPattern(UpdateTransformationPatternReq $parameters)
    124    [120] => StandardResponse removeTransformationPattern(RemoveTransformationPatternReq $parameters)
    125    [121] => StandardResponse addCalledPartyTransformationPattern(AddCalledPartyTransformationPatternReq $parameters)
    126    [122] => GetCalledPartyTransformationPatternRes getCalledPartyTransformationPattern(GetCalledPartyTransformationPatternReq $parameters)
    127    [123] => StandardResponse updateCalledPartyTransformationPattern(UpdateCalledPartyTransformationPatternReq $parameters)
    128    [124] => StandardResponse removeCalledPartyTransformationPattern(RemoveCalledPartyTransformationPatternReq $parameters)
    129    [125] => GetRoutePatternRes getRoutePattern(GetRoutePatternReq $parameters)
    130    [126] => StandardResponse removeRoutePattern(RemoveRoutePatternReq $parameters)
    131    [127] => StandardResponse addRoutePattern(AddRoutePatternReq $parameters)
    132    [128] => StandardResponse updateRoutePattern(UpdateRoutePatternReq $parameters)
    133    [129] => GetHuntPilotRes getHuntPilot(GetHuntPilotReq $parameters)
    134    [130] => StandardResponse removeHuntPilot(RemoveHuntPilotReq $parameters)
    135    [131] => StandardResponse addHuntPilot(AddHuntPilotReq $parameters)
    136    [132] => StandardResponse updateHuntPilot(UpdateHuntPilotReq $parameters)
    137    [133] => StandardResponse addLineGroup(AddLineGroupReq $parameters)
    138    [134] => StandardResponse updateLineGroup(UpdateLineGroupReq $parameters)
    139    [135] => GetLineGroupRes getLineGroup(NameAndGUIDRequest $parameters)
    140    [136] => StandardResponse removeLineGroup(NameAndGUIDRequest $parameters)
    141    [137] => StandardResponse addRouteGroup(AddRouteGroupReq $parameters)
    142    [138] => StandardResponse updateRouteGroup(UpdateRouteGroupReq $parameters)
    143    [139] => GetRouteGroupRes getRouteGroup(NameAndGUIDRequest $parameters)
    144    [140] => StandardResponse removeRouteGroup(NameAndGUIDRequest $parameters)
    145    [141] => StandardResponse addRouteList(AddRouteListReq $parameters)
    146    [142] => StandardResponse updateRouteList(UpdateRouteListReq $parameters)
    147    [143] => GetRouteListRes getRouteList(NameAndGUIDRequest $parameters)
    148    [144] => StandardResponse removeRouteList(NameAndGUIDRequest $parameters)
    149    [145] => StandardResponse addHuntList(AddHuntListReq $parameters)
    150    [146] => StandardResponse updateHuntList(UpdateHuntListReq $parameters)
    151    [147] => GetHuntListRes getHuntList(NameAndGUIDRequest $parameters)
    152    [148] => StandardResponse removeHuntList(NameAndGUIDRequest $parameters)
    153    [149] => StandardResponse addCTIRoutePoint(AddCTIRoutePointReq $parameters)
    154    [150] => StandardResponse updateCTIRoutePoint(UpdateCTIRoutePointReq $parameters)
    155    [151] => GetCTIRoutePointRes getCTIRoutePoint(NameAndGUIDRequest $parameters)
    156    [152] => StandardResponse removeCTIRoutePoint(NameAndGUIDRequest $parameters)
    157    [153] => StandardResponse addDHCPSubnet(AddDHCPSubnetReq $parameters)
    158    [154] => GetDHCPSubnetRes getDHCPSubnet(DHCPSubnetReq $parameters)
    159    [155] => StandardResponse updateDHCPSubnet(UpdateDHCPSubnetReq $parameters)
    160    [156] => StandardResponse removeDHCPSubnet(DHCPSubnetReq $parameters)
    161    [157] => GetDialPlanRes getDialPlan(NameAndGUIDRequest $parameters)
    162    [158] => GetDialPlanTagRes getDialPlanTag(getDialPlanTagReq $parameters)
    163    [159] => StandardResponse addCallPark(AddCallParkReq $parameters)
    164    [160] => StandardResponse updateCallPark(UpdateCallParkReq $parameters)
    165    [161] => GetCallParkRes getCallPark(GetCallParkReq $parameters)
    166    [162] => StandardResponse removeCallPark(RemoveCallParkReq $parameters)
    167    [163] => StandardResponse addDirectedCallPark(AddDirectedCallParkReq $parameters)
    168    [164] => StandardResponse updateDirectedCallPark(UpdateDirectedCallParkReq $parameters)
    169    [165] => GetDirectedCallParkRes getDirectedCallPark(GetDirectedCallParkReq $parameters)
    170    [166] => StandardResponse removeDirectedCallPark(RemoveDirectedCallParkReq $parameters)
    171    [167] => StandardResponse addCallPickupGroup(AddCallPickupGroupReq $parameters)
    172    [168] => StandardResponse updateCallPickupGroup(UpdateCallPickupGroupReq $parameters)
    173    [169] => GetCallPickupGroupRes getCallPickupGroup(GetCallPickupGroupReq $parameters)
    174    [170] => StandardResponse removeCallPickupGroup(RemoveCallPickupGroupReq $parameters)
    175    [171] => GetDDIRes getDDI(getDDIReq $parameters)
    176    [172] => ListPhoneByNameRes listPhoneByName(ListPhoneByNameReq $parameters)
    177    [173] => ListPhoneByDescriptionRes listPhoneByDescription(ListPhoneByDescriptionReq $parameters)
    178    [174] => ListUserByNameRes listUserByName(ListUserByNameReq $parameters)
    179    [175] => ListRoutePlanByTypeRes listRoutePlanByType(ListRoutePlanByTypeReq $parameters)
    180    [176] => GetNumDevicesRes getNumDevices(GetNumDevicesReq $parameters)
    181    [177] => ListServiceParametersRes listServiceParameters(ListServiceParametersReq $parameters)
    182    [178] => ListCSSByNameRes listCSSByName(ListCSSByNameReq $parameters)
    183    [179] => StandardResponse addDevicePool(AddDevicePoolReq $parameters)
    184    [180] => StandardResponse updateDevicePool(UpdateDevicePoolReq $parameters)
    185    [181] => GetDevicePoolRes getDevicePool(NameAndGUIDRequest $parameters)
    186    [182] => StandardResponse removeDevicePool(NameAndGUIDRequest $parameters)
    187    [183] => StandardResponse addCallManagerGroup(AddCallManagerGroupReq $parameters)
    188    [184] => StandardResponse updateCallManagerGroup(UpdateCallManagerGroupReq $parameters)
    189    [185] => GetCallManagerGroupRes getCallManagerGroup(NameAndGUIDRequest $parameters)
    190    [186] => StandardResponse removeCallManagerGroup(NameAndGUIDRequest $parameters)
    191    [187] => StandardResponse addVG224(AddVG224Req $parameters)
    192    [188] => GetVG224Res getVG224(GetVG224Req $parameters)
    193    [189] => StandardResponse removeVG224(RemoveVG224Req $parameters)
    194    [190] => StandardResponse updateVG224(UpdateVG224Req $parameters)
    195    [191] => StandardResponse addVoiceMailPilot(AddVoiceMailPilotReq $parameters)
    196    [192] => StandardResponse updateVoiceMailPilot(UpdateVoiceMailPilotReq $parameters)
    197    [193] => GetVoiceMailPilotRes getVoiceMailPilot(GetVoiceMailPilotReq $parameters)
    198    [194] => StandardResponse removeVoiceMailPilot(RemoveVoiceMailPilotReq $parameters)
    199    [195] => StandardResponse addVoiceMailProfile(AddVoiceMailProfileReq $parameters)
    200    [196] => StandardResponse updateVoiceMailProfile(UpdateVoiceMailProfileReq $parameters)
    201    [197] => GetVoiceMailProfileRes getVoiceMailProfile(NameAndGUIDRequest $parameters)
    202    [198] => StandardResponse removeVoiceMailProfile(NameAndGUIDRequest $parameters)
    203    [199] => StandardResponse addVoiceMailPort(AddVoiceMailPortReq $parameters)
    204    [200] => StandardResponse updateVoiceMailPort(UpdateVoiceMailPortReq $parameters)
    205    [201] => GetVoiceMailPortRes getVoiceMailPort(NameAndGUIDRequest $parameters)
    206    [202] => StandardResponse removeVoiceMailPort(NameAndGUIDRequest $parameters)
    207    [203] => StandardResponse addGatewayEndpoint(AddGatewayEndpointReq $parameters)
    208    [204] => StandardResponse updateGatewayEndpoint(UpdateGatewayEndpointReq $parameters)
    209    [205] => GetGatewayEndpointRes getGatewayEndpoint(NameAndGUIDRequest $parameters)
    210    [206] => StandardResponse removeGatewayEndpoint(NameAndGUIDRequest $parameters)
    211    [207] => StandardResponse addRouteFilter(AddRouteFilterReq $parameters)
    212    [208] => StandardResponse updateRouteFilter(UpdateRouteFilterReq $parameters)
    213    [209] => GetRouteFilterRes getRouteFilter(NameAndGUIDRequest $parameters)
    214    [210] => StandardResponse removeRouteFilter(NameAndGUIDRequest $parameters)
    215    [211] => GetServiceParameterRes getServiceParameter(GetServiceParameterReq $parameters)
    216    [212] => StandardResponse updateServiceParameter(UpdateServiceParameterReq $parameters)
    217    [213] => StandardResponse addLocation(AddLocationReq $parameters)
    218    [214] => StandardResponse updateLocation(UpdateLocationReq $parameters)
    219    [215] => GetLocationRes getLocation(NameAndGUIDRequest $parameters)
    220    [216] => StandardResponse removeLocation(NameAndGUIDRequest $parameters)
    221    [217] => StandardResponse addCMCInfo(AddCMCInfoReq $parameters)
    222    [218] => StandardResponse updateCMCInfo(UpdateCMCInfoReq $parameters)
    223    [219] => GetCMCInfoRes getCMCInfo(CMCInfoReq $parameters)
    224    [220] => StandardResponse removeCMCInfo(CMCInfoReq $parameters)
    225    [221] => StandardResponse addFACInfo(AddFACInfoReq $parameters)
    226    [222] => StandardResponse updateFACInfo(UpdateFACInfoReq $parameters)
    227    [223] => GetFACInfoRes getFACInfo(NameAndGUIDRequest $parameters)
    228    [224] => StandardResponse removeFACInfo(NameAndGUIDRequest $parameters)
    229    [225] => StandardResponse addRegion(AddRegionReq $parameters)
    230    [226] => StandardResponse updateRegion(UpdateRegionReq $parameters)
    231    [227] => StandardResponse removeRegion(NameAndGUIDRequest $parameters)
    232    [228] => GetRegionRes getRegion(NameAndGUIDRequest $parameters)
    233    [229] => StandardResponse updateRegionMatrix(UpdateRegionMatrixReq $parameters)
    234    [230] => StandardResponse addMGCP(AddMGCPReq $parameters)
    235    [231] => StandardResponse addMGCPUnit(AddMGCPUnitReq $parameters)
    236    [232] => StandardResponse addMGCPSubunit(AddMGCPSubunitReq $parameters)
    237    [233] => StandardResponse addMGCPEndpoint(AddMGCPEndpointReq $parameters)
    238    [234] => GetMGCPRes getMGCP(GetMGCPReq $parameters)
    239    [235] => StandardResponse removeMGCP(RemoveMGCPReq $parameters)
    240    [236] => StandardResponse removeMGCPUnit(RemoveMGCPUnitReq $parameters)
    241    [237] => StandardResponse removeMGCPSubunit(RemoveMGCPSubunitReq $parameters)
    242    [238] => StandardResponse removeMGCPEndpoint(RemoveMGCPEndpointReq $parameters)
    243    [239] => StandardResponse updateMGCP(UpdateMGCPReq $parameters)
    244    [240] => StandardResponse addCallManager(AddCallManagerReq $parameters)
    245    [241] => StandardResponse updateCallManager(UpdateCallManagerReq $parameters)
    246    [242] => GetCallManagerRes getCallManager(NameAndGUIDRequest $parameters)
    247    [243] => StandardResponse removeCallManager(NameAndGUIDRequest $parameters)
    248    [244] => GetMobileSmartClientProfileRes getMobileSmartClientProfile(NameAndGUIDRequest $parameters)
    249    [245] => StandardResponse addProcessNode(AddProcessNodeReq $parameters)
    250    [246] => StandardResponse updateProcessNode(UpdateProcessNodeReq $parameters)
    251    [247] => GetProcessNodeRes getProcessNode(NameAndGUIDRequest $parameters)
    252    [248] => StandardResponse removeProcessNode(NameAndGUIDRequest $parameters)
    253    [249] => ListAllProcessNodesRes listAllProcessNodes(ListAllProcessNodesReq $parameters)
    254    [250] => ListProcessNodesByServiceRes listProcessNodesByService(ListProcessNodesByServiceReq $parameters)
    255    [251] => GetProcessNodeServiceRes getProcessNodeService(GetProcessNodeServiceReq $parameters)
    256    [252] => StandardResponse updateProcessNodeService(UpdateProcessNodeServiceReq $parameters)
    257    [253] => ListRoutePartitionRes listRoutePartitionByName(ListBySearchString $parameters)
    258    [254] => ListDevicePoolRes listDevicePoolByName(ListBySearchString $parameters)
    259    [255] => ListPhoneTemplateRes listPhoneTemplateByName(ListBySearchString $parameters)
    260    [256] => ListDeviceRes listDeviceByNameAndClass(ListDeviceByNameAndClassReq $parameters)
    261    [257] => ListDeviceByServiceNameRes listDeviceByServiceName(ListDeviceByNameAndClassReq $parameters)
    262    [258] => ListMOHAudioSourceRes listMOHAudioSourceByName(ListBySearchString $parameters)
    263    [259] => StandardResponse updateMOHAudioSource(UpdateMOHAudioSourceReq $parameters)
    264    [260] => GetMOHAudioSourceRes getMOHAudioSource(GetMOHAudioSourceByIDAndSourceReq $parameters)
    265    [261] => StandardResponse removeMOHAudioSource(GetMOHAudioSourceByIDAndSourceReq $parameters)
    266    [262] => ListMediaResourceListRes listMediaResourceListByName(ListBySearchString $parameters)
    267    [263] => StandardResponse addMediaResourceList(AddMediaResourceListReq $parameters)
    268    [264] => GetMediaResourceListRes getMediaResourceList(NameAndGUIDRequest $parameters)
    269    [265] => StandardResponse removeMediaResourceList(NameAndGUIDRequest $parameters)
    270    [266] => StandardResponse updateMediaResourceList(UpdateMediaResourceListReq $parameters)
    271    [267] => ListMediaResourceGroupRes listMediaResourceGroupByName(ListBySearchString $parameters)
    272    [268] => StandardResponse addMediaResourceGroup(AddMediaResourceGroupReq $parameters)
    273    [269] => GetMediaResourceGroupRes getMediaResourceGroup(NameAndGUIDRequest $parameters)
    274    [270] => StandardResponse removeMediaResourceGroup(NameAndGUIDRequest $parameters)
    275    [271] => StandardResponse updateMediaResourceGroup(UpdateMediaResourceGroupReq $parameters)
    276    [272] => StandardResponse addUserGroup(AddUserGroupReq $parameters)
    277    [273] => GetUserGroupRes getUserGroup(NameAndGUIDRequest $parameters)
    278    [274] => StandardResponse removeUserGroup(NameAndGUIDRequest $parameters)
    279    [275] => StandardResponse updateUserGroup(UpdateUserGroupReq $parameters)
    280    [276] => ListLocationRes listLocationByName(ListBySearchString $parameters)
    281    [277] => ListAARGroupRes listAARGroupByName(ListBySearchString $parameters)
    282    [278] => ListVoiceMailProfileRes listVoiceMailProfileByName(ListBySearchString $parameters)
    283    [279] => ListGatekeeperRes listGatekeeperByName(ListBySearchString $parameters)
    284    [280] => StandardResponse addGatekeeper(AddGatekeeperReq $parameters)
    285    [281] => GetGatekeeperRes getGatekeeper(NameAndGUIDRequest $parameters)
    286    [282] => StandardResponse removeGatekeeper(NameAndGUIDRequest $parameters)
    287    [283] => StandardResponse updateGatekeeper(UpdateGatekeeperReq $parameters)
    288    [284] => StandardResponse addH323Phone(AddH323PhoneReq $parameters)
    289    [285] => StandardResponse addH323Gateway(AddH323GatewayReq $parameters)
    290    [286] => StandardResponse addH323Trunk(AddH323TrunkReq $parameters)
    291    [287] => GetH323PhoneRes getH323Phone(NameAndGUIDRequest $parameters)
    292    [288] => GetH323GatewayRes getH323Gateway(NameAndGUIDRequest $parameters)
    293    [289] => GetH323TrunkRes getH323Trunk(NameAndGUIDRequest $parameters)
    294    [290] => StandardResponse removeH323Phone(NameAndGUIDRequest $parameters)
    295    [291] => StandardResponse removeH323Gateway(NameAndGUIDRequest $parameters)
    296    [292] => StandardResponse removeH323Trunk(NameAndGUIDRequest $parameters)
    297    [293] => StandardResponse updateH323Phone(UpdateH323PhoneReq $parameters)
    298    [294] => StandardResponse updateH323Gateway(UpdateH323GatewayReq $parameters)
    299    [295] => StandardResponse updateH323Trunk(UpdateH323TrunkReq $parameters)
    300    [296] => StandardResponse addSIPTrunk(AddSIPTrunkReq $parameters)
    301    [297] => GetSIPTrunkBase getSIPTrunk(NameAndGUIDRequest $parameters)
    302    [298] => StandardResponse removeSIPTrunk(NameAndGUIDRequest $parameters)
    303    [299] => StandardResponse updateSIPTrunk(UpdateSIPTrunkReq $parameters)
    304    [300] => StandardResponse addSIPRealm(AddSIPRealmReq $parameters)
    305    [301] => StandardResponse removeSIPRealm(RemoveSIPRealmReq $parameters)
    306    [302] => StandardResponse updateSIPRealm(UpdateSIPRealmReq $parameters)
    307    [303] => GetSIPRealmRes getSIPRealm(GetSIPRealmReq $parameters)
    308    [304] => StandardResponse addSIPProfile(AddSIPProfileReq $parameters)
    309    [305] => StandardResponse updateSIPProfile(UpdateSIPProfileReq $parameters)
    310    [306] => GetSIPProfileRes getSIPProfile(NameAndGUIDRequest $parameters)
    311    [307] => StandardResponse removeSIPProfile(NameAndGUIDRequest $parameters)
    312    [308] => StandardResponse addRecordingProfile(AddRecordingProfileReq $parameters)
    313    [309] => StandardResponse removeRecordingProfile(RemoveRecordingProfileReq $parameters)
    314    [310] => StandardResponse updateRecordingProfile(UpdateRecordingProfileReq $parameters)
    315    [311] => GetRecordingProfileRes getRecordingProfile(GetRecordingProfileReq $parameters)
    316    [312] => StandardResponse addPilotPoint(AddPilotPointReq $parameters)
    317    [313] => StandardResponse updatePilotPoint(UpdatePilotPointReq $parameters)
    318    [314] => GetPilotPointRes getPilotPoint(NameAndGUIDRequest $parameters)
    319    [315] => StandardResponse removePilotPoint(NameAndGUIDRequest $parameters)
    320    [316] => StandardResponse updateLicenseCapabilities(UpdateLicenseCapabilitiesReq $parameters)
    321    [317] => GetLicenseCapabilitiesRes getLicenseCapabilities(GetLicenseCapabilitiesReq $parameters)
    322    [318] => StandardResponse addMobileVoiceAccess(AddMobileVoiceAccessReq $parameters)
    323    [319] => StandardResponse updateMobileVoiceAccess(UpdateMobileVoiceAccessReq $parameters)
    324    [320] => GetMobileVoiceAccessRes getMobileVoiceAccess(GetMobileVoiceAccessReq $parameters)
    325    [321] => StandardResponse removeMobileVoiceAccess(RemoveMobileVoiceAccessReq $parameters)
    326    [322] => StandardResponse addIVRUserLocale(AddIVRUserLocaleReq $parameters)
    327    [323] => StandardResponse updateIVRUserLocale(UpdateIVRUserLocaleReq $parameters)
    328    [324] => GetIVRUserLocaleRes getIVRUserLocale(GetIVRUserLocaleReq $parameters)
    329    [325] => StandardResponse removeIVRUserLocale(RemoveIVRUserLocaleReq $parameters)
    330    [326] => StandardResponse addMobility(AddMobilityReq $parameters)
    331    [327] => StandardResponse updateMobility(UpdateMobilityReq $parameters)
    332    [328] => GetMobilityRes getMobility(GetMobilityReq $parameters)
    333    [329] => GetCCMVersionRes getCCMVersion(GetCCMVersionReq $parameters)
    334    [330] => GetOSVersionRes getOSVersion(GetOSVersionReq $parameters)
    335    [331] => StandardResponse removeMobility(RemoveMobilityReq $parameters)
    336    [332] => StandardResponse addPhoneTemplate(AddPhoneTemplateReq $parameters)
    337    [333] => StandardResponse updatePhoneTemplate(UpdatePhoneTemplateReq $parameters)
    338    [334] => GetPhoneTemplateRes getPhoneTemplate(NameAndGUIDRequest $parameters)
    339    [335] => StandardResponse removePhoneTemplate(NameAndGUIDRequest $parameters)
    340    [336] => StandardResponse addCredentialPolicy(AddCredentialPolicyReq $parameters)
    341    [337] => StandardResponse updateCredentialPolicy(UpdateCredentialPolicyReq $parameters)
    342    [338] => GetCredentialPolicyRes getCredentialPolicy(NameAndGUIDRequest $parameters)
    343    [339] => StandardResponse removeCredentialPolicy(RemoveCredentialPolicyReq $parameters)
    344    [340] => StandardResponse addSIPTrunkSecurityProfile(AddSIPTrunkSecurityProfileReq $parameters)
    345    [341] => StandardResponse updateSIPTrunkSecurityProfile(UpdateSIPTrunkSecurityProfileReq $parameters)
    346    [342] => GetSIPTrunkSecurityProfileRes getSIPTrunkSecurityProfile(NameAndGUIDRequest $parameters)
    347    [343] => StandardResponse removeSIPTrunkSecurityProfile(NameAndGUIDRequest $parameters)
    348    [344] => StandardResponse addRemoteDestination(AddRemoteDestinationReq $parameters)
    349    [345] => StandardResponse removeRemoteDestination(RemoveRemoteDestinationReq $parameters)
    350    [346] => StandardResponse updateRemoteDestination(UpdateRemoteDestinationReq $parameters)
    351    [347] => GetRemoteDestinationRes getRemoteDestination(GetRemoteDestinationReq $parameters)
    352    [348] => StandardResponse addRemoteDestinationProfile(AddRemoteDestinationProfileReq $parameters)
    353    [349] => StandardResponse removeRemoteDestinationProfile(NameAndGUIDRequest $parameters)
    354    [350] => StandardResponse updateRemoteDestinationProfile(UpdateRemoteDestinationProfileReq $parameters)
    355    [351] => GetRemoteDestinationProfileRes getRemoteDestinationProfile(NameAndGUIDRequest $parameters)
    356    [352] => StandardResponse addResourcePriorityNamespace(AddResourcePriorityNamespaceReq $parameters)
    357    [353] => GetResourcePriorityNamespaceRes getResourcePriorityNamespace(ResourcePriorityNamespaceReq $parameters)
    358    [354] => StandardResponse updateResourcePriorityNamespace(UpdateResourcePriorityNamespaceReq $parameters)
    359    [355] => StandardResponse removeResourcePriorityNamespace(ResourcePriorityNamespaceReq $parameters)
    360    [356] => GetResourcePriorityDefaultNamespaceRes getResourcePriorityDefaultNamespace(GetResourcePriorityDefaultNamespaceReq $parameters)
    361    [357] => StandardResponse updateResourcePriorityDefaultNamespace(UpdateResourcePriorityDefaultNamespaceReq $parameters)
    362    [358] => StandardResponse addResourcePriorityNamespaceList(AddResourcePriorityNamespaceListReq $parameters)
    363    [359] => GetResourcePriorityNamespaceListRes getResourcePriorityNamespaceList(NameAndGUIDRequest $parameters)
    364    [360] => StandardResponse updateResourcePriorityNamespaceList(UpdateResourcePriorityNamespaceListReq $parameters)
    365    [361] => StandardResponse removeResourcePriorityNamespaceList(NameAndGUIDRequest $parameters)
    366    [362] => ExecuteSQLQueryRes executeSQLQuery(ExecuteSQLQueryReq $parameters)
    367    [363] => ExecuteSQLUpdateRes executeSQLUpdate(ExecuteSQLUpdateReq $parameters)
    368    [364] => StandardResponse addGeoLocation(AddGeoLocationReq $parameters)
    369    [365] => GetGeoLocationRes getGeoLocation(GeoLocationReq $parameters)
    370    [366] => StandardResponse updateGeoLocation(UpdateGeoLocationReq $parameters)
    371    [367] => StandardResponse removeGeoLocation(GeoLocationReq $parameters)
    372    [368] => StandardResponse addGeoLocationPolicy(AddGeoLocationPolicyReq $parameters)
    373    [369] => GetGeoLocationPolicyRes getGeoLocationPolicy(GeoLocationPolicyReq $parameters)
    374    [370] => StandardResponse updateGeoLocationPolicy(UpdateGeoLocationPolicyReq $parameters)
    375    [371] => StandardResponse removeGeoLocationPolicy(GeoLocationPolicyReq $parameters)
    376    [372] => StandardResponse addGeoLocationFilter(AddGeoLocationFilterReq $parameters)
    377    [373] => GetGeoLocationFilterRes getGeoLocationFilter(GeoLocationFilterReq $parameters)
    378    [374] => StandardResponse updateGeoLocationFilter(UpdateGeoLocationFilterReq $parameters)
    379    [375] => StandardResponse removeGeoLocationFilter(GeoLocationFilterReq $parameters)
    380)

     
    Please help me on this ....

    Subject: RE: giving an error "No Handler found for ExecuteCCMSQLStatement"
    Replied by: David Staudt on 14-09-2009 01:20:44 PM
    The Risport functions are provided by a separate web service/WSDL: https://servername:8443/realtimeservice/services/RisPort?wsdl

    Subject: RE: giving an error "No Handler found for ExecuteCCMSQLStatement"
    Replied by: Chandar vr on 14-09-2009 01:53:50 PM
    But some of api's provided by risport are throwing error stating no handler found.
     
    How can i get rid of this. Will there be any syntax error ?
     
    thanks/Chandar

    Subject: RE: giving an error "No Handler found for ExecuteCCMSQLStatement"
    Replied by: Stephan Steiner on 16-09-2009 02:37:14 PM
    I seem to recall something like that error... I'm not a 100% sure anymore whether it was a syntax error, or a missing soap header though.. but it's one of the two for sure.
    By the way I quickly gave up on using autogenerated stubs for serviceability... it never quite worked out (I was interested in the RISPort information) so I wrote my own code which after handling the syntax issues is now working just fine.

    Subject: RE: giving an error "No Handler found for ExecuteCCMSQLStatement"
    Replied by: Chandar vr on 17-09-2009 07:57:25 AM
    If you dont could you share the code you have customised for getting the risport info.
     
    I am trying to do it through PHP..
     
     
    Thanks/chandar

    Subject: RE: giving an error "No Handler found for ExecuteCCMSQLStatement"
    Replied by: Stephan Steiner on 18-09-2009 12:42:50 PM
    My code is java though.. that doesn't translate easily.
     
    2 minutes of search in netpro yielded this working sample written by myself last year: http://forums.cisco.com/eforum/servlet/NetProf?page=netprof&forum=Unified%20Communications%20and%20Video&topic=IP%20Phone%20Services%20for%20Developers&topicID=.ee94c94&CommCmd=MB%3Fcmd%3Dpass_through%26location%3Doutline%40^1%40%40.2cbff352/2#selected_message
     

    Subject: RE: giving an error "No Handler found for ExecuteCCMSQLStatement"
    Replied by: David Staudt on 24-09-2009 05:06:13 AM
    Attached is a sample I got working using PHP and RisPort.wsdl on UCM v7.0(1)  Note I manually copied the RisPort.wsdl to /var/www on the web server so it wouldn't have to download it from the UCM at run time.  There is a comment that hints at how to submit multiple device names at once.
     
    When I get a chance I'll write up a how-to in the wiki area for this.