Thanks for the log.
Originally Posted by chetan86
Hmmm, that's just over 60 seconds. That could be the default ODBC driver time-out, lock or otherwise, I don't know.
>> 00004556: 2017-01-02T01:10:33 [SOURCE_UNLOAD ]I: Source endpoint 'ODBC' is using provider syntax
>> 00006420: 2017-01-02T01:10:39 [TARGET_LOAD ]I: Full load Max file size: 1048576 bytes
>> 00004556: 2017-01-02T01:11:42 [SOURCE_UNLOAD ]E: Failed to execute statement: 'SELECT "GPS_ID"
>> 00004556: 2017-01-02T01:11:42 [SOURCE_UNLOAD ]E: RetCode: SQL_ERROR SqlState: HYT00 NativeError: 0 Message: [Teradata][ODBC Teradata Driver] Query timeout expired  (ar_odbc_stmt.c:2246)
Really the best thing to do in these circumstances is to lift the SQL from the reptask log, and execute it in a generic ODBC based query tool, or maybe TeradataStudioExpress
Does it run fine, or give a similar error perhaps with more details?
(Note, you may want to put a 'limit' on the query)
Btw... a Max full-load file size of 1MB may be fine for DEV testing, but seems small for high volume production.
I would sooner expect 100 MB or 1GB
Hope this helps,