Forum Discussion

vijay22kar's avatar
vijay22kar
Helper II
5 years ago
Solved

Error at time refresh scheduler

Please help to resolve below error

 

Underlying error code: -2147467259
Underlying error message: The credentials provided for the MySql source are invalid. (Source at 10.0.0.00;databasename.)
DM_ErrorDetailNameCode_UnderlyingHResult: -2147467259
Microsoft.Data.Mashup.CredentialError.DataSourceKind: MySql
Microsoft.Data.Mashup.CredentialError.DataSourcePath: 10.0.0.00;databasename

Microsoft.Data.Mashup.CredentialError.Reason: AccessUnauthorized
Microsoft.Data.Mashup.MashupSecurityException.DataSources: [{"kind":"MySql","path":"10.0.0.00;databasename"}]
Microsoft.Data.Mashup.MashupSecurityException.Reason: AccessUnauthorized
Cluster URI: WABI-INDIA-CENTRAL-A-PRIMARY-redirect.analysis.windows.net
Activity ID: e2ca9c41-0869-4de2-b7d4-35dd6cea1a2a
Request ID: d386236e-021a-ca14-3422-d537b291883a
Time: 2021-07-07 11:20:51Z

  • Hi. The error has the message you need. Please read it.

    Usually the second line is the one with the text that will help you. In this case: "The credentials provided for the MySql source are invalid". You are providing wrong credentials to the MySQL source in the Service or somebody has changed those old credentials and now it's not working.

    I hope that helps,

  • Hi, vijay22kar 

    According to the error message above, the reason is that the access credentials are invalid.
    The workaround is to re-edit a valid access credential.
    You can view or edit it under Data Source Credentials or you can add a new data source under Manage Gateways.

     

     

     

    Best Regards,
    Community Support Team _ Zeon Zheng
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

4 Replies

  • Hi. The error has the message you need. Please read it.

    Usually the second line is the one with the text that will help you. In this case: "The credentials provided for the MySql source are invalid". You are providing wrong credentials to the MySQL source in the Service or somebody has changed those old credentials and now it's not working.

    I hope that helps,

  • Hi, vijay22kar 

    According to the error message above, the reason is that the access credentials are invalid.
    The workaround is to re-edit a valid access credential.
    You can view or edit it under Data Source Credentials or you can add a new data source under Manage Gateways.

     

     

     

    Best Regards,
    Community Support Team _ Zeon Zheng
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

    • vijay22kar's avatar
      vijay22kar
      Helper II

      checked credentials but the same error occurred

       

       

      • v-angzheng-msft's avatar
        v-angzheng-msft
        Community Support

        Hi, vijay22kar 

         

        However, this connection failure is still a credential issue.

         

        Best Regards,
        Community Support Team _ Zeon Zheng