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

Technical rule with birthright use case not getting triggered on csv import to create AD account

asharma
Regular Contributor II
Regular Contributor II

Hi Team,

Technical rule with birthright use case not getting triggered on csv import to create AD account.

Kindly help asap. Let me know for any information.

 

Thanks

35 REPLIES 35

Saathvik
All-Star
All-Star

Did you select the Zero Day provisioning and Check Rules as YES while csv import? If not try with that setting

sk_0-1689346029445.png

 

 


Regards,
Saathvik
If this reply answered your question, please Accept As Solution and give Kudos to help others facing similar issue.

asharma
Regular Contributor II
Regular Contributor II

I am trying with using SAV files as we are importing the csv from SFTP server. However, in SAV files we have put ZeroDayProvisioning as TRUE and Checkrules as TRUE.

dgandhi
All-Star
All-Star

Can you paste screenshot of the rule?

 

Thanks,
Devang Gandhi
If this reply answered your question, please Accept As Solution and give Kudos to help others who may have a similar problem.

asharma
Regular Contributor II
Regular Contributor II

asharma_0-1689349233579.png

 

Hi @asharma ,

Can you try below options one by one

Option1:

Change Last And operator as OR, which is present at the end of your last condition, as highlighted in below screenshot.

pmahalle_0-1689390118404.png

Option2:

If above change did not work, better use advanced config for technical rule condition. Make sure you can not enable advanced config while updating the existing rule. So create new technical rule, enable advanced config, use required condition in advanced config condition like below and try. 

pmahalle_1-1689390597734.png

 


Pandharinath Mahalle(Paddy)
If this reply answered your question, please Accept As Solution to help other who may have a same problem. Give Kudos 🙂

As per  Entity Starts with H but sample file have starts with "

J4--Coperion Corporation

rushikeshvartak_0-1689822081500.png

 


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

Hi @asharma ,

As mentioned by @rushikeshvartak check the data of users in csv matching the condition provided in technical rule or not.

If not then, correct it in csv and try it again.


Pandharinath Mahalle(Paddy)
If this reply answered your question, please Accept As Solution to help other who may have a same problem. Give Kudos 🙂

asharma
Regular Contributor II
Regular Contributor II

I tried both ways but nothing worked. 

Also, i add more conditions so sharing the screenshot for the same.

asharma_0-1689594722239.png

Kindly suggest a fix for this asap.

Hi @asharma ,

Can you share the query you are using in advanced config of the rule. Also share the SAV file you are using for import.


Pandharinath Mahalle(Paddy)
If this reply answered your question, please Accept As Solution to help other who may have a same problem. Give Kudos 🙂

pmahalle
All-Star
All-Star

Hi @asharma ,

can you see rule run in the update history of the user?


Pandharinath Mahalle(Paddy)
If this reply answered your question, please Accept As Solution to help other who may have a same problem. Give Kudos 🙂

asharma
Regular Contributor II
Regular Contributor II

didn't triggered. 

Share input file.


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

asharma
Regular Contributor II
Regular Contributor II

Attached csv file and SAV file config.

USER_NOT_IN_FILE_ACTION=NOACTION
FILENAME=schemauser
DELIMITER=,
SKIP_NUMBER_OF_LINES=1
ZERODAYPROVISIONING=TRUE
userReconcillationField=username
GENERATESYSTEMUSERNAME=FALSE
GENERATEEMAIL=TRUE
EMAILTEMPLATE=""
CHECKRULES=TRUE

STATUSKEYJSON=XXXXXXXXXXXXXXXXXXXXX

CITY,COMPANYNAME,COSTCENTER,COUNTRY,CUSTOMPROPERTY1,CREATEDBY,DEPARTMENTNAME,DEPARTMENTNUMBER,DISPLAYNAME,EMAIL,EMPLOYEECLASS,EMPLOYEEID,EMPLOYEETYPE,ENDDATE,ENTITY,FIRSTNAME,JOB_FUNCTION,JOBCODE,JOBCODEDESC,JOBDESCRIPTION,JOB_ID,LASTNAME,LEAVESTATUS,LOCATION,LOCATIONDESC,MANAGER,MIDDLENAME,ORGUNITID,OWNER,PHONENUMBER,PREFEREDFIRSTNAME,REGION,REGIONCODE,RISKSCORE,SECONDARYEMAIL,SECONDARYMANAGER,SECONDARYPHONE,SITEID,STARTDATE,STATE,STATUSKEY,STREET,TERMDATE,TITLE,USERNAME

SAV and CSV files looks good.

Also, can you provide advanced config query you are using in rule conditions. From the screenshot  you provided, seems like you used different alias for conditions like a and User

pmahalle_0-1689667295008.png

 


Pandharinath Mahalle(Paddy)
If this reply answered your question, please Accept As Solution to help other who may have a same problem. Give Kudos 🙂

asharma
Regular Contributor II
Regular Contributor II

