Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
BedrockMission!

Learn More

View all

Sign in to view all badges

ACS - Error when send transactional message with API

Avatar

Avatar
Validate 10
Level 3
eveline8
Level 3

Likes

24 likes

Total Posts

70 posts

Correct Reply

5 solutions
Top badges earned
Validate 10
Validate 1
Boost 5
Boost 3
Boost 10
View profile

Avatar
Validate 10
Level 3
eveline8
Level 3

Likes

24 likes

Total Posts

70 posts

Correct Reply

5 solutions
Top badges earned
Validate 10
Validate 1
Boost 5
Boost 3
Boost 10
View profile
eveline8
Level 3

13-06-2019

Hi,

I have a problem with transactional message.

We have set up a process with API and when we call the event to push the transactional message occurs this error:

“RST-360011 An error has occurred - please contact your administrator.

PGS-220000 PostgreSQL error: ERROR:  column r0.scuscity does not exist

LINE 1: ..., R0.iCusMonth, R0.iCusYear, R0.sCusCity...

^

HINT:  Perhaps you meant to reference the column "r0.scity".”

We had set the same process in stage instance and all worked fine.

The problem is that in prod instance we don't have the field cusCity in the profiles custom resource, in stage instance there is this field.

I saw in the Event Metadata that there is cusCity but I don't have this field in Profile custom resource.

Why there is this dissaligment? How can I solve the issue?

Thanks

E.

Accepted Solutions (1)

Accepted Solutions (1)

Avatar

Avatar
Validate 10
Level 3
eveline8
Level 3

Likes

24 likes

Total Posts

70 posts

Correct Reply

5 solutions
Top badges earned
Validate 10
Validate 1
Boost 5
Boost 3
Boost 10
View profile

Avatar
Validate 10
Level 3
eveline8
Level 3

Likes

24 likes

Total Posts

70 posts

Correct Reply

5 solutions
Top badges earned
Validate 10
Validate 1
Boost 5
Boost 3
Boost 10
View profile
eveline8
Level 3

25-06-2019

Hi,

we found the error. When we publish the custom resources we have to select "Update the Profiles and Services Ext API".

Thanks,

E.

Answers (3)

Answers (3)

Avatar

Avatar
Give Back 5
Employee
ramon_bisswange
Employee

Likes

243 likes

Total Posts

353 posts

Correct Reply

182 solutions
Top badges earned
Give Back 5
Give Back 3
Give Back 25
Give Back 10
Give Back
View profile

Avatar
Give Back 5
Employee
ramon_bisswange
Employee

Likes

243 likes

Total Posts

353 posts

Correct Reply

182 solutions
Top badges earned
Give Back 5
Give Back 3
Give Back 25
Give Back 10
Give Back
View profile
ramon_bisswange
Employee

14-06-2019

Can you check the schema for the real time event:

Adminsitration > Development > Diagnosis > Data Schemas

Does it reference the cusCity anywhere? Under rtEvent or profile?

And then same for the recipient extension

Avatar

Avatar
Give Back 5
Employee
ramon_bisswange
Employee

Likes

243 likes

Total Posts

353 posts

Correct Reply

182 solutions
Top badges earned
Give Back 5
Give Back 3
Give Back 25
Give Back 10
Give Back
View profile

Avatar
Give Back 5
Employee
ramon_bisswange
Employee

Likes

243 likes

Total Posts

353 posts

Correct Reply

182 solutions
Top badges earned
Give Back 5
Give Back 3
Give Back 25
Give Back 10
Give Back
View profile
ramon_bisswange
Employee

13-06-2019

Did you create the event/email from scratch in PROD or did you take it via package export from STAGE?

Avatar

Avatar
Validate 10
Level 3
eveline8
Level 3

Likes

24 likes

Total Posts

70 posts

Correct Reply

5 solutions
Top badges earned
Validate 10
Validate 1
Boost 5
Boost 3
Boost 10
View profile

Avatar
Validate 10
Level 3
eveline8
Level 3

Likes

24 likes

Total Posts

70 posts

Correct Reply

5 solutions
Top badges earned
Validate 10
Validate 1
Boost 5
Boost 3
Boost 10
View profile
eveline8
Level 3

14-06-2019

We create the event and the template from scratch in prod.