Specified cast is not valid (Run Query Activity)

Help Studio
1

Howdy all, I’m trying to run SQL in UiPath, but keep getting the above error. This SQL works perfect in oracle so I’m not sure why this is erroring out in UiPath

Ill attach the SQL.

new 2.txt (3.8 KB)

2

@David_Hernandez2

Looks like nested query is causing an issue…

To confirm…can you remove the nested query and run to check?

Cheers

3

select
i.invoice_gid,
i.servprov_gid,
i.attribute_number8,
i.net_amount_due,
i.attribute_number10,
i.attribute_number7,
i.attribute_number9,
i.attribute7,
i.attribute8,
i.invoice_date,
i.attribute_date1,
i.gl_date,
i.attribute9,
i.attribute_date3,
i.attribute11,
i.attribute10,
i.attribute_date4,
i.start_date,
i.end_date,
i.origin_station_city,
i.origin_station_province_code,
i.origin_station_postal_code,
i.dest_station_city,
i.dest_station_province_code,
i.dest_station_postal_code,
i.attribute6,
i.invoice_xid,
i.invoice_number,
i.update_date,
i.consolidation_type,
i.correction_code_id,
i.domain_name,
i.net_amount_due_gid,
i.exchange_rate_date,
i.exchange_rate_gid,
i.net_amount_due_fn_currency_gid,
i.net_amount_due_fn
from
INVOICE i,
SERVPROV sp
where
(i.invoice_type = ‘I’)
and (i.invoicing_process = ‘S’)
and (i.domain_name = ‘XA’)
and (i.servprov_gid = sp.servprov_gid)
and (
i.insert_date >sysdate-7
)
and (i.invoice_type = ‘I’)
and (i.invoicing_process = ‘S’)
AND sp.servprov_xid IN (‘ABFS’, ‘AACT’, ‘NOPK’)

This does not work also.

4

@David_Hernandez2

Can you tell what are the datatypes of the columns…

Is it the same error again?

Cheers

5

I removed all but the first select statment and that fixed the bug… guess one of the data columns isn’t playing nice with UiPath.

1 Like
7

It may be the periods in the column names. UiPath doesn’t like datatable column names with periods - and I assume your query is returning data to a datatable.

I would try renaming the columns in the sql query with “as” notation ie “i.invoice_gid as invoice_gid” and see if that makes any difference. I’m not sure where exactly UiPath gets the datatable column names.

8

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