topic Problem with blob storage connection in Qlik Automate

Problem with blob storage connection

roger-melo — Fri, 15 Nov 2024 21:45:47 GMT

Hello,

I did an automation with dropbox, using list files, copy, etc, and it was working well. But I had to change dropbox to Blob storage, so I changed the boxes, but it doesn't work. Not even just the list files block. When I put the block list containers, It works, and return the only existing container correctly. I am thinking the problem is in the path, but I have tried this argument in so many ways, without success. The script just run for 7 minutes and ends with the message "Execution has failed".

The Blob storage just have 1 container and 1 file in this container.

Do somebody know something that I can do to fix that?

Thank you!

Roger Melo

Re: Problem with blob storage connection

AfeefaTk — Thu, 09 Mar 2023 11:53:38 GMT

Hi @roger-melo

I think you have already raised salesforce case with this issue: 00074524.

The "Execution has failed" error usually occurs when the automation runs out of memory.

You can find more details regarding Out of Memory issue's here: https://community.qlik.com/t5/Official-Support-Articles/How-to-deal-with-Out-of-Memory-errors-in-an-automation-QAA/ta-p/1844720

https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_QlikAutomation/introduction/platform-limitations.htm

Also looking into Splunk logs we see the automation run has hit the memory limit

Thanks

Re: Problem with blob storage connection

AfeefaTk — Thu, 09 Mar 2023 11:52:50 GMT

Hi @roger-melo

Could you please remove the "List Files" block that is placed within the loop of the "List Containers" block and add it after the "List Containers" block?

See if that works

Thanks

Re: Problem with blob storage connection

AfeefaTk — Thu, 09 Mar 2023 11:56:28 GMT

Hi @roger-melo

Are you sure that Azure Blob Storage has only one container and one file in it?

We don't have a working test account to test these blocks

Thanks

Re: Problem with blob storage connection

roger-melo — Thu, 09 Mar 2023 11:59:42 GMT

Hi @AfeefaTk ,

Thanks for the quick response.

I removed the list files from the "List Containers" block in the loop and placed it after it, but the same error keeps.

BR,

Roger Melo

Re: Problem with blob storage connection

roger-melo — Thu, 09 Mar 2023 12:06:50 GMT

Yes, I'm sure. When I run just the list container block, returns just 1 container:

And at Blob have just this file:

Thank you,

Roger Melo

Re: Problem with blob storage connection

roger-melo — Thu, 01 Jun 2023 00:40:26 GMT

Just one update:

I could solve the problem. The problem was the role in the Blob side. It's not enough to be "Owner", it's necessary the “Storage Blob Data Contributer” and “Storage Blob Data Owner” role associated to the user.

Thank you all.