Announcing the Saviynt Knowledge Exchange unifying the Saviynt forums, documentation, training,
and more in a single search tool across platforms. Read the announcement here.

MODIFYUSERDATAJSON - Column count doesn't match value count at row 1

Murmur
Regular Contributor III
Regular Contributor III

Hi everyone, 

I recently faced the issue, that no matter what I did to make the MODIFYUSERDATAJSON work, I received the following error: 

Error in Users Import - Error while processing data: Column count doesn't match value count at row 1

Turns out, the issue was in the ImportUserJSON instead of the MODIFYUSERDATAJSON.
I accidentally set a value twice in colsToPropsMap. 

Imagine something like: 

 "colsToPropsMap": {
    "username": "email~#~char",
    "username": "email~#~char"
}
 
I hope this helps someone to get out of this rabbit hole easier. 
2 REPLIES 2

Murmur
Regular Contributor III
Regular Contributor III

Already solved

Sunil
Community Manager
Community Manager

@Murmur Thanks for sharing.