Data truncation error for customproperty16

[rajat1996]

Hi ,

We are importing entitlement from AD system and ran the access import job. but we got the "Data truncation error for customprpoerty16." The value which we are pulling in CP16 is big and that's why it's not coming in CP16 as the data type of CP16 is varchar (255).

I tried using the CP1-CP5 as they are of type longtext but when i do that the mapping doesn't show up.

I am attaching the groupimportmappping code and the error we are getting.

Can anyone help me on this ?

[armaanzahir]

Hi @rajat1996 

Can you share your groupimportmapping?

[rajat1996]

{
"entitlementTypeName": "memberOf",
"performGroupAccountLinking": "true",
"importGroupHierarchy": "true",
"incrementalTimeField": "whenChanged",
"groupObjectClass": "(objectclass=group)",
"mapping": "memberHash:member_char,customproperty1:sAMAccountType_char,customproperty16:memberOf_char,customproperty2:instanceType_char,customproperty3:uSNCreated_char,customproperty4:groupType_char,customproperty5:dSCorePropagationData_char,customproperty12:dn_char,customproperty13:cn_char,lastscandate:whenCreated_date,customproperty15:managedBy_char,entitlement_glossary:description_char,customproperty9:name_char,customproperty10:objectCategory_char,customproperty11:sAMAccountName_char,customproperty14:objectClass_char,status:isCriticalSystemObject_char,entitlement_value:distinguishedName_char,customproperty17:distinguishedName_char,updatedate:whenChanged_date, RECONCILATION_FIELD:customproperty17",
"activeGroupPossibleValues": [
"active",
"TRUE"
]
}

[dgandhi]

Can you paste the error when you are using CP1 to CP5?

[rajat1996]

I am not getting any error. CP1-CP5 are already being used in our group import mapping JSON. I just tried to switch the values like CP16 value i tried put in CP1 and CP1 to CP16. Then i ran the import job. and the acc. to entitlement mapping doesn't show up. 

[rushikeshvartak]

{
"entitlementTypeName": "memberOf",
"performGroupAccountLinking": "true",
"importGroupHierarchy": "true",
"incrementalTimeField": "whenChanged",
"groupObjectClass": "(objectclass=group)",
"mapping": "memberHash:member_char,customproperty1:sAMAccountType_char,customproperty4:memberOf_char,customproperty2:instanceType_char,customproperty3:uSNCreated_char,customproperty16:groupType_char,customproperty5:dSCorePropagationData_char,customproperty12:dn_char,customproperty13:cn_char,lastscandate:whenCreated_date,customproperty15:managedBy_char,entitlement_glossary:description_char,customproperty9:name_char,customproperty10:objectCategory_char,customproperty11:sAMAccountName_char,customproperty14:objectClass_char,status:isCriticalSystemObject_char,entitlement_value:distinguishedName_char,customproperty17:distinguishedName_char,updatedate:whenChanged_date, RECONCILATION_FIELD:customproperty17",
"activeGroupPossibleValues": [
"active",
"TRUE"
]
}

[rajat1996]

Hey Rushi, 

Thank you for the reply!

i tried the code u pasted. and ran the import job (access) . Job ran successfully but the mapping breaks up (screenshot attached below)

[rushikeshvartak]

what was old mapping there ?

[SumathiSomala · Accepted solution]

@rajat1996  is your issue resolved? if not could try below groupimport mapping JSON

{ "entitlementTypeName": "memberOf", "performGroupAccountLinking": "true", "importGroupHierarchy": "true", "incrementalTimeField": "whenChanged", "groupObjectClass": "(objectclass=group)","mapping": "memberHash:member_char,customproperty1:sAMAccountType_char,customproperty2:instanceType_char,customproperty3:memberof_char,customproperty16:uSNCreated_char,customproperty4:groupType_char,customproperty5:dSCorePropagationData_char,customproperty12:dn_char,customproperty13:cn_char,lastscandate:whenCreated_date,customproperty15:managedBy_char,entitlement_glossary:description_char,customproperty9:name_char,customproperty10:objectCategory_char,customproperty11:sAMAccountName_char,customproperty14:objectClass_char,status:isCriticalSystemObject_char,entitlement_value:distinguishedName_char,customproperty18:distinguishedName_char,updatedate:whenChanged_date, customproperty17:objectGUID_Binary,RECONCILATION_FIELD:customproperty17,description:description_char",
"entitlementOwnerAttribute":"managedBy",
"tableFieldAttribute":"accountID"}

and let me know if it helps.