TS002095062,TS002131868 — ODBC imports between 2 models does not work
Fixed: Resolved an issue where data imports via ODBC imports across 2 models import no records when run through Scheduler.
Reproduction Steps
1. Refresh or create 2 models named Model1 and Model2.
2. Using Model1, go to Composer and add a table to Model1 with 1 column called NewTable.
3. Add some rows of data to the table.
4. Using Model2, go to Composer and add an identical NewTable with the same column structure.
5. Select NewTable and create a new saved import with the query SELECT * FROM NewTable.
Note: Do not run the import.
6. From Scheduler, add a new schedule and run the import via the schedule. Notice that the table has 0 records imported.
7. Go to Admin > Manage > Saved Imports and run the saved import.
The result is the import runs successfully when run via Saved Imports but not when run via Scheduler when it should run successfully for both.