AnsweredAssumed Answered

Record count mismatch between object table and odf_ca custom attribute tab

Question asked by beekerc2 on Dec 4, 2009
Latest reply on Dec 5, 2009 by Dave
There's probably a simple explanation to this, so I'd like to confirm an assumption with other users.  I created some custom attributes on the task object which live in the ODF_CA_TASK table.   There should be a 1:1 relationship between records in that table and PRTASK with each pair sharing the same ID value to link them together, in this case PRTASK.PRID = ODF_CA_TASK.ID.   However, when I did a records count, I found 261 records in PRTASK and 266 records in ODF_CA_TASK.   The only thing I can think of is if there were tasks deleted but not through the GUI, however i'm the only one with access to the database and i know i didn't do that.   I believe, and I confirmed that when you delete an object record (in the GUI, or via XOG) the matching ODF_CA records containing the custom attributes also gets deleted too.  Should I be concerned about this mismatch.Has anyone seen anything like this?   and if so, were there any data integrity ramifications?Thanks

Outcomes