Resolution:
Environment:

TIBCO Product name and version: TIBCO Collaborative Information Manager 7.1.0
Operating System(s): All Operating Systems

Symptoms:

The CONTAINS column is empty in the generated export file.

Cause:

This is a result of misconfiguration.  Please refer to steps in Resolution section for details about the configuration that needs to be done.

Resolution:

If you are using "SubsetForDBDump" activity from wfin26catsynchdbdumpv2.xml (by setting &ltParameter direction="in" name="dbDump" type="string" eval="constant"&gtY</Parameter> in UpdateEventStartSync" activity of wfin26catsynchv6.xml workflow.), then you will need to pass the relationship names in this activity to get CONTAINS field populated with data. Here's an example of SubsetForDBDump activity with different relationship names:

&ltActivity Name="SubsetForDBDump">
        &ltAction&gtEvaluateSubset</Action>
        &ltDescription lang="en"&gtApply subset</Description>
        &ltParameter direction="in" type="string" eval="constant" name="eventState"&gtSUBSET</Parameter>
        &ltParameter direction="in" name="InDocument" type="document" eval="variable"&gtinDoc</Parameter>
        &ltParameter direction="in" name="VersionOption" type="string" eval="constant"&gtLATEST</Parameter>
        &ltParameter direction="in" name="RelationshipName" type="string" eval="constant"&gtVendor</Parameter
        &ltParameter direction="in" name="RelationshipName1" type="string" eval="constant"&gtAddress</Parameter>
        &ltParameter direction="in" name="RelationshipName2" type="string" eval="constant"&gtCustomer</Parameter>
        &ltParameter direction="out" name="OutRecordList" type="recordlist" eval="variable"&gtworkRecordList</Parameter>
</Activity>

Here Vendor, Address and Customer are the relationships defined in the master catalog.

Attachments:

None

References:

None

While exporting the data (Synchronization workflow), CONTAINS column is empty in the export file.