[en] Varicent Incentive Compensation Management Documentation

[en] TS002095062,TS002131868 — ODBC imports between 2 models does not work

[en] Fixed: Resolved an issue where data imports via ODBC imports across 2 models import no records when run through Scheduler.

[en] Reproduction Steps

[en] 1. Refresh or create 2 models named Model1 and Model2.

[en] 2. Using Model1, go to Composer and add a table to Model1 with 1 column called NewTable.

[en] 3. Add some rows of data to the table.

[en] 4. Using Model2, go to Composer and add an identical NewTable with the same column structure.

[en] 5. Select NewTable and create a new saved import with the query SELECT * FROM NewTable.

[en] Note: Do not run the import.

[en] 6. From Scheduler, add a new schedule and run the import via the schedule. Notice that the table has 0 records imported.

[en] 7. Go to Admin > Manage > Saved Imports and run the saved import.

[en] 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.