Projects

Epicor ERP 9
, ,
1

We are trying to setup a Project for Time Booking only. I have setup the Project and Phases in Project Entry and it saves without issue. But when we create a Test Booking in Time and Expense entry and submit, we then get the following error in Project Entry and we can no longer get into the Project -

Error Detail

Failed to enable constraints. One or more rows contain values violating non-null, unique, or foreign-key constraints.

Stack Trace

at System.Data.DataSet.FailedEnableConstraints()
at System.Data.DataSet.EnableConstraints()
at System.Data.DataSet.set_EnforceConstraints(Boolean value)
at System.Data.Merger.MergeDataSet(DataSet source)
at System.Data.DataSet.Merge(DataSet dataSet, Boolean preserveChanges, MissingSchemaAction missingSchemaAction)
at System.Data.DataSet.Merge(DataSet dataSet)
at Epicor.Mfg.Core.UserDataHandler.Load(DataSet udd, DataSet ds)
at Epicor.Mfg.Proxy.ProjectImpl.GetByID(String projectID)
at Epicor.Mfg.UI.Adapters.ProjectAdapter.GetByID(String projectID)
at Epicor.Mfg.UI.App.ProjectEntry.Transaction.GetByID(String projID)

If i query the project in the SQL DB it is there and so is the phase i setup.

Anyone got any ideas?

2

Did you create a WBS Phase Job? That is where you actually record the time into.

3

Yes i did, that is where the time was booked to. As soon as the booking happened, we could no longer open the Project in Entry or Tracker

4

This is really confusing the hell out of me. The fact that it is showing in the DB but not in EPICOR is weird :roll_eyes: