19.1 beta exception on AWS EC2 server

For complex topics that regular users would not be interested in. For power users and database administrators.
Post Reply
User avatar
wjstarck
Posts: 935
Joined: Tue Jul 31, 2007 7:18 am
Location: Keller, TX
Contact:

19.1 beta exception on AWS EC2 server

Post by wjstarck » Fri Mar 22, 2019 1:20 pm

Hello-

I am testing OD on a AWS EC2 instance of Windows Server 2016.

I have compiled the latest beta of 19.1 (19.1.8) and it runs fine on my Windows 10 desktop. But, if I upload all the files and my db to the EC2 server, I get the following exception at runtime:

Code: Select all

Error Encountered - 03/22/2019 3:01:14 PM
Unhandled exception:  ThemeSetByUser is an invalid pref name.
System.Exception
   at OpenDentBusiness.Prefs.GetOne(String prefName) in C:\Users\wjs\Desktop\ODVersions\opendental19.1\opendental19.1\OpenDentBusiness\Data Interface\Prefs.cs:line 152
   at OpenDentBusiness.Prefs.GetOne(PrefName prefName) in C:\Users\wjs\Desktop\ODVersions\opendental19.1\opendental19.1\OpenDentBusiness\Data Interface\Prefs.cs:line 145
   at OpenDentBusiness.PrefC.GetBool(PrefName prefName) in C:\Users\wjs\Desktop\ODVersions\opendental19.1\opendental19.1\OpenDentBusiness\Cache\PrefC.cs:line 153
   at OpenDentBusiness.UserOdPrefs.SetThemeForUserIfNeeded() in C:\Users\wjs\Desktop\ODVersions\opendental19.1\opendental19.1\OpenDentBusiness\Data Interface\UserOdPrefs.cs:line 339
   at OpenDental.FormLogOn.butOK_Click(Object sender, EventArgs e) in C:\Users\wjs\Desktop\ODVersions\opendental19.1\opendental19.1\OpenDental\Forms\FormLogOn.cs:line 154
   at System.Windows.Forms.Control.OnClick(EventArgs e)
   at System.Windows.Forms.Button.OnClick(EventArgs e)
   at OpenDental.UI.Button.OnClick(EventArgs ea) in C:\Users\wjs\Desktop\ODVersions\opendental19.1\opendental19.1\OpenDental\UI\Button.cs:line 108
   at System.Windows.Forms.Button.OnMouseUp(MouseEventArgs mevent)
   at System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons button, Int32 clicks)
   at System.Windows.Forms.Control.WndProc(Message& m)
   at System.Windows.Forms.ButtonBase.WndProc(Message& m)
   at System.Windows.Forms.Button.WndProc(Message& m)
   at System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m)
   at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)
   at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)
I was hoping you might have suggestions as to how to resolve it (I am accessing the server via RDP, and if I look at themes it does say that backgrounds are turned off by RDP)
Cheers,

Bill Starck, DDS
Big Idea Software, LLC
Developer, EASy(Electronic Anesthesia System) for Open Dental
817-807-1709
TX, USA

User avatar
jsalmon
Posts: 1551
Joined: Tue Nov 30, 2010 12:33 pm
Contact:

Re: 19.1 beta exception on AWS EC2 server

Post by jsalmon » Fri Mar 22, 2019 1:57 pm

That error makes it sound like your database didn't quite finish the 19_1_1 script. Does your preference table contain rows for the following PrefNames? ThemeSetByUser, GlobalUpdateWriteOffLastClinicCompleted
The best thing about a boolean is even if you are wrong, you are only off by a bit.

Jason Salmon
Open Dental Software
http://www.opendental.com

User avatar
wjstarck
Posts: 935
Joined: Tue Jul 31, 2007 7:18 am
Location: Keller, TX
Contact:

Re: 19.1 beta exception on AWS EC2 server

Post by wjstarck » Fri Mar 22, 2019 3:06 pm

Yes, that's it thanks.
Cheers,

Bill Starck, DDS
Big Idea Software, LLC
Developer, EASy(Electronic Anesthesia System) for Open Dental
817-807-1709
TX, USA

User avatar
wjstarck
Posts: 935
Joined: Tue Jul 31, 2007 7:18 am
Location: Keller, TX
Contact:

Re: 19.1 beta exception on AWS EC2 server

Post by wjstarck » Fri Mar 22, 2019 3:11 pm

One more question, on the same box:

I'm getting this when I try to send a NewCrop Rx. eConnector service is setup and running:

Code: Select all

A technical error has been automatically reported to your EMR/PM vendor.  Contact them for more information. MSG 3 - Credentials: partner invalid or not authorized - MSG01

Original XML:
<?xml version="1.0"?>
<NCScript xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns="http://secure.newcropaccounts.com/interfaceV7">
  <Credentials>
    <partnerName>OpenDentalLexi</partnerName>
    <name>demo</name>
    <password>demo</password>
    <productName>OpenDental</productName>
    <productVersion>19.1.8.0</productVersion>

 [snip for HIPPAA]


    </PatientCharacteristics>
  </Patient>
