• There could be various reasons for getting tempdb full. Some of the reasons are insufficient disk space, running complex query, or heavy transaction processing.The transaction log for database "tempdb" is full could be due to 'ACTIVE_TRANSACTION'. Identify your active transaction. Track it by running either DBCC opentran or sys.dm_tran_active_transaction. Once identified, either commit or rollback transaction.
    You can go through the following link for how to check your active transaction:
    http://www.sqlserverlogexplorer.com/check-active-transactions-in-sql-server/