Issue with refresh

[lennardheyder]

Hey everybody, anybody an idea how to fix this error when updating my dashboards?

An error occurred while processing the data in the dataset.

Refresh failed:

DMT Data reduced has failed to refresh.
Failure details: The last refresh attempt failed because of an internal service error. This is usually a transient issue. If you try again later and still see this message, contact support.

{"error":{"code":"DM_GWPipeline_Gateway_MashupDataAccessError","pbi.error":{"code":"DM_GWPipeline_Gateway_MashupDataAccessError","parameters":{},"details":[{"code":"DM_ErrorDetailNameCode_UnderlyingErrorCode","detail":{"type":1,"value":"-2147467259"}},{"code":"DM_ErrorDetailNameCode_UnderlyingErrorMessage","detail":{"type":1,"value":"<pi>Oracle: ORA-12545: Connect failed because target host or object does not exist</pi>"}},{"code":"DM_ErrorDetailNameCode_UnderlyingHResult","detail":{"type":1,"value":"-2147467259"}},{"code":"Microsoft.Data.Mashup.ValueError.DataSourceKind","detail":{"type":1,"value":"Oracle"}},{"code":"Microsoft.Data.Mashup.ValueError.DataSourcePath","detail":{"type":1,"value":"(description=(address = (protocol=tcp)(host=masterdatapool-p.basf-ag.de)(port=1521))(connect_data = (sid = mdpoolp)))"}},{"code":"Microsoft.Data.Mashup.ValueError.ErrorCode","detail":{"type":1,"value":"-2147467259"}},{"code":"Microsoft.Data.Mashup.ValueError.Message","detail":{"type":1,"value":"ORA-12545: Connect failed because target host or object does not exist"}},{"code":"Microsoft.Data.Mashup.ValueError.Reason","detail":{"type":1,"value":"DataSource.Error"}}],"exceptionCulprit":1}}} Table: grouped.

Technical Information  

Activity Id:

                086ad683-b70e-4023-a3f2-59963aa10c77

Request Id:

                99ec4d5a-8a26-4d61-9acf-4b5e6f5a7509

Cluster Name:

                WABI-NORTH-EUROPE-D-PRIMARY-redirect.analysis.windows.net

[v-luwang-msft · Accepted solution]

Hi @lennardheyder ,

First,please use CMD to test if you can connect to Oracle Database:

sqlplus username/password@ip:port/servername

Please refer to this article: https://kb.informatica.com/solution/5/Pages/18751.aspx.

Then please configure your tnsnames.ora file with the proper information for your database. Power BI Desktop and the gateway go off of the net_service_name defined in the tnsnames.ora file. If the net_service_name isn't configured, you can't connect. The default path for tnsnames.ora is [Oracle Home Directory]\Network\Admin\tnsnames.ora. For more information about how to configure tnsnames.ora files, see Oracle: Local naming parameters (tnsnames.ora).

and also please refer to these blog:

http://logic.edchen.org/how-to-resolve-tns-12545-connect-failed-because-target-host-or-object-does-n...

http://www.dba-oracle.com/t_tns_12545_connect_failed_because_target_host_or_object_does_not_exist.ht...

http://nimishgarg.blogspot.com/2014/07/ora-12545-connect-failed-because-target.html 

Did I answer your question? Mark my post as a solution!

Best Regards

Lucien