The Connector import complete but we receive the error in the logs, do we need to bring the adrline1 column into the adapter by itself as well?
Changes register item processing on failed.
Changes register item processing on connector Chris21 Work Address Connector failed with reason The column adrline1 is not a pre-existing column in adapter Chris21 Person (ba1a8cf9-e7af-42dd-b53f-34c0ca938221). Please check your configuration before continuing. Currently known fields: detnumber, dettitle, detsurname, detdatejnd, detg1name1, detg1name2, detg1name3, detprefnm, detpresurn, dettele, detbirdate, detsex, detcntrynm, detcitcd, detmarcd, detmardate, detemailad, detaltnbr, detabn, detbutton, detpaytype, detterdate, detalttele, detpasssur, detglbexp, terdate, terlstduty, terminated, archivedate, forarchive, lvetypecd, lvestart, lveend, posstart, posend, posholzone, posavhrwk, posalttitl, posstatus, posempocc, possupervis, poscostgrp, poslvegrp, pospdtreas, pospdtel, posdayswk, posl1cd, posl2cd, posl3cd, posl4cd, posl5cd, posindustry, posl1cdtrn, posl2cdtrn, posl3cdtrn, posl4cdtrn, posl5cdtrn, managerref, nextposstart, nextposend, nextposholzone, nextposavhrwk, nextposalttitl, nextposstatus, nextposempocc, nextpossupervis, nextposcostgrp, nextposlvegrp, nextpospdtreas, nextpospdtel, nextposdayswk, nextposl1cd, nextposl2cd, nextposl3cd, nextposl4cd, nextposl5cd, nextposl1cdtrn, nextposl2cdtrn, nextposl3cdtrn, nextposl4cdtrn, nextposl5cdtrn, nextposindustry, workadrline1, homeadrcntsur, homeadrcntname, homeadrcntrel, homeadrcntphon, homeadrline1, homeadrline2, homeadrsuburb, homeadrstate, homeadrcountry, homeadrpstcode, zsmcompany, zsmstartdt, zsmenddate, zsmexplnth, zsmchgrate, zsmreptnam, zsmscdmthr, zsmincity, erhstartdt, erhenddate, erhrstrcd, erhrstrcdtrn, erhoffsetd, erhreason, erhrwpdate, zadadmdate, zadexpdate, zadpromsa, zadovsad, zadgraddat, zadmerce2, zadpartner, zadexeccou, zadspeccou, zadjuricrt, zadovscrt, zadpraccrt, zadfedreg, zadcerttyp, zadsupres, zadmemnum, zadovschek, zadjurifrs, zadjursact, zadjursnsw, zadjursnt, zadjursqld, zadjurssa, zadjurstas, zadjursvic, zadjurswa, zadjursoth, zadadmaus, holidayGroup, OfficeCode, timeEntryCode, expertPersonnelTypeCode, ProfitCentreCode, ProfitCentreDescription, DeptCode, DeptDesc, PracticeGroup, GlbSupervisID. Duration: 00:00:34.6274624
Error details:
Unify.Product.IdentityBroker.AdapterColumnException: The column adrline1 is not a pre-existing column in adapter Chris21 Person (ba1a8cf9-e7af-42dd-b53f-34c0ca938221). Please check your configuration before continuing. Currently known fields: detnumber, dettitle, detsurname, detdatejnd, detg1name1, detg1name2, detg1name3, detprefnm, detpresurn, dettele, detbirdate, detsex, detcntrynm, detcitcd, detmarcd, detmardate, detemailad, detaltnbr, detabn, detbutton, detpaytype, detterdate, detalttele, detpasssur, detglbexp, terdate, terlstduty, terminated, archivedate, forarchive, lvetypecd, lvestart, lveend, posstart, posend, posholzone, posavhrwk, posalttitl, posstatus, posempocc, possupervis, poscostgrp, poslvegrp, pospdtreas, pospdtel, posdayswk, posl1cd, posl2cd, posl3cd, posl4cd, posl5cd, posindustry, posl1cdtrn, posl2cdtrn, posl3cdtrn, posl4cdtrn, posl5cdtrn, managerref, nextposstart, nextposend, nextposholzone, nextposavhrwk, nextposalttitl, nextposstatus, nextposempocc, nextpossupervis, nextposcostgrp, nextposlvegrp, nextpospdtreas, nextpospdtel, nextposdayswk, nextposl1cd, nextposl2cd, nextposl3cd, nextposl4cd, nextposl5cd, nextposl1cdtrn, nextposl2cdtrn, nextposl3cdtrn, nextposl4cdtrn, nextposl5cdtrn, nextposindustry, workadrline1, homeadrcntsur, homeadrcntname, homeadrcntrel, homeadrcntphon, homeadrline1, homeadrline2, homeadrsuburb, homeadrstate, homeadrcountry, homeadrpstcode, zsmcompany, zsmstartdt, zsmenddate, zsmexplnth, zsmchgrate, zsmreptnam, zsmscdmthr, zsmincity, erhstartdt, erhenddate, erhrstrcd, erhrstrcdtrn, erhoffsetd, erhreason, erhrwpdate, zadadmdate, zadexpdate, zadpromsa, zadovsad, zadgraddat, zadmerce2, zadpartner, zadexeccou, zadspeccou, zadjuricrt, zadovscrt, zadpraccrt, zadfedreg, zadcerttyp, zadsupres, zadmemnum, zadovschek, zadjurifrs, zadjursact, zadjursnsw, zadjursnt, zadjursqld, zadjurssa, zadjurstas, zadjursvic, zadjurswa, zadjursoth, zadadmaus, holidayGroup, OfficeCode, timeEntryCode, expertPersonnelTypeCode, ProfitCentreCode, ProfitCentreDescription, DeptCode, DeptDesc, PracticeGroup, GlbSupervisID ---> System.Collections.Generic.KeyNotFoundException: The given key was not present in the dictionary.
at System.Collections.Generic.Dictionary`2.get_Item(TKey key)
at Unify.Product.IdentityBroker.AdapterColumnSources.get_Item(GroupedNameValueCollectionKey column)
--- End of inner exception stack trace ---
at Unify.Product.IdentityBroker.AdapterColumnSources.get_Item(GroupedNameValueCollectionKey column)
at Unify.Product.IdentityBroker.EntityDistinguishedNameRelationMapperValueAdapterFactoryBase`1.<>c__DisplayClass25.<CalculatePossibleAffectedItems>b__11(IAttributeMappingInformation item)
at System.Linq.Enumerable.WhereSelectEnumerableIterator`2.MoveNext()
at System.Linq.Enumerable.WhereSelectEnumerableIterator`2.MoveNext()
at Unify.Product.IdentityBroker.AttributeMapper.MapAttributeValues(IEntity leftSideEntity, IEntity rightSideEntity)
at Unify.Product.IdentityBroker.EntityDistinguishedNameRelationMapperValueAdapterFactoryBase`1.<>c__DisplayClass27.<CalculatePossibleAffectedItems>b__19(<>f__AnonymousTypea`2 <>h__TransparentIdentifierb)
at System.Linq.Enumerable.<>c__DisplayClass12`3.<CombineSelectors>b__11(TSource x)
at System.Linq.Enumerable.WhereSelectEnumerableIterator`2.MoveNext()
at System.Linq.Buffer`1..ctor(IEnumerable`1 source)
at System.Linq.Enumerable.ToArray[TSource](IEnumerable`1 source)
at Unify.Product.IdentityBroker.EntityDistinguishedNameRelationMapperValueAdapterFactoryBase`1.CalculatePossibleAffectedItems(IEnumerable`1 affectedEntities, IAdapterColumnSources columnSources)
at Unify.Product.IdentityBroker.EntityDistinguishedNameRelationMapperValueAdapterFactoryBase`1.DetermineChangeTimes(IChangeDetectionTimeChangeReport report, DateTime lowerLimit, DateTime upperLimit, IAdapterColumnSources columnSources)
at Unify.Product.IdentityBroker.ChainedTransformationChangeProcessor.PublishChange(IEnumerable`1 changedEntities, DateTime changeProcessTime, ICollection`1 changeRecords)
at Unify.Product.IdentityBroker.ChainedTransformationChangeProcessor.ProcessChangeReport(IDictionaryTwoPassDifferenceReport`4 changesReport, DateTime changeProcessTime)
at Unify.Framework.Visitor.Visit[T](IEnumerable`1 visitCollection, Action`2 visitor)
at Unify.Product.IdentityBroker.ChangeReportProcessor.CreateAndProcessReport[T](ITransformationChangeProcessor[] adapterTransformationProcessors, IEnumerable`1 sourceEnumerable, DateTime changeTime, HashSet`1 invalidEntities, Action`2 addAction, Func`3 addCheck)
at Unify.Product.IdentityBroker.ChangeReportProcessor.ProcessReport(IChangeReportProcessingRequest request)
Hi André,
Did you check for existing instance of this issue? Please follow the resolution from http://voice.unifysolutions.net/topics/2675-unifyproductidentitybrokeradaptercolumnexception-the-column-erhrstrcdtrn-is-not-a-pre-existing/ (either discontinue use of v4.0.x, or install the available patch).
An FYI, a notice will be going out shortly about End of Product Life, so support for v4.0 will be ending (as per https://unifysolutions.jira.com/wiki/display/IDB/End+of+Product+Life+Policy).
Thanks.