Sav4Sav userImport job failure

[yash]

Issue: While running the import user job for the Sav4Sav connector we are getting the below error message

Error: Ambiguous method overloading for method java.lang.String#. Cannot resolve which method to invoke for [null] due to overlapping prototypes between: [class [B] [class [C] [class java.lang.String]

Below is the ImportUserJSON

{

"call": [

{

"connection": "userAuth",

"url": "https://####/ECM/api/v5/fetchRuntimeControlsData",

"httpMethod": "POST",

"httpContentType": "application/json",

"httpParams": "{\"analyticsname\":\"queryreport\"}",

"userResponsePath": "result",

"httpHeaders": {

"Authorization": "${access_token}",

"Accept": "application/json"

},

"colsToPropsMap": {

"username": "username~#~char",

"customproperty12": "customproperty12~#~char"

}

}

]

}

[NM]

Hi @yash , try adding alias in column and then map the same in json.

[yash]

Hi @NM i have given alias only see the below query

select us.username as username, 'yes' as customproperty12 from users us inner join user_accounts uac on us.userkey = uac.userkey inner join accounts ac on uac.accountkey = ac.accountkey inner join endpoints en on ac.endpointkey=en.endpointkey inner join customer_users cus on us.userkey = cus.userkey inner join customer cu on cu.customerkey = cus.customerkey

but still getting the error

[rushikeshvartak]

Refer https://forums.saviynt.com/t5/identity-governance/unable-to-populate-usercustomproperty-based-on-sav...

[yash]

Hi @rushikeshvartak i have followed the same post and still getting the error

In version 24.5 while creating the runtime analytics its creating v1 report, which is giving me proper output in the postman

[rushikeshvartak]

Can you share data analyzer screenshot of report configuration and output

select * from analyticsconfigses

[NM]

Add this in SQL query and then give it a shot

select us.username as UserName, 'yes' as CUSTOMPROPERTY12 from users us inner join user_accounts uac on us.userkey = uac.userkey inner join accounts ac on uac.accountkey = ac.accountkey inner join endpoints en on ac.endpointkey=en.endpointkey inner join customer_users cus on us.userkey = cus.userkey inner join customer cu on cu.customerkey = cus.customerkey

[yash]

i did updated the query now but still the same error