</NCScript>
TIA
Cheers,

Bill Starck, DDS
Big Idea Software, LLC
Developer, EASy(Electronic Anesthesia System) for Open Dental
817-807-1709
TX, USA

User avatar
jsalmon
Posts: 1551
Joined: Tue Nov 30, 2010 12:33 pm
Contact:

Re: 19.1 beta exception on AWS EC2 server

Post by jsalmon » Fri Mar 22, 2019 5:00 pm

Try building in Release mode? Looks like demo credentials were sent over.
The best thing about a boolean is even if you are wrong, you are only off by a bit.

Jason Salmon
Open Dental Software
http://www.opendental.com

User avatar
wjstarck
Posts: 935
Joined: Tue Jul 31, 2007 7:18 am
Location: Keller, TX
Contact:

Re: 19.1 beta exception on AWS EC2 server

Post by wjstarck » Fri Mar 22, 2019 8:33 pm

Yes that's it thank you.

Last one: I am having trouble get the eConnectorService running on this PC (it will install but won't start). Is that because I have it running on my production PC? This is my development machine (AWS EC2) that I am trying to get set up to move my production OD install over to.

I've tried opening AWS firewall ports 49997, 49999, 50000 and 50002 but the service still won't start. I've tried uninstalling the eConnector service on my production PC but it still won't work.
Cheers,

Bill Starck, DDS
Big Idea Software, LLC
Developer, EASy(Electronic Anesthesia System) for Open Dental
817-807-1709
TX, USA

User avatar
cmcgehee
Posts: 711
Joined: Tue Aug 25, 2015 5:06 pm
Location: Salem, Oregon

Re: 19.1 beta exception on AWS EC2 server

Post by cmcgehee » Mon Mar 25, 2019 8:28 am

You might need to set the "Update Server Name" to the name of the computer where your eConnector is running. This can be set in Setup -> Miscellaneous. If that isn't it, there should be a folder named "Logger" in the eConnector installation folder that should tell you why the eConnector isn't starting.
Chris McGehee
Open Dental Software
http://www.opendental.com

User avatar
wjstarck
Posts: 935
Joined: Tue Jul 31, 2007 7:18 am
Location: Keller, TX
Contact:

Re: 19.1 beta exception on AWS EC2 server

Post by wjstarck » Mon Mar 25, 2019 10:40 am

I had to manually install the EConnector service and change the servername in that dialog to my AWS instance servername from 'localhost'.

Working now, thanks.
Cheers,

Bill Starck, DDS
Big Idea Software, LLC
Developer, EASy(Electronic Anesthesia System) for Open Dental
817-807-1709
TX, USA

User avatar
wjstarck
Posts: 935
Joined: Tue Jul 31, 2007 7:18 am
Location: Keller, TX
Contact:

Re: 19.1 beta exception on AWS EC2 server

Post by wjstarck » Mon Mar 25, 2019 11:05 am

Whelp, one step forward, two steps back.

I have the EConnector installed and running, but now when I try to write an eRx I get:

'Based on a period of inactivity, you have been automatically logged-out of your account. To resume prescribing, re-enter the website address. It is recommended that this address is added to your browser Favorites list'

I have ports 80 and 443 open on the AWS firewall, what website address is it referring to and how would I re-enter it?
Cheers,

Bill Starck, DDS
Big Idea Software, LLC
Developer, EASy(Electronic Anesthesia System) for Open Dental
817-807-1709
TX, USA

User avatar
cmcgehee
Posts: 711
Joined: Tue Aug 25, 2015 5:06 pm
Location: Salem, Oregon

Re: 19.1 beta exception on AWS EC2 server

Post by cmcgehee » Mon Mar 25, 2019 2:21 pm

Here's our internal documentation about what to do when you encounter this issue:
Solution 1: Close the eRx window and Open Dental. Clear the cache and cookies out of Internet Explorer. Re-open Open Dental and try eRx again.
Solution 2: Add NewCrop to the trusted sites in Internet Explorer. From Within Internet Explorer -> Settings "Gear icon in upper right" ->Security tab ->Trusted sites ->Sites ->Type: "secure.newcropaccounts.com" ->Add. Close IE and try eRx again.
Chris McGehee
Open Dental Software
http://www.opendental.com

User avatar
wjstarck
Posts: 935
Joined: Tue Jul 31, 2007 7:18 am
Location: Keller, TX
Contact:

Re: 19.1 beta exception on AWS EC2 server

Post by wjstarck » Mon Mar 25, 2019 7:30 pm

#2 did the trick, Chris. Thank you
Cheers,

Bill Starck, DDS
Big Idea Software, LLC
Developer, EASy(Electronic Anesthesia System) for Open Dental
817-807-1709
TX, USA

Post Reply