Lakehouse table error -'Message: The SQL pool is warming up.

[Mathan1787]

Hi,

when i ran a pipeline and i have got a following error message.

Failure happened on 'Source' side. ErrorCode=SqlOperationFailed,'Type=Microsoft.DataTransfer.Common.Shared.HybridDeliveryException,Message=A database operation failed with the following error: 'Message: The SQL pool is warming up. Please try again.; Server Name: '51b86d2b-2e94-41e2-99af-038c977e6981.database.windows.net'; Procedure Name: ''; Number: 42109; State: 1; Class: 20; Line: 0 Current Activity Id: b51420cf-2646-4862-b937-b83c1925486c',Source=,''Type=System.Data.SqlClient.SqlException,Message=Message: The SQL pool is warming up. Please try again.; Server Name: '51b86d2b-2e94-41e2-99af-038c977e6981.database.windows.net'; Procedure Name: ''; Number: 42109; State: 1; Class: 20; Line: 0 Current Activity Id: b51420cf-2646-4862-b937-b83c1925486c,Source=.Net SqlClient Data Provider,SqlErrorNumber=9756,Class=19,ErrorCode=-2146232060,State=1,Errors=[{Class=19,Number=9756,State=1,Message=Message: The SQL pool is warming up. Please try again.; Server Name: '51b86d2b-2e94-41e2-99af-038c977e6981.database.windows.net'; Procedure Name: ''; Number: 42109; State: 1; Class: 20; Line: 0 Current Activity Id: b51420cf-2646-4862-b937-b83c1925486c,},],'

pipeline contains a lookup activity which collects the max data from lakehouse table. I have retried two times and i got a same message.

[DennesTorres]

Hi,

Does this pipeline use Synapse serverless in some way? 

This is a warm up message usually triggered by Synapse Serverless when it's warm up. The solution: Wait 1 minute or two and try again.

If it doesn't involve Synapse Serverless, I believe it's a temporary problem. Otherwise you may need to open a support ticket.

Kind Regards,

Dennes

[HimanshuS-msft]

Hello @Mathan1787 
Thanks for using the Fabric community.

I just tried out a ppeiline with a lookup activity pointing to Lakehouse table and it ran just fine .

The error mentions "51b86d2b-2e94-41e2-99af-038c977e6981.database.windows.net" which is confusing me . 
In the lookup activity when you click Preview , does that fetch data ?

Thanks
HImanshu

[Mathan1787]

It worked for me in lookup when i ran a separate lookup in a new pipeline but when i invoke multiple pipeline and some of the pipeline these lookup from lakehouse threw me an error.

[Element115]

How on earth did you manage to get Lookup to return the MAX of anything??  The Settings GUI I have on screen doesn't let me specify any SQL query, only select First row or by default, 5,000 rows returned in an arbitrary order. 

Could you please explain how you did it?