Oracle Web Services On Demand Troubleshooting Guide > Error Codes: Causes and Solutions >

SBL-DAT-00359

This error code has no error symbol.

Generic Error Message

Method 'SetFieldValue' of business component '%1' (integration component '%2') for record with search specification '%3' returned the following error:"The value '%4' cannot be converted to a date time value.(SBL-DAT-00359)"(SBL-EAI-04375)

Causes and Solutions

One possible cause is that the Web service request that is being processed inserts and updates a dateTime or date field that has an invalid or an incorrectly formatted dateTime or date value.

Error Message

Method 'SetFieldValue' of business component 'Action'(integration component 'Activity') for record with search specification '[Description] = "Test Date"' returned the following error:"The value '12-41-abcT12:30:00' cannot be converted to a date time value.(SBL-DAT-00359)"(SBL-EAI-04375)

Incorrect SOAP Request

In the following incorrect SOAP request, an existing Activity record is updated with an invalid start time:

<?xml version="1.0" encoding="utf-16"?>

<soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:wsse="http://docs.oasis-open.org/wss/2004/01/oasis-200401-wss-wssecurity-secext-1.0.xsd" xmlns:xsd="http://www.w3.org/2001/XMLSchema">

   <soap:Header>

      <wsse:Security>

         <wsse:UsernameToken>

            <wsse:Username>%%%USERNAME%%%</wsse:Username>

            <wsse:Password Type="http://docs.oasis-open.org/wss/2004/01/oasis-200401-wss-username-token-profile-1.0#PasswordText">%%%PASSWORD%%%</wsse:Password>

         </wsse:UsernameToken>

      </wsse:Security>

   </soap:Header>

   <soap:Body>

      <ActivityUpdate_Input xmlns="urn:crmondemand/ws/ecbs/activity/">

         <ListOfActivity>

            <Activity>

               <Subject>Test Date</Subject>

               <StartTime>2012-41-abcT12:30:00</StartTime>

            </Activity>

         </ListOfActivity>

      </ActivityUpdate_Input>

   </soap:Body>

</soap:Envelope>

Resolving Error SBL-DAT-00144

Ensure that the specified date or dateTime values are valid and that they are correctly formatted. For example, setting Month = 41 in the date or dateTime field is incorrect and causes this error. For more information on time and date formats, see Oracle Web Services On Demand Guide.

Correcting the SOAP Request

To correct the SOAP request, modify the start time to a correctly formatted date and time value. The dateTime value cannot contain alphabetic characters for the month value within the date.

<?xml version="1.0" encoding="utf-16"?>

<soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:wsse="http://docs.oasis-open.org/wss/2004/01/oasis-200401-wss-wssecurity-secext-1.0.xsd" xmlns:xsd="http://www.w3.org/2001/XMLSchema">

   <soap:Header>

      <wsse:Security>

         <wsse:UsernameToken>

            <wsse:Username>%%%USERNAME%%%</wsse:Username>

            <wsse:Password Type="http://docs.oasis-open.org/wss/2004/01/oasis-200401-wss-username-token-profile-1.0#PasswordText">%%%PASSWORD%%%</wsse:Password>

         </wsse:UsernameToken>

      </wsse:Security>

   </soap:Header>

   <soap:Body>

      <ActivityUpdate_Input xmlns="urn:crmondemand/ws/ecbs/activity/">

         <ListOfActivity>

            <Activity>

               <Subject>Test Date</Subject>

               <StartTime>2012-01-30T12:30:00</StartTime>

            </Activity>

         </ListOfActivity>

      </ActivityUpdate_Input>

   </soap:Body>

</soap:Envelope>