- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
08-04-2021 10:45 AM
Hello,
I am working on Integrating Cisco Collector with ServiceNow via the IntegrationHub ETL. I have the REST API's for getting data from Cisco Collector, the Oauth app has been registered and also can successfully get the token.
The error I am seeing is when I open the ETL Transform Map that is supposed to pull in the data from the import sets. I constantly get the following error "There was an error with the partial preview API." and then subsequently step 2 which is "Prepare Source Data for Mapping" shows no data. I have not found any forums or documentation that is relevant to this error.
Would really appreciate your help on this.
Thanks!
Solved! Go to Solution.
- Labels:
-
Integrations
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
08-09-2021 09:02 AM
The issue has been resolved. The integration lost some of it's a mappings after moving the update set to prod and hence started throwing the error. I just reloaded the old update sets, committed them one by one and then remapped the fields. That fixed the issue.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
01-20-2023 04:47 AM
@Per Kristian1 Hi that also works for me, thank you 🙂
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
01-18-2025 02:51 PM
Thank you @Kristian1 Activating the transform also worked for me. Error disappeared immedaitely after activating.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
3 weeks ago
Root cause: A Reference field used in the lookup was configured to reference the wrong table. When the Partial Preview API attempted to perform the reference lookup, it was unable to fetch the target data, and the internal query object remained uninitialized. That led to the exception:
There was an error with the partial preview API. Transfomation failed: Cannot invoke "com.glide.db.meta.Query.addQuery(com.glide.util.IQueryCondition)" because "this.fQuery" is null
Fix: Correct the Reference field configuration (Dictionary entry) so the Reference points to the correct table.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
3 weeks ago
Root cause: A Reference field used in the lookup was configured to reference the wrong table. When the Partial Preview API attempted to perform the reference lookup, it was unable to fetch the target data, and the internal query object remained uninitialized. That led to the exception:
There was an error with the partial preview API. Transformation failed: Cannot invoke "com.glide.db.meta.Query.addQuery(com.glide.util.IQueryCondition)" because "this.fQuery" is null
Fix: Correct the Reference field configuration (Dictionary entry) so the Reference points to the correct table.
