We are delighted to share our new EIC Delivery Methodology for efficiently managing Saviynt Implementations and delivering quick time to value. CLICK HERE.

Column count doesn't match value count at row 1 Error for SOAP Connector

Uzair
New Contributor
New Contributor

Hello,

We have a SOAP Connector and under SOAP connector when we're using ModifyUserDataJSON we are getting the following error

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


The ModifyUserDataJSON is as follows,

 

{
"ADDITIONALTABLES": {
"USERS": "SELECT username, CUSTOMPROPERTY45 from USERS WHERE USERNAME LIKE 'a36803%'"
},
"COMPUTEDCOLUMNS": [
"CUSTOMPROPERTY45"
],
"TABLEINDEXES": {
"currentusers": [
"username"
]
},
"PREPROCESSQUERIES": [

"UPDATE NEWUSERDATA LEFT JOIN CURRENTUSERS ON NEWUSERDATA.USERNAME=CURRENTUSERS.USERNAME SET NEWUSERDATA.CUSTOMPROPERTY45 = 'Licensed Status' "
]
}


and this is our UserMapping under HR_IMPORT_JSON

"USERMAPPING1": "FIRSTNAME:FirstName,LASTNAME:LastName,USERNAME:UserName,EMAIL:EmailAddress,STATUSKEY:Status"

When we remove the ModifyUserDataJSON and run the job we are able to see the updates.

Any suggestion on how we can overcome this?

 

2 REPLIES 2

ParitaSavla
Saviynt Employee
Saviynt Employee

Can you try with the below ModifyuserdataJSON

{
"ADDITIONALTABLES":{"USERS": "SELECT username, CUSTOMPROPERTY45 from USERS'"},
"COMPUTEDCOLUMNS": ["CUSTOMPROPERTY45","USERNAME"],
"TABLEINDEXES": {
"currentusers": ["username"]
},
"PREPROCESSQUERIES": ["UPDATE NEWUSERDATA SET NEWUSERDATA.CUSTOMPROPERTY45 = 'Licensed Status' where NEWUSERDATA.username like 'a36803%'"]
}

Uzair
New Contributor
New Contributor

@ParitaSavla 

In out HR_IMPORT_JSON,
I removed the 'TEMP MAPPING' that we initially had and we got it working.

Thanks for your suggestions