The transaction log for database 'tempdb' is full due to 'ACTIVE_TRANSACTION'

While doing investigation for missing cashiers in MX I found this error in [dbo].[tbPolledLogTransaction] for some stores, the PolledFileName = ERROR - Catch
 
Please investigate and let us know what this error means and why we are getting this error.? 
 
Ex: 
 
EntityID = 4157,  EntityID = 654
 
MMS.Utilities.MxException: DayShiftProcessing failed at MMS.POS.POSProcessing.TransferFinancial(LivelinkTransactionRecord posRecord, POSTransaction posTransaction, LinkedFinancialList linkedFinancial, SqlTransaction myTransaction) at MMS.POS.

MMS.Utilities.MxException: DayShiftProcessing failed at MMS.POS.POSProcessing.TransferFinancial(LivelinkTransactionRecord posRecord, POSTransaction posTransaction, LinkedFinancialList linkedFinancial, SqlTransaction myTransaction)
 
System.Data.SqlClient.SqlException: The transaction log for database 'tempdb' is full due to 'ACTIVE_TRANSACTION'. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at 
System.Data.SqlClient.TdsPar
 

select top 1000 * from [dbo].[tbPolledLogTransaction] with (nolock)
 where   PolledLogTransactionID > 254000000 and EntityID = 4157 and LogDate between '2022-08-12 22:14:30.683' and '2022-08-12 22:14:50.993'
 order by 2 desc