Hello,
We are trying to create a 1-n join from Recipients to a small offer detail table and are having trouble with the join. Can anyone help? We've engaged our install consultants but they are having issues with it too.
this is a simple join to the recipient table off of Member Key and using the Offer ID as the primary key for this table.
We are able to add data and pull data in a query, but sedning deliveries (mail/email) fails at pulling the recipient. I recieve an error as follows:
An error occurred and the process has been stopped. Error while executing the method 'PrepareTargetImpl' of service 'nms:delivery'. The delivery cannot be started because the resources are not available. Please restart the analysis process It looks like the delivery cannot find the recipients. We are also having an issue deleting data from the table - it wants to deleted the full recipient record and not just the offer detail.
Here's our offer detail table
<element desc="Loan Preapproval Offer Details" label="LPA Offer Details" labelSingular="LPA Offer Detail"
name="lpaOfferDetails">
<key name="offerNumber">
<keyfield xpath="@offerNumber"/>
</key>
<!--Offer Attributes-->
<attribute label="Offer Number" name="offerNumber" type="string"/>
<attribute label="Member Key" name="memberKey" type="long"/> (link to recipients)
<attribute label="Offer ID" name="offerID" type="string"/> (primary key for this table)
<attribute label="Date Opened" name="dateOpened" type="date"/>
<attribute label="Date Closed" name="dateClosed" type="date"/>
<attribute label="Expiration Date" name="offerExpirationDate" type="date"/>
<attribute label="Offer Rate" name="offerRate" type="double"/>
<attribute label="Offer Amount" name="offerAmount" type="long"/>
<attribute label="Offer Term" name="offerTerm" type="long"/>
<!--Recipient Schema Link-->
<element advanced="false" externalJoin="true" label="Recipients" name="recipient"
revCardinality="unbound" revLabel="LPA Offer Detail" target="nms:recipient"
type="link">
<join xpath-dst="@memberKey" xpath-src="@memberKey"/>
</element>
</element>
</srcSchema>
Thank you in advance
Best,
Scott