Execute Query: Input string was not in a correct format

Help
, ,
1

Hey Guys,

i have an issue with my Execute Query. While executing i get the Error: Execute Query: Input string was not in a correct format.

I guess the string might be correct:
“Select EZUE_AA_DZEDR.m_id, EZUE_AA_DZEDR.CNO, EZUE_AA_DZEDR.AMOUNT_EURO, EZUE_AA_DZEDR.LV_DATE, EZUE_AA_DZEDR.FLAG_2 From EZUE_AA_DZEDR Where EZUE_AA_DZEDR.LV_Date = (select max(LV_DATE)- INTERVAL ‘1’ day from EZUE_AA_DZEDR) AND EZUE_AA_DZEDR.CNO = ‘01’”

(tested at SQL-Developer and it works, just added " " in UIPath-activity)

Maybe there is a limit of values or something which can be stored in a DT? Querys with smaller amount of values work like:
“Select max(m_id) from EZUE_AA_DZEDR”

Is someone able to help me with this issue?

Thank you!

2

Hi @BotUser

Can you print the query in log message and check whether it is returning true or false

Thanks
Ashwin S

3

Hey, i solved the problem in another way. Thank you for the reply!

4

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.