ACS - Error when send transactional message with API | Community
Skip to main content
eveline8
eveline8
Level 4
June 13, 2019
Solved

ACS - Error when send transactional message with API

  • June 13, 2019
  • 4 replies
  • 6998 views

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.

    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 eveline8

    Hi,

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

    Thanks,

    E.

    4 replies

    B
    Adobe Employee
    bisswangAdobe Employee
    Adobe Employee
    June 13, 2019

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

      eveline8
      eveline8Author
      Level 4
      June 14, 2019

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

      B
      Adobe Employee
      bisswangAdobe Employee
      Adobe Employee
      June 14, 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

        eveline8
        eveline8AuthorAccepted solution
        Level 4
        June 25, 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.

        Terms & ConditionsAccessibility statement

        Loading footer...