Yes condition is same as you mentioned in the screenshot above.

asharma
Regular Contributor II
Regular Contributor II

asharma_0-1689683679750.png

 

Hi @asharma ,

Field name "User Type" is wrong in the query. Can you try below one

(a.startdate=curdate() AND a.statuskey=1 AND a.employeeType='Employee' AND a.entity='XXX')

 


Pandharinath Mahalle(Paddy)
If this reply answered your question, please Accept As Solution to help other who may have a same problem. Give Kudos 🙂

asharma
Regular Contributor II
Regular Contributor II

Any suggestions @pmahalle @rushikeshvartak @dgandhi @Saathvik 

This is now crucial as we are newar our Go Live.

What is the result of this as suggested by @pmahalle 

(a.startdate=curdate() AND a.statuskey=1 AND a.employeeType='Employee' AND a.entity='XXX')

Thanks,
Devang Gandhi
If this reply answered your question, please Accept As Solution and give Kudos to help others who may have a similar problem.

Hi @asharma ,

After user imported, user status is active? Can you also check the statuskey of the users in data analyzer


Pandharinath Mahalle(Paddy)
If this reply answered your question, please Accept As Solution to help other who may have a same problem. Give Kudos 🙂

asharma
Regular Contributor II
Regular Contributor II

Yes status is active and statuskey is 1

 

Can you share the logs during the import process?


Regards,
Saathvik
If this reply answered your question, please Accept As Solution and give Kudos to help others facing similar issue.

asharma
Regular Contributor II
Regular Contributor II

asharma_0-1689951132048.png

user - 911814

above is the user which we imported and attached is the logs for that time duration

asharma
Regular Contributor II
Regular Contributor II

Hi @pmahalle , @rushikeshvartak , @Saathvik , @dgandhi 

Request all expertise to help here as we are reaching towards go live and we got stuck here. I have already provided all the required information and let me know if you need any more.

 

Hi @asharma ,

Can you check whether your user (on which you are expecting technical rule should be triggered) is coming in the list after you clicked on Preview button in the technical rule.

pmahalle_0-1690271473419.png

 

 


Pandharinath Mahalle(Paddy)
If this reply answered your question, please Accept As Solution to help other who may have a same problem. Give Kudos 🙂

asharma
Regular Contributor II
Regular Contributor II

Preview is not coming up.

naveenss
All-Star
All-Star

Hi @asharma ,

With the same csv file if you're uploading the users from ADMIN > Users list page, is the rule evaluation working?

Regards,
Naveen Sakleshpur
If this reply answered your question, please click the Accept As Solution button to help future users who may have a similar problem.

asharma
Regular Contributor II
Regular Contributor II

that is also not working

Hmm. That's strange. there must be something wrong with the rules then. Can you create a simple rule like below

Users.statuskey equals 1

Make this as a birthright rule.

Upload a user using csv file (make sure the csv file should have the statuskey value as 1)

Make sure to select "zero day provisioning" and "check rules" as true in the upload dialog box. 

Once the user is uploaded, can you see at least the new rule is getting fired? Also please share the logs for this activity if it doesn't work. 

Regards,
Naveen Sakleshpur
If this reply answered your question, please click the Accept As Solution button to help future users who may have a similar problem.

asharma
Regular Contributor II
Regular Contributor II

Hi @naveenss I tried as per below.

  • using sav files keeping "zero day provisioning" and "check rules" as true.
  • uploaded data file with 1 user, data to satisfy conditions.
  • Preview was coming up after importing user.

Preview screenshot attached as below.

asharma_0-1690352427704.png

However, technical rule didn't trigered. Logs screenshot is below.

asharma_1-1690352515837.png

 

Hi @asharma ,

Since user is coming under Preview means satisfying the rule condition. Seems like bug or some configuration missing from backend in your environment, raise a Freshdesk ticket.


Pandharinath Mahalle(Paddy)
If this reply answered your question, please Accept As Solution to help other who may have a same problem. Give Kudos 🙂

@asharma ok looks like there is a problem then. Anyways, lets keep this aside for now and try out an alternate approach.

1. Create a user update rule with the same conditions mentioned in the technical rule. 

2. Keep the action as "re-run selected technical rules" and select the technical rule.

3. In the Trigger Actions when option, select "Trigger action when user is created from Import".

4. Now create the user through import and see if the technical rule is triggered from the user update rule?

 

Regards,
Naveen Sakleshpur
If this reply answered your question, please click the Accept As Solution button to help future users who may have a similar problem.

asharma
Regular Contributor II
Regular Contributor II

Tried the same but no success.

ok. Please raise a FD ticket for Saviynt to investigate further. 

Regards,
Naveen Sakleshpur
If this reply answered your question, please click the Accept As Solution button to help future users who may have a similar problem.

asharma
Regular Contributor II
Regular Contributor II

@naveenss  adding screenshot for technical rule.

asharma_2-1690352762204.png