topic Oracle: ORA-12154 in Report Server https://community.fabric.microsoft.com/t5/Report-Server/Oracle-ORA-12154/m-p/367814#M4212 <P>Hi,</P><P>Getting error&nbsp; while configuring the On-Premises Gateway. During Data source Setting the below error thorw.&nbsp;</P><P>On other side through ODBC 64 bit i am able to connect with Database from Gateway server.</P><P><IMG src="Data Source Setting" border="0" alt="" /></P><P><SPAN>Unable to connect:&nbsp;We encountered an error while trying to connect to vfrecdev3.fmr.com. Details: "We could not register this data source for all gateway instances within this cluster. Please find more details below about specific errors for each gateway instance."</SPAN><SPAN><SPAN class="detailsExpander"><A href="https://app.powerbi.com/" target="_blank">Hide details</A></SPAN></SPAN></P><TABLE><TBODY><TR><TD><SPAN>Activity ID</SPAN>:</TD><TD>50003b0a-e4cc-b4ca-0b47-854007985058</TD></TR><TR><TD><SPAN>Request ID</SPAN>:</TD><TD>00b49394-6b4c-9d21-229c-562abd271b6c</TD></TR><TR><TD><SPAN>Cluster URI</SPAN>:</TD><TD><A href="https://wabi-us-north-central-redirect.analysis.windows.net" target="_blank">https://wabi-us-north-central-redirect.analysis.windows.net</A></TD></TR><TR><TD><SPAN>Status code</SPAN>:</TD><TD>400</TD></TR><TR><TD><SPAN>Error Code</SPAN>:</TD><TD>DMTS_PublishDatasourceToClusterErrorCode</TD></TR><TR><TD><SPAN>Time</SPAN>:</TD><TD>Wed Feb 28 2018 08:08:29 GMT-0500 (Eastern Standard Time)</TD></TR><TR><TD><SPAN>Version</SPAN>:</TD><TD>13.0.4551.155</TD></TR></TBODY></TABLE><TABLE><TBODY><TR><TD><SPAN>Frec_PowerBI_Gateway</SPAN>:</TD><TD>Cannot connect to the mashup data source. See error details for more information.</TD></TR><TR><TD><SPAN>Underlying error code</SPAN>:</TD><TD>-2147467259</TD></TR><TR><TD><SPAN>Underlying error message</SPAN>:</TD><TD>Oracle: ORA-12154: TNS:could not resolve the connect identifier specified</TD></TR><TR><TD><SPAN>DM_ErrorDetailNameCode_UnderlyingHResult</SPAN>:</TD><TD>-2147467259</TD></TR><TR><TD><SPAN>Microsoft.Data.Mashup.ValueError.DataSourceKind</SPAN>:</TD><TD>Oracle</TD></TR><TR><TD><SPAN>Microsoft.Data.Mashup.ValueError.DataSourcePath</SPAN>:</TD><TD>&nbsp;</TD></TR><TR><TD><SPAN>Microsoft.Data.Mashup.ValueError.ErrorCode</SPAN>:</TD><TD>-2147467259</TD></TR><TR><TD><SPAN>Microsoft.Data.Mashup.ValueError.Message</SPAN>:</TD><TD>ORA-12154: TNS:could not resolve the connect identifier specified</TD></TR><TR><TD><SPAN>Microsoft.Data.Mashup.ValueError.Reason</SPAN>:</TD><TD>DataSource.Error</TD></TR></TBODY></TABLE><DIV class="warningTroubleshootLink"><A href="https://go.microsoft.com/fwlink/?LinkId=627095" target="_blank">Troubleshoot connection problems</A></DIV><DIV class="warningTroubleshootLink">&nbsp;</DIV><DIV class="warningTroubleshootLink">I have Installed Correct Version Of ODAC122010Xcopy_x64.&nbsp;&nbsp;</DIV> Thu, 01 Mar 2018 11:40:00 GMT kaushalpandey 2018-03-01T11:40:00Z Oracle: ORA-12154 https://community.fabric.microsoft.com/t5/Report-Server/Oracle-ORA-12154/m-p/367814#M4212 <P>Hi,</P><P>Getting error&nbsp; while configuring the On-Premises Gateway. During Data source Setting the below error thorw.&nbsp;</P><P>On other side through ODBC 64 bit i am able to connect with Database from Gateway server.</P><P><IMG src="Data Source Setting" border="0" alt="" /></P><P><SPAN>Unable to connect:&nbsp;We encountered an error while trying to connect to vfrecdev3.fmr.com. Details: "We could not register this data source for all gateway instances within this cluster. Please find more details below about specific errors for each gateway instance."</SPAN><SPAN><SPAN class="detailsExpander"><A href="https://app.powerbi.com/" target="_blank">Hide details</A></SPAN></SPAN></P><TABLE><TBODY><TR><TD><SPAN>Activity ID</SPAN>:</TD><TD>50003b0a-e4cc-b4ca-0b47-854007985058</TD></TR><TR><TD><SPAN>Request ID</SPAN>:</TD><TD>00b49394-6b4c-9d21-229c-562abd271b6c</TD></TR><TR><TD><SPAN>Cluster URI</SPAN>:</TD><TD><A href="https://wabi-us-north-central-redirect.analysis.windows.net" target="_blank">https://wabi-us-north-central-redirect.analysis.windows.net</A></TD></TR><TR><TD><SPAN>Status code</SPAN>:</TD><TD>400</TD></TR><TR><TD><SPAN>Error Code</SPAN>:</TD><TD>DMTS_PublishDatasourceToClusterErrorCode</TD></TR><TR><TD><SPAN>Time</SPAN>:</TD><TD>Wed Feb 28 2018 08:08:29 GMT-0500 (Eastern Standard Time)</TD></TR><TR><TD><SPAN>Version</SPAN>:</TD><TD>13.0.4551.155</TD></TR></TBODY></TABLE><TABLE><TBODY><TR><TD><SPAN>Frec_PowerBI_Gateway</SPAN>:</TD><TD>Cannot connect to the mashup data source. See error details for more information.</TD></TR><TR><TD><SPAN>Underlying error code</SPAN>:</TD><TD>-2147467259</TD></TR><TR><TD><SPAN>Underlying error message</SPAN>:</TD><TD>Oracle: ORA-12154: TNS:could not resolve the connect identifier specified</TD></TR><TR><TD><SPAN>DM_ErrorDetailNameCode_UnderlyingHResult</SPAN>:</TD><TD>-2147467259</TD></TR><TR><TD><SPAN>Microsoft.Data.Mashup.ValueError.DataSourceKind</SPAN>:</TD><TD>Oracle</TD></TR><TR><TD><SPAN>Microsoft.Data.Mashup.ValueError.DataSourcePath</SPAN>:</TD><TD>&nbsp;</TD></TR><TR><TD><SPAN>Microsoft.Data.Mashup.ValueError.ErrorCode</SPAN>:</TD><TD>-2147467259</TD></TR><TR><TD><SPAN>Microsoft.Data.Mashup.ValueError.Message</SPAN>:</TD><TD>ORA-12154: TNS:could not resolve the connect identifier specified</TD></TR><TR><TD><SPAN>Microsoft.Data.Mashup.ValueError.Reason</SPAN>:</TD><TD>DataSource.Error</TD></TR></TBODY></TABLE><DIV class="warningTroubleshootLink"><A href="https://go.microsoft.com/fwlink/?LinkId=627095" target="_blank">Troubleshoot connection problems</A></DIV><DIV class="warningTroubleshootLink">&nbsp;</DIV><DIV class="warningTroubleshootLink">I have Installed Correct Version Of ODAC122010Xcopy_x64.&nbsp;&nbsp;</DIV> Thu, 01 Mar 2018 11:40:00 GMT https://community.fabric.microsoft.com/t5/Report-Server/Oracle-ORA-12154/m-p/367814#M4212 kaushalpandey 2018-03-01T11:40:00Z