Hi Team,
We have observed below issue:
1. We have configured a sav to sav connection to update cp 38 value,below is the connection
<dataMapping>
<before-import>
</before-import>
<sql-query description="This is the Source DB Query" uniquecolumnsascommaseparated="username">
<![CDATA[
select distinct username,
case when length(CONCAT(firstname,'.',lastname,'.',employeeid,'_',DATE_FORMAT(sysdate(),'%Y%m%d')))<40 then CONCAT(firstname,'.',lastname,'.',employeeid)
when length(CONCAT(lastname,'.',employeeid,'_',DATE_FORMAT(sysdate(),'%Y%m%d')))<40 then CONCAT(lastname,'.',employeeid)
else employeeid end as customproperty39 from users where username!='PLACEHOLDER_IDENTITY'
]]>
</sql-query>
<importsettings>
<zeroDayProvisioning>false</zeroDayProvisioning>
<userNotInFileAction>NOACTION</userNotInFileAction>
<checkRules>true</checkRules>
<buildUserMap>false</buildUserMap>
<generateSystemUsername>false</generateSystemUsername>
<generateEmail>false</generateEmail>
</importsettings>
<mapper description="This is the mapping field for SAviynt Field name" defaultrole="ROLE_ENDUSER" >
<mapfield saviyntproperty="username" sourceproperty="username" type="character"></mapfield>
<mapfield saviyntproperty="customproperty39" sourceproperty="customproperty39" type="character"></mapfield>
</mapper>
<after-import description="EMAIL,BATCH,SQL">
</after-import>
</dataMapping>
------------------------------------------------------------------------------------------------------------------------------------------------------------
2. we have one more query where it updates cp58
<dataMapping>
<before-import>
</before-import>
<sql-query description="This is the Source DB Query" uniquecolumnsascommaseparated="username">
<![CDATA[
select username,customproperty1
from users where customproperty1 is not null and username!='PLACEHOLDER_IDENTITY'
]]>
</sql-query>
<importsettings>
<zeroDayProvisioning>false</zeroDayProvisioning>
<userNotInFileAction>NOACTION</userNotInFileAction>
<checkRules>true</checkRules>
<buildUserMap>false</buildUserMap>
<generateSystemUsername>false</generateSystemUsername>
<generateEmail>false</generateEmail>
</importsettings>
<mapper description="This is the mapping field for SAviynt Field name" defaultrole="ROLE_ENDUSER" >
<mapfield saviyntproperty="username" sourceproperty="username" type="character"></mapfield>
<mapfield saviyntproperty="customproperty58" sourceproperty="customproperty1" type="character"></mapfield>
</mapper>
<after-import description="EMAIL,BATCH,SQL">
</after-import>
</dataMapping>
------------------------------------------------------------------------------------------------------------------------------------------------------------
When these jobs are triggered, it should update cp39 and cp58. But it is creating new user without firstname or lastname or any other attributes. only username and cp39 or cp58 are present in the user.
It is like when these cp shuld update it is creating new user.
This is a prod issue, can you please help us here
Regards,
varshitha
