Skip to Content
author's profile photo Former Member
Former Member

compound field- 'Unable to retrieve source records'

Hi all,

My Compound field is Contract price.

Iam in MDM 5.5.

I have created a Compound field and works fine when i import records manually with one record. But when i use automatic process I get a strucutral exception. Then opening the IM manually and selecting the file using Port option in Import status i get error the 'Contract price' is not mapped.

the Compound field-Contract price which i have created on right clicking is not present in soruce and the destination field-Contract price is not mapped to any source field.

So when now i manually right click again -create compund field-Contract price, I get error 'Unable to retrieve source records' .

I have mapped all the Non Qualifier and then only i right clicked and selected the COmpund field-Contract price for the first time. but, y its not creating in automatic process.

Any steps missing by me or some data issues?

Thanks ,


Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • author's profile photo Former Member
    Former Member
    Posted on Aug 18, 2011 at 05:05 AM

    Hi all,

    here is my scenario.

    I am importing qualified table along with main table.

    Qualified table initial value:

    Non Qualifier 1:X (type:text)

    Non Qualifier 2:Y (type:look up flat)

    Qualifier 1:currency

    Qualifier 2:Start date

    Qualifier 3:end date

    Both Non qualifier is a Display field.

    I mapped all Qualifier and Non Qualifier fields and then right click-compound field. This compound field is mapped to the destination field(Contract price).

    Here in Ist import i get with values as mentioned above and it is maintained in DM so it gets matched and process successfully.

    In 2nd import i get a different value in (Non Qualifier 1 : P). So, Now since this value is not maintained in DM,I need to Add this value and Map it on importing main table itself automatically.

    Is it possible?.

    Or Is it Mandate that all Non Qualfier values needs to maintained before importing main table.

    If this is the case then My Non Qualfier 1 is a text field and it gets value every time newly.

    i get an error with no COmpound field getting populated automatcically in source side and throws structural exception. On trying to import manually using Port option , Compound field is enabled but on clicking on it i get an error 'Unable to reterieve the source records'

    I expect all your valuable suggestion ...



    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.