PGS-220000 PostgreSQL error: ERROR: function substr(integer, integer, integer) does not exist LINE 1: ...0.ts4, W0.ts9, W0.ts11, W0.ts10, W0.ts12, W0.ts6, substr(W0.... ^

Forum|Forum|2 years ago
September 27, 2023
2 replies
2039 views

Hi, how to debug this error?

I was tasked with adding a new column to a table. So I:

1.- Modified the XML of the schema to add this new column (attribute).
2.- Updated DB Structure.
3.- Configure fields on the Load activity.
4.- Add the new field in the Update activity (Destination and Source Expression).

What does it mean?

Edit: I didn't find the reason. But exporting the pacakge , that was working from Production to Development, solve this.

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

Best answer by Manoj_Kumar

Hello @god_prophet

You are trying to ingest an integer value in a String column.

To fix the issue, use ToString(@COLUMN_NAME) in the update data activity.

ParthaSarathy

Community Advisor

Hi @god_prophet ,

Share the screenshot of Update data activity where you had configured substring function.

Syntax of substring is Substring(<string>,<offset> ,<length> )

Example,

Substring(@StringTypeAttributeName,1 ,1 )

~ ParthaSarathy S~ Click here to join ADOBE CAMPAIGN USER GROUP for Quarterly In-person | Hybrid | Virtual Meetups

G

god_prophetAuthor

Level 6

Please, see edit 1.

There is not SubString function applied, not by me. Just added the last highlighted field.

ParthaSarathy

Community Advisor

@god_prophet , So just after adding the 'yellow highlighted' field in update data activity, you're getting error?

Check what is the data type of that field in your schema.

Then select 'display target' in the inbound transition of update data activity, In top left navigate to 'Schema' tab. Click on your field and in bottom you can see the data type of it. This data type should be same as the data type of your schema.