Cast string data type

[MarcosPaz]

Hi all, I have a workflow with an enrichment activity where I add a string column (named "my_column" for example) . The issue is that this string has a length of 512 characters, and when I try to execute the workflow it gives me an error because the string is truncated to 256. How can I force to create that column in the working table with a varchar(512) data type? Any ideas?

This is the log:

ODBC error: [Microsoft][SQL Server Native Client 11.0][SQL Server]String or binary data would be truncated. SQLState: 22001
ODB-240000 ODBC error: [Microsoft][SQL Server Native Client 11.0][SQL Server]The statement has been terminated. SQLState: 01000
WDB-200001 SQL statement 'INSERT INTO wkf61909108_61_1 (sMy_column,iId) SELECT N'This is a proof' + Isnull(Replicate(N'X',512-len(N'This is a proof')),''), W0.iId FROM wkf61909108_60_1 W0 JOIN NmsRecipient R1 ON (R1.iRecipientId = W0.iId) WHERE ((R1.iRecipientId > 0 OR R1.iRecipientId < 0))' could not be executed.
SQL: -- Log: Creating table 'wkf61909108_61_1' DropTableIfExists 'wkf61909108_61_1'; CREATE TABLE wkf61909108_61_1( iId int Default 0, sMy_column nvarchar(255) );
SQL: INSERT INTO wkf61909108_61_1 (sMy_column,iId) SELECT N'This is a proof' + Isnull(Replicate(N'X',512-len(N'This is a proof')),''), W0.iId FROM wkf61909108_60_1 W0 JOIN NmsRecipient R1 ON (R1.iRecipientId = W0.iId) WHERE ((R1.iRecipientId > 0 OR R.iRecipientId < 0))

[SatheeskannaK · Accepted solution]

Hi @MarcosPaz,

You will not be able to have enrichment additional data to have more than 255 chars in ACS. Take a look at this community question on the same: https://experienceleaguecommunities.adobe.com/t5/adobe-campaign-standard/enrichment-not-able-to-crea...