IH-ETL FAQ - In guided set-up or preview data page, it shows “There is an error in partial preview API”

[Siyou Li]

Additional Resources

Landing page

Common error scenarios

[Community Alums]

@Siyou Li : We are getting the below error

Tried above-suggested steps but still having the issue. Any thoughts on this? Thank you in advance!

[Siyou Li]

@Community Alums 

We need more information to investigate this issue. Please create a case task with customer support team and our team will further investigate this issue.

Thanks,

Siyou

[Remus]

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.