Azure logic app , extract file from sharepoint to ADLS

Ritu Harivansh Prajapati 0 Reputation points
2024-04-26T20:06:43.52+00:00

Hi,

I am working on a file extraction from sharepint to ADLS and the file size is 1 GB. I need to copy the file to ADLS.

I am currently using standard logic app as the file size is more than the default size.

After that i tried adding the file size in host.json as per the document.

After doing the same my logic app is running and not executing its just keep running.

Can you tell what is wrong in the logic app.

Azure Data Lake Storage
Azure Data Lake Storage
An Azure service that provides an enterprise-wide hyper-scale repository for big data analytic workloads and is integrated with Azure Blob Storage.
1,371 questions
Azure Logic Apps
Azure Logic Apps
An Azure service that automates the access and use of data across clouds without writing code.
2,900 questions
SharePoint
SharePoint
A group of Microsoft Products and technologies used for sharing and managing content, knowledge, and applications.
9,875 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. Abhishek Tripathi 0 Reputation points
    2024-04-27T04:20:28.6433333+00:00

    It seems you’re encountering an issue with your Azure Logic App not executing properly after adjusting the file size in the host.json. Let’s troubleshoot this:

    Check Trigger History:

    • Every workflow starts with a trigger. Review the trigger history to ensure it’s firing as expected.
      • Confirm that the trigger inputs (such as file path or SharePoint event) are correctly configured.
        • Verify that the trigger outputs (if any) match your expectations.
        Chunking for Large Files:
        - If you’re dealing with large files (like your 1 GB file), consider enabling chunking.
        
           - Chunking splits large messages into smaller pieces, allowing you to transfer large files under specific conditions.
        
              - [Check if your workflow uses built-in HTTP actions or specific managed connector actions that support chunking](https://learn.microsoft.com/en-us/azure/logic-apps/logic-apps-handle-large-messages)[1](https://learn.microsoft.com/en-us/azure/logic-apps/logic-apps-handle-large-messages).
        
              **Runtime Dependencies**:
        
                 - Ensure that your logic app has the necessary runtime dependencies.
        
                    - If you’re using Visual Studio Code, check if the Azure Logic Apps Standard extension settings are correctly configured.
        
                       - [Verify that the auto runtime dependencies path and validation settings are set appropriately](https://learn.microsoft.com/en-us/azure/logic-apps/logic-apps-handle-large-messages)[2](https://techcommunity.microsoft.com/t5/azure-integration-services-blog/making-it-easy-to-get-started-with-the-azure-logic-apps-standard/ba-p/3979643).
        
                       **Network and Inbound Traffic**:
        
                          - If your logic app uses private endpoints, ensure that your client machine has access to the private IP of the logic app.
        
                             - [Check the networking settings and inbound traffic configuration in your logic app](https://learn.microsoft.com/en-us/azure/logic-apps/logic-apps-handle-large-messages)[3](https://techcommunity.microsoft.com/t5/azure-integration-services-blog/common-errors-in-azure-logic-apps-standard-unexpected-error/ba-p/3293197).
        
                             **Azure Logic App Limits**:
        
                                - Review the limits and configuration for Azure Logic Apps, especially for the Standard tier.
        
                                   - [Confirm that your logic app doesn’t exceed any execution duration or other resource limits](https://learn.microsoft.com/en-us/azure/logic-apps/logic-apps-handle-large-messages)[4](https://learn.microsoft.com/en-us/azure/logic-apps/logic-apps-limits-and-config).
        
                                   **Storage Account Connection String**:
        
                                      - If your logic app interacts with storage accounts, ensure that the connection string is correctly configured.
        
                                         - Verify that the storage account has sufficient capacity and permissions.
        
                                         **Diagnostic Logs and Monitoring**:
        
                                            - Enable diagnostic logs for your logic app to capture detailed information.
        
                                               - Monitor the execution flow, check for any errors, and inspect the logs for clues.
        
                                               **Retry and Resubmit**:
        
                                                  - Sometimes logic apps fail due to transient issues. Consider retrying or resubmitting the workflow.
        

    Remember to test each step thoroughly and verify that your logic app is configured correctly. If the issue persists, consider reaching out to Azure support for further assistance. Troubleshooting logic apps can be complex, but with careful analysis, you’ll identify the root cause and resolve the issue4132.

    0 comments No comments