Click HERE to see how Saviynt Intelligence is transforming the industry. |
06/04/2024 04:31 AM
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 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
Solved! Go to Solution.
06/04/2024 09:00 AM
@Varshi_Balaji include what operation going to do mapping tags
<userOperationsAllowed>UPDATE</userOperationsAllowed>
<userReconcillationField>username</userReconcillationField>
<userNotInFileAction>NOACTION</userNotInFileAction>
06/05/2024 02:16 AM
Hi Raghu,
If we don't add this then what will be the issue.
We did not have these tags before and that time it was not creating users.Now we have upgraded from 23.4 to 24.3. SO is this dependent on the version upgrade?
06/04/2024 07:42 PM
Does query giving proper results ?
06/05/2024 02:16 AM
Yes
06/09/2024 10:31 PM
Could you kindly provide a detailed snapshot of the information extracted from the logs, encompassing errors and other pertinent functionality details encountered during the execution of this process? Your assistance in furnishing this information would greatly aid in the analysis and resolution of any issues .
‼️‼️⚠️Do not upload any attachments that contain sensitive information, such as IP Addresses, URLs, Company/Employee Names, Email Addresses, etc.⚠️‼️‼️
06/27/2024 11:38 PM
Hi All,
We used the below code in all Sav to sav connections,now dummy users are not creating .
<userOperationsAllowed>UPDATE</userOperationsAllowed>
<userReconcillationField>username</userReconcillationField>
<userNotInFileAction>NOACTION</userNotInFileAction>
Thank you for the support
Regards,
Varshitha