Troubleshooting iTransfer
Do the following to troubleshoot iTransfer:
Issue: Getting an error saying ambiguous match found
This is due to the IQA Query used in iTransfer as a column named Item.
Issue: Performance Issues with iTransfer Jobs
Make sure to check the following:
- SELECT DISTINCT is NOT enabled in the IQA Query
- "NOLOCK" should be used for increased iMIS performance while iTransfer jobs are running
- No visible Prompt filters - only use internal filters (Prompt = None)
- All columns should have Alias
- Do note use Item.
- Hidden columns (starting with underscores) are not actually hidden in iTransfer so if you don not want a column, do not include it.
- Sorting in the IQA Query causes performance issues
Important! Be sure to test the IQA both using the Run tab and the Report tab to ensure performance is good, and verify the number of total records matches what you expect.