0
Answered

Unify.Product.IdentityBroker.AdapterColumnException: The column erhrstrcd.trn is not a pre-existing column in adapter

André van der Westhuizen 7 years ago in UNIFYBroker/Frontier ichris/chris21 updated by anonymous 7 years ago 4

Have migrated the IdB 4.0 configuration to a new test environment and almost for all the Connector Import All I receive a similar error, event though the connector import complete. I have check the configuration and the attribute is available in the connector and there is a transformation for the attribute in the adapter.

20161030,22:18:42,UNIFY Identity Broker,Change detection engine,Error,"Changes register item processing on failed.Changes register item processing on connector Chris21 Roster Connector failed with reason The column erhrstrcd.trn 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. Duration: 00:00:22.7662764
Error details:
Unify.Product.IdentityBroker.AdapterColumnException: The column erhrstrcd.trn 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 ---> 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)",Normal


Answer

Answer
Answered

I'm not sure when the fix was included in Identity Broker, but it doesn't appear to be an issue any longer. Either update to a later version (e.g. v4.1.x) or try the patch (I'll add another comment with the details).

Under review

Hi André,

I'm unable to reproduce, the import works fine for me with that set of configuration (replaced with CSV's).

If you edit the transformation (that has the erhrstrcd.trn field mapped), does the field correctly appear in the mapping drop down? It does for me.

Thanks.

Are you on the latest v4.0.x?

I have checked the field when I edit the transformation and it did appear correctly. HSF is currently running IdB 4.0.1.3 with IdB for Chris21 4.0.1.0.

The error is only for the initial load or first Import All, the error does not re-occur.

Answer
Answered

I'm not sure when the fix was included in Identity Broker, but it doesn't appear to be an issue any longer. Either update to a later version (e.g. v4.1.x) or try the patch (I'll add another comment with the details).