Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

[BUG] deploy of dataExtension fails with "Error: String or binary data would be truncated. The statement has been terminated." #1644

Closed
2 tasks done
JoernBerkefeld opened this issue Sep 2, 2024 · 1 comment · Fixed by #1642
Closed
2 tasks done

[BUG] deploy of dataExtension fails with "Error: String or binary data would be truncated. The statement has been terminated." #1644

JoernBerkefeld opened this issue Sep 2, 2024 · 1 comment · Fixed by #1642
Labels
bug Something isn't working c/dataExtension COMPONENT
Milestone
7.4.0

Comments

@JoernBerkefeld
Copy link
Contributor

JoernBerkefeld commented Sep 2, 2024 •
edited
Loading

Is there an existing issue for this?

  • I have searched the existing issues

Current Behavior

caching request for dataExtensions fields for a specific dataExtension

<Envelope xmlns="http://schemas.xmlsoap.org/soap/envelope/"
    xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
    <Body>
        <RetrieveRequestMsg xmlns="http://exacttarget.com/wsdl/partnerAPI">
            <RetrieveRequest>
                <ObjectType>DataExtensionField</ObjectType>
                <Properties>CustomerKey</Properties>
                <Properties>DataExtension.CustomerKey</Properties>
                <Properties>DefaultValue</Properties>
                <Properties>FieldType</Properties>
                <Properties>IsPrimaryKey</Properties>
                <Properties>IsRequired</Properties>
                <Properties>MaxLength</Properties>
                <Properties>Name</Properties>
                <Properties>Ordinal</Properties>
                <Properties>Scale</Properties>
                <Properties>ObjectID</Properties>
                <Filter xsi:type="SimpleFilterPart">
                    <Property>DataExtension.CustomerKey</Property>
                    <SimpleOperator>IN</SimpleOperator>
                    <Value>New Journey - March 4 2024 at 455 PM - 2024-03-04T101217103</Value>
                </Filter>
            </RetrieveRequest>
        </RetrieveRequestMsg>
    </Body>
    <Header>
        <fueloauth>*** TOKEN REMOVED ***</fueloauth>
    </Header>
</Envelope>

API response:

  <?xml version="1.0" encoding="utf-8"?>
<soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/"
    xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
    xmlns:xsd="http://www.w3.org/2001/XMLSchema"
    xmlns:wsa="http://schemas.xmlsoap.org/ws/2004/08/addressing"
    xmlns:wsse="http://docs.oasis-open.org/wss/2004/01/oasis-200401-wss-wssecurity-secext-1.0.xsd"
    xmlns:wsu="http://docs.oasis-open.org/wss/2004/01/oasis-200401-wss-wssecurity-utility-1.0.xsd">
    <soap:Header>
        <wsa:Action>RetrieveResponse</wsa:Action>
        <wsa:MessageID>urn:uuid:6a73bb43-f68b-4b9c-8fe7-2c53d74a7ba8</wsa:MessageID>
        <wsa:RelatesTo>urn:uuid:b32c8dbb-e850-4b57-be73-6e874869cd40</wsa:RelatesTo>
        <wsa:To>http://schemas.xmlsoap.org/ws/2004/08/addressing/role/anonymous</wsa:To>
        <wsse:Security>
            <wsu:Timestamp wsu:Id="Timestamp-723e8ca2-72f0-4532-ad70-f43b2b318605">
                <wsu:Created>2024-09-02T08:30:19Z</wsu:Created>
                <wsu:Expires>2024-09-02T08:35:19Z</wsu:Expires>
            </wsu:Timestamp>
        </wsse:Security>
    </soap:Header>
    <soap:Body>
        <RetrieveResponseMsg xmlns="http://exacttarget.com/wsdl/partnerAPI">
            <OverallStatus>Error: String or binary data would be truncated.
The statement has been terminated.</OverallStatus>
            <RequestID>1786b98d-5b1d-4d6b-8c9f-3f0ce93a701e</RequestID>
        </RetrieveResponseMsg>
    </soap:Body>
</soap:Envelope>

Expected Behavior

caching de fields does not throw an error :D

maybe switch key IN value to key equals value?

Steps To Reproduce

  1. Go to '...'
  2. Click on '....'
  3. Run '...'
  4. See error...

Version

7.3.1

Environment

  • OS:
  • Node:
  • npm:

Participation

  • I am willing to submit a pull request for this issue.

Additional comments

No response
@JoernBerkefeld JoernBerkefeld added bug Something isn't working c/dataExtension COMPONENT labels Sep 2, 2024
@JoernBerkefeld JoernBerkefeld added this to the 7.3.4 milestone Sep 2, 2024
@JoernBerkefeld JoernBerkefeld changed the title [BUG] deploy of dataExtension sometimes fails when caching the dataExtension fields [BUG] deploy of dataExtension fails with "Error: String or binary data would be truncated. The statement has been terminated." Sep 2, 2024
@JoernBerkefeld JoernBerkefeld modified the milestones: 7.4.2, 7.4.0 Sep 2, 2024
JoernBerkefeld added a commit that referenced this issue Sep 2, 2024
@JoernBerkefeld
#1644: workaround, not solution for the "string or binary data would …
2b5978f 
…be truncated"-error
@JoernBerkefeld JoernBerkefeld mentioned this issue Sep 2, 2024
Merged
4 tasks
@github-actions GitHub Actions
Copy link

github-actions bot commented Sep 2, 2024

Closed by #1660.

@github-actions github-actions bot closed this as completed Sep 2, 2024
@JoernBerkefeld JoernBerkefeld mentioned this issue Sep 2, 2024
Merged
11 tasks
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
bug Something isn't working c/dataExtension COMPONENT
Projects
None yet
Milestone
7.4.0
Development

Successfully merging a pull request may close this issue.

7.4.0 Accenture/sfmc-devtools
1 participant
@JoernBerkefeld