Execute DataMapping Error

[0005] W3001 : Error while executing plugin: HTTP/1.1 500 LoggedApplicationException: There was an error running the data mapping process caused by ApplicationException: Error executing DM configuration: UCAExc:::4.0.4 Unsupported newer version: 32 (DM1000031)
ApplicationException: Error executing DM configuration: UCAExc:::4.0.4 Unsupported newer version: 32 (DM1000031)
(SRV000012)

Any ideas? I create a simple datamapper and when i run through the execute datamapping this error occurs

I tried on 2 different Connect installations with the same result

Thanks

Looks like you used a recent version of the DataMapper to create your config, but your Connect Servers are older and can’t understand some of the commands in the config.

Try saving your DM Config as an older version (using the File | Save a Copy…" option).

Thanks Phil

It is a clean install of 2020.1 and latest workflow and datamapper created from that version

Dave

That’s very strange. Open a call with our Support team, they should be able to determine the cause of the issue fairly quickly.

Once they resolve it, we would all appreciate it if you posted the resolution here, in case it happens to anyone else.

1 Like

Hi

Resolution was this

I did not have the Access 64 bit ODBC installed and once this was installed and a 64 bit data source created I was able to do the query in the designer at 64 bit level and skip the database query plugin in Workflow

2 docs that were really useful

https://learn.objectiflune.com/howto/database-lookups-datamapper/

https://help.objectiflune.com/en/pres-connect-user-guide/2020.2/#cshid=31020

Unsupported version is the 32 bit driver being used by the 64 bit datamapper

Thanks for all assistance in this thread

1 Like

Yep, the ODBC world can sometimes be confusing because Connect is a 64-bit application and can therefore only use 64-bit ODBC Data Sources, while Workflow is a 32-bit application that can only use 32-bit ODBC Data Sources. Which means that in some cases, you have to create both a 32 and a 64 bit Data Source for the same database if you want to be able to access it from Connect and from Workflow.

In this instance, it would have been useful if Connect / Workflow had been able to report a more meaningful error message, it might have saved you some hassle. I will raise that point with our R&D team.

Thanks for posting the resolution.

1 Like