How do we link nms:delivery (on PostgreSQL) to recipientlookupfolder (on Snowflake) | Community
Skip to main content
M
Adobe Employee
MonikaAgAdobe Employee
Adobe Employee
May 20, 2024
Solved

How do we link nms:delivery (on PostgreSQL) to recipientlookupfolder (on Snowflake)

  • May 20, 2024
  • 1 reply
  • 625 views

17/05/2024 09:24:57 XSV-350122 An error occurred and the process has been stopped.
17/05/2024 09:24:57 XML-110018 Error while parsing XML string ''
17/05/2024 09:24:57 (1:1) : invalid document structure
17/05/2024 09:24:57 SOP-330011 Error while executing the method 'Prepare' of service 'nms:delivery'.
17/05/2024 09:24:57 SOP-330011 Error while executing the method 'PrepareMessage' of service 'nms:delivery'.
17/05/2024 09:24:57 SOP-330011 Error while executing the method 'PrepareMessageImpl' of service 'nms:delivery'.
17/05/2024 09:24:57 DLV-490000 An error occurred while executing rule 'HM KR Subject Legal Text'. Please ask the platform administrator 'Adobe Inc.' to check syntax and validity of this rule.
17/05/2024 09:24:57 SCR-160012 Javascript: error while evaluating script 'hmKRSubjectLegal'.
17/05/2024 09:24:57 Cannot load document of type 'hm:recipientLookupFolder' satisfying condition '([/@id] = '0')'.
17/05/2024 09:24:57 WDB-200011 The requested database record does not exist.
17/05/2024 09:24:57 OUNTRYCODE, R0.TSJOURNEYSTARTPAUSE, R0.TSJOURNEYENDPAUSE, R0.IEXECUTIONINSTANCEID, F1.SLABEL, E2.SLABEL FROM HmRecipientLookupFolder R0 JOIN XtkFolder F1 ON (F1.iFolderId = R0.iFolderId) JOIN NmsExtAccount E2 ON (E2.iExtAccountId = R0.iExecutionInstanceId) WHERE (R0.URECIPIENTLOOKUPFOLDERID = ?)' could not be executed.
17/05/2024 09:24:57 WDB-200001 SQL statement 'SELECT R0.URECIPIENTLOOKUPFOLDERID, R0.IMEMBERSHIPCLUB, R0.IFOLDERID, R0.IDISCOUNTCODESTOREENABLED, R0.TSLASTMODIFIED, R0.ISITEOK, R0.II1011_WELCOMEREMINDER, R0.TSLASTMODIFIEDSITESTATUS, R0.STIMEZONE, CONVERT_TIMEZONE('Europe/Berlin' , R0.STIMEZONE , current_timestamp()), R0.ILOCALTIMEOFFSET, R0.ILOCALENDDATEOFFSET, R0.IBRANDID, R0.SREPLYEMAIL, R0.ICLOSETOTIERVALUE, R0.ITIERTHRESHOLD, R0.ICLOSETOPLUSOFFERDURATION, R0.II875EXECUTIONORDER, R0.TSEARLIESTINACTIVITY, R0.SC

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 MonikaAg

Hi @_manoj_kumar_ ,

 

Yes, you are right, but that typology had a code which was referencing to recipientLookupFolder on Snowflake. I had created a link with recipientLookupFolder in extended schema of delivery and it worked. Initially the link was with old schema which was on PG (PostgreSql) recipientLookupPG. That's why it couldn't find the link while running the typology.

 

Thanks

Monika

1 reply

Manoj_Kumar
Community Advisor
Manoj_KumarCommunity Advisor
Community Advisor
May 20, 2024

Hello @monikaag 

Looks like there is some issue with the Typology rule "HM KR Subject Legal Text'". That would be the first place to start investigation.

Manoj  | https://themartech.pro
M
Adobe Employee
MonikaAgAdobe EmployeeAuthorAccepted solution
Adobe Employee
May 21, 2024

Hi @_manoj_kumar_ ,

 

Yes, you are right, but that typology had a code which was referencing to recipientLookupFolder on Snowflake. I had created a link with recipientLookupFolder in extended schema of delivery and it worked. Initially the link was with old schema which was on PG (PostgreSql) recipientLookupPG. That's why it couldn't find the link while running the typology.

 

Thanks

Monika

    Terms & ConditionsAccessibility statement

    Loading footer...