0
Fixed

Full-Import on a Placeholder connector fails with 'Method 'Boolean Contains(System.Guid)' has no supported translation to SQL.'

Tony Sheehy 13 years ago updated by anonymous 9 years ago 2

On full-import with the default-test configuration of the test connector 'System Connector', the following exception is encountered:

NotSupportedException: "Method 'Boolean Contains(System.Guid)' has no supported translation"

Stack Trace:

   at System.Data.Linq.SqlClient.PostBindDotNetConverter.Visitor.VisitMethodCall(SqlMethodCall mc)
   at System.Data.Linq.SqlClient.SqlVisitor.Visit(SqlNode node)
   at System.Data.Linq.SqlClient.SqlVisitor.VisitExpression(SqlExpression exp)
   at System.Data.Linq.SqlClient.SqlVisitor.VisitUnaryOperator(SqlUnary uo)
   at System.Data.Linq.SqlClient.SqlVisitor.Visit(SqlNode node)
   at System.Data.Linq.SqlClient.SqlVisitor.VisitExpression(SqlExpression exp)
   at System.Data.Linq.SqlClient.SqlVisitor.VisitSelectCore(SqlSelect select)
   at System.Data.Linq.SqlClient.PostBindDotNetConverter.Visitor.VisitSelect(SqlSelect select)
   at System.Data.Linq.SqlClient.SqlVisitor.Visit(SqlNode node)
   at System.Data.Linq.SqlClient.SqlVisitor.VisitAlias(SqlAlias a)
   at System.Data.Linq.SqlClient.SqlVisitor.Visit(SqlNode node)
   at System.Data.Linq.SqlClient.SqlVisitor.VisitSource(SqlSource source)
   at System.Data.Linq.SqlClient.SqlVisitor.VisitSelectCore(SqlSelect select)
   at System.Data.Linq.SqlClient.PostBindDotNetConverter.Visitor.VisitSelect(SqlSelect select)
   at System.Data.Linq.SqlClient.SqlVisitor.Visit(SqlNode node)
   at System.Data.Linq.SqlClient.SqlProvider.BuildQuery(ResultShape resultShape, Type resultType, SqlNode node, ReadOnlyCollection`1 parentParameters, SqlNodeAnnotations annotations)
   at System.Data.Linq.SqlClient.SqlProvider.BuildQuery(Expression query, SqlNodeAnnotations annotations)
   at System.Data.Linq.SqlClient.SqlProvider.System.Data.Linq.Provider.IProvider.Execute(Expression query)
   at System.Data.Linq.DataQuery`1.System.Collections.Generic.IEnumerable<T>.GetEnumerator()
   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.Framework.Data.LinqWhereQuery`5.GetEnumerator() in c:\Program Files (x86)\Jenkins\jobs\Framework Core (DEV)\workspace\Source\Data\Unify.Framework.Data\LinqWhereQuery.cs:line 96

Entity-Schema Configuration:

<entitySchema>
          <field name="defaultConfiguration" key="false" readonly="false" required="true" validator="string.multi" id="0b41b813-0520-4299-9c9a-01ac05be8d8b" />
          <field name="keyedDefaultConfiguration" key="true" readonly="true" required="false" validator="guid" id="226aad17-c909-4fb5-bf43-7e500a6e141f" />
          <field name="providerFieldA" key="true" readonly="true" required="false" validator="ref" id="d0bce92d-504f-4880-b824-fc960978e6c1" />
          <field name="providerFieldB" key="false" readonly="false" required="true" validator="boolean" id="12570b73-36b1-4bcc-8512-78025ae2dc5f" />
          <field name="PersonId" key="true" readonly="true" required="true" validator="guid" id="2393b9b6-dafc-4c6d-a9cf-fa11768b4e7b" />
          <field name="PersonName" key="false" readonly="true" required="false" validator="string" id="4176be4e-74ba-491f-bbab-5a920ac810f2" />
          <field name="PhoneNumber" key="false" readonly="false" required="false" validator="string" id="9b87374a-8fb9-4de3-ba23-73d1b5600a05" />
          <field name="Email" key="false" readonly="false" required="false" validator="string" id="301295ad-90ef-4416-9b1c-bd250f753cca" />
          <field name="ManagerId" key="false" readonly="true" required="false" validator="guid" id="dc39a355-90e7-4b4e-9693-c6def826c631" />
          <field name="Status" key="false" readonly="true" required="false" validator="int" id="db1b9b31-69e7-4453-9f58-b7f7d3b6b8b1" />
          <field name="AccountName" key="false" readonly="true" required="false" validator="dn" id="1af12693-fe38-4c7a-92f3-d84c1c03026e" />
        </entitySchema>

Resolved.

Please confirm.

Thanks.

Confirmed complete, the full-import no longer fails with the described exception.