Map Data Check SQLValidation Task Error
SmartConnect Version 126.96.36.199
I have a simple GP GL Journal import and have created the following SQL Validation task:
I have tried both using a Custom Connection and existing connection
The validation is looking at the GL00105 table and querying my source account column with the GL00105.ACTNUMST column
On integration it fails:
When trying to get back into the Task, I get the following error messages:
Incorrect syntax near the keyword 'distinct'
User Defined Query is not a valid table. It si only for use with the query builder modify option
These errors occur another 5 times and the task now looks like this: Note Table has changed to say "User Defined Query" instead of GL00105
Looking at the SQL statement in the Query, it looks OK
An ideas of why this is occurring – it seems like an issue!
Should I be logging this issue with support? It doesn't seem to be setup issue. Thanks in advance for any help.
Having the same issue and it seems pretty straight forward. Is it a bug?
I'll send an email to eone support to see if I can get any further response. I'm hoping to get a better response.
If you would like to submit an answer or comment, please sign in to the eOne portal.