Symptom
Error "The value does not match the expected data format" occurs in inbound message processing due to phone/fax number format in sap service cloud version 2
Environment
- SAP Sales Cloud Version 2
- SAP Service Cloud Version 2
Reproducing the Issue
- Open the Message Monitoring tool.
- Check for errors in the replication process for `businessPartnerRelationshipS4ReplicationMessageIn` and `businessPartnerS4ReplicationMessageIn`.
- You might encounter the following errors.
- "The value does not match the expected data format. Verify and try again."
- "Data should be of maximum 3 characters. Correct it and try again."
- "The value does not match the expected data format. Verify and try again."
- "The value does not match the expected data format. Verify and try again."
- The issue occurs in `businessPartnerRelationshipS4ReplicationMessageIn` and `businessPartnerS4ReplicationMessageIn`.
- Duplicate fax numbers are present in the payload, which should only contain a single phone number instead of an array.
Cause
- There may be several reasons for the error, but all are related to issues in the CPI post-exit mapping.
- The payload contains duplicate fax numbers in the `facsimile` field, which should only include a single phone number.
- A hyphen ("-") in the phone number format may also contribute to the issue.
Resolution
- Check the source XML file from the S4 system for the failed message ID in CNS.
- Simulate the call in CPI before the post-exit mapping stage.
- Compare the payload received by CNS to spot any differences.
- Verify that the email data structure matches the payload prior to the post-exit mapping.
- If you find any mismatches, update the mapping in the post-exit phase of CPI.
- Once the mapping is corrected in CPI, reprocess the message from the S4 system.
Keywords
inbound message error, phone number format, fax number duplication, sap service cloud version 2, data type mismatch, inbound-data-connector.132, businessPartnerRelationshipS4ReplicationMessageIn, businessPartnerS4ReplicationMessageIn, payload validation, cpi customizations, phone number hyphen issue. , KBA , CEC-CRM-INT , Integration for SAP Sales/Service Cloud , Problem
Product
SAP Service Cloud Version 2 all versions
SAP Knowledge Base Article - Public