I'm creating a new Attestation, using 1IM version 7.0.3. The base objects are PersonWantsOrg.
When I create a case and click on 'View Object Details' I get the following exception:
2018-05-10 17:58:21.7179 ERROR (VI.WebRuntime.Communication.BaseRequestHandler):VI.Base.ViException: An exception has occurred while executing the form method F1_ctl00_Main_Main_ControlRef7_ContainerTemplate2_R0_ControlReferenceContainer2_Tab1_ctl00_T0_ctl00_Container15_Button1_Method. ---> VI.WebRuntime.WebRuntimeException: The primary key condition was violated in the collection DeserializedObjects.
at VI.WebRuntime.DbObjectStore.InsertRow(IDbObjectRow newRow)
at VI.WebRuntime.DbObjectStore.InsertFromXml(String serializedObjects, Int32 loadLimit, ColumnInsertValues insertValues)
at VI.WebRuntime.CCC_Web.ATT_AttestationCase_ViewObjects_Action1.Start()
at VI.WebRuntime.CCC_Web.VI_Attestation_AttestationCase_Information_ServerActionCall1.Start()
at VI.WebRuntime.CCC_Web.VI_Attestation_AttestationCase_Information.ServerActionCall1_Action(CursorControlInfo _cursorInfos)
at VI.WebRuntime.ActionQueue.RunActionQueue(Action firstAction)
at VI.WebRuntime.CallActionFormMethod.Execute(HttpContextBase context, IFormRenderPart renderPart)
at VI.WebRuntime.FormMethodHandler.ExecuteFormMethod(HttpContextBase context, String renderPartId, IDictionary`2 parameters, String clientId)
--- End of inner exception stack trace ---
at VI.WebRuntime.FormMethodHandler.ExecuteFormMethod(HttpContextBase context, String renderPartId, IDictionary`2 parameters, String clientId)
Using the debugger in WebDesigner with a breakpoint in ATT_AttestationCase_ViewObjects, I am able to grab the 'ReportContent' xml that is used to fill this DbObjectStore
In that xml I can see that there are indeed repetitions of the same objects:
<Table Name="PersonWantsOrg" Display="xxxxxxx, xxx - 4/9/2018 3:51:56 PM" Key="f20840e5-ddbf-41b0-aa8f-6f852eae7d19">
<Table Name="ESet" Display="Access to Pricing Data Repository" Key="326e346a-dd59-4d58-8e37-4e8f590473e1">
<Table Name="ITShopOrg" Display="ARC" Key="A176960F-8C86-44A8-840B-A203E9E204A9">
<Table Name="ITShopOrg" Display="ARC" Key="A176960F-8C86-44A8-840B-A203E9E204A9">
<Table Name="ITShopOrg" Display="Applications" Key="b5a38061-973b-41ed-a3eb-d6fb7a6d2e49">
<Table Name="ITShopOrg" Display="All Active Users" Key="1619f025-ce2f-47f6-a7a5-ca3f4f3c9bd1">
<Table Name="Person" Display="xxxxx, xxxxx (xxxxxx)" Key="8e16d218-73c3-4a20-b7ae-35800bea9553">
<Table Name="Person" Display="xxxxxxx, xxx (xxxxxxxx)" Key="ec3d0c2b-996b-433d-90f5-91d6883f5b26">
<Table Name="Person" Display="xxxxxxx, xxx (xxxxxxxx)" Key="ec3d0c2b-996b-433d-90f5-91d6883f5b26">
<Table Name="ShoppingCartOrder" Display="159 - xxxxxxx, xxx" Key="8437a1e2-5828-4e65-aa70-4ff006a4f38a">
Has anyone seen this before and is there a way to control what is put into this 'ReportContent' xml that is generated?
Thanks for your help!