M.App Enterprise Discussions

Discuss topics with other M.App Enterprise Product pioneers and experts to get the most out of it.
Showing results for 
Search instead for 
Do you mean 
Reply
Highlighted
Contributor
Posts: 37
Registered: ‎10-07-2019
Accepted Solution

M.App Enterprise Oracle Connection

I want to connect our Oracle database with M.App and I get this dialog box for data connection

mapp_dialog_oracle.PNG

What data source or connection string should I use here ?

 

Thanks,

 

Muhammad Almas

Highlighted
Technical Evangelist
Posts: 1,269
Registered: ‎09-11-2015

Re: M.App Enterprise Oracle Connection

Hi Muhammad,

 

Usually the TNS connection identifier (from tns_names.ora), or easy-connect connection string.

Jan Neumann
Post Sales Engineer Web Applications
Hexagon Geospatial

Highlighted
Contributor
Posts: 37
Registered: ‎10-07-2019

Re: M.App Enterprise Oracle Connection

Thank you very much. TSN name worked.

 

Now I can connect and get the list of all the layers, however, now I am running in to another weird error. If I select a layer and try to import it, the name value is not being accepted by MApp enterprise server and it is showing very uninformative error. Can you please help in fixing that ? (I have tried clearing the cache of browser as well).

 

error_mapp_vector_name.PNG

 

Thank you,

 

Muhammad Almas

Highlighted
Technical Evangelist
Posts: 1,269
Registered: ‎09-11-2015

Re: M.App Enterprise Oracle Connection

Do you have anything logged in the Studio > Log?

Jan Neumann
Post Sales Engineer Web Applications
Hexagon Geospatial

Highlighted
Contributor
Posts: 37
Registered: ‎10-07-2019

Re: M.App Enterprise Oracle Connection

Hi Jan,

 

There are errors in log but I can't understand them much right now. One thing that I noticed that in every name field when I try to enter I get same error 'could not validate. Internal Server error.' Just like this one is for new role.

 

mapp_error1.PNG

 

Log file is something like this:

mapp_error2.PNG

 

Could this be something related to certificate issue ? 

 

Regards,

 

Muhammad Almas

Highlighted
Contributor
Posts: 37
Registered: ‎10-07-2019

Re: M.App Enterprise Oracle Connection

Hi Jan,

 

I installed the self signed certificate as Trusted Authority but I am still getting similar error message. It looks like that MApp is looking for following table/relation in postgres database "mapp_user_role", but there is no such table in postgres database. Could that be the issue ? if yes then how can we fix it? 

 

Regards,

 

Muhammad Almas

 

Full error message is:

Npgsql.PostgresException: 42P01: relation "mapp_user_role" does not exist
   [Details]
   Severity: ERROR
   SqlState: 42P01
   Code: 42P01
   MessageText: relation "mapp_user_role" does not exist
   Position: 168
   File: d:\pginstaller_12.auto\postgres.windows-x64\src\backend\parser\parse_relation.c
   Line: 1194
   Routine: parserOpenTable
   MS_LoggedBy: System.Collections.Generic.List`1[System.Object]
   at Npgsql.NpgsqlConnector.<>c__DisplayClass161_0.<<ReadMessage>g__ReadMessageLong|0>d.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
   at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
   at Npgsql.NpgsqlConnector.<>c__DisplayClass161_0.<<ReadMessage>g__ReadMessageLong|0>d.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
   at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
   at Npgsql.NpgsqlDataReader.<NextResult>d__46.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
   at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
   at Npgsql.NpgsqlCommand.<ExecuteDbDataReader>d__100.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
   at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
   at MApp.Data.Database.<ExecuteReaderAsync>d__114.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
   at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
   at MApp.Data.Database.<ExecuteReaderAsync>d__61.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
   at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
   at MApp.Endpoints.SecurityController.<GetUsers>d__0.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
   at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
   at System.Threading.Tasks.TaskHelpersExtensions.<CastToObject>d__1`1.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
   at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
   at System.Web.Http.Controllers.ApiControllerActionInvoker.<InvokeActionAsyncCore>d__1.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
   at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
   at System.Web.Http.Filters.ActionFilterAttribute.<CallOnActionExecutedAsync>d__6.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
   at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
   at System.Web.Http.Filters.ActionFilterAttribute.<CallOnActionExecutedAsync>d__6.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
   at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
   at System.Web.Http.Filters.ActionFilterAttribute.<ExecuteActionFilterAsyncCore>d__5.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
   at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
   at System.Web.Http.Controllers.ActionFilterResult.<ExecuteAsync>d__5.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
   at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
   at System.Web.Http.Filters.AuthorizationFilterAttribute.<ExecuteAuthorizationFilterAsyncCore>d__3.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
   at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
   at System.Web.Http.Controllers.AuthenticationFilterResult.<ExecuteAsync>d__5.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
   at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
   at System.Web.Http.Dispatcher.HttpControllerDispatcher.<SendAsync>d__15.MoveNext()

 

 

Highlighted
Technical Evangelist
Posts: 1,269
Registered: ‎09-11-2015

Re: M.App Enterprise Oracle Connection

This seems to be related to Tenant database problem. Please see following two topics with similar symptoms:

https://community.hexagongeospatial.com/t5/M-App-Enterprise-Discussions/Why-Each-Input-will-display-...

https://community.hexagongeospatial.com/t5/M-App-Enterprise-Discussions/Update-M-App-Enterprise-to-2...

 

You can try to create a new tenant via Management using postgres (admin) user connection, then revert back to standard user.

Jan Neumann
Post Sales Engineer Web Applications
Hexagon Geospatial

Highlighted
Contributor
Posts: 37
Registered: ‎10-07-2019

Re: M.App Enterprise Oracle Connection

Thank you very much Jan.

 

Your first link did the trick. I seperated the Master database and tennents database (and used postgis template for both) and it resolved the issue.

 

Regards,

 

Muhammad Almas