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

[MonikaAg]

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

[Manoj_Kumar_]

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.

[MonikaAg · Accepted solution]

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