Queries working on windows-legacy but not on windows

Help Activities
, ,
1

I have been importing a workflow from windows legacy to windows version of UiPath and im running into problems when using an ExecuteQuery activity from the database package.

The activity uses an ODBC connection with a iSeries Access ODBC Driver, with Plattform 32/64 bit, the connection activity works just fine in both versions but when excecuting the query the windows version gives me the error: “Arithmetic operation resulted in an overflow.”

Given that the query works just fine in the legacy version I dont believe its a problem with how the query is worded.

Any help would be great.

2

Hi, can you try assign your query to a string and pass that string variable to ‘ExecuteQuery’ activity?

3

It gives me the same error when I tried it

4

Have you managed to figure it out @g-konig?

Was it maybe an issue with an outdated driver that didn’t support the newer framework that the Database package uses on Windows projects?