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

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
Honored Contributor
Honored Contributor

@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 you find the response useful, kindly consider selecting Accept As Solution and clicking on the kudos button.

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 you find the response useful, kindly consider selecting Accept As Solution and clicking on the kudos button.