Error when running DMT to approve Specification Revs

lairdl · June 17, 2021, 12:09pm

My file has 197 records, and 98 fail, I can 't figure out why. Anyone have any idea?

Table: SpecRev
Company=‘ATF’ SpecType=’’ SpecID=‘B15639191’ SpecRevNum=’(new)’ SysRowID=‘00000000-0000-0000-0000-000000000000’: ForeignKeyConstraint SpecHedSpecRev requires the child key values (ATF, , B15639191) to exist in the parent table.
2021-06-17T08:01:24 Company ATF SpecID B15640842 SpecRevNum R01 Failed to enable constraints. One or more rows contain values violating non-null, unique, or foreign-key constraints.

SteveFossey · June 17, 2021, 12:21pm

Do you have a plant column? Several DMTs don’t make it a requirement but in fact need it if records affect different plants in the same DMT.

lairdl · June 17, 2021, 12:24pm

Plant is not a field in the table, this is a list of all of the files in the SpecRev Table.

Matt_Belshaw · June 18, 2021, 4:10pm

Looks like a SQL issue rather than DMT. I am guessing there is a constraint on the specid field saying it’s mandatory to have data. Do the rows that fail have a specID?

lairdl · June 18, 2021, 5:32pm

From Epicor Support:

After testing this, the issue was found as a bug on DMT. Only odd rows are updated by DMT, records on even rows are marked as an error. This case is connected to open problem PRB0236328 and has been sent to development for review.