Forum Discussion
gateway refresh error - The credentials provided for the Oracle source are invalid
When i'm refreshing the dataset in staging environment. it's giving the below error message. We have oracle db connecting with TNS entry
Database - Oracle
TNS Name/Server = gmirealtime
Dataset Credentials type - Basic
username - s***_mnt_view
Password - ********
i gave the proper credentials only. issue is happening in our staging environment. for the same refreshing successful in testing enviroment data base without error.
Can you please guide me how to resolve the issue
Note: different enviroment using different logins & gateways(test_gateway, Stage_gateway)
| Underlying error code: | -2147467259 |
| Underlying error message: | The credentials provided for the Oracle source are invalid. (Source at gmirealtime.) |
| DM_ErrorDetailNameCode_UnderlyingHResult: | -2147467259 |
| Microsoft.Data.Mashup.CredentialError.DataSourceKind: | Oracle |
| Microsoft.Data.Mashup.CredentialError.DataSourcePath: | gmirealtime |
| Microsoft.Data.Mashup.CredentialError.Reason: | AccessUnauthorized |
| Microsoft.Data.Mashup.MashupSecurityException.DataSources: | [{"kind":"Oracle","path":"gmirealtime"}] |
| Microsoft.Data.Mashup.MashupSecurityException.Reason: | AccessUnauthorized |
| Cluster URI: | WABI-US-EAST2-redirect.analysis.windows.net |
| Activity ID: | cb706626-d2c2-4de2-a3f4-a1922c62743b |
| Request ID: | 30eb5e02-be54-84d6-91c6-a569581d4f03 |
| Time: | 2020-07-21 06:24:20Z |
Previously faced error
| Data source error: | {"error":{"code":"DM_GWPipeline_Gateway_InvalidConnectionCredentials","pbi.error":{"code":"DM_GWPipeline_Gateway_InvalidConnectionCredentials","parameters":{},"details":[{"code":"DM_ErrorDetailNameCode_UnderlyingErrorCode","detail":{"type":1,"value":"-2147467259"}},{"code":"DM_ErrorDetailNameCode_UnderlyingErrorMessage","detail":{"type":1,"value":"The credentials provided for the Oracle source are invalid. (Source at gmirealtime.)"}},{"code":"DM_ErrorDetailNameCode_UnderlyingHResult","detail":{"type":1,"value":"-2147467259"}},{"code":"Microsoft.Data.Mashup.CredentialError.DataSourceKind","detail":{"type":1,"value":"Oracle"}},{"code":"Microsoft.Data.Mashup.CredentialError.DataSourcePath","detail":{"type":1,"value":"gmirealtime"}},{"code":"Microsoft.Data.Mashup.CredentialError.Reason","detail":{"type":1,"value":"AccessUnauthorized"}},{"code":"Microsoft.Data.Mashup.MashupSecurityException.DataSources","detail":{"type":1,"value":"[{\"kind\":\"Oracle\",\"path\":\"gmirealtime\"}]"}},{"code":"Microsoft.Data.Mashup.MashupSecurityException.Reason","detail":{"type":1,"value":"AccessUnauthorized"}}],"exceptionCulprit":1}}} Table: COMPANY. |
| Cluster URI: | WABI-US-EAST2-redirect.analysis.windows.net |
| Activity ID: | 2ab8c05c-f924-451d-a919-44f3ba726dae |
| Request ID: | d77d46a4-474e-1ffe-0384-05ef3462125b |
| Time: | 2020-07-06 10:34:04Z |
Hi rveerasamy ,
Please check whether you have configured gateway correctly and select the corresponding gateway of the dataset when you configure refresh.
If you see the credentail error like below, you need to edit the credentials and re-sign-in.
Best Regards,
Yingjie LiIf this post helps then please consider Accept it as the solution to help the other members find it more quickly.
3 Replies
rveerasamy - The obvious issue would be if the staging and test environments do not have the same user names and/or passwords.
Hi rveerasamy ,
Please check whether you have configured gateway correctly and select the corresponding gateway of the dataset when you configure refresh.
If you see the credentail error like below, you need to edit the credentials and re-sign-in.
Best Regards,
Yingjie LiIf this post helps then please consider Accept it as the solution to help the other members find it more quickly.
credential error only, i got it. thanks v-yingjl
