Saviynt unveils its cutting-edge Intelligence Suite products to revolutionize Identity Security!
Click HERE to see how Saviynt Intelligence is transforming the industry.
Saviynt Copilot Icon

Issue with group_concat in preprocessor

deepa
New Contributor III
New Contributor III

We are facing issue with import when the length of the group_concat exceeds 225. When we try to import the data through CSV it works. Wondering What is the maximum length for group_concat? Is there any way to update it in Saviynt?

Regards,

Deepa.S

4 REPLIES 4

Raghu
All-Star
All-Star

@deepa  Based on column it will import, some of column 256 char and some of column have long length also support.

check Data analyzer table expend and click I symbol , you will get info of the column size's

 

Raghu_0-1716347034154.png

 

 


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

rushikeshvartak
All-Star
All-Star

"We are facing issue with import"  Please elaborate what type of import ?


Regards,
Rushikesh Vartak
If this helped you move forward, click 'Kudos'. If it solved your query, select 'Accept As Solution'.

deepa
New Contributor III
New Contributor III

We found the issue, it is because cp30 was of type tiny text though it said text in the DataAnalyzer.  We are working to reduce the size of the content to fit 255 charachters.

You can use any property post 51-65 to use longtext and considering future


Regards,
Rushikesh Vartak
If this helped you move forward, click 'Kudos'. If it solved your query, select 'Accept As Solution'.