Facing pipeline failure issue while running Data flow activity

Question

Operation on target DataFlowFactSales failed: {"StatusCode":"DFExecutorUserError","Message":"Job failed due to reason: com.microsoft.dataflow.broker.InvalidOperationException: Only one valid authentication should be used for "dedicated sql pool db". SQLAuthentication is invalid. One of user/password is missing.","Details":""}

Answer 1

Hi @Shivani
Welcome to Microsoft Q&A platform and thanks for posting your question here.

To resolve the issue, you're facing with the Data Flow activity in Azure Data Factory, which suggests an authentication issue with your dedicated SQL pool database,

You can follow these steps:

• Check Authentication Details: The error message you provided states that either the username or password for SQL Authentication is missing. To resolve this issue, ensure that both the username and password are correctly provided in the connection settings for the dedicated SQL pool database. Double-check that the credentials are accurate and that there are no typos or errors in the input.
• Single Authentication Method: Another possible cause of the issue is that multiple authentication methods are being used, which can lead to conflicts. If you have provided both SQL Authentication and another method like Azure Active Directory authentication, make sure to use only one. Verify that only one authentication method is being used for the "dedicated sql pool db" and that no other credentials or authentication methods are conflicting.
• Integration Runtime Settings: If you're handling large datasets, it's important to review the compute type of your Integration Runtime to ensure it’s set to ‘compute optimized’. This can help improve performance and prevent issues related to data processing and transfer.

By following these steps, you should be able to troubleshoot and resolve the issue with the SQL Authentication for your dedicated SQL pool database in Azure Data Factory. If the issue persists, you need to consider creating a support ticket for a deeper investigation into the problem.

Reference:
https://learn.microsoft.com/en-us/azure/azure-portal/supportability/how-to-create-azure-support-request

I hope this information helps you. Let me know if you have any further questions or concerns.