Medisoft Mobile Interface Configuration

Posts related Medisoft software.
Post Reply
User avatar
ExpertSkinDoc
Posts: 31
Joined: Sat Feb 01, 2014 9:30 pm
Location: San Jose, CA
Contact:

Medisoft Mobile Interface Configuration

Post by ExpertSkinDoc » Mon Nov 05, 2018 7:30 pm

I am unable to get the screen in Medisoft to get Api Key and Api Code for Medisoft Mobile. It somehow has disappeared from Tools -> Services -> Mobile Interface Configuration. I have eMDs MSL Connectivity Service running on the server, but it keeps on stopping when you manually start the service, a dialog would pop ups saying it is not in use by other services or programs.

I've restarted the Server to no avail, cannot get Mobile Interface Configuration screen to get the Api Key and Api code. What else should I do?

Running Networked Medisoft Server/Client Version 22sp1(22.1.2.69)

User avatar
Gavin Walker
Posts: 4193
Joined: Wed Apr 04, 2007 10:11 pm
Location: Springfield, MO
Contact:

Re: Medisoft Mobile Interface Configuration

Post by Gavin Walker » Mon Nov 05, 2018 7:44 pm

Start and exit Medisoft from the server and make sure you browse to MediData through the share instead of C: (Press and hold F7 when starting Medisoft to select the MediData root folder on the share). Then restart the eMD MSL Mobile Service. Mobile can get confused if there is more than one MediData root on the server. Otherwise, there is a log file you can go look at for some more information in C:\Program Files (x86)\eMDs MSL Connectivity Service\.
Gavin Walker
Walker Tek Solutions, LLC
866-890-6777
417-890-6777

User avatar
ExpertSkinDoc
Posts: 31
Joined: Sat Feb 01, 2014 9:30 pm
Location: San Jose, CA
Contact:

Re: Medisoft Mobile Interface Configuration

Post by ExpertSkinDoc » Tue Nov 06, 2018 11:53 am

Problem solved.

My problem I figured out was I set for Advantage database server service to delayed start where as the Mobile service to immediate start. After reversing the order of the services, restart the server, the Mobile Interface Configuration Service is showing up under Tools and is working again.

Thanks for the tips above, Gavin.

User avatar
ExpertSkinDoc
Posts: 31
Joined: Sat Feb 01, 2014 9:30 pm
Location: San Jose, CA
Contact:

Re: Medisoft Mobile Interface Configuration

Post by ExpertSkinDoc » Wed Nov 07, 2018 12:19 pm

New problem arise.

emDsMSLService stopped! It was working fine for a couple of hours, then the service mysteriously stopped. I restarted the service but each time it would stop right away. So I open the log file and it seems that the SQL database is locked:

181107.063411.428 I -- Running script '10.MSLSVC_GT.sql', version 0, existing version -1
181107.063411.584 E -- Unhandled exception in FhirHose:ThreadMain
181107.063411.584 E -- ...SQLiteException: database is locked
database is locked
181107.063411.584 E -- ... at System.Data.SQLite.SQLite3.Step(SQLiteStatement stmt)
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.SQLite.SQLiteCommand.ExecuteNonQuery()
at DbStmt.Exec(String sql) in C:\Build\Source\MSLService-3.0\3.0\MSL\Server\MSLService\Shared\DbStmt.cs:line 71
at MSLService.LocalDatabase.SetGT(String key, String value) in C:\Build\Source\MSLService-3.0\3.0\MSL\Server\MSLService\LocalDatabase.cs:line 576
at MSLService.FhirHose.FhCoreMedisoft.OnDbPathRegistered(String dbPath) in C:\Build\Source\MSLService-3.0\3.0\MSL\Server\MSLService\FhirHose\FhCoreMedisoft.cs:line 193
at MSLService.FhirHose.FhirHose.RegisterDbPath(String dbPath) in C:\Build\Source\MSLService-3.0\3.0\MSL\Server\MSLService\FhirHose\FhirHose.cs:line 469
at MSLService.FhirHose.FhirHose.<>c__DisplayClass13_0.<Reload>b__0(FhConfigRec conInfo) in C:\Build\Source\MSLService-3.0\3.0\MSL\Server\MSLService\FhirHose\FhirHose.cs:line 148
at MSLService.LocalDatabase.EnumConnections(FhCoreBase coreImpl, Action`1 func) in C:\Build\Source\MSLService-3.0\3.0\MSL\Server\MSLService\LocalDatabase.cs:line 471
at MSLService.FhirHose.FhirHose.Reload() in C:\Build\Source\MSLService-3.0\3.0\MSL\Server\MSLService\FhirHose\FhirHose.cs:line 120
at MSLService.FhirHose.FhirHose.ThreadMain() in C:\Build\Source\MSLService-3.0\3.0\MSL\Server\MSLService\FhirHose\FhirHose.cs:line 305
181107.063411.584 E -- Unhandled exception in ThreadMain. Stopping the service.
181107.063411.584 I -- FhirHose:Shutdown - stopping RPC
181107.063416.591 I -- FhirHose:Shutdown - Killing connections
181107.063416.607 I -- End Auto-Update Timer stopped.
181107.063416.607 I -- ThreadMain exiting

Is there a way I can unlock the SQLLite database or just uninstall the eMDs Mobile Interface and reinstall it?

User avatar
ExpertSkinDoc
Posts: 31
Joined: Sat Feb 01, 2014 9:30 pm
Location: San Jose, CA
Contact:

Re: Medisoft Mobile Interface Configuration

Post by ExpertSkinDoc » Fri Nov 09, 2018 5:42 am

Uninstalling Medisoft and reinstalling did not work, but deleting Mobile.db in c:\ProgramData\Medisoft then restart Mobile service did the trick. Mobile.db must have been corrupted somehow.

User avatar
Gavin Walker
Posts: 4193
Joined: Wed Apr 04, 2007 10:11 pm
Location: Springfield, MO
Contact:

Re: Medisoft Mobile Interface Configuration

Post by Gavin Walker » Fri Nov 09, 2018 9:56 am

Good find. I'll have to keep that in mind the next time I run into this.

Post Reply