We are delighted to share our new EIC Delivery Methodology for efficiently managing Saviynt Implementations and delivering quick time to value. CLICK HERE.

USER SAV File Modifications

WEG
New Contributor
New Contributor

Hello,  We modified an existing user csv and corresponding SAV file, combining delimited attributes in a single field to free up user attributes needed for a different use case.  We tested thoroughly in DEV and all works as expected.  In PROD the job errors out with:  

'Error in Users Import - Error while processing data: Column count doesn't match value count at row 1 '

We've verified column counts and names are correct in the SAV file and the extract and suspect that importing fewer columns is the issue - is there a configuration we missed or is this possibly something a Saviynt engineer needs to address?

Thank you.

5 REPLIES 5

Sivagami
Valued Contributor
Valued Contributor

Can you check when moving the changes to production, the SAV file was loaded successfully and you are able to see the changes?

Also the CSV file has new formatted data instead of the old format?

-Siva

WEG
New Contributor
New Contributor

Thanks for the response, Sivagami.   It appears that the SAV file is loaded.  The CSV is in a different format, not as many columns.  Log entries attached - seem to show the csv format is the issue, is there around this, we need to re-purpose the attributes?

Cheers

Share csv file headers & sav file


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

Manu269
All-Star
All-Star

@WEG few questions:

1. How the sav file and CSV file uploaded on eic? This is because we faced similar issue in past associated with permission.

2. Did the number and order of attributes got changed while migration? 

 

Regards
Manish Kumar
If the response answered your query, please Accept As Solution and Kudos
.

WEG
New Contributor
New Contributor

The SAV file and an example row of the CSV are attached.  I uploaded the SAV file (renamed from ProviderUSERS.sav) manually via File Directory.  The CSV was delivered by Rhapsody, our ETL tool that delivers several files to Saviynt.  The CSV is in a different order and has fewer columns.

Regards,

Bill