web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / Data Migration Preview...
Microsoft Dynamics AX (Archived)

Data Migration Preview Error - Incorrect syntax near 's'. Unclosed quotation mark after the character string '

(0) ShareShare
ReportReport
Posted on by thomasm4 65

I've created a new entity, then created a new processing group for that entity.  I have scaled back my import file to 1 field and it generates the source mapping & validates ok.  However, when I go to "preview" the data (or even if I move onto staging it) I get the following error:

Incorrect syntax near 's'.

Unclosed quotation mark after the character string '    AND B.[PARTITION]=5637144576'.

Any suggestions on how to resolve this?  I'm new to AX and learning just so you don't assume I know the basics.  

Thanks, -Tom

*This post is locked for comments

I have the same question (0)
  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 301,171 Super User 2025 Season 2 on at

    Hi Tom,

    Did you use a csv file for import? What values did you use for the column and row delimiter in the data source format? For a normal csv file u will have to setup {CR}{LF} as row delimiter. Do you have a little preview of the file itself?

  • thomasm4 Profile Picture
    thomasm4 65 on at

    The data source format is comma delimited with CR/LF as row delimiter from a CSV file.

    I scaled back the import file to 1 field just to get passed this error.  The csv file looks like this:

    AccountNum

    28310

    I should add that this is a "custom entity" that I created using the DMF "Create a custom entity for data import/export" menu option.

    It's pretty basic which has got me puzzled.  

  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 301,171 Super User 2025 Season 2 on at

    For which table have you created the new entity? Have you checked if the generated class is complete?

  • thomasm4 Profile Picture
    thomasm4 65 on at

    It is a new table I created to hold vehicle information.  The only field I'm trying to import right now is the account number just to get the import to work without error.  The DMF wizard automatically creates the class for the table that I want to create an entity for.  It appears to be created ok and is similar to other tables that I have create entities for.

  • Verified answer
    thomasm4 Profile Picture
    thomasm4 65 on at

    Scratch this problem....I deleted the processing group and recreated it and the data imports to the staging area ok.

    Being new to AX I need to remember to try undoing and redoing first before I bother others.  Thanks so much for responding though.

    -tom

  • Community Member Profile Picture
    Community Member on at

    In addition to that : the fact you recreated the processing group probably get you in the situation where you did not have special caracters within the Processing Group Name field anymore (DMFDefinitionGroup.DefinationGroupName). I have just discovered that (with R3 CU12) while fixing the same issue.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Martin Dráb Profile Picture

Martin Dráb 4 Most Valuable Professional

#1
Priya_K Profile Picture

Priya_K 4

#3
MyDynamicsNAV Profile Picture

MyDynamicsNAV 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans