Topic
  • 5 replies
  • Latest Post - ‏2012-09-10T12:38:08Z by ViswanathG
SystemAdmin
SystemAdmin
345 Posts

Pinned topic two question about MDM development

‏2011-04-21T13:05:22Z |
hello can some guy give your idea about the question, any suggestion will be appreciate.

1. we created an extension(MDMXOrgBObjExt) from ORG. And for some child object ex: orgname, when I send a request XML like
<TCRMTxType>searchThenAddOrUpdateOrg</TCRMTxType>
<TCRMTxObject>MDMBatch3DeltaLoadBObj</TCRMTxObject>
<TCRMObject>
<MDMBatch3DeltaLoadBObj>
<AdminSysKey>TEST000ORG01</AdminSysKey>
<AdminSysKeyType>1</AdminSysKeyType>
<TCRMOrganizationBObj>
<TCRMOrganizationNameBObj>
<OrganizationName>12222222</OrganizationName>
<NameUsageType>3</NameUsageType>
<SourceIdentifierType>2</SourceIdentifierType>
</TCRMOrganizationNameBObj>
</TCRMOrganizationBObj>
</MDMBatch3DeltaLoadBObj>

to add or update the Orgname child object, the service will failed:

2011-04-20 16:43:16,859 ORB.thread.pool : 0 ERROR com.dwl.tcrm.coreParty.controller.TCRMCorePartyTxnBean - 1056 INSERR 2303 Reindentifying suspects failed.
com.dwl.base.exception.DWLBaseException: Exception_DWLCommon_IncompatibleObjectsImmediate: CDKCS2012E:The following attribute in the object cannot be cloned. Object = gov.fdc.mdm.component.MDMXOrgBObjExt; attribute = MDMXOrgLastUpdateTxId

I don't attach anything about the extension part, I don't know there is wrong with MDMXOrgLastUpdateTxId.
then I add the Extension part make it like:

<TCRMTxType>searchThenAddOrUpdateOrg</TCRMTxType>
<TCRMTxObject>MDMBatch3DeltaLoadBObj</TCRMTxObject>
<TCRMObject>
<MDMBatch3DeltaLoadBObj>
<AdminSysKey>TEST000ORG01</AdminSysKey>
<AdminSysKeyType>1</AdminSysKeyType>
<TCRMOrganizationBObj>
<TCRMExtension>
<ExtendedObject>MDMXOrgBObjExt</ExtendedObject>
</TCRMExtension>
<TCRMOrganizationNameBObj>
<OrganizationName>12222222</OrganizationName>
<NameUsageType>3</NameUsageType>
<SourceIdentifierType>2</SourceIdentifierType>
</TCRMOrganizationNameBObj>
</TCRMOrganizationBObj>
</MDMBatch3DeltaLoadBObj>

and set the partyid and lastupdatedate in service, the service will run ok. but the MDMXOrgBObjExt will also be updated.

why will this happen?

2. according to transactionReferenceGuide:
A given billing summary can be associated with either a contract or a
contract component. A given contract or contract component can have one
or more associated billing summaries.

A contract can have more then one billingsummary,
but I try to add two billingsummary records to one contract, the first one is ok. the second one(different BillingStatusType)return that: Duplicate record already exists.

how should we add several billingsummary to one contract? you can see the request and response XML file in attachment.
Updated on 2012-09-10T12:38:08Z at 2012-09-10T12:38:08Z by ViswanathG
  • ViswanathG
    ViswanathG
    6 Posts

    Re: two question about MDM development

    ‏2012-07-26T09:24:29Z  
    Hi,

    I am facing same problem, If get the solution for this problem. Please help to resolve.

    Viswa
  • Sathiya123
    Sathiya123
    3 Posts

    Re: two question about MDM development

    ‏2012-09-07T05:58:54Z  
    Hi,

    I am facing same problem, If get the solution for this problem. Please help to resolve.

    Viswa
    Hi All,

    For BillingSummary table, Combination CONTRACT_ID, CONTRACTCOMPONEONT_ID and EFFECTIVEDATE are business keys for that table. You can't insert duplicate record with same CONTRACT_ID, CONTRACTCOMPONEONT_ID and EFFECTIVEDATE again.

    Hope it helps

    Sathiya
  • ViswanathG
    ViswanathG
    6 Posts

    Re: two question about MDM development

    ‏2012-09-07T15:00:03Z  
    Hi All,

    For BillingSummary table, Combination CONTRACT_ID, CONTRACTCOMPONEONT_ID and EFFECTIVEDATE are business keys for that table. You can't insert duplicate record with same CONTRACT_ID, CONTRACTCOMPONEONT_ID and EFFECTIVEDATE again.

    Hope it helps

    Sathiya
    Hi Sathiya,

    Thanks for your reply. I am getting "Duplicate record already exist." error message for the personname table also when I try to add smae name more than once.
    May I know the businessKeys for personname table.

    Thanks,
    Viswa
  • Sathiya123
    Sathiya123
    3 Posts

    Re: two question about MDM development

    ‏2012-09-10T05:20:40Z  
    Hi Sathiya,

    Thanks for your reply. I am getting "Duplicate record already exist." error message for the personname table also when I try to add smae name more than once.
    May I know the businessKeys for personname table.

    Thanks,
    Viswa
    For Personname, The following are business key,
    nameusagetype, GivenNameOne, GivenNameTwo, GivenNameThree, GivennameFour, PrefixType, Suffix

    Please refer V_ELEMENTATTRIBUTE table for business key fields .

    Hope it helps
    Regards,
    Sathiya
  • ViswanathG
    ViswanathG
    6 Posts

    Re: two question about MDM development

    ‏2012-09-10T12:38:08Z  
    For Personname, The following are business key,
    nameusagetype, GivenNameOne, GivenNameTwo, GivenNameThree, GivennameFour, PrefixType, Suffix

    Please refer V_ELEMENTATTRIBUTE table for business key fields .

    Hope it helps
    Regards,
    Sathiya
    Hi Sathiya,

    Thanks for your clarification.

    I forgot menction MDM versio which I am using. I am using MDM 9.0.2. I guess the above clarification which you given about business key for personname is applicable for MDM version 9.0.2 also.

    Thanks,
    Viswa