Unable to retrieve unique values for field ... Server error:Field not found

[Former Member]

Hello Colleague

We periodically have got this error message "Unable to retrieve unique values for field ... Server error:Field not found" during the import.

Next data structire realized

main->attributes->priznaks(multivalued=MV)

where are:

main - main table

attributes - tuple with 2 fields

priznaks - multivalued tuple with 3 fields

attributes:

class(DF) - hierarchy table

priznaks(MV) - multivalued tuple priznaks

priznaks:

Code(text,DF)

ValueCode(text,DF)

ValueName(text, DF)

when we try to import some record to main we are filling our tuples:

Class link to attributes->Class

Code link to priznaks-Code

ValueCode link to priznaks-ValueCode

ValueName link to priznaks-ValueName

One record in main table has one class and many specific attributes and it values

but somtimes when we try to link code,ValueCode or ValueName to destignation fields we have got error message declared abowe

Could you, colleagues, explain to me root cause of this problem?

and maybe propose same alternative solution?

Regards

Kanstantsin Chernichenka

Edited by: kanstantsin_ch on Dec 13, 2011 12:20 PM

Little bit more information

SAP MDM Server 7.1.07.245

We are using automatic import(MDIS) and block structural exception set to "No"

Sometimes exception is happen and when we load import manager for fix

We get error message "Unable to retrieve unique values for field "..." Server error:Field not found"

Than we update map - remap that 3 fileds and get error for each of them

than try to do import

import operation has finished successfully

but why we periodically have got this error?

i hope this information may help to answer my question....

Regards

Kanstantsin Chernichenka

Edited by: kanstantsin_ch on Dec 14, 2011 6:30 AM

[Former Member]

Hi,

In the import map, try maintaining the tuple update (Unique) field for both the tuples attributes & priznaks

Also try maintaining unique fields in both the tuples

Regards,

Antony

Edited by: A.Antony vivekprasanna on Dec 14, 2011 12:36 PM