Mobile App with tenant metadata and/or data in Oracle database

by on (863 Views)

Symptoms

Having tenant metadata in Oracle configured using a TNS name specified in tnsnames.ora, you cannot login into the Mobile App getting "Invalid User" error.

Having data in Oracle configured using a TNS name specified in tnsnames.ora, you get error while trying to load the Mobile App assigned to you.

Diagnosis

On the server side you can check the event viewer and you will find an error related to a .NET application. In the details you will find an oracle error like:

ORA-12154: TNS:could not resolve the connect identifier specified

That errors is related to the Oracle .NET managed driver that is not capabile or reading the settings in the Windows registry. Please refer to:

https://docs.oracle.com/cd/E63277_01/win.121/e63268/InstallManagedConfig.htm#ODPNT8159

Solution

You have to manually edit the web.config file of the Mobile endpoint within:

[M.App Enterprise installation folder]\Mobile

You have to add the following within the <configuration> section:

at the beginning, before <system.web> section:

<configSections>
	<section name="oracle.manageddataaccess.client" type="OracleInternal.Common.ODPMSectionHandler, Oracle.ManagedDataAccess, Version=4.122.18.3, Culture=neutral, PublicKeyToken=89b483f429c47342"/>
</configSections>

right after <system.data> section (changing the content of the "value"):

<oracle.manageddataaccess.client>
	<version number="*">
		<settings>
			<setting name="TNS_ADMIN" value="C:\oracle\product\18.0.0\client_1\network\admin" />
		 </settings>
	</version>
</oracle.manageddataaccess.client>

Rate this article:

Yes No

Comments

Thanks Stefano,

a short remark. I have followed your steps and modified the web.config as stated above. After the change the mobile endpoint was not accessible anymore: Error500

The reason: the oracle.manageddataaccess.client has been already defined.

After removing the complete <configSections>-part the mobile endpoint was accessible and I was able to login even when using Oracle

Cheers

Fritz

Permalink

hi Fritz,

thanks for the feedback.

Did you have this line in the <DbProviderFactories>?

Stefano

Permalink

Hi Stefano,

yes this line is there. The DB-Providers block looks like:

<system.data>
    <DbProviderFactories>
      <remove invariant="Npgsql" />
      <add name="Npgsql Data Provider" invariant="Npgsql" description=".Net Framework Data Provider for Postgresql" type="Npgsql.NpgsqlFactory, Npgsql" />
      <remove invariant="Oracle.ManagedDataAccess.Client" />
      <add name="ODP.NET, Managed Driver" invariant="Oracle.ManagedDataAccess.Client" description="Oracle Data Provider for .NET, Managed Driver" type="Oracle.ManagedDataAccess.Client.OracleClientFactory, Oracle.ManagedDataAccess, Version=4.122.18.3, Culture=neutral, PublicKeyToken=89b483f429c47342" />
    </DbProviderFactories>
</system.data>

Right after this block I added:

<oracle.manageddataaccess.client>
  <version number="*">
    	<settings>
    		<setting name="TNS_ADMIN" value="C:\Program Files\Oracle\Client\product\12.1.0\client_32\network\admin" />
    	 </settings>
  </version>
</oracle.manageddataaccess.client>

Now I do not get any errors in the event viewer, the mobile endpoints still works and I am able to login and startup the mobile app.

Cheers

Fritz

Permalink

[{"id":"c_27","title":"All tutorials","items":[{"id":"27874","title":"M.App Enterprise - Mobile Documentation","view_href":"/t5/M-App-Enterprise-Tutorials/M-App-Enterprise-Mobile-Documentation/ta-p/27874","isArticle":true,"isUnordered":false,"items":[]},{"id":"27294","title":"How to setup a Mobile App","view_href":"/t5/M-App-Enterprise-Tutorials/How-to-setup-a-Mobile-App/ta-p/27294","isArticle":true,"isUnordered":false,"items":[]},{"id":"26072","title":"Build a Browser App to run a spatial Recipe","view_href":"/t5/M-App-Enterprise-Tutorials/Build-a-Browser-App-to-run-a-spatial-Recipe/ta-p/26072","isArticle":true,"isUnordered":false,"items":[]},{"id":"28016","title":"How to setup a Mobile App - Part 2","view_href":"/t5/M-App-Enterprise-Tutorials/How-to-setup-a-Mobile-App-Part-2/ta-p/28016","isArticle":true,"isUnordered":false,"items":[]},{"id":"29750","title":"M.App Enterprise - Mobile App Beta Testing","view_href":"/t5/M-App-Enterprise-Tutorials/M-App-Enterprise-Mobile-App-Beta-Testing/ta-p/29750","isArticle":true,"isUnordered":false,"items":[]},{"id":"26853","title":"M.App Enterprise 2018 - Hexagon App Launcher","view_href":"/t5/M-App-Enterprise-Tutorials/M-App-Enterprise-2018-Hexagon-App-Launcher/ta-p/26853","isArticle":true,"isUnordered":false,"items":[]},{"id":"33226","title":"Mobile App with tenant metadata and/or data in Oracle database","view_href":"/t5/M-App-Enterprise-Tutorials/Mobile-App-with-tenant-metadata-and-or-data-in-Oracle-database/ta-p/33226","isArticle":true,"isUnordered":false,"items":[]},{"id":"20578","title":"Workflow Tutorial: Creating a Basic Workflow for Desktop App","view_href":"/t5/M-App-Enterprise-Tutorials/Workflow-Tutorial-Creating-a-Basic-Workflow-for-Desktop-App/ta-p/20578","isArticle":true,"isUnordered":false,"items":[]},{"id":"23260","title":"Javascript API in Desktop M.App","view_href":"/t5/M-App-Enterprise-Tutorials/Javascript-API-in-Desktop-M-App/ta-p/23260","isArticle":true,"isUnordered":false,"items":[]},{"id":"34352","title":"Using domain accounts for the Warehouse user","view_href":"/t5/M-App-Enterprise-Tutorials/Using-domain-accounts-for-the-Warehouse-user/ta-p/34352","isArticle":true,"isUnordered":false,"items":[]},{"id":"34056","title":"How to solve Spatial Workshop problems","view_href":"/t5/M-App-Enterprise-Tutorials/How-to-solve-Spatial-Workshop-problems/ta-p/34056","isArticle":true,"isUnordered":false,"items":[]},{"id":"14379","title":"Trainings Materials for M.App Enterprise","view_href":"/t5/M-App-Enterprise-Tutorials/Trainings-Materials-for-M-App-Enterprise/ta-p/14379","isArticle":true,"isUnordered":false,"items":[]},{"id":"28355","title":"Query API samples","view_href":"/t5/M-App-Enterprise-Tutorials/Query-API-samples/ta-p/28355","isArticle":true,"isUnordered":false,"items":[]},{"id":"28400","title":"Support of different Oracle Database Client software versions","view_href":"/t5/M-App-Enterprise-Tutorials/Support-of-different-Oracle-Database-Client-software-versions/ta-p/28400","isArticle":true,"isUnordered":false,"items":[]},{"id":"18999","title":"Apps for the public (no user login)","view_href":"/t5/M-App-Enterprise-Tutorials/Apps-for-the-public-no-user-login/ta-p/18999","isArticle":true,"isUnordered":false,"items":[]},{"id":"34092","title":"Published vectorset not available for use as M.App Enterprise Feature Data in Analyzer View","view_href":"/t5/M-App-Enterprise-Tutorials/Published-vectorset-not-available-for-use-as-M-App-Enterprise/ta-p/34092","isArticle":true,"isUnordered":false,"items":[]},{"id":"17688","title":"How to use Power BI and M.App Enterprise","view_href":"/t5/M-App-Enterprise-Tutorials/How-to-use-Power-BI-and-M-App-Enterprise/ta-p/17688","isArticle":true,"isUnordered":false,"items":[]},{"id":"32966","title":"Working with Tutorial: How to display points thematically in Mobile M.App","view_href":"/t5/M-App-Enterprise-Tutorials/Working-with-Tutorial-How-to-display-points-thematically-in/ta-p/32966","isArticle":true,"isUnordered":false,"items":[]},{"id":"29479","title":"How to add a My Geoservice WMS as a layer in Analyzer Views","view_href":"/t5/M-App-Enterprise-Tutorials/How-to-add-a-My-Geoservice-WMS-as-a-layer-in-Analyzer-Views/ta-p/29479","isArticle":true,"isUnordered":false,"items":[]},{"id":"19004","title":"Standalone Workflow in custom panel","view_href":"/t5/M-App-Enterprise-Tutorials/Standalone-Workflow-in-custom-panel/ta-p/19004","isArticle":true,"isUnordered":false,"items":[]},{"id":"23708","title":"M.App Enterprise Load Balanced","view_href":"/t5/M-App-Enterprise-Tutorials/M-App-Enterprise-Load-Balanced/ta-p/23708","isArticle":true,"isUnordered":false,"items":[]},{"id":"10159","title":"Installation of M.App Enterprise","view_href":"/t5/M-App-Enterprise-Tutorials/Installation-of-M-App-Enterprise/ta-p/10159","isArticle":true,"isUnordered":false,"items":[]},{"id":"17560","title":"How to use Active Directory in M.App Enterprise","view_href":"/t5/M-App-Enterprise-Tutorials/How-to-use-Active-Directory-in-M-App-Enterprise/ta-p/17560","isArticle":true,"isUnordered":false,"items":[]},{"id":"22573","title":"How to: Display thematic legend entry in Desktop M.Apps","view_href":"/t5/M-App-Enterprise-Tutorials/How-to-Display-thematic-legend-entry-in-Desktop-M-Apps/ta-p/22573","isArticle":true,"isUnordered":false,"items":[]},{"id":"29473","title":"Desktop Client Log Console (F12)","view_href":"/t5/M-App-Enterprise-Tutorials/Desktop-Client-Log-Console-F12/ta-p/29473","isArticle":true,"isUnordered":false,"items":[]}],"isUnordered":false}]

Overview

M.App Enterprise Tutorials

Mobile App with tenant metadata and/or data in Oracle database

M.App Enterprise

Mobile App

Oracle

Symptoms

Diagnosis

Solution