I’m having problems with Dynamics CRM online analysis, as a result of which a set of records was added for import. Now I have reduced the problem to one field.
I have a field called "Description", a text field that expands the work. When I try to import into CRM online WITHOUT a field, import goes fine. But with the field turned on, I get this message:
I initially thought that there was a symbol in the results of this field that dropped things for import. Therefore, I conducted a multi-day process of executing large REPLACES , RTRIM (ing), and CAST . Nothing succeeded.
Then I thought: "What if this is not a strange character?" and made a LEFT with the RTRIM function to get only one character for import verification. Here's what my last import statement looked like:
RTRIM(LEFT(CAST(lntmu11.matter.memo AS varchar(1)), 1)) AS Description
So now I am returning only one character for this column. I double-checked the output in Excel and checked that there are no punctuation marks or odd data. And STILL I get an error.
I am exporting from SQL, and the source field is a TEXT type field.
Does anyone encounter a similar problem when importing? My other thought was that I exceeded the maximum size of individual records in CRM when I included the Description field in the export. (Because some of the entries will contain 500 characters or more). But now, when I export only 1 character, this may not be a problem.
Any thoughts?
source share