# Projects

**URL:** <https://www.epiusers.help/t/projects/114733>\
**Category:** Epicor ERP 9\
**Tags:** kinetic, projects, epicor\
**Created:** [May 16, 2024, 9:24am UTC](https://www.epiusers.help/t/projects/114733 "2024-05-16T09:24:22Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![Daniel\_White](https://www.epiusers.help/user_avatar/www.epiusers.help/daniel_white/32/51550_2.png) [@Daniel\_White](https://www.epiusers.help/u/Daniel_White)\
**Post date:** [May 16, 2024, 9:24am UTC](https://www.epiusers.help/t/projects/114733/1 "2024-05-16T09:24:22Z")

</div>

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?

---

<div class="post-metadata">

**Author:** ![Ernie](https://www.epiusers.help/user_avatar/www.epiusers.help/ernie/32/69401_2.png) [@Ernie](https://www.epiusers.help/u/Ernie)\
**Post date:** [May 16, 2024, 12:43pm UTC](https://www.epiusers.help/t/projects/114733/2 "2024-05-16T12:43:15Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![Daniel\_White](https://www.epiusers.help/user_avatar/www.epiusers.help/daniel_white/32/51550_2.png) [@Daniel\_White](https://www.epiusers.help/u/Daniel_White)\
**Post date:** [May 16, 2024, 12:48pm UTC](https://www.epiusers.help/t/projects/114733/3 "2024-05-16T12:48:35Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![Daniel\_White](https://www.epiusers.help/user_avatar/www.epiusers.help/daniel_white/32/51550_2.png) [@Daniel\_White](https://www.epiusers.help/u/Daniel_White)\
**Post date:** [May 20, 2024, 11:32am UTC](https://www.epiusers.help/t/projects/114733/4 "2024-05-20T11:32:03Z")

</div>

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