This discussion has been locked.
You can no longer post new replies to this discussion. If you have a question you can start a new discussion

Enable constraints 2, stuck DBQueue operation

Hi all,

I'm using v 7.1

Eveytime I try to extend che 1IM schema with a new view or table, there is this operation "Enable constraints 2" in the DBQueue who needs to be executed before I can proceed, but this operation is stucked and won't be executed. I solved this "killing" the operation with Management Studio deleting it from the QBMDBQueueCurrent table, but I think there is a reason why it is there. What "Enable constraints 2" does and how can I prevent to blocking my system?

This happen only in the develop environment. If I remove the operation from the queue, extend the schema and transport with a change label the changes to test and production, the "Enable constraints 2" operation is ran with success and in few moments.

Parents
  • I found that for some reason BaseTreeCollectionF had some UID_Org which were not present in BaseTreeCollection. I removed those UID_Orgs and then the alter table command ran fine.

    I'm now getting similar errors in other basetree tables and I suspect somehow the other basetree tables have got data which isn't present in the parent basetree table. I'm removing these entries - so it looks like a data issue
Reply
  • I found that for some reason BaseTreeCollectionF had some UID_Org which were not present in BaseTreeCollection. I removed those UID_Orgs and then the alter table command ran fine.

    I'm now getting similar errors in other basetree tables and I suspect somehow the other basetree tables have got data which isn't present in the parent basetree table. I'm removing these entries - so it looks like a data issue
Children
No Data