New version of DMT loaded yesterday, on a 10.2.300.9 appserver. Other DMT imports work fine. (This is a new “post upgrade” problem for last weeks upgrade from 10.1.500)
Workforce Authorized User (SaleAuth) DMT template only has 4 columns (Company, SalesRepCode, DcdUserID and DefaultUser) and result is the same with first three or all four.
To test the issue - I cannot update using existing data in the table, nor can I add new records using valid data which works when I enter it via the UI.
The Error returned for each row when Add New and Update are selected, or just when Add New is selected:
2019-03-19T09:09:09 Company 200 SalesRepCode jrobinson DcdUserId ahuff Failed to enable constraints. One or more rows contain values violating non-null, unique, or foreign-key constraints.
Company=‘200’ SalesRepCode=‘jrobinson’ DcdUserID=’’ SysRowID=‘00000000-0000-0000-0000-000000000000’: ForeignKeyConstraint SalesRepSaleAuth requires the child key values (200, jrobinson) to exist in the parent table.
When only Update is selected, each row in the input file returns the error:
2019-03-19T09:10:32 Company 200 SalesRepCode jrobinson DcdUserId ahuff SaleAuth Row not found
Any DMT folks out there have a clue for me?