SOAP Web Services with fractional date value fails with "Invalid date value '1495620131.336'. Out of valid range (0 to 2147483647)"

Document ID:  TEC1006127
Last Modified Date:  06/09/2017
{{active ? 'Hide' : 'Show'}} Technical Document Details

Products

  • CA Service Desk Manager

Releases

  • CA Service Desk Manager:Release:14.1

Components

  • UNICENTER SERVICE DESK RXX:USRD
  • Svc Desk Web Services:SDWEBS
Symptoms:

 

A SOAP web services call that includes a date value that is not a whole integer fails with an error message that indicates that the date value is out of range but it is not.

Example 1:

When the following attribute value pair is included in a createRequest web services call:

<string>call_back_date</string>
<string>1496275200,336</string>

the response returned is:

<soapenv:Fault>
<faultcode>soapenv:Client</faultcode>
<faultstring>Invalid date value '1493157600.0'. Out of valid range (0 to 2147483647)</faultstring>
<faultactor/>
<detail>
<ErrorMessage>Invalid date value  '1493157600.0'. Out of valid range (0 to 2147483647)</ErrorMessage>
<ErrorCode>1000</ErrorCode>
</detail>
</soapenv:Fault>

Example 2:

For a number format which uses "," as the separator between the integer value and the fractional value for the locale, such as in the following pair:

<string>call_back_date</string>
<string>1496275200,336</string>

the response returned is:

"Invalid date value '1496275200,336'. Out of valid range (0 to 2147483647)"

Environment:
CA Service Desk Manager 14.1.03 and 17.0
Workaround:

Drop the fractional part of the date before providing it as the value of a date in a web services call.

Additional Information:

The Date data type is defined as an integer, which is a whole number.  For more information, please see: Definition of the Date data type

Please help us improve!

Will this information enable you to resolve your issue?

Please tell us what we can do better.

{{feedbackText.length ? feedbackText.length : '0'}}/255

{{status}}

Not what you were looking for?

Search Again >

Product Information

Support by Product >

Communities

Join a Community >

Chat with CA

Just give us some brief information and we'll connect you to the right CA ExpertCA sales representative.

Our hours of availability are 8AM - 5PM CST.

All Fields Required

connecting

We're matching your request.

Unfortunately, we can't connect you to an agent. If you are not automatically redirected please click here.

  • {{message.agentProfile.name}} will be helping you today.

    View Profile


  • Transfered to {{message.agentProfile.name}}

    {{message.agentProfile.name}} joined the conversation

    {{message.agentProfile.name}} left the conversation

  • Your chat with {{$storage.chatSession.messages[$index - 1].agentProfile.name}} has ended.
    Thank you for your interest in CA.


    Rate Your Chat Experience.

    {{chat.statusMsg}}

agent is typing