Configuring db connection for Windows Authentication causes JVM to crash

Ignition
,
1

This weekend I attempted to add a new db connection to a running gateway. Two db connections with sql authentication were up and running, and I wanted to add a third db connection using windows authentication. I used these instructions:

https://support.inductiveautomation.com/index.php?/Knowledgebase/Article/View/5/0/microsoft-sql-server-mssql-connection-guide-for-ignition

The gateway service failed to restart due to access violation errors:
INFO | jvm 5 | 2019/08/25 14:44:44 | #
INFO | jvm 5 | 2019/08/25 14:44:44 | # A fatal error has been detected by the Java Runtime Environment:
INFO | jvm 5 | 2019/08/25 14:44:44 | #
INFO | jvm 5 | 2019/08/25 14:44:44 | # EXCEPTION_ACCESS_VIOLATION (0xc0000005) at pc=0x00007ffe8697ce10, pid=12032, tid=1928
INFO | jvm 5 | 2019/08/25 14:44:44 | #
INFO | jvm 5 | 2019/08/25 14:44:44 | # JRE version: OpenJDK Runtime Environment (Zulu11.31+10-SA) (11.0.3+7) (build 11.0.3+7-LTS)
INFO | jvm 5 | 2019/08/25 14:44:44 | # Java VM: OpenJDK 64-Bit Server VM (11.0.3+7-LTS, mixed mode, tiered, compressed oops, g1 gc, windows-amd64)
INFO | jvm 5 | 2019/08/25 14:44:44 | # Problematic frame:
INFO | jvm 5 | 2019/08/25 14:44:44 | # V [jvm.dll+0xfce10]
INFO | jvm 5 | 2019/08/25 14:44:44 | #
INFO | jvm 5 | 2019/08/25 14:44:44 | # Core dump will be written. Default location: C:\Program Files\Inductive Automation\Ignition\hs_err_pid12032.mdmp
INFO | jvm 5 | 2019/08/25 14:44:44 | #
INFO | jvm 5 | 2019/08/25 14:44:44 | # An error report file with more information is saved as:
INFO | jvm 5 | 2019/08/25 14:44:44 | # C:\Program Files\Inductive Automation\Ignition\hs_err_pid12032.log
INFO | jvm 5 | 2019/08/25 14:44:45 | #
INFO | jvm 5 | 2019/08/25 14:44:45 | # If you would like to submit a bug report, please visit:
INFO | jvm 5 | 2019/08/25 14:44:45 | # http://www.azulsystems.com/support/
INFO | jvm 5 | 2019/08/25 14:44:45 | #
ERROR | wrapper | 2019/08/25 14:44:47 | JVM exited unexpectedly.
FATAL | wrapper | 2019/08/25 14:44:47 | There were 5 failed launches in a row, each lasting less than 300 seconds. Giving up.
FATAL | wrapper | 2019/08/25 14:44:47 | There may be a configuration problem: please check the logs.
STATUS | wrapper | 2019/08/25 14:44:47 | <-- Wrapper Stopped

The 5 JVM crashes were all during the ‘Starting Project’ phase of the restart, but each one was at a slightly different point - i.e. not after the same project each time. It varied in position from after project #1 to after #7.

Environment info:
Ignition Version: 8.0.2 (b2019060511)
Gateway OS: Windows Server 2012 R2 | amd64
SQL target instance:
Microsoft SQL Server 2008 R2 (SP1) - 10.50.2861.0 (X64)
Aug 20 2012 19:28:58
Copyright © Microsoft Corporation
Standard Edition (64-bit) on Windows NT 6.1 (Build 7601: Service Pack 1) (Hypervisor)

2

If this was an upgrade you might need a newer version of the JDBC driver and the authentication DLL to match.

3

In the instructions, scenario 2, step 1, there is a link provided for the sqljdbc_auth.dll

http://files.inductiveautomation.com/sqlserver_winauth_dlls/auth.zip

Are these dlls compatible with the built in azul JVM or is there a newer set?

4

The DLL from the KBA may be old.

When you download the JDBC drivers from Microsoft they include the DLL for that version: http://www.microsoft.com/en-us/download/details.aspx?id=11774

2 Likes
5

Old thread I know, but I am also having same problem as near as I can tell. I tried the newer files from your MS link, same problems. If I should be starting a new post, please move/advise! Looking for some help, I’m new to Java and Ignition. My last support ticket took more than 10 days to get a response :frowning:

6

Are you sure you used the corresponding DLL + JDBC driver you downloaded? Do you have any logs you can share?

Call if you want a quick response. The email queue is quite backed up right now, and sits behind the call queue in priority.

1 Like
7

I guess it pays to read the included install files… I had misplaced the folder by one level. Authentication seems to be working now! I think the instructions at https://docs.inductiveautomation.com/display/DOC/Connecting+to+Microsoft+SQL+Server+Express need updating or new links!

8

Is the current documentation matching what you had to do? You seem to have yourself a link to the Ignition 7.8 manual.

https://docs.inductiveautomation.com/display/DOC80/Connecting+to+Microsoft+SQL+Server+Express#ConnectingtoMicrosoftSQLServerExpress-MicrosoftSQLServerConnectionGuide

9

I did a search for connecting to SQL Express and got the documents for 7.8, I followed them, but the instructions are quite similar to the 8.0 documents, with the exception of the JDBC files themselves. It appears I followed the rabbit down the wrong hole… Thanks for your quick response and pointers!