Find your people. Pick a challenge. Ship something real. The CreatorCon Hackathon is coming to the Community Pavilion for one epic night. Every skill level, every role welcome. Join us on May 5th and learn more here.

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