About EasyMorph Tutorials & Examples Web-help

Scheduling Data from IDP/Redshift Cluster on server


#1

Hi - Is it possible to run IDP/redshift cluster linked files on easy morph server. I keep getting the following error :

The table R3022_Base is picking data from the redshift connector. The file works fine when run on my desktop Task failed: 1 error(s).

Action “Import from database” in table “R3022_Base” in project “C:\Users\Public\Documents\Morphs\HR Analytics\R3022_Morph_28May2019.morph”


#2

Hi Shruti,

There should be an actual error message after the string which you provided.

Can you please post that message to this topic?

If it’s not there, please send the full log for that task to our support email.


#4

Done . Below are the details

Error description
ERROR [IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified

Error location
Action “Import from database” in table “R3022_Base” in project “C:\Users\Public\Documents\Morphs\HR Analytics\R3022_Morph_28May2019_14Jun2019.morph”

Log step by step
06/17/2019 08:50:00 AM 000001 INFO Task started on schedule: Today once at 8:50 AM

06/17/2019 08:50:00 AM 000002 INFO Project path is C:\Users\Public\Documents\Morphs\HR Analytics\R3022_Morph_28May2019_14Jun2019.morph

06/17/2019 08:50:07 AM 000003 ERROR Task failed: 1 error(s).

06/17/2019 08:50:07 AM 000004 ERROR Action “Import from database” in table “R3022_Base” in project "C:\Users\Public\Documents\Morphs\HR Analytics\R3022_Morph_28May2019_14Jun2019

Note this file needs to be generated through IDP/redshift


#5

Hi Shruti,

Thank you for the log. It seems that ODBC DSN, specified in the Redshift connector, is not configured on the Windows Server which runs EasyMorph Server.

When EasyMorph project uses ODBC connector, ODBC DSN, specified in that connector, should be configured on all the computers which run that project.