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

Dummy users are getting created when any Custom property is updated.

Varshi_Balaji
Regular Contributor
Regular Contributor

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

6 REPLIES 6

Raghu
All-Star
All-Star

@Varshi_Balaji  include what operation going to do mapping tags

 

<userOperationsAllowed>UPDATE</userOperationsAllowed>
<userReconcillationField>username</userReconcillationField>
<userNotInFileAction>NOACTION</userNotInFileAction>


Thanks,
Raghu
If this reply answered your question, Please Accept As Solution and hit Kudos.

Varshi_Balaji
Regular Contributor
Regular Contributor

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?

rushikeshvartak
All-Star
All-Star

Does query giving proper results ?


Regards,
Rushikesh Vartak
If you find this response useful, kindly consider selecting 'Accept As Solution' and clicking on the 'Kudos' button.

Yes

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.⚠️‼️‼️


Regards,
Rushikesh Vartak
If you find this response useful, kindly consider selecting 'Accept As Solution' and clicking on the 'Kudos' button.

Varshi_Balaji
Regular Contributor
Regular Contributor

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