WebGIS Discussions

Need a push in the right direction when configuring WebMap, Portal or SDI services? Looking for hints and tips, or just looking for Ideas and information? The WebGIS discussion board is where you start those discussions, connect and share information.
Showing results for 
Search instead for 
Do you mean 
Reply
Staff
Posts: 20
Registered: ‎03-16-2020

Error in Geomedia Webmap Mobile 2020 updates 1

Hi,

 

Recently I have installed following products in Windows server 2016 .

 

Geomedia Desktop 2020 with update 1

Geoemdia Webmap 2020 with update 1

 

After successful configuration fo the Webmap,. When I have connected Mobile publisher from Geomedia and created a user & assign a work to the user.

 

Try to login in the GMW Mobile then its showing the "Login Username / Password are incorrect please try again or contact your administrator" Error.jpegMicrosoftTeams-image (1).png

2021-01-07 17:55:54,777 [7] ERROR Hexagon.Geospatial.Mobile.Backend.Controllers.AuthenticateController [(null)] - An error occurred while executing the command definition. See the inner exception for details.
System.Data.Entity.Core.EntityCommandExecutionException: An error occurred while executing the command definition. See the inner exception for details. ---> System.Data.SQLite.SQLiteException: SQL logic error
no such table: Users
   at System.Data.SQLite.SQLite3.Prepare(SQLiteConnection cnn, String strSql, SQLiteStatement previous, UInt32 timeoutMS, String& strRemain)
   at System.Data.SQLite.SQLiteCommand.BuildNextCommand()
   at System.Data.SQLite.SQLiteDataReader.NextResult()
   at System.Data.SQLite.SQLiteDataReader..ctor(SQLiteCommand cmd, CommandBehavior behave)
   at System.Data.SQLite.SQLiteCommand.ExecuteReader(CommandBehavior behavior)
   at System.Data.Entity.Infrastructure.Interception.InternalDispatcher`1.Dispatch[TTarget,TInterceptionContext,TResult](TTarget target, Func`3 operation, TInterceptionContext interceptionContext, Action`3 executing, Action`3 executed)
   at System.Data.Entity.Infrastructure.Interception.DbCommandDispatcher.Reader(DbCommand command, DbCommandInterceptionContext interceptionContext)
   at System.Data.Entity.Core.EntityClient.Internal.EntityCommandDefinition.ExecuteStoreCommands(EntityCommand entityCommand, CommandBehavior behavior)
   --- End of inner exception stack trace ---
   at System.Data.Entity.Core.EntityClient.Internal.EntityCommandDefinition.ExecuteStoreCommands(EntityCommand entityCommand, CommandBehavior behavior)
   at System.Data.Entity.Core.Objects.Internal.ObjectQueryExecutionPlan.Execute[TResultType](ObjectContext context, ObjectParameterCollection parameterValues)
   at System.Data.Entity.Core.Objects.ObjectContext.ExecuteInTransaction[T](Func`1 func, IDbExecutionStrategy executionStrategy, Boolean startLocalTransaction, Boolean releaseConnectionOnSuccess)
   at System.Data.Entity.Core.Objects.ObjectQuery`1.<>c__DisplayClass41_0.<GetResults>b__0()
   at System.Data.Entity.Core.Objects.ObjectQuery`1.GetResults(Nullable`1 forMergeOption)
   at System.Data.Entity.Core.Objects.ObjectQuery`1.<System.Collections.Generic.IEnumerable<T>.GetEnumerator>b__31_0()
   at System.Data.Entity.Internal.LazyEnumerator`1.MoveNext()
   at System.Linq.Enumerable.SingleOrDefault[TSource](IEnumerable`1 source)
   at Hexagon.Geospatial.Mobile.MobilePublisherMMWServicePlugin.Core.MobilePublisherMMWServicePlugin.IsCredentialsValid(String username, String password)
   at Hexagon.Geospatial.Mobile.MobilePublisherMMWServicePlugin.Core.MobilePublisherMMWServicePlugin.Authenticate(String credentials)
   at Hexagon.Geospatial.Mobile.Backend.Controllers.AuthenticateController.Post(HttpRequestMessage requestData)
2021-01-07 17:56:07,539 [8] ERROR Hexagon.Geospatial.Mobile.Backend.Controllers.AuthenticateController [(null)] - An error occurred while executing the command definition. See the inner exception for details.
System.Data.Entity.Core.EntityCommandExecutionException: An error occurred while executing the command definition. See the inner exception for details. ---> System.Data.SQLite.SQLiteException: SQL logic error
no such table: Users
   at System.Data.SQLite.SQLite3.Prepare(SQLiteConnection cnn, String strSql, SQLiteStatement previous, UInt32 timeoutMS, String& strRemain)
   at System.Data.SQLite.SQLiteCommand.BuildNextCommand()
   at System.Data.SQLite.SQLiteDataReader.NextResult()
   at System.Data.SQLite.SQLiteDataReader..ctor(SQLiteCommand cmd, CommandBehavior behave)
   at System.Data.SQLite.SQLiteCommand.ExecuteReader(CommandBehavior behavior)
   at System.Data.Entity.Infrastructure.Interception.InternalDispatcher`1.Dispatch[TTarget,TInterceptionContext,TResult](TTarget target, Func`3 operation, TInterceptionContext interceptionContext, Action`3 executing, Action`3 executed)
   at System.Data.Entity.Infrastructure.Interception.DbCommandDispatcher.Reader(DbCommand command, DbCommandInterceptionContext interceptionContext)
   at System.Data.Entity.Core.EntityClient.Internal.EntityCommandDefinition.ExecuteStoreCommands(EntityCommand entityCommand, CommandBehavior behavior)
   --- End of inner exception stack trace ---
   at System.Data.Entity.Core.EntityClient.Internal.EntityCommandDefinition.ExecuteStoreCommands(EntityCommand entityCommand, CommandBehavior behavior)
   at System.Data.Entity.Core.Objects.Internal.ObjectQueryExecutionPlan.Execute[TResultType](ObjectContext context, ObjectParameterCollection parameterValues)
   at System.Data.Entity.Core.Objects.ObjectContext.ExecuteInTransaction[T](Func`1 func, IDbExecutionStrategy executionStrategy, Boolean startLocalTransaction, Boolean releaseConnectionOnSuccess)
   at System.Data.Entity.Core.Objects.ObjectQuery`1.<>c__DisplayClass41_0.<GetResults>b__0()
   at System.Data.Entity.Core.Objects.ObjectQuery`1.GetResults(Nullable`1 forMergeOption)
   at System.Data.Entity.Core.Objects.ObjectQuery`1.<System.Collections.Generic.IEnumerable<T>.GetEnumerator>b__31_0()
   at System.Data.Entity.Internal.LazyEnumerator`1.MoveNext()
   at System.Linq.Enumerable.SingleOrDefault[TSource](IEnumerable`1 source)
   at Hexagon.Geospatial.Mobile.MobilePublisherMMWServicePlugin.Core.MobilePublisherMMWServicePlugin.IsCredentialsValid(String username, String password)
   at Hexagon.Geospatial.Mobile.MobilePublisherMMWServicePlugin.Core.MobilePublisherMMWServicePlugin.Authenticate(String credentials)
   at Hexagon.Geospatial.Mobile.Backend.Controllers.AuthenticateController.Post(HttpRequestMessage requestData)
2021-01-07 17:56:11,490 [8] ERROR Hexagon.Geospatial.Mobile.Backend.Controllers.AuthenticateController [(null)] - An error occurred while executing the command definition. See the inner exception for details.
System.Data.Entity.Core.EntityCommandExecutionException: An error occurred while executing the command definition. See the inner exception for details. ---> System.Data.SQLite.SQLiteException: SQL logic error
no such table: Users
   at System.Data.SQLite.SQLite3.Prepare(SQLiteConnection cnn, String strSql, SQLiteStatement previous, UInt32 timeoutMS, String& strRemain)
   at System.Data.SQLite.SQLiteCommand.BuildNextCommand()
   at System.Data.SQLite.SQLiteDataReader.NextResult()
   at System.Data.SQLite.SQLiteDataReader..ctor(SQLiteCommand cmd, CommandBehavior behave)
   at System.Data.SQLite.SQLiteCommand.ExecuteReader(CommandBehavior behavior)
   at System.Data.Entity.Infrastructure.Interception.InternalDispatcher`1.Dispatch[TTarget,TInterceptionContext,TResult](TTarget target, Func`3 operation, TInterceptionContext interceptionContext, Action`3 executing, Action`3 executed)
   at System.Data.Entity.Infrastructure.Interception.DbCommandDispatcher.Reader(DbCommand command, DbCommandInterceptionContext interceptionContext)
   at System.Data.Entity.Core.EntityClient.Internal.EntityCommandDefinition.ExecuteStoreCommands(EntityCommand entityCommand, CommandBehavior behavior)
   --- End of inner exception stack trace ---
   at System.Data.Entity.Core.EntityClient.Internal.EntityCommandDefinition.ExecuteStoreCommands(EntityCommand entityCommand, CommandBehavior behavior)
   at System.Data.Entity.Core.Objects.Internal.ObjectQueryExecutionPlan.Execute[TResultType](ObjectContext context, ObjectParameterCollection parameterValues)
   at System.Data.Entity.Core.Objects.ObjectContext.ExecuteInTransaction[T](Func`1 func, IDbExecutionStrategy executionStrategy, Boolean startLocalTransaction, Boolean releaseConnectionOnSuccess)
   at System.Data.Entity.Core.Objects.ObjectQuery`1.<>c__DisplayClass41_0.<GetResults>b__0()
   at System.Data.Entity.Core.Objects.ObjectQuery`1.GetResults(Nullable`1 forMergeOption)
   at System.Data.Entity.Core.Objects.ObjectQuery`1.<System.Collections.Generic.IEnumerable<T>.GetEnumerator>b__31_0()
   at System.Data.Entity.Internal.LazyEnumerator`1.MoveNext()
   at System.Linq.Enumerable.SingleOrDefault[TSource](IEnumerable`1 source)
   at Hexagon.Geospatial.Mobile.MobilePublisherMMWServicePlugin.Core.MobilePublisherMMWServicePlugin.IsCredentialsValid(String username, String password)
   at Hexagon.Geospatial.Mobile.MobilePublisherMMWServicePlugin.Core.MobilePublisherMMWServicePlugin.Authenticate(String credentials)
   at Hexagon.Geospatial.Mobile.Backend.Controllers.AuthenticateController.Post(HttpRequestMessage requestData)

 

Later I observed that at Mobile Backend, .json configuration file has not been created . I have reconfigured again wothout any error but same error persists.

 

I am attaching the GMWM log file . 

 

Thanks in advance for your solution.

 

Regards

VIPLAW KUMAR P

 

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

Re: Error in Geomedia Webmap Mobile 2020 updates 1

Hi viplaw,

 

Can you check if you have the users created available after opening Mobile Publisher > Users?

Is there any error in MobileBackend log or Mobile Publisher log, when you create a new user?

 

Do you have GeomediaMobile.gpkg file available in both of these locations?

- C:\ProgramData\Hexagon\GWM\MobilePublisher
- C:\Program Files\Common Files\Hexagon\Services\AdminInstances\MobileBackend\App_Data\MobilePublisher

Jan Neumann
Post Sales Engineer Web Applications
Hexagon Geospatial

Staff
Posts: 20
Registered: ‎03-16-2020

Re: Error in Geomedia Webmap Mobile 2020 updates 1

[ Edited ]

Hi Jan,

 

Thnkas for the reply,

 

After creating the users, those users are avilable in mobile publisher & there aere no errors in GMWM Log.

 

 

Yes, GeomediaMobile.gpkg file available in both of the following locations (attached screenshot for your reference)

  • C:\ProgramData\Hexagon\GWM\MobilePublisher
    - C:\Program Files\Common Files\Hexagon\Services\AdminInstances\MobileBackend\App_Data\MobilePublisher

MicrosoftTeams-image (2).pngMicrosoftTeams-image (3).png

Regards

VIPLAW