Recent pages

Edit
page

New
page

Print
page
Page last modified 07:00, 13 Sep 2011 by Admin
0
Redirect
Page Notifications Off
Documentation Wiki > ExactTarget > Subscribers > Data Extensions and Data Relationships > Data Extension and Data Relationship Error Messages

Data Extension and Data Relationship Error Messages

From $1

    Table of contents
    1. 1. Data Extension Error Messages
      1. 1.1. Specify a Name
        1. 1.1.1. This Error Occurs When
        2. 1.1.2. To Correct this Error
      2. 1.2. Object Name Already Exists
        1. 1.2.1. This Error Occurs When
        2. 1.2.2. To Correct this Error
      3. 1.3. External Key Already Exists
        1. 1.3.1. This Error Occurs When
        2. 1.3.2. To Correct this Error
      4. 1.4. Field Name Cannot Be Blank
        1. 1.4.1. This Error Occurs When
        2. 1.4.2. To Correct this Error
      5. 1.5. Field Name Already Exists
        1. 1.5.1. This Error Occurs When
        2. 1.5.2. To Correct this Error
      6. 1.6. Text Field with No Length Cannot Be Primary Key
        1. 1.6.1. This Error Occurs When
        2. 1.6.2. To Correct this Error
      7. 1.7. Primary Key Cannot be Nullable
        1. 1.7.1. This Error Occurs When
        2. 1.7.2. To Correct this Error
      8. 1.8. Cannot Contain Illegal Characters
        1. 1.8.1. This Error Occurs When
        2. 1.8.2. To Correct this Error
      9. 1.9. External Key Cannot be Longer than 36 Characters
        1. 1.9.1. This Error Occurs When
        2. 1.9.2. To Correct this Error
      10. 1.10. Data Extension Name Cannot be Longer than 128 Characters
        1. 1.10.1. This Error Occurs When
        2. 1.10.2. To Correct this Error
      11. 1.11. Data Extension Name Cannot be Blank
        1. 1.11.1. This Error Occurs When
        2. 1.11.2. To Correct this Error
      12. 1.12. Data Extension Name Cannot Begin With Underscore
        1. 1.12.1. This Error Occurs When
        2. 1.12.2. To Correct this Error
      13. 1.13. Data Extension Name Cannot Consist Entirely of Numbers
        1. 1.13.1. This Error Occurs When
        2. 1.13.2. To Correct this Error
      14. 1.14. Field Name Cannot be Longer than 128 Characters
        1. 1.14.1. This Error Occurs When
        2. 1.14.2. To Correct this Error
      15. 1.15. Field Name Cannot Be Blank
        1. 1.15.1. This Error Occurs When
        2. 1.15.2. To Correct this Error
      16. 1.16. Field Name Cannot Begin With Underscore
        1. 1.16.1. This Error Occurs When
        2. 1.16.2. To Correct this Error
      17. 1.17. Field Name Cannot Consist Entirely of Numbers
        1. 1.17.1. This Error Occurs When
        2. 1.17.2. To Correct this Error
      18. 1.18. Length of an Existing Text Field Cannot be Decreased
        1. 1.18.1. This Error Occurs When
        2. 1.18.2. To Correct this Error
    2. 2. Data Relationship Error Messages
      1. 2.1. External Key Cannot be Longer than 36 Characters
        1. 2.1.1. This Error Occurs When
        2. 2.1.2. To Correct this Error
      2. 2.2. External Key Already Exists
        1. 2.2.1. This Error Occurs When
        2. 2.2.2. To Correct this Error
      3. 2.3. Relationship Already Exists
        1. 2.3.1. This Error Occurs When
        2. 2.3.2. To Correct this Error
      4. 2.4. Data Relationship Name Cannot be Longer than 64 Characters
        1. 2.4.1. This Error Occurs When
        2. 2.4.2. To Correct this Error
      5. 2.5. Data Relationship Name Cannot be Blank
        1. 2.5.1. This Error Occurs When
        2. 2.5.2. To Correct this Error
      6. 2.6. Relationship Must Have Both Left and Right Sides
        1. 2.6.1. This Error Occurs When
        2. 2.6.2. To Correct this Error
      7. 2.7. Same Object Cannot Exist on Both Sides of a Relationship
        1. 2.7.1. This Error Occurs When
        2. 2.7.2. To Correct this Error
      8. 2.8. Relationship Field Map Already Exists for Selected Field
        1. 2.8.1. This Error Occurs When
        2. 2.8.2. To Correct this Error
      9. 2.9. Relationship Must Exist
        1. 2.9.1. This Error Occurs When
        2. 2.9.2. To Correct this Error
      10. 2.10. Relationship Must Have Both Left and Right Columns
        1. 2.10.1. This Error Occurs When
        2. 2.10.2. To Correct this Error
      11. 2.11. Same Column Cannot Exist on Both Sides of a Relationship
        1. 2.11.1. This Error Occurs When
        2. 2.11.2. To Correct this Error

    This document contains conceptual and procedural information regarding data extension error messages that may occur. 

    Data Extension Error Messages

    Use the information below to identify and fix errors with data extensions in your account.

    Specify a Name

    Specify a name.

    This Error Occurs When

    You try to save the data extension when the Name field for the data extension is NULL.

    To Correct this Error

    Enter a value in the Name field for the data extension.

    Object Name Already Exists

    An object named <object name> already exists.

    This Error Occurs When

    You try to save a data extension (new or modified) with a value in the Name field that matches the name of a data extension that already exists in your system.

    To Correct this Error

    Use a name for the data extension that does not match a data extension that already exists.

    External Key Already Exists

    An object with external key <external key> already exists.

    This Error Occurs When

    You try to save the data extension when the value in the External Key field for the data extension is the same as the External Key for a data extension that already exists on your system.

    To Correct this Error

    Enter a value in the Name field for the data extension.

    Field Name Cannot Be Blank

    Field name cannot be blank.

    This Error Occurs When

    You try to save the data extension when the Name field for one of the columns is NULL.

    To Correct this Error

    You can do any of the following:

    • Enter a value in the Name field for the column.
    • Click Delete next to the column to remove it from the data extension.

    Field Name Already Exists

    A field named <column name> already exists on object <object name>.

    This Error Occurs When

    You create a column in a data extension with the same name as a column that already exists on the data extension.

    To Correct this Error

    Use a name for the column that does not match a column that already exists on the data extension.

    Text Field with No Length Cannot Be Primary Key

    A text field with no length specified cannot be used as primary key.

    This Error Occurs When

    You select the Primary Key checkbox for a column whose Data type is Text and whose Length field is NULL.

    To Correct this Error

    You can do any of the following:

    • Specify a maximum length for the Data Type field in the primary key.
    • Clear the Primary Key checkbox for the text field.
    • Change the Data type of the text field to a different value.

    Primary Key Cannot be Nullable

    A primary key field cannot be nullable.

    This Error Occurs When

    You try to save the data extension when both the Primary Key checkbox and the Nullable checkbox are selected for a column.

    To Correct this Error

    You can do any of the following:

    • Clear the Primary Key checkbox for the column.
    • Clear the Nullable checkbox for the column.
    • Clear both the Primary Key checkbox and the Nullable checkbox for the column.

    Cannot Contain Illegal Characters

    Cannot contain illegal characters \ / " : * ? | @ # , . < >

    This Error Occurs When

    You try to save the data extension when any of the fields contains one of the following characters:

    \  (slash)

    /  (backslash)

    "  (quotation mark)

    :  (colon)

    *  (asterisk)

    ?  (question mark)

    |  (pipe)

    @  (at sign)

    #  (pound sign)

    ,  (comma)

    .  (period)

    <  (less than)

    > (greater than)

    To Correct this Error

    Remove the illegal character.

    External Key Cannot be Longer than 36 Characters

    The external key cannot be longer than 36 characters.

    This Error Occurs When

    You try to save the data extension when the length of the value in the External Key field is greater than 36 characters.

    To Correct this Error

    Reduce the number of characters in the External Key value to 36 or fewer.

    Data Extension Name Cannot be Longer than 128 Characters

    The data extension name cannot be longer than 128 characters.

    This Error Occurs When

    You try to save the data extension when the length of the value in the Name field is greater than 128 characters.

    To Correct this Error

    Reduce the number of characters in the Name value to 128 or fewer.

    Data Extension Name Cannot be Blank

    The Data extension name cannot be blank.

    This Error Occurs When

    You try to save the data extension when the Name field is NULL.

    To Correct this Error

    Enter a value in the Name field for the data extension.

    Data Extension Name Cannot Begin With Underscore

    The data extension name cannot begin with an underscore.

    This Error Occurs When

    You try to save the data extension when the first character in the value in the Name field is _.

    To Correct this Error

    Enter a number or letter as the first character in the data extension name.

    Data Extension Name Cannot Consist Entirely of Numbers

    The data extension name cannot consist entirely of numbers.

    This Error Occurs When

    You try to save the data extension when the value in the Name field for the data extension contains only numbers.

    To Correct this Error

    Enter a letter in the value in the Name field for the data extension.

    Field Name Cannot be Longer than 128 Characters

    Field name cannot be longer than 128 characters.

    This Error Occurs When

    You try to save the data extension when the length of the value in the Name field for the column is greater than 128.

    To Correct this Error

    Reduce the length of the Name value to 128 or fewer characters.

    Field Name Cannot Be Blank

    Field name cannot be blank.

    This Error Occurs When

    You try to save the data extension when the Name field for the column is NULL.

    To Correct this Error

    Enter a value in the Name field for the column.

    Field Name Cannot Begin With Underscore

    Field name cannot begin with an underscore.

    This Error Occurs When

    You try to save the data extension when the first character in the value in the Name field for a column is _.

    To Correct this Error

    Enter a number or letter as the first character in the column name.

    Field Name Cannot Consist Entirely of Numbers

    Field name cannot consist entirely of numbers.

    This Error Occurs When

    You try to save the data extension when the value in the Name field for a column contains only numbers.

    To Correct this Error

    Enter a letter in the value in the Name field for the column.

    Length of an Existing Text Field Cannot be Decreased

    The length of an existing Text field cannot be decreased.

    This Error Occurs When

    You try to modify a previously saved data extension by reducing the character length of a text-type field. This change could result in the loss of data.

    To Correct this Error

    Enter a character length for the field that is the same or greater than it was at the time the data extension was previously saved.

    Data Relationship Error Messages

    External Key Cannot be Longer than 36 Characters

    The external key cannot be longer than 36 characters.

    This Error Occurs When

    You try to save the data relationship when the length of the value in the External Key field is greater than 36 characters.

    To Correct this Error

    Reduce the number of characters in the External Key value to 36 or fewer.

    External Key Already Exists

    An object with external key <external key> already exists.

    This Error Occurs When

    You try to save the data relationship when the value in the External Key field for the data extension is the same as the External Key for a data relationship that already exists on your system.

    To Correct this Error

    Enter a value in the Name field for the data relationship.

    Relationship Already Exists

    A relationship already exists for the left and right side of the relationship.

    This Error Occurs When

    You try to save a data relationship where the combination of the left and right side objects already appears in another data relationship.

    To Correct this Error

    You can do any of the following:

    • Change the left-side object.
    • Change the right-side object.
    • Remove the data relationship.

    Data Relationship Name Cannot be Longer than 64 Characters

    The relationship name cannot be longer than 64 characters.

    This Error Occurs When

    You try to save the data relationship when the length of the value in the Name field is greater than 64 characters, including spaces.

    To Correct this Error

    Reduce the number of characters in the Name value to 64 or fewer.

    Data Relationship Name Cannot be Blank

    The relationship name cannot be blank.

    This Error Occurs When

    You try to save the data relationship when the Name field is NULL.

    To Correct this Error

    Enter a value in the Name field for the data relationship.

    Relationship Must Have Both Left and Right Sides

    The relationship must have both a left and right object.

    This Error Occurs When

    You try to save the data relationship without a left or right object.

    To Correct this Error

    Select both a right and left object.

    Same Object Cannot Exist on Both Sides of a Relationship

    The same object cannot be selected for the left and right object in a relationship.

    This Error Occurs When

    You try to save the data relationship when the left and right objects are the same object.

    To Correct this Error

    Select a different object for either the left or the right side of the relationship.

    Relationship Field Map Already Exists for Selected Field

    A relationship field map already exists for selected fields.

    This Error Occurs When

    You try to save the data relationship when a single column is involved in multiple relationships.

    To Correct this Error

    Include the column in only one relationship.

    Relationship Must Exist

    Create the relationship between the appropriate objects and fields.

    This Error Occurs When

    You try to save the data relationship when any of the objects and fields that define the relationship is not included.

    To Correct this Error

    Provide the objects and columns that define the data relationship.

    Relationship Must Have Both Left and Right Columns

    There must be a left and right field when defining a relationship.

    This Error Occurs When

    You try to save the data relationship without a left or right column.

    To Correct this Error

    Select both a left and a right column.

    Same Column Cannot Exist on Both Sides of a Relationship

    The same field cannot be selected when mapping data relationship fields.

    This Error Occurs When

    You try to save the data relationship when the left and right columns are the same columns on the same object.

    To Correct this Error

    Select a different column for either the left or the right side of the relationship. 

    This page was last updated by Ryan Williams on Tue, 13 Sep 2011 11:00:23 GMT.

    If you require assistance with the ExactTarget application, please contact Global Support. If you wish to send Ryan direct feedback, fill out the form below:

     

    Was This Page Helpful?
    Suggestions or Comments:
    Name (optional):
    Email Address (optional):
    Enter 8460 backwards:
       
    Tags: (Edit tags)
    • No tags
    Attach file or image
    Files (0)
     
    Comments (0)
    You must login to post a comment.

     
    Powered by MindTouch 2010
    Admin