topic Re: Lakehouse table error -'Message: The SQL pool is warming up. in Data Engineering

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

Mathan1787 — Wed, 23 Aug 2023 10:22:54 GMT

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.

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

DennesTorres — Wed, 23 Aug 2023 14:31:56 GMT

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

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

HimanshuS-msft — Wed, 23 Aug 2023 18:50:24 GMT

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

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

Mathan1787 — Thu, 24 Aug 2023 12:47:03 GMT

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.

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

Element115 — Tue, 02 Apr 2024 20:24:53 GMT

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?