addDateTimeGroup CUCM v9.1(2) not working

Chad Stachowicz · ‎03-01-2015

Hello,

No matter what I sent to the api, (dateformat = M/D/Y, timeformat = 12-hour, separator = / (slash) for example)... it always comes back with DateTimeSetting has invalid formation... see logs below... is this a bug?

2015-03-01 08:58:49,968 INFO [http-bio-443-exec-82] servletRouters.AXLFilter - Received request 1423923142775 from admin at IP 192.168.1.165

2015-03-01 08:58:49,969 INFO [http-bio-443-exec-82] servletRouters.AXLFilter - AXL REQUEST :

<?xml version="1.0" encoding="UTF-8"?><env:Envelope xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:s0="http://www.cisco.com/AXL/API/9.1" xmlns:env="http://schemas.xmlsoap.org/soap/envelope/"><env:Body><s0:addDateTimeGroup><dateTimeGroup><name>DTG-PST</name><timeZone>America/Los_Angeles</timeZone><separator>/ (slash)</separator><dateTimeSettingName>M/D/Y</dateTimeSettingName><timeformat>12-hour</timeformat></dateTimeGroup></s0:addDateTimeGroup></env:Body></env:Envelope>

2015-03-01 08:58:49,981 INFO [http-bio-443-exec-82] servletRouters.AXLAlpha - SOAPAction : "CUCM:DB ver=9.1 addDateTimeGroup"

2015-03-01 08:58:50,001 INFO [http-bio-443-exec-82] servletRouters.AXLAlpha - Going to axis--->

2015-03-01 08:58:50,024 ERROR [http-bio-443-exec-82] axlapiservice.AXLAPIServiceSkeleton - SQL EXCEPTION has occurred, will be sending you the exact error Info

2015-03-01 08:58:50,025 INFO [http-bio-443-exec-82] servletRouters.AXLAlpha - Request processed by AXIS

2015-03-01 08:58:50,026 INFO [http-bio-443-exec-82] servletRouters.AXLFilter - <?xml version='1.0' encoding='utf-8'?><soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/"><soapenv:Body><soapenv:Fault><faultcode>soapenv:Client</faultcode><faultstring>DateTimeSetting has invalid format. Regular expression used to validate:^(M-D-Y|M/D/Y|M.D.Y|D-M-Y|D/M/Y|D.M.Y|Y-M-D|Y/M/D|Y.M.D)A?$ </faultstring><detail><axlError><axlcode>35154</axlcode><axlmessage>DateTimeSetting has invalid format. Regular expression used to validate:^(M-D-Y|M/D/Y|M.D.Y|D-M-Y|D/M/Y|D.M.Y|Y-M-D|Y/M/D|Y.M.D)A?$ </axlmessage><request>addDateTimeGroup</request></axlError></detail></soapenv:Fault></soapenv:Body></soapenv:Envelope>

2015-03-01 08:58:50,027 INFO [http-bio-443-exec-82] servletRouters.AXLFilter - Request 1423923142775 was process in 58ms

Chad

cstachowicz@cloverhound.com

Chad Stachowicz · ‎03-01-2015

Sorry that was old XML from just testing random things...here s the request with xml formatted as documentation asks.

2015-03-01 09:01:06,982 INFO [http-bio-443-exec-53] servletRouters.AXLFilter - Received request 1423923142776 from admin at IP 192.168.1.165

2015-03-01 09:01:06,983 INFO [http-bio-443-exec-53] servletRouters.AXLFilter - AXL REQUEST :

<?xml version="1.0" encoding="UTF-8"?><env:Envelope xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:s0="http://www.cisco.com/AXL/API/9.1" xmlns:env="http://schemas.xmlsoap.org/soap/envelope/"><env:Body><s0:addDateTimeGroup><dateTimeGroup><name>DTG-PST</name><timeZone>America/Los_Angeles</timeZone><separator>/ (slash)</separator><dateformat>M/D/Y</dateformat><timeformat>12-hour</timeformat></dateTimeGroup></s0:addDateTimeGroup></env:Body></env:Envelope>

2015-03-01 09:01:06,994 INFO [http-bio-443-exec-53] servletRouters.AXLAlpha - SOAPAction : "CUCM:DB ver=9.1 addDateTimeGroup"

2015-03-01 09:01:06,995 INFO [http-bio-443-exec-53] servletRouters.AXLAlpha - Going to axis--->

2015-03-01 09:01:07,018 ERROR [http-bio-443-exec-53] axlapiservice.AXLAPIServiceSkeleton - SQL EXCEPTION has occurred, will be sending you the exact error Info

2015-03-01 09:01:07,019 INFO [http-bio-443-exec-53] servletRouters.AXLAlpha - Request processed by AXIS

2015-03-01 09:01:07,020 INFO [http-bio-443-exec-53] servletRouters.AXLFilter - <?xml version='1.0' encoding='utf-8'?><soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/"><soapenv:Body><soapenv:Fault><faultcode>soapenv:Client</faultcode><faultstring>DateTimeSetting has invalid format. Regular expression used to validate:^(M-D-Y|M/D/Y|M.D.Y|D-M-Y|D/M/Y|D.M.Y|Y-M-D|Y/M/D|Y.M.D)A?$ </faultstring><detail><axlError><axlcode>35154</axlcode><axlmessage>DateTimeSetting has invalid format. Regular expression used to validate:^(M-D-Y|M/D/Y|M.D.Y|D-M-Y|D/M/Y|D.M.Y|Y-M-D|Y/M/D|Y.M.D)A?$ </axlmessage><request>addDateTimeGroup</request></axlError></detail></soapenv:Fault></soapenv:Body></soapenv:Envelope>

2015-03-01 09:01:07,020 INFO [http-bio-443-exec-53] servletRouters.AXLFilter - Request 1423923142776 was process in 38ms

npetrele · ‎03-02-2015

This is working for me. The only difference I see is that there's no "(slash)" in mine.

<env:Envelope xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:s0="http://www.cisco.com/AXL/API/9.1" xmlns:env="http://schemas.xmlsoap.org/soap/envelope/">

<env:Body>

<s0:addDateTimeGroup>

<timeZone>America/Los_Angeles</timeZone>

</dateTimeGroup>

</s0:addDateTimeGroup>

</env:Body>

</env:Envelope>

Jonathan Els · ‎04-12-2018

Interestingly, this is possible:

<separator>-</separator>

<dateformat>M/D/Y</dateformat>

It honours the separator attribute over the separator in the dateformat.