Controlling WKF table field length

Question

I have a schema with a string field of length 2100.

In enrichment, an expression field is added which does a substring of that field such as this: Substring(@recommendation, 101, Length(@recommendation)-100)

This is the error I get:

03/03/2020 12:01:29 PM enrich PostgreSQL error: ERROR: value too long for type character varying(255)

Which mean the WKF field is created with length of 255, while the source of that expression field is much longer than that.

Is there a way to define the length for the expression field or maybe controlling the WKF field length instead?

Jonathon_wodnicki · Accepted Answer

Hi,

This isn't possible with ordinary ootb query activities.

Alternative options in descending order of maintainability:

Use sql or js activity to alter the temp table's structure and populate it with substrings
Write substrings to a file then load them into workflow with Data loading (file) activity formatted with long text col
Create a permanent temp schema with big string col and in workflow truncate then use Update data activity to write substrings to it, with outgoing transition (replaces enrichment)
Create your own temp schema in the workflow in js with undocumented registerSchema(), setSchemaSqlTable(), buildSqlTable(), etc.

Thanks,

-Jon

Sign up

Login with SSO

Login to the community

Login with SSO

Scanning file for viruses.

This file cannot be downloaded