Salesforce Connector错误复制活动 [英] Salesforce Connector Error on copy activity

问题描述

收到错误：

{ " errorCode"：" 2200"，" message"：" ErrorCode = UserErrorSourceStructureMismatchWithPhysicalSchema，'Type = Microsoft.DataTransfer.Common.Shared.HybridDeliveryException，Message =
列'SystemModstamp'，如源中所定义DataSet无法位于实际源中。检查配置以确保源DataSet中的所有列确实存在于实际源中。，Source = Microsoft.DataTransfer.ClientLibrary，'"，
" failureType"：" UserError"，" target" ："sf_sb_account_incremental_copy" }

我正在连接到沙盒组织进行测试。我正在尝试为数据仓库项目创建概念。我试图按计划从Salesforce中提取数据。我已经成功创建了一个复制活动，它可以提取整个Salesforce Objects
表。我现在正在尝试创建一个提取更新记录的增量复制活动。如果但是在尝试查询Salesforce时出现上述错误时副本出错了。我已经尝试了生成的查询Salesforce工作台，它在那里工作。
关于它为什么说"SystemModstamp"的任何想法来源不存在？

I am connecting to a sandbox org for testing. I am trying to create a prof of concept for a data warehouse project. I am trying to pull data from Salesforce on a schedule. I have successfully created a copy activity that pulls the entire Salesforce Objects table. I am now trying to create an incremental copy activity that pulls updated records. If but the copy is erroring out when trying to query Salesforce giving the the error above. I have tried the generated query Salesforce work bench and it works there. Any ideas on why it is saying that "SystemModstamp" is not present in the source?

推荐答案

嗨ndlang76，

Hi ndlang76,

您是否在要复制的所有文档中都有名为"SystemModstamp"的属性（列）？或者某些文件是否缺少该属性？

Do you have the property(column) named "SystemModstamp" present in all the documents you are trying to copy? Or is the property itself is missing for some documents?

有关详细信息，请参阅
SO 线程解决类似问题。

For more details, you may refer SO thread which addressing similar issue.

希望这会有所帮助。

这篇关于Salesforce Connector错误复制活动的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！