Skip to content

Instantly share code, notes, and snippets.

@swaters86
Created July 13, 2015 20:43
Show Gist options
  • Save swaters86/21b93335ccd20c0ea62c to your computer and use it in GitHub Desktop.
Save swaters86/21b93335ccd20c0ea62c to your computer and use it in GitHub Desktop.
2015-07-13 12:48:43,009 | ERROR | DevExpress.Xpo.DB.Exceptions.UnableToCreateDBObjectException: Unable to create 'ForeignKey' 'FK_CG_Flex1Ticket_UDF_ForwardEmail'. Parent: 'CG_Flex1Ticket'. Error: Executing Sql 'alter table "dbo"."CG_Flex1Ticket" add constraint "FK_CG_Flex1Ticket_UDF_ForwardEmail" foreign key ("UDF_ForwardEmail") references "dbo"."CG_Principal"("OID") NOT FOR REPLICATION' with parameters '' exception 'System.Data.SqlClient.SqlException (0x80131904): There is already an object named 'FK_CG_Flex1Ticket_UDF_ForwardEmail' in the database.
Could not create constraint. See previous errors.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite)
at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at DevExpress.Xpo.DB.ConnectionProviderSql.<>c__DisplayClass2.<InternalExecSql>b__0()
at DevExpress.Xpo.Logger.LogManager.Log[T](String category, LogHandler`1 handler, MessageHandler`1 createMessageHandler)
at DevExpress.Xpo.DB.ConnectionProviderSql.InternalExecSql(IDbCommand command)
at DevExpress.Xpo.DB.ConnectionProviderSql.ExecSql(Query query)
ClientConnectionId:4c767f01-87ef-4f46-80ef-7f4eda9602a7' ---> DevExpress.Xpo.DB.Exceptions.SqlExecutionErrorException: Executing Sql 'alter table "dbo"."CG_Flex1Ticket" add constraint "FK_CG_Flex1Ticket_UDF_ForwardEmail" foreign key ("UDF_ForwardEmail") references "dbo"."CG_Principal"("OID") NOT FOR REPLICATION' with parameters '' exception 'System.Data.SqlClient.SqlException (0x80131904): There is already an object named 'FK_CG_Flex1Ticket_UDF_ForwardEmail' in the database.
Could not create constraint. See previous errors.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite)
at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at DevExpress.Xpo.DB.ConnectionProviderSql.<>c__DisplayClass2.<InternalExecSql>b__0()
at DevExpress.Xpo.Logger.LogManager.Log[T](String category, LogHandler`1 handler, MessageHandler`1 createMessageHandler)
at DevExpress.Xpo.DB.ConnectionProviderSql.InternalExecSql(IDbCommand command)
at DevExpress.Xpo.DB.ConnectionProviderSql.ExecSql(Query query)
ClientConnectionId:4c767f01-87ef-4f46-80ef-7f4eda9602a7' ---> System.Data.SqlClient.SqlException: There is already an object named 'FK_CG_Flex1Ticket_UDF_ForwardEmail' in the database.
Could not create constraint. See previous errors.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite)
at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at DevExpress.Xpo.DB.ConnectionProviderSql.<>c__DisplayClass2.<InternalExecSql>b__0()
at DevExpress.Xpo.Logger.LogManager.Log[T](String category, LogHandler`1 handler, MessageHandler`1 createMessageHandler)
at DevExpress.Xpo.DB.ConnectionProviderSql.InternalExecSql(IDbCommand command)
at DevExpress.Xpo.DB.ConnectionProviderSql.ExecSql(Query query)
--- End of inner exception stack trace ---
at DevExpress.Xpo.DB.ConnectionProviderSql.ExecSql(Query query)
at DevExpress.Xpo.DB.ConnectionProviderSql.ExecuteSqlSchemaUpdate(String objectTypeName, String objectName, String parentObjectName, String textSql)
--- End of inner exception stack trace ---
at DevExpress.Xpo.DB.ConnectionProviderSql.ExecuteSqlSchemaUpdate(String objectTypeName, String objectName, String parentObjectName, String textSql)
at DevExpress.Xpo.DB.ConnectionProviderSql.CreateForeignKey(DBTable table, DBForeignKey fk)
at DevExpress.Xpo.DB.ConnectionProviderSql.ProcessUpdateSchema(Boolean skipIfFirstTableNotExists, DBTable[] tables)
at DevExpress.Xpo.DB.DataStoreSerializedBase.UpdateSchema(Boolean dontCreateIfFirstTableNotExist, DBTable[] tables)
at DevExpress.Xpo.DB.ConnectionProviderSql.UpdateSchema(Boolean dontCreateIfFirstTableNotExist, DBTable[] tables)
at DevExpress.Xpo.DB.DataStoreForkBase.UpdateSchema(Boolean dontCreateIfFirstTableNotExist, DBTable[] tables)
at DevExpress.Xpo.ThreadSafeDataLayer.UpdateSchema(Boolean dontCreate, XPClassInfo[] types)
at DevExpress.Xpo.SimpleObjectLayer.UpdateSchema(Boolean dontCreateIfFirstTableNotExist, XPClassInfo[] types)
at DevExpress.Xpo.Session.UpdateSchema(Boolean dontCreateIfFirstTableNotExist, XPClassInfo[] types)
at DevExpress.Xpo.Helpers.ObjectCollectionLoader.PrepareLoadObjects(ObjectsQuery[] queries)
at DevExpress.Xpo.Helpers.ObjectCollectionLoader.LoadObjects(ObjectsQuery[] queries)
at DevExpress.Xpo.SimpleObjectLayer.LoadObjects(Session session, ObjectsQuery[] queries)
at DevExpress.Xpo.SimpleObjectLayer.GetObjectsByKey(Session session, ObjectsByKeyQuery[] queries)
at DevExpress.Xpo.Session.<>c__DisplayClass3a.<GetObjectByKey>b__38()
at DevExpress.Xpo.Logger.LogManager.Log[T](String category, LogHandler`1 handler, MessageHandler`1 createMessageHandler)
at DevExpress.Xpo.Session.GetObjectByKey(XPClassInfo classInfo, Object id, Boolean alwaysGetFromDb)
at DevExpress.Xpo.Session.GetObjectByKey(Type classType, Object id, Boolean alwaysGetFromDb)
at XPOPersistenceService.XPOPersistenceManager.GetObjectForEdit(IUserSession uSession, IUnitOfWork unitOfWork, Type entityType, Int32 key)
at ApplicationServices.EntityHandlers.EntityHandler.GetObjectForEdit(IUserSession uSession, IUnitOfWork unitOfWork, Type entityType, Int32 key)
2015-07-13 12:48:43,112 | ERROR | Utilities.Exceptions.YaminException: A_GET_OBJECT_FOR_EDIT_FAILED
2015-07-13 12:49:30,626 | INFO | Cannot find user NT AUTHORITY\IUSR in the system
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment