Skip to Content (Press Enter)
2020-08-28 11-45-47
Jordy van der Jagt
26Views
1Comments
[Data Migration Manager (DMM)] DMM SQL Syntax errors
Question
Forge
data-migration-manager-dmm
Web icon
Data Migration Manager (DMM) (O11)
Forge asset by Infosistema Solutions

Hi DMM team,

We are having trouble with the SQL syntax for, for example, exporting a selection of data. Every syntax I try results in the error:

Unable to execute command with given WHERE Clause. Server error was: Incorrect syntax near '.'.

I attached a screenshot of just a simple syntax.

I tried to debug the problem, and the error occurs in the extension action 'GetFilteredDataByEntityId', but I'm not really familair with extension code, so maybe, based on this information, you already have an idea what the issue could be?

Do I use the wrong syntax? Or could it be related to our database settings?

We use DMM version 4.0.16.

DMMsyntaxerror.PNG
0
0
28 Sep 2020
Copy Link
2017-11-22 16-21-58
Eduardo Poças

Hello Jordy,


You should use our support email address for this kind of issues as that will allow us to file your ticket and manage it.


Nevertheless your problem seems to be that you're trying to write a where clause with SQL Server syntax and using it against na Oracle database. Can that be the issue?


If not, let us know via the support email so we can track and help you in that matter.


Best regards

0
0
28 Sep 2020
Copy Link
Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.