Copy activity failed: Failure happened on 'Source' side

@PP

Thanks for reaching out to Microsoft Q&A.

The error you’re encountering is related to a timeout issue with your PostgreSQL query. The error message ERROR: VERROR; canceling statement due to statement timeout indicates that the query you’re trying to execute is taking longer than the allowed time limit, causing the system to automatically cancel it.

Here are a few steps resolve this issue:

1. Optimize your query: If your query is complex and involves large amounts of data, it might be worth looking into ways to make it more efficient. This could involve using indexes effectively, reducing the amount of data processed, or restructuring the query.
2. Increase the timeout limit: If the query is expected to take a long time due to the amount of data being processed, you could consider increasing the timeout limit. However, this should be done cautiously, as it could lead to longer running times and higher resource usage.
3. Check your network connection: Make sure that your network connection is stable and that there are no issues with your internet service provider. You can try running a network diagnostic tool to identify any network issues.
4. Check the server logs: Check the server logs to see if there are any errors or warnings that could be related to the file upload operation. This can help you identify the root cause of the issue1.
5. Retry the operation: You can try retrying the file upload operation to see if the issue was a temporary one. If the issue persists, you may need to investigate further or contact support for assistance

Hope this helps. Do let us know if you any further queries.

Where can we increase allowed time limit to complete query. Timeout limit is 1 hour in ADF still it throws timeout error at 30 mins ADF taking longer then usual time to complete from last one week during overnight schedule whereas performance increases during day time. Though no new pipeline added in ADF from last 2-3 months

Where can we increase allowed time limit to complete query. Timeout limit is 1 hour in ADF still it throws timeout error at 30 mins ADF taking longer then usual time to complete from last one week during overnight schedule whereas performance increases during day time. Though no new pipeline added in ADF from last 2-3 months