Technical Blog Post
Abstract
Relationship exists for the given organization and partner identities
Body
Have you ever tried to create a new AS2 Trading Partner (TP) and encountered the dreaded "Relationship exists for the given organization and partner identities" error message?
You're certain this is a new TP identifier but the error message indicates otherwise. Unfortunately, you'll have to open a new PMR with IBM to resolve this but let's gather the necessary data to expedite the resolution.
First, verify that a record exists for the given organization and TP identifier by executing a SQL query by going to the Admin Console and selecting Operations > System > Support Tools > SQL Manager . Then, execute the following statement:
SELECT * FROM AS2_TRADEPART_INFO WHERE ORG_AS2_ID = 'OrganizationAS2Identifier' AND PART_AS2_ID = 'PartnerAS2Identifier'
Replacing the OrganizationAS2Identifier and PartnerAS2Identifierwith the appropriate values for the partner with which you're encountering this error. Here's an example query and its results (click on the image to enlarge):
Since this query returned a result, the partner does in fact exist. The next step is to gather the data support needs by "dumping" the AS2 trading partner table. To do this, execute the following query:
SELECT * FROM AS2_TRADEPART_INFO
Then export the results to an xls file.
Zip the xls file along with your dump_info and attach this to your PMR. IBM will guide you or your Database Administrator through the process of correcting the trading partner record.
UID
ibm11121745