Bookshelf Home | Contents | Index | PDF |
Oracle Web Services On Demand Troubleshooting Guide > Error Codes: Causes and Solutions > SBL-DAT-00359This error code has no error symbol. Generic Error MessageMethod '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 SolutionsOne 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 MessageMethod '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 RequestIn 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"> <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> <ActivityUpdate_Input xmlns="urn:crmondemand/ws/ecbs/activity/"> <StartTime>2012-41-abcT12:30:00</StartTime> Resolving Error SBL-DAT-00144Ensure 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 RequestTo 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"> <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> <ActivityUpdate_Input xmlns="urn:crmondemand/ws/ecbs/activity/"> |
Oracle Web Services On Demand Troubleshooting Guide | Copyright © 2014, Oracle and/or its affiliates. All rights reserved. Legal Notices. | |