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 답변들
2048 조회

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.

이 주제는 답변이 닫혔습니다.

최고의 답변: 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_prophet작성자

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.