Data gateway error "Failed to get UserAuth access token"

[CrhIT]

I have a virtual machine where I installed a data gateway. I built a pipeline that retrieves the data from there and stores it in a warehouse. At first it was working properly but going through the monitoring log, the first incidence appeared on the 5/30/2024 indicating some kind of error with the firewall configuration from the VM

Failed to execute script. Exception: 'Cannot connect to SQL Database. Please contact SQL server team for further support. Server: 'p6qjrwhwccquje2v5pai6zxfve-m3swdvx67elejkiovd6iwwsicy.datawarehouse.fabric.microsoft.com', Database: '3940c389-9bc9-4be2-ae11-36d9a1a51ecd', User: ''. Check the connection configuration is correct, and make sure the SQL Database firewall allows the Data Factory runtime to access.'

Then on the 5/31/2024, THis pieline that includes three dataflows, 1 of them was successfully the other two return the error mentioned above. 

Then on the 6/17/2024 the error changed to 

Failed to execute script. Exception: ''Type=Microsoft.DataTransfer.Common.Shared.HybridDeliveryException,Message=Cannot connect to SQL Database. Please contact SQL server team for further support. Server: 'p6qjrwhwccquje2v5pai6zxfve-m3swdvx67elejkiovd6iwwsicy.datawarehouse.fabric.microsoft.com', Database: '3940c389-9bc9-4be2-ae11-36d9a1a51ecd', User: ''. Check the connection configuration is correct, and make sure the SQL Database firewall allows the Data Factory runtime to access.,Source=Microsoft.DataTransfer.ClientLibrary,''Type=System.Data.SqlClient.SqlException,Message=The SQL pool is warming up. Please try again.,Source=.Net SqlClient Data Provider,SqlErrorNumber=42109,Class=20,ErrorCode=-2146232060,State=1,Errors=[{Class=20,Number=42109,State=1,Message=The SQL pool is warming up. Please try again.,},],''

and now over the passed few days I'm getting an error that for what I understand seems to indicate that the auth token has expired. However, I never changed the password from my VM nor changed any user passwords. I don't get why this error arrised.

Failed to execute script. Exception: ''Type=Microsoft.DataTransfer.Common.Shared.HybridDeliveryException,Message=Failed to get UserAuth access token. The error message is: AADSTS50173: The provided grant has expired due to it being revoked, a fresh auth token is needed. The user might have changed or reset their password. The grant was issued on '2024-02-12T08:55:55.7032775Z' and the TokensValidFrom date (before which tokens are not valid) for this user is '2024-06-17T09:56:39.0000000Z'. Trace ID: eac3876e-227d-4054-8238-c0a854f71700 Correlation ID: 57efa2de-1ad0-42a0-925e-2b3751006e90 Timestamp: 2024-06-28 06:00:25Z.,Source=Microsoft.DataTransfer.Common,''Type=Microsoft.DataTransfer.TokenService.Client.Models.ErrorResponseException,Message=Operation returned an invalid status code 'BadRequest',Source=Microsoft.DataTransfer.TokenServiceClient,''

This is my pipeline

and the script just deletes data from the warehouse 

DELETE FROM [TRINITEC-DWH].[dbo].[SalesTransactionPayment]
WHERE DateTimePaid>=(SELECT Dateadd(DAY,-30,MAX(DateTimePaid)) FROM [TRINITEC-DWH].[dbo].[SalesTransactionPayment])

[jwinchell40]

@CrhIT - I assume the Gateway itself is still showing as "Online" in the Gateway Admin Portal?  Can you test connectivity to the Data Source from the Gateway Admin Portal?

I would check the Gateway App itself?  Does the management app open?  Can you log-in to the management app on the VM?  Have you restarted the service at all on the VM?