IntegrationHub ETL

KarankiS
Tera Contributor

Hello experts!! I have an integrationHUB Etl record created to retrieve data using rest api, Im able to get the data and insert into a staging table but while testing it. I see below error. Please help me here.

 

 

There was an error with the partial preview API. Cannot convert Failed with error:java.lang.IllegalArgumentException: Invalid RTE definition Id to com.glide.rest.service.custom.errors.ScriptableServiceError (sys_ws_operation.df31a1ee7394001024e5aa114df6a72e.operation_script; line 49)

3 REPLIES 3

Tom R1
Tera Contributor

I got the same error today; same GUID, same line 49.  I suspect it got introduced when I tried to remove an unused field from sys_rte_eb_field.  I re-imported the XML backup I had made prior to the deletion; and it has not helped.

Anuneeti Mathur
Tera Contributor

Hey, 

 

We're facing the same issue. Did you get a resolution for this?

 

Thanks

Anu 

 

HiteshPatel21
ServiceNow Employee

Hi There,

 

When I got this error, it was because there was a problem in my Robust Transformer Definition > RTE field mappings. When I deleted a field from my import set table, ServiceNow does not automatically refresh the RTE field mappings. Hence, I manually removed the field from the RTE Entity Fields related list.  However, that created a gap in the RTE Field Mapping related list. I saw a row where both the source field (import) and target fields (temp) went empty and the error started to show up.

 

Once I deleted that entry, the error went away. Hope this helps someone.

 

Regards,

Hitesh Patel