"No query results returned" error message in Data Manager

[Former Member]

Hi,

We have a few records stuck in several workflows.

They have been checked out and we need to delete the WF to be able to have the records checked in again.

When trying to delete the WF we get the error message saying

"No query results returned"

We have found the following errors in our Oracle DB:

ERROR CODE=2292 ||| ORA-02292: integrity constraint (xxxx) violated - child record found

It seems that table A2i_1 has a parent-child relationship with A2I_1_431 with constraint name F1_431_ID.

How can I find what tabled in MDM these are?

Why can this problem have arisen? We have moved MDM to a new server landscape.

KR,

Thomas

[former_member204080 · Accepted solution]

Hi Thomas,

What is the version of MDM

Please have a check on below note

1587095 - Deletion of a MDM main table record fails

[Former Member · Accepted solution]

Hi and thank you,

We are running MDM 7.1 SP14.

The error occurs when we try to check in records at the end of a workflow.

We are not trying to delete any main table record.

We are not using Java API, and the workflow is triggered by record Import.

I see that the problem reffered to in the note you mention was solved in previous versions of MDM.

KR,

Thomas