DMA 7.1(3) and missing key

Unanswered Question
Oct 22nd, 2009

I'm trying to track this DMA error down, would I use SQL Enterprise Manager to track it down?

***> DATA PROCESSING TESTS REVEALED AN ISSUE WHICH GENERATED THE FOLLOWING EVENT:

The error number is: [-691]

The error message is: [-691 Missing key in referenced table for referential constraint

]

The following additional event information is available:

This record was not processed because another record it needs,

(see reference name listed below), is missing. This likely may be due to a previous error

already reported in the log above, or the result of Directory Services Export issues

reported separately, or due to missing Product, Locale, or other add-on definition CSV

files that should exist on the source system but do not.

SUGGESTED ACTION: Resolve all prior reported issues. If none, look at the Suspected Field,

if listed, for an indication of what data reference could not be resolved. Some hints:

- if ...DirGroup related, check for a Directory Export failure

- if ...Locale related, check for a missing Locale Plug-In

Re-execute DMA when all other issues are addressed.

Suspected Field/Item Is [DMABack_Admin.fk_enduserdevicemap_fkenduser]

TABLE NAME IS [EndUserDeviceMap ]

defaultprofile 'F'

description ''

fkdevice '5afcaa0b-775c-4274-b91c-4710dc46beae'

fkenduser '8ab29d17-e305-4bb2-bc2a-4566e2f58a9b'

pkid '4ecaccd8-c242-4b20-86f5-7402e3cd2cd2'

tkuserassociation 5

I have this problem too.
0 votes
  • 1
  • 2
  • 3
  • 4
  • 5
Overall Rating: 0 (0 ratings)
Loading.

Actions

This Discussion