# Use SQL Server

**URL:** <https://discuss.epiforge.com/t/use-sql-server/28>\
**Category:** Extension Gallery\
**Created:** [February 25, 2020, 7:33pm UTC](https://discuss.epiforge.com/t/use-sql-server/28 "2020-02-25T19:33:34Z")\
**Posts on this page:** 1\
**Showing post:** 4

<div class="post-metadata">

**Author:** ![donvnielsen](https://avatars.discourse-cdn.com/v4/letter/d/e5b9ba/32.png) [@donvnielsen](https://discuss.epiforge.com/u/donvnielsen)\
**Post date:** [March 31, 2020, 4:10pm UTC](https://discuss.epiforge.com/t/use-sql-server/28/4 "2020-03-31T16:10:03Z")

</div>

I am getting the following error when activating Use SQL Server. I think it is trying to insert data out of sequence, inserting into ListValueProperties before the child value has been inserted in ListValues, maybe.

I see that WorkItems is completely populated. I expected to see ListValues and TextProperties to be fully populated. Time slices is not yet populated.

(I get the feeling I am going to be a thorn in your side.)

```auto
-- SqlException: The INSERT statement conflicted with the FOREIGN KEY constraint "FK_ListValues_ListValueProperties". The conflict occurred in database "Grindstone4", table "dbo.ListValueProperties", column 'Id'.
The statement has been terminated.
   at void System.Data.SqlClient.SqlConnection.OnError(SqlException exception, bool breakConnection, Action<Action> wrapCloseInAction)
   at void System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, bool breakConnection, Action<Action> wrapCloseInAction)
   at void System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, bool callerHasConnectionLock, bool asyncClose)
   at bool System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, out bool dataReady)
   at void System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, string resetOptionsString, bool isInternal, bool forDescribeParameterEncryption, bool shouldCacheForAlwaysEncrypted)
   at SqlDataReader System.Data.SqlClient.SqlCommand.CompleteAsyncExecuteReader(bool isInternal, bool forDescribeParameterEncryption)
   at object System.Data.SqlClient.SqlCommand.InternalEndExecuteNonQuery(IAsyncResult asyncResult, string endMethod, bool isInternal)
   at int System.Data.SqlClient.SqlCommand.EndExecuteNonQueryInternal(IAsyncResult asyncResult)
   at int System.Data.SqlClient.SqlCommand.EndExecuteNonQueryAsync(IAsyncResult asyncResult)
   at void System.Threading.Tasks.TaskFactory<TResult>.FromAsyncCoreLogic(IAsyncResult iar, Func<IAsyncResult, TResult> endFunction, Action<IAsyncResult> endAction, Task<TResult> promise, bool requiresSynchronization)
   at async Task Submission#0+SqlServerTransactor.ApplyChangesToSqlAsync(ChangeSet changes)
   at async Task Submission#0+SqlServerTransactor.ConnectToSqlServerAsync(string connectionString)
   at async Task Submission#0+SqlServerTransactor.ConnectToSqlServerAsync(string connectionString)
   at void Submission#0+<<<Initialize>>b__0_1>d.MoveNext()

```

---

_[View the full topic](https://discuss.epiforge.com/t/use-sql-server/28)._