000029326 - Unexpected error when saving related application in application builder

Document created by RSA Customer Support Employee on Jun 15, 2016Last modified by RSA Customer Support Employee on Apr 22, 2017
Version 2Show Document
  • View in full screen mode

Article Content

Article Number000029326
Applies ToRSA Product Set: Archer
RSA Product/Service Type: Archer
RSA Version/Condition: 5.5 SP1
Platform: Windows
Platform (Other): null
O/S Version: Customer doesn't know/not sure-see notes
Product Name: null
Product Description: null
IssueGrid items do not display in record. 
Note that the log entry came 14 minutes after the reference time.

Archer.NET 0 The INSERT statement conflicted with the FOREIGN KEY constraint "FK_tblFieldSortOption_tblSort". The conflict occurred in database "20201", table "dbo.tblSort", column 'sort_type_id'. The statement has been terminated. SQL statement: usp_ui_field_sort_option @userToken = 'EB566CC0F969B2D5908E3F517B94FAB4', @fieldId = 15851, @fieldSortXML = '<ROOT><V a="I" b="20698" c="1" d="1" /><V a="I" b="2825" c="2" d="1" /><V a="I" b="116" c="3" d="1" /></ROOT>', @date = '1/6/2015 7:05:51 PM' /LM/W3SVC/1/ROOT-1-130650048050831082 ArcherTech.Kernel.Utility.Data.ArcherDbException, ArcherTech.Kernel, Version=5.5.10200.1011, Culture=neutral, PublicKeyToken=null The INSERT statement conflicted with the FOREIGN KEY constraint "FK_tblFieldSortOption_tblSort". The conflict occurred in database "20201", table "dbo.tblSort", column 'sort_type_id'. The statement has been terminated. SQL statement: usp_ui_field_sort_option @userToken = 'EB566CC0F969B2D5908E3F517B94FAB4', @fieldId = 15851, @fieldSortXML = '<ROOT><V a="I" b="20698" c="1" d="1" /><V a="I" b="2825" c="2" d="1" /><V a="I" b="116" c="3" d="1" /></ROOT>', @date = '1/6/2015 7:05:51 PM' ArcherTech.Kernel at ArcherTech.Kernel.Utility.Data.ArcherSqlDatabase.WrapDatabaseCall(DbCommand command, Action methodToWrap) at ArcherTech.Kernel.Utility.Data.ArcherSqlDatabase.ExecuteNonQuery(DbCommand command) at ArcherTech.Kernel.DataSource.Db.FieldSortOptionDataSource.Save(Int32 referenceFieldId, IList`1 sortFieldOperationContainer) at ArcherTech.Kernel.Brokers.RelatedRecordFieldDefinitionBrokerHelper.<>c__DisplayClass2.<SaveInternalTransactionOptional>b__1() at ArcherTech.Kernel.Brokers.RelatedRecordFieldDefinitionBrokerHelper.SaveInternalTransactionOptional(FieldContainerBase fieldContainer, FieldSaveOptions saveOptions, Boolean useTransaction) at ArcherTech.Kernel.Brokers.FieldDefinitionBrokerHelperBase.WrapValidate(FieldContainerBase fieldContainer, Level level, FieldSaveOptions saveOptions, FieldSave fieldSave) at ArcherTech.Kernel.Brokers.FieldDefinitionBrokerHelperBase.Save(FieldContainerBase fieldContainer, Level level, FieldSaveOptions saveOptions) at ArcherTech.Kernel.Brokers.BrokerBase.<>c__DisplayClass11`1.<SaveWithUniqueNameAlias>b__f() at ArcherTech.Kernel.Brokers.BrokerBase.CheckUniqueConstraint(Action deleg) at ArcherTech.Kernel.Brokers.BrokerBase.SaveWithUniqueNameAlias[T](Func`2 saveFunction, T domainObject, Func`1 getNameFunction, Func`1 getAliasFunction, Func`2 setNameFunction, Func`2 setAliasFunction, Boolean createUniqueNameAlias) at ArcherTech.Kernel.Brokers.FieldDefinitionBroker.SaveInternal(FieldContainerBase fieldContainer, Level level, FieldSaveOptions saveOptions) at ArcherTech.Kernel.Brokers.FieldDefinitionBroker.Save(FieldContainerBase fieldContainer) at ArcherTech.Kernel.Managers.FieldDefinitionManager.Save(SessionContext sessionContext, FieldContainerBase fieldContainer)
CauseThe sorting for the related was corrupt. The related grid had 3 sorts set up. 
ResolutionOnce the sorts were removed, then redone. The application worked properly.

Attachments

    Outcomes