0
Fixed
Full-Import on a Placeholder connector fails with 'Method 'Boolean Contains(System.Guid)' has no supported translation to SQL.'
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>
Customer support service by UserEcho
Resolved.
Please confirm.
Thanks.
Confirmed complete, the full-import no longer fails with the described exception.