Announcing the SAVIYNT KNOWLEDGE EXCHANGE unifying the Saviynt forums, documentation, training, and more in a single search tool across platforms. Click HERE to read the Announcement.

Uploading Accounts and associated Entitlements using Schema Upload

Sahana_BB
New Contributor
New Contributor

Hi Team,

We are trying to Import Accounts  and associated Entitlements using Schema Upload in v2021, 

I have this SAV file(SN_Accounts.sav)

Sahana_BB_2-1664364883877.png

The data file is as follows (ServiceNow_Accounts_01.csv):

endpointname,ACCOUNTNAME,username,Permissions,status

Sahana_BB_3-1664365010836.png

 

The SAV and data files were loaded to the corresponding directories on the UI /Datafiles and /SAV

When the schema based import job is run with the below configuration:

 

Sahana_BB_5-1664365296962.png

 

 

the job history shows the below error:

Sahana_BB_6-1664365411117.png

 

Job ends up with error, and the data file (.csv) is being moved to the /Fail folder.

Is something wrong with the files ? 

Can anyone help me out if you have faced the same issue before or know something about it?

12 REPLIES 12

rushikeshvartak
All-Star
All-Star

Open csv file in notepad & check if any extra column exists 

Please share logs

https://saviynt.freshdesk.com/support/solutions/articles/43000431762-uploading-accounts-and-associat...


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

Hi Rushikesh,

Thanks for replying!

There are no extra columns in CSV file. And the number of attributes are same in both(csv and sav) the files.
Attaching the logs.

Can you remove all special character from file name

like ServiceNowAccounts01.csv

also update sav file

 


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

Hi Rushikesh,

Removed  special character from file name(csv file) and updated the Sav file as well. Observing same error after running the Job.

avinashchhetri
Saviynt Employee
Saviynt Employee

@Sahana_BB,

For a start, try and keep the column names same across both files.

avinashchhetri_0-1664460320259.png

Secondly, try and delete the existing job and re-create a new one and then try.

Lastly, download the logs from the import in a csv format and upload.

 

 

Regards,
Avinash Chhetri

Hi Avinash,

Thanks for replying!

1. Changed  the column name to endpointname and created a new job and tested, facing same error.

2. Downloaded the sample files from Freshdesk and updated the attribute values accordingly without doing any changes to the files and tested, again same error.

Here's the sav file(SNAccounts.sav) ,

Sahana_BB_0-1664519687893.png

Attaching csv and log files.

Change job name in api & dont keep _ also & attach sav file


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

Hey Rushikesh,

Changed job name in api & removed _ from Sav file name and Job name as well, still same error

Please share api screenshot from postman


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

@Sahana_BB,

Did you try deleting the job trigger and creating a new one ?

 

 

Regards,
Avinash Chhetri

jezzanuena
Regular Contributor
Regular Contributor

Hello! I have the same issues. Is this resolved? If yes, how?