1. UNIFYBroker Forum
  2. Bugs
0
Fixed

An import to Identity Broker fails due to a NullReferenceException

Bob Bradley 12 years ago • updated by anonymous 9 years ago • 18

The inclusion of a Relational.Composite adapter tranformation causes a FIM-instigated full import (adapter) to fail with the following exception:

Log Name:      UNIFY.IdB.PeopleSoft
Source:        Adapter get all entities for adapter failed.
Date:          3/10/2012 11:50:00 AM
Event ID:      0
Task Category: None
Level:         Warning
Keywords:      Classic
User:          N/A
Computer:      D-OCCCP-AS001.dbb.local
Description:
Error occurred in module: Adapter

Adapter get all entities for adapter 5db0f5e1-a032-450a-9415-fa4863f171da failed with reason Object reference not set to an instance of an object.. Duration: 00:00:40.8116688
Error details:
System.NullReferenceException: Object reference not set to an instance of an object.
   at Unify.Framework.ArrayEqualityComparer`1.GetHashCode(T[] obj)
   at Unify.Framework.MultiKeyValue.GetHashCode()
   at System.Collections.Generic.GenericEqualityComparer`1.GetHashCode(T obj)
   at System.Linq.Set`1.InternalGetHashCode(TElement value)
   at System.Linq.Set`1.Find(TElement value, Boolean add)
   at System.Linq.Set`1.Add(TElement value)
   at System.Linq.Enumerable.<DistinctIterator>d__7a`1.MoveNext()
   at System.Linq.Enumerable.Count[TSource](IEnumerable`1 source)
   at Unify.Repository.EntityExpressionQueryVisitor`3.CreateMultiValueRangeExpression(IMultiKey`1 multiKey, IEnumerable`1 sourceValueList, IQueryable`1 sourceQueryable)
   at Unify.Repository.EntityExpressionQueryVisitor`3.VisitMethodWhereWithMultiValueEnumerableContains(MethodCallExpression expression)
   at Unify.Repository.EntityExpressionQueryVisitor`3.VisitMethodCall(MethodCallExpression m)
   at Unify.Framework.ExpressionVisitorBase`11.Visit(Expression exp)
   at Unify.Framework.LinqContextConversionExpressionVisitorBase`5.ConvertExpression(Expression partitionExpression)
   at Unify.Framework.LinqQueryConversionProvider`5.GetOrderedQuery(Expression businessExpression, IQueryable`1 sourceQueryable, TContext sourceContext)
   at Unify.Framework.LinqWhereQuery`5.EvaluateQuery(TContext context)
   at Unify.Framework.LinqWhereQuery`5.GetEnumerator()
   at System.Linq.Lookup`2.Create[TSource](IEnumerable`1 source, Func`2 keySelector, Func`2 elementSelector, IEqualityComparer`1 comparer)
   at System.Linq.Enumerable.ToLookup[TSource,TKey](IEnumerable`1 source, Func`2 keySelector)
   at Unify.Framework.EntityCompositeKeyDistinguishedNameStaticRelationValueAdapterBase.Transform(IEnumerable`1 sourceValue)
   at Unify.Framework.ChainValueAdapter`3.Transform(TBaseValue baseValue)
   at System.Linq.Enumerable.<>c__DisplayClass12`3.<CombineSelectors>b__11(TSource x)
   at System.Linq.Enumerable.WhereSelectEnumerableIterator`2.MoveNext()
   at Unify.Framework.EnumerableExtensions.<ActionOnLast>d__16`1.MoveNext()
   at System.Linq.Enumerable.<SelectManyIterator>d__14`2.MoveNext()
   at Unify.Framework.EnumerableExtensions.<ActionOnLast>d__16`1.MoveNext()
   at System.Linq.Enumerable.<SelectManyIterator>d__14`2.MoveNext()
   at Unify.Framework.EnumerableExtensions.<ActionOnFirst>d__1c`1.MoveNext()
   at System.Linq.Enumerable.WhereSelectEnumerableIterator`2.MoveNext()
   at Unify.Framework.ActionOnExceptionEnumerator`1.MoveNext()
   at Unify.Framework.EnumerableExtensions.<ActionOnLast>d__16`1.MoveNext()
   at System.Linq.Enumerable.WhereSelectEnumerableIterator`2.MoveNext()
   at System.Linq.Enumerable.<SelectManyIterator>d__14`2.MoveNext()
   at System.Linq.Enumerable.<ConcatIterator>d__71`1.MoveNext()
   at Unify.Framework.LDIFComponentFileGenerator`1.GenerateFile(TextWriter writer, IEnumerable`1 entries)
   at Unify.Framework.LDIFAdapter.<>c__DisplayClass7`1.<CreateLDIFComponentStream>b__6(Stream stream)
   at Unify.Framework.LazyEvaluationStream.Evaluate(Object obj)
Event Xml:
<Event xmlns="http://schemas.microsoft.com/win/2004/08/events/event">
  <System>
    <Provider Name="Adapter get all entities for adapter failed." />
    <EventID Qualifiers="0">0</EventID>
    <Level>3</Level>
    <Task>0</Task>
    <Keywords>0x80000000000000</Keywords>
    <TimeCreated SystemTime="2012-10-03T01:50:00.000000000Z" />
    <EventRecordID>1364406</EventRecordID>
    <Channel>UNIFY.IdB.PeopleSoft</Channel>
    <Computer>D-OCCCP-AS001.dbb.local</Computer>
    <Security />
  </System>
  <EventData>
    <Data>Error occurred in module: Adapter

Adapter get all entities for adapter 5db0f5e1-a032-450a-9415-fa4863f171da failed with reason Object reference not set to an instance of an object.. Duration: 00:00:40.8116688
Error details:
System.NullReferenceException: Object reference not set to an instance of an object.
   at Unify.Framework.ArrayEqualityComparer`1.GetHashCode(T[] obj)
   at Unify.Framework.MultiKeyValue.GetHashCode()
   at System.Collections.Generic.GenericEqualityComparer`1.GetHashCode(T obj)
   at System.Linq.Set`1.InternalGetHashCode(TElement value)
   at System.Linq.Set`1.Find(TElement value, Boolean add)
   at System.Linq.Set`1.Add(TElement value)
   at System.Linq.Enumerable.&lt;DistinctIterator&gt;d__7a`1.MoveNext()
   at System.Linq.Enumerable.Count[TSource](IEnumerable`1 source)
   at Unify.Repository.EntityExpressionQueryVisitor`3.CreateMultiValueRangeExpression(IMultiKey`1 multiKey, IEnumerable`1 sourceValueList, IQueryable`1 sourceQueryable)
   at Unify.Repository.EntityExpressionQueryVisitor`3.VisitMethodWhereWithMultiValueEnumerableContains(MethodCallExpression expression)
   at Unify.Repository.EntityExpressionQueryVisitor`3.VisitMethodCall(MethodCallExpression m)
   at Unify.Framework.ExpressionVisitorBase`11.Visit(Expression exp)
   at Unify.Framework.LinqContextConversionExpressionVisitorBase`5.ConvertExpression(Expression partitionExpression)
   at Unify.Framework.LinqQueryConversionProvider`5.GetOrderedQuery(Expression businessExpression, IQueryable`1 sourceQueryable, TContext sourceContext)
   at Unify.Framework.LinqWhereQuery`5.EvaluateQuery(TContext context)
   at Unify.Framework.LinqWhereQuery`5.GetEnumerator()
   at System.Linq.Lookup`2.Create[TSource](IEnumerable`1 source, Func`2 keySelector, Func`2 elementSelector, IEqualityComparer`1 comparer)
   at System.Linq.Enumerable.ToLookup[TSource,TKey](IEnumerable`1 source, Func`2 keySelector)
   at Unify.Framework.EntityCompositeKeyDistinguishedNameStaticRelationValueAdapterBase.Transform(IEnumerable`1 sourceValue)
   at Unify.Framework.ChainValueAdapter`3.Transform(TBaseValue baseValue)
   at System.Linq.Enumerable.&lt;&gt;c__DisplayClass12`3.&lt;CombineSelectors&gt;b__11(TSource x)
   at System.Linq.Enumerable.WhereSelectEnumerableIterator`2.MoveNext()
   at Unify.Framework.EnumerableExtensions.&lt;ActionOnLast&gt;d__16`1.MoveNext()
   at System.Linq.Enumerable.&lt;SelectManyIterator&gt;d__14`2.MoveNext()
   at Unify.Framework.EnumerableExtensions.&lt;ActionOnLast&gt;d__16`1.MoveNext()
   at System.Linq.Enumerable.&lt;SelectManyIterator&gt;d__14`2.MoveNext()
   at Unify.Framework.EnumerableExtensions.&lt;ActionOnFirst&gt;d__1c`1.MoveNext()
   at System.Linq.Enumerable.WhereSelectEnumerableIterator`2.MoveNext()
   at Unify.Framework.ActionOnExceptionEnumerator`1.MoveNext()
   at Unify.Framework.EnumerableExtensions.&lt;ActionOnLast&gt;d__16`1.MoveNext()
   at System.Linq.Enumerable.WhereSelectEnumerableIterator`2.MoveNext()
   at System.Linq.Enumerable.&lt;SelectManyIterator&gt;d__14`2.MoveNext()
   at System.Linq.Enumerable.&lt;ConcatIterator&gt;d__71`1.MoveNext()
   at Unify.Framework.LDIFComponentFileGenerator`1.GenerateFile(TextWriter writer, IEnumerable`1 entries)
   at Unify.Framework.LDIFAdapter.&lt;&gt;c__DisplayClass7`1.&lt;CreateLDIFComponentStream&gt;b__6(Stream stream)
   at Unify.Framework.LazyEvaluationStream.Evaluate(Object obj)</Data>
  </EventData>
</Event>

The following is the adapter configuration which triggered the problem:

            <adapter
              name="Relational.Composite"
              RelationshipConnectorId="{2030B82B-BCE1-40DD-A1EE-09C9F0DC66C6}" >
              <Relationships>
                <Relationship InputKey="SalAdminPlan" RelationshipKey="SalAdminPlan" />
                <Relationship InputKey="Grade" RelationshipKey="Grade" />
              </Relationships>
              <dn target="Grades">
                <dnComponent name="Field" key="Grade" attributeType="CN" />
                <dnComponent name="Constant" value="Grades" attributeType="OU" />
                <dnComponent name="Field" key="SalAdminPlan" attributeType="CN" />
                <dnComponent name="Constant" value="Plans" attributeType="OU" />
              </dn>
            </adapter>

The generated full import of the adapter minus the above transformation would have been attached for reference had the subsequent full import attempt not failed with a timeout exceeded exteption (see comments), as I am suspecting null data values may not be being handled in the hash function call.


1000.jobs.evtx
Installed.png
PlatformDetails.txt
Unify.Framework.AdapterEntityTransformation.dll
Unify.Framework.Collections.dll
Bob Bradley 12 years ago

Subsequent full import failure:

Log Name:      UNIFY.IdB.PeopleSoft
Source:        Adapter get all entities for adapter failed.
Date:          3/10/2012 1:22:32 PM
Event ID:      0
Task Category: None
Level:         Warning
Keywords:      Classic
User:          N/A
Computer:      D-OCCCP-AS001.dbb.local
Description:
Error occurred in module: Adapter

Adapter get all entities for adapter 5db0f5e1-a032-450a-9415-fa4863f171da failed with reason This operation returned because the timeout period expired. (Exception from HRESULT: 0x800705B4). Duration: 00:20:15.9931500
Error details:
System.ApplicationException: This operation returned because the timeout period expired. (Exception from HRESULT: 0x800705B4)
   at System.Threading.ReaderWriterLock.AcquireReaderLockInternal(Int32 millisecondsTimeout)
   at System.Threading.ReaderWriterLock.AcquireReaderLock(TimeSpan timeout)
   at Unify.Framework.Threadsafe.ReaderWriterResourceLock.AcquireReaderLock()
   at Unify.Framework.LinqWhereQuery`5.GetEnumerator()
   at Unify.Framework.QueryableExtensions.<AutoStream>d__b`1.MoveNext()
   at System.Linq.Enumerable.WhereSelectEnumerableIterator`2.MoveNext()
   at Unify.Framework.EnumerableExtensions.<ProduceAutoPages>d__9`1.MoveNext()
   at System.Linq.Enumerable.WhereSelectEnumerableIterator`2.MoveNext()
   at Unify.Framework.EnumerableExtensions.<ActionOnLast>d__16`1.MoveNext()
   at System.Linq.Enumerable.<SelectManyIterator>d__14`2.MoveNext()
   at Unify.Framework.EnumerableExtensions.<ActionOnLast>d__16`1.MoveNext()
   at System.Linq.Enumerable.<SelectManyIterator>d__14`2.MoveNext()
   at Unify.Framework.EnumerableExtensions.<ActionOnFirst>d__1c`1.MoveNext()
   at System.Linq.Enumerable.WhereSelectEnumerableIterator`2.MoveNext()
   at Unify.Framework.ActionOnExceptionEnumerator`1.MoveNext()
   at Unify.Framework.EnumerableExtensions.<ActionOnLast>d__16`1.MoveNext()
   at System.Linq.Enumerable.WhereSelectEnumerableIterator`2.MoveNext()
   at System.Linq.Enumerable.<SelectManyIterator>d__14`2.MoveNext()
   at System.Linq.Enumerable.<ConcatIterator>d__71`1.MoveNext()
   at Unify.Framework.LDIFComponentFileGenerator`1.GenerateFile(TextWriter writer, IEnumerable`1 entries)
   at Unify.Framework.LDIFAdapter.<>c__DisplayClass7`1.<CreateLDIFComponentStream>b__6(Stream stream)
   at Unify.Framework.LazyEvaluationStream.Evaluate(Object obj)
Event Xml:
<Event xmlns="http://schemas.microsoft.com/win/2004/08/events/event">
  <System>
    <Provider Name="Adapter get all entities for adapter failed." />
    <EventID Qualifiers="0">0</EventID>
    <Level>3</Level>
    <Task>0</Task>
    <Keywords>0x80000000000000</Keywords>
    <TimeCreated SystemTime="2012-10-03T03:22:32.000000000Z" />
    <EventRecordID>1364512</EventRecordID>
    <Channel>UNIFY.IdB.PeopleSoft</Channel>
    <Computer>D-OCCCP-AS001.dbb.local</Computer>
    <Security />
  </System>
  <EventData>
    <Data>Error occurred in module: Adapter

Adapter get all entities for adapter 5db0f5e1-a032-450a-9415-fa4863f171da failed with reason This operation returned because the timeout period expired. (Exception from HRESULT: 0x800705B4). Duration: 00:20:15.9931500
Error details:
System.ApplicationException: This operation returned because the timeout period expired. (Exception from HRESULT: 0x800705B4)
   at System.Threading.ReaderWriterLock.AcquireReaderLockInternal(Int32 millisecondsTimeout)
   at System.Threading.ReaderWriterLock.AcquireReaderLock(TimeSpan timeout)
   at Unify.Framework.Threadsafe.ReaderWriterResourceLock.AcquireReaderLock()
   at Unify.Framework.LinqWhereQuery`5.GetEnumerator()
   at Unify.Framework.QueryableExtensions.&lt;AutoStream&gt;d__b`1.MoveNext()
   at System.Linq.Enumerable.WhereSelectEnumerableIterator`2.MoveNext()
   at Unify.Framework.EnumerableExtensions.&lt;ProduceAutoPages&gt;d__9`1.MoveNext()
   at System.Linq.Enumerable.WhereSelectEnumerableIterator`2.MoveNext()
   at Unify.Framework.EnumerableExtensions.&lt;ActionOnLast&gt;d__16`1.MoveNext()
   at System.Linq.Enumerable.&lt;SelectManyIterator&gt;d__14`2.MoveNext()
   at Unify.Framework.EnumerableExtensions.&lt;ActionOnLast&gt;d__16`1.MoveNext()
   at System.Linq.Enumerable.&lt;SelectManyIterator&gt;d__14`2.MoveNext()
   at Unify.Framework.EnumerableExtensions.&lt;ActionOnFirst&gt;d__1c`1.MoveNext()
   at System.Linq.Enumerable.WhereSelectEnumerableIterator`2.MoveNext()
   at Unify.Framework.ActionOnExceptionEnumerator`1.MoveNext()
   at Unify.Framework.EnumerableExtensions.&lt;ActionOnLast&gt;d__16`1.MoveNext()
   at System.Linq.Enumerable.WhereSelectEnumerableIterator`2.MoveNext()
   at System.Linq.Enumerable.&lt;SelectManyIterator&gt;d__14`2.MoveNext()
   at System.Linq.Enumerable.&lt;ConcatIterator&gt;d__71`1.MoveNext()
   at Unify.Framework.LDIFComponentFileGenerator`1.GenerateFile(TextWriter writer, IEnumerable`1 entries)
   at Unify.Framework.LDIFAdapter.&lt;&gt;c__DisplayClass7`1.&lt;CreateLDIFComponentStream&gt;b__6(Stream stream)
   at Unify.Framework.LazyEvaluationStream.Evaluate(Object obj)</Data>
  </EventData>
</Event>

Is this timeout influenced by any adapter/app config timout setting Adam?

Adam van Vliet 12 years ago

Please try with Unify.Framework.Collections.dll, this should stop the null reference.

Bob Bradley 12 years ago

Attached output of PlatformDetails.ps1 script

Bob Bradley 12 years ago

No joy Adam - downloaded the DLL, uncommented that transform, restarted the service and ran a full import:

Log Name:      UNIFY.IdB.PeopleSoft
Source:        Adapter get all entities for adapter failed.
Date:          3/10/2012 4:16:52 PM
Event ID:      0
Task Category: None
Level:         Warning
Keywords:      Classic
User:          N/A
Computer:      D-OCCCP-AS001.dbb.local
Description:
Error occurred in module: Adapter

Adapter get all entities for adapter 5db0f5e1-a032-450a-9415-fa4863f171da failed with reason Object reference not set to an instance of an object.. Duration: 00:00:40.0538645
Error details:
System.NullReferenceException: Object reference not set to an instance of an object.
   at System.Object.GetType()
   at Unify.Repository.EntityExpressionQueryVisitor`3.<CreateMultiValueRangeExpression>b__29(IValue firstItemValue)
   at System.Linq.Enumerable.<>c__DisplayClass12`3.<CombineSelectors>b__11(TSource x)
   at System.Linq.Enumerable.WhereSelectArrayIterator`2.MoveNext()
   at System.Linq.Buffer`1..ctor(IEnumerable`1 source)
   at System.Linq.Enumerable.ToArray[TSource](IEnumerable`1 source)
   at Unify.Repository.EntityExpressionQueryVisitor`3.CreateMultiValueRangeExpression(IMultiKey`1 multiKey, IEnumerable`1 sourceValueList, IQueryable`1 sourceQueryable)
   at Unify.Repository.EntityExpressionQueryVisitor`3.VisitMethodWhereWithMultiValueEnumerableContains(MethodCallExpression expression)
   at Unify.Repository.EntityExpressionQueryVisitor`3.VisitMethodCall(MethodCallExpression m)
   at Unify.Framework.ExpressionVisitorBase`11.Visit(Expression exp)
   at Unify.Framework.LinqContextConversionExpressionVisitorBase`5.ConvertExpression(Expression partitionExpression)
   at Unify.Framework.LinqQueryConversionProvider`5.GetOrderedQuery(Expression businessExpression, IQueryable`1 sourceQueryable, TContext sourceContext)
   at Unify.Framework.LinqWhereQuery`5.EvaluateQuery(TContext context)
   at Unify.Framework.LinqWhereQuery`5.GetEnumerator()
   at System.Linq.Lookup`2.Create[TSource](IEnumerable`1 source, Func`2 keySelector, Func`2 elementSelector, IEqualityComparer`1 comparer)
   at System.Linq.Enumerable.ToLookup[TSource,TKey](IEnumerable`1 source, Func`2 keySelector)
   at Unify.Framework.EntityCompositeKeyDistinguishedNameStaticRelationValueAdapterBase.Transform(IEnumerable`1 sourceValue)
   at Unify.Framework.ChainValueAdapter`3.Transform(TBaseValue baseValue)
   at Unify.Framework.ChainValueAdapter`3.Transform(TBaseValue baseValue)
   at System.Linq.Enumerable.<>c__DisplayClass12`3.<CombineSelectors>b__11(TSource x)
   at System.Linq.Enumerable.WhereSelectEnumerableIterator`2.MoveNext()
   at Unify.Framework.EnumerableExtensions.<ActionOnLast>d__16`1.MoveNext()
   at System.Linq.Enumerable.<SelectManyIterator>d__14`2.MoveNext()
   at Unify.Framework.EnumerableExtensions.<ActionOnLast>d__16`1.MoveNext()
   at System.Linq.Enumerable.<SelectManyIterator>d__14`2.MoveNext()
   at Unify.Framework.EnumerableExtensions.<ActionOnFirst>d__1c`1.MoveNext()
   at System.Linq.Enumerable.WhereSelectEnumerableIterator`2.MoveNext()
   at Unify.Framework.ActionOnExceptionEnumerator`1.MoveNext()
   at Unify.Framework.EnumerableExtensions.<ActionOnLast>d__16`1.MoveNext()
   at System.Linq.Enumerable.WhereSelectEnumerableIterator`2.MoveNext()
   at System.Linq.Enumerable.<SelectManyIterator>d__14`2.MoveNext()
   at System.Linq.Enumerable.<ConcatIterator>d__71`1.MoveNext()
   at Unify.Framework.LDIFComponentFileGenerator`1.GenerateFile(TextWriter writer, IEnumerable`1 entries)
   at Unify.Framework.LDIFAdapter.<>c__DisplayClass7`1.<CreateLDIFComponentStream>b__6(Stream stream)
   at Unify.Framework.LazyEvaluationStream.Evaluate(Object obj)
Event Xml:
<Event xmlns="http://schemas.microsoft.com/win/2004/08/events/event">
  <System>
    <Provider Name="Adapter get all entities for adapter failed." />
    <EventID Qualifiers="0">0</EventID>
    <Level>3</Level>
    <Task>0</Task>
    <Keywords>0x80000000000000</Keywords>
    <TimeCreated SystemTime="2012-10-03T06:16:52.000000000Z" />
    <EventRecordID>1364533</EventRecordID>
    <Channel>UNIFY.IdB.PeopleSoft</Channel>
    <Computer>D-OCCCP-AS001.dbb.local</Computer>
    <Security />
  </System>
  <EventData>
    <Data>Error occurred in module: Adapter

Adapter get all entities for adapter 5db0f5e1-a032-450a-9415-fa4863f171da failed with reason Object reference not set to an instance of an object.. Duration: 00:00:40.0538645
Error details:
System.NullReferenceException: Object reference not set to an instance of an object.
   at System.Object.GetType()
   at Unify.Repository.EntityExpressionQueryVisitor`3.&lt;CreateMultiValueRangeExpression&gt;b__29(IValue firstItemValue)
   at System.Linq.Enumerable.&lt;&gt;c__DisplayClass12`3.&lt;CombineSelectors&gt;b__11(TSource x)
   at System.Linq.Enumerable.WhereSelectArrayIterator`2.MoveNext()
   at System.Linq.Buffer`1..ctor(IEnumerable`1 source)
   at System.Linq.Enumerable.ToArray[TSource](IEnumerable`1 source)
   at Unify.Repository.EntityExpressionQueryVisitor`3.CreateMultiValueRangeExpression(IMultiKey`1 multiKey, IEnumerable`1 sourceValueList, IQueryable`1 sourceQueryable)
   at Unify.Repository.EntityExpressionQueryVisitor`3.VisitMethodWhereWithMultiValueEnumerableContains(MethodCallExpression expression)
   at Unify.Repository.EntityExpressionQueryVisitor`3.VisitMethodCall(MethodCallExpression m)
   at Unify.Framework.ExpressionVisitorBase`11.Visit(Expression exp)
   at Unify.Framework.LinqContextConversionExpressionVisitorBase`5.ConvertExpression(Expression partitionExpression)
   at Unify.Framework.LinqQueryConversionProvider`5.GetOrderedQuery(Expression businessExpression, IQueryable`1 sourceQueryable, TContext sourceContext)
   at Unify.Framework.LinqWhereQuery`5.EvaluateQuery(TContext context)
   at Unify.Framework.LinqWhereQuery`5.GetEnumerator()
   at System.Linq.Lookup`2.Create[TSource](IEnumerable`1 source, Func`2 keySelector, Func`2 elementSelector, IEqualityComparer`1 comparer)
   at System.Linq.Enumerable.ToLookup[TSource,TKey](IEnumerable`1 source, Func`2 keySelector)
   at Unify.Framework.EntityCompositeKeyDistinguishedNameStaticRelationValueAdapterBase.Transform(IEnumerable`1 sourceValue)
   at Unify.Framework.ChainValueAdapter`3.Transform(TBaseValue baseValue)
   at Unify.Framework.ChainValueAdapter`3.Transform(TBaseValue baseValue)
   at System.Linq.Enumerable.&lt;&gt;c__DisplayClass12`3.&lt;CombineSelectors&gt;b__11(TSource x)
   at System.Linq.Enumerable.WhereSelectEnumerableIterator`2.MoveNext()
   at Unify.Framework.EnumerableExtensions.&lt;ActionOnLast&gt;d__16`1.MoveNext()
   at System.Linq.Enumerable.&lt;SelectManyIterator&gt;d__14`2.MoveNext()
   at Unify.Framework.EnumerableExtensions.&lt;ActionOnLast&gt;d__16`1.MoveNext()
   at System.Linq.Enumerable.&lt;SelectManyIterator&gt;d__14`2.MoveNext()
   at Unify.Framework.EnumerableExtensions.&lt;ActionOnFirst&gt;d__1c`1.MoveNext()
   at System.Linq.Enumerable.WhereSelectEnumerableIterator`2.MoveNext()
   at Unify.Framework.ActionOnExceptionEnumerator`1.MoveNext()
   at Unify.Framework.EnumerableExtensions.&lt;ActionOnLast&gt;d__16`1.MoveNext()
   at System.Linq.Enumerable.WhereSelectEnumerableIterator`2.MoveNext()
   at System.Linq.Enumerable.&lt;SelectManyIterator&gt;d__14`2.MoveNext()
   at System.Linq.Enumerable.&lt;ConcatIterator&gt;d__71`1.MoveNext()
   at Unify.Framework.LDIFComponentFileGenerator`1.GenerateFile(TextWriter writer, IEnumerable`1 entries)
   at Unify.Framework.LDIFAdapter.&lt;&gt;c__DisplayClass7`1.&lt;CreateLDIFComponentStream&gt;b__6(Stream stream)
   at Unify.Framework.LazyEvaluationStream.Evaluate(Object obj)</Data>
  </EventData>
</Event>

Increased app.config timeouts to 30 mins, renamed the DLL and re-commented the section, then restarted the service and trying another full import to see if I can get a clean one minus this attribute for now ...

Bob Bradley 12 years ago

Full import succeeded minus that offending transform

Adam van Vliet 12 years ago

That looks like it's helped, good.

Unify.Framework.AdapterEntityTransformation.dll migrates a v4 update for the transformation. Let me know how it goes.

Bob Bradley 12 years ago

OK Adam - but I had to remove the first DLL above and keep the code commented. I'll leave it out and try the new v4 DLL now, cos the first DLL introduced a new bug (above).

Adam van Vliet 12 years ago

The first dll did not introduce a new bug, it exposed an existing one.

Bob Bradley 12 years ago

It worked (with both)!!! OK so now does that create a problem for deployment? Can you include the above fix in a 3.* MSI, or should we deploy it and patch like in UAT?

Adam van Vliet 12 years ago

I don't want to have version and deployment issues, and we are trying to improve our release management.

I hope to release a v3.0.8 shortly. I just have to schedule time for testing.

Bob Bradley 12 years ago

Uninstalled IdB for Peoplesoft and IdB service, cleaned out Services folder of all DLLs (except 3 SAS2IDM ones), and reinstalled service together with new 3.0.0.8 PeopleSoft MSI (twice to be sure to be sure).
Assigned the correct service account identity to the service and attempted to start ... got the following exception:

Log Name:      Application
Source:        The following error in Identity Broker occurred during start of the server: The DELETE statement conflicted with the REFERENCE constraint "FK_Container_Container". The conflict occurred in database "UNIFY.Identit
Date:          15/10/2012 2:15:46 PM
Event ID:      0
Task Category: None
Level:         Error
Keywords:      Classic
User:          N/A
Computer:      D-OCCCP-AS001.dbb.local
Description:
Error occurred in module: Identity Broker

The following error occurred: 
System.Data.SqlClient.SqlException: The DELETE statement conflicted with the REFERENCE constraint "FK_Container_Container". The conflict occurred in database "UNIFY.IdentityBroker", table "dbo.Container", column 'PartitionId'.
The statement has been terminated.
   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
   at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
   at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
   at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)
   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result)
   at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
   at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
   at System.Data.Linq.SqlClient.SqlProvider.Execute(Expression query, QueryInfo queryInfo, IObjectReaderFactory factory, Object[] parentArgs, Object[] userArgs, ICompiledSubQuery[] subQueries, Object lastResult)
   at System.Data.Linq.SqlClient.SqlProvider.ExecuteAll(Expression query, QueryInfo[] queryInfos, IObjectReaderFactory factory, Object[] userArguments, ICompiledSubQuery[] subQueries)
   at System.Data.Linq.SqlClient.SqlProvider.System.Data.Linq.Provider.IProvider.Execute(Expression query)
   at System.Data.Linq.ChangeDirector.StandardChangeDirector.DynamicDelete(TrackedObject item)
   at System.Data.Linq.ChangeDirector.StandardChangeDirector.Delete(TrackedObject item)
   at System.Data.Linq.ChangeProcessor.SubmitChanges(ConflictMode failureMode)
   at System.Data.Linq.DataContext.SubmitChanges(ConflictMode failureMode)
   at Unify.Data.LinqContextConversionBase`4.DeleteItems(HashSet`1 deletedItems, TContext sourceContext, SqlConnection connection)
   at Unify.Data.LinqContextConversionBase`4.SubmitChanges()
   at Unify.Framework.IdentityBrokerEngine.SetUpEntityRepositoryPartitions(IEnumerable`1 connectorConfigurationCollection, IEnumerable`1 adapters)
   at Unify.Framework.IdentityBrokerEngine.Start()
   at Unify.Framework.UnifyEngine.Start()
Event Xml:
<Event xmlns="http://schemas.microsoft.com/win/2004/08/events/event">
  <System>
    <Provider Name="The following error in Identity Broker occurred during start of the server: The DELETE statement conflicted with the REFERENCE constraint &quot;FK_Container_Container&quot;. The conflict occurred in database &quot;UNIFY.Identit" />
    <EventID Qualifiers="0">0</EventID>
    <Level>2</Level>
    <Task>0</Task>
    <Keywords>0x80000000000000</Keywords>
    <TimeCreated SystemTime="2012-10-15T03:15:46.000000000Z" />
    <EventRecordID>1721352</EventRecordID>
    <Channel>Application</Channel>
    <Computer>D-OCCCP-AS001.dbb.local</Computer>
    <Security />
  </System>
  <EventData>
    <Data>Error occurred in module: Identity Broker

The following error occurred: 
System.Data.SqlClient.SqlException: The DELETE statement conflicted with the REFERENCE constraint "FK_Container_Container". The conflict occurred in database "UNIFY.IdentityBroker", table "dbo.Container", column 'PartitionId'.
The statement has been terminated.
   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
   at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
   at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
   at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)
   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result)
   at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
   at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
   at System.Data.Linq.SqlClient.SqlProvider.Execute(Expression query, QueryInfo queryInfo, IObjectReaderFactory factory, Object[] parentArgs, Object[] userArgs, ICompiledSubQuery[] subQueries, Object lastResult)
   at System.Data.Linq.SqlClient.SqlProvider.ExecuteAll(Expression query, QueryInfo[] queryInfos, IObjectReaderFactory factory, Object[] userArguments, ICompiledSubQuery[] subQueries)
   at System.Data.Linq.SqlClient.SqlProvider.System.Data.Linq.Provider.IProvider.Execute(Expression query)
   at System.Data.Linq.ChangeDirector.StandardChangeDirector.DynamicDelete(TrackedObject item)
   at System.Data.Linq.ChangeDirector.StandardChangeDirector.Delete(TrackedObject item)
   at System.Data.Linq.ChangeProcessor.SubmitChanges(ConflictMode failureMode)
   at System.Data.Linq.DataContext.SubmitChanges(ConflictMode failureMode)
   at Unify.Data.LinqContextConversionBase`4.DeleteItems(HashSet`1 deletedItems, TContext sourceContext, SqlConnection connection)
   at Unify.Data.LinqContextConversionBase`4.SubmitChanges()
   at Unify.Framework.IdentityBrokerEngine.SetUpEntityRepositoryPartitions(IEnumerable`1 connectorConfigurationCollection, IEnumerable`1 adapters)
   at Unify.Framework.IdentityBrokerEngine.Start()
   at Unify.Framework.UnifyEngine.Start()</Data>
  </EventData>
</Event>

Does that mean there's a db corruption?

Bob Bradley 12 years ago

Adam - Ryan was caught up with WorkCover so I went ahead with this. Can you please help?

Bob Bradley 12 years ago

Screenshot of installed IdB versions attached

Adam van Vliet 12 years ago

The issues has already been fixed in IDB-116.

Either manually clear the database, or delete it and start again.

Bob Bradley 12 years ago

version 3.0.0.9 appears to have solved all problems identified in this issue (including incorporating an IdB 4 feature) ... will close when testing is complete

Shane Day (Chief Technology Officer) 12 years ago

This issue has not been updated for two weeks, and is still not closed. Update the issue with the current status or progress the issue.

Shane Day (Chief Technology Officer) 12 years ago

This issue has not been updated in two weeks. Please provide a status update or transition the issue to the correct state.

Bob Bradley 12 years ago

Closed due to there being no further evidence of the issue - will reopen if it reappears during formal UAT (which has been delayed due to PHRIS timeframe shifts).

Customer support service by UserEcho