unable import dataset values with more than 10000 rows

[Saviynt_mar_IGA]

Hi,

We have an existing dataset with 16k rows and being used for computing data for dynamic attributes in application access request form.

We have request update this existing dataset with new mappings, so tried using csv upload with column names, however, getting 504 bad gateway error and upload file is fully not processed after reloading. Is there any solution available to import or update dataset when having more rows. Please suggest what can be the workaround solutions for our case.

Thanks,
Sampath

[Raghu]

it is expected only, try to split data and upload

Article for reference:

https://docs.saviyntcloud.com/bundle/EIC-Admin-v24x/page/Content/Chapter02-Identity-Repository/Updat...

[Saviynt_mar_IGA]

Hi @Raghu 

Thanks for the response, splitting is not giving desired outcome. as it is overwriting the previously uploaded rows.

Regards,
Sampath 

[Raghu]

yes its correct , it will over ride , you can divide multiple data sets and based on query join it and  fetch results , we dont have other option.

or assist saviynt team backed table insert.

[rushikeshvartak]

• Currently only 10000 is maximum limit.
• You need to make multiple dataset and use union in query to get data from multiple data sets 
• You can raise idea ticket to increase limit with business use case.
• showing 10000 values in one dynamic attributes may impact request form performance 

[Saviynt_mar_IGA]

Hi @rushikeshvartak 

Thank you for the inputs. we would check on to split dataset into multiple as per the suggestion.

Regards,
Sampath

[rushikeshvartak]

Please click the 'Accept As Solution' button on the reply (or replies) that best answered your original question.