web stats
Error Building SQL Session - Mirth Community

Go Back   Mirth Community > Mirth Connect > Support

Reply
 
Thread Tools Display Modes
  #1  
Old 04-15-2019, 09:30 AM
petem petem is offline
What's HL7?
 
Join Date: Nov 2018
Posts: 5
petem is on a distinguished road
Default Error Building SQL Session

Hello,

I am creating a new MIRTH server for our environment. It is running Server 2019 in Azure and connecting to a SQL PaaS instance in Azure. Java 8 Update 201 (64 bit) is installed along with Mirth Connect 3.7.1.b243 and the Mirth Connect Administrator Launcher. I added the JDBC driver to dbdrivers.xml. I changed the mirth.properties file to server.includecustomlib = true and added the database.url and database.driver. In the custom-lib file I have the smsql-jdbc-7.2.1.jre11.jar file.

Whenever I try to open http://localhost:8080 or https://localhost:8443, I get the following error:

ERROR 2019-04-15 12:14:39,131 [Main Server Thread] Server: Exception in thread "Main Server Thread" java.lang.RuntimeException: org.apache.ibatis.exceptions.PersistenceException:
ERROR 2019-04-15 12:14:39,131 [Main Server Thread] Server: ### Error building SqlSession.
ERROR 2019-04-15 12:14:39,131 [Main Server Thread] Server: ### The error may exist in SQL Mapper Configuration
ERROR 2019-04-15 12:14:39,131 [Main Server Thread] Server: ### Cause: org.apache.ibatis.builder.BuilderException: Error parsing SQL Mapper Configuration. Cause: java.lang.NullPointerException
ERROR 2019-04-15 12:14:39,131 [Main Server Thread] Server: at com.mirth.connect.server.util.SqlConfig.init(SqlCo nfig.java:117)
ERROR 2019-04-15 12:14:39,131 [Main Server Thread] Server: at com.mirth.connect.server.util.SqlConfig.<init>(Sql Config.java:71)
ERROR 2019-04-15 12:14:39,131 [Main Server Thread] Server: at com.mirth.connect.server.util.SqlConfig.getInstanc e(SqlConfig.java:62)
ERROR 2019-04-15 12:14:39,131 [Main Server Thread] Server: at com.mirth.connect.server.Mirth.startup(Mirth.java: 228)
ERROR 2019-04-15 12:14:39,131 [Main Server Thread] Server: at com.mirth.connect.server.Mirth.run(Mirth.java:154)
ERROR 2019-04-15 12:14:39,131 [Main Server Thread] Server: Caused by: org.apache.ibatis.exceptions.PersistenceException:
ERROR 2019-04-15 12:14:39,131 [Main Server Thread] Server: ### Error building SqlSession.
ERROR 2019-04-15 12:14:39,131 [Main Server Thread] Server: ### The error may exist in SQL Mapper Configuration
ERROR 2019-04-15 12:14:39,131 [Main Server Thread] Server: ### Cause: org.apache.ibatis.builder.BuilderException: Error parsing SQL Mapper Configuration. Cause: java.lang.NullPointerException
ERROR 2019-04-15 12:14:39,131 [Main Server Thread] Server: at org.apache.ibatis.exceptions.ExceptionFactory.wrap Exception(ExceptionFactory.java:23)
ERROR 2019-04-15 12:14:39,131 [Main Server Thread] Server: at org.apache.ibatis.session.SqlSessionFactoryBuilder .build(SqlSessionFactoryBuilder.java:51)
ERROR 2019-04-15 12:14:39,131 [Main Server Thread] Server: at org.apache.ibatis.session.SqlSessionFactoryBuilder .build(SqlSessionFactoryBuilder.java:43)
ERROR 2019-04-15 12:14:39,131 [Main Server Thread] Server: at com.mirth.connect.server.util.SqlConfig.createFact ory(SqlConfig.java:141)
ERROR 2019-04-15 12:14:39,131 [Main Server Thread] Server: at com.mirth.connect.server.util.SqlConfig.init(SqlCo nfig.java:101)
ERROR 2019-04-15 12:14:39,131 [Main Server Thread] Server: ... 4 more
ERROR 2019-04-15 12:14:39,131 [Main Server Thread] Server: Caused by: org.apache.ibatis.builder.BuilderException: Error parsing SQL Mapper Configuration. Cause: java.lang.NullPointerException
ERROR 2019-04-15 12:14:39,131 [Main Server Thread] Server: at org.apache.ibatis.builder.xml.XMLConfigBuilder.par seConfiguration(XMLConfigBuilder.java:105)
ERROR 2019-04-15 12:14:39,131 [Main Server Thread] Server: at org.apache.ibatis.builder.xml.XMLConfigBuilder.par se(XMLConfigBuilder.java:88)
ERROR 2019-04-15 12:14:39,131 [Main Server Thread] Server: at org.apache.ibatis.session.SqlSessionFactoryBuilder .build(SqlSessionFactoryBuilder.java:49)
ERROR 2019-04-15 12:14:39,131 [Main Server Thread] Server: ... 7 more
ERROR 2019-04-15 12:14:39,131 [Main Server Thread] Server: Caused by: java.lang.NullPointerException
ERROR 2019-04-15 12:14:39,131 [Main Server Thread] Server: at com.mirth.connect.server.mybatis.BridgeDataSourceF actory.setProperties(BridgeDataSourceFactory.java: 30)
ERROR 2019-04-15 12:14:39,131 [Main Server Thread] Server: at org.apache.ibatis.builder.xml.XMLConfigBuilder.dat aSourceElement(XMLConfigBuilder.java:264)
ERROR 2019-04-15 12:14:39,131 [Main Server Thread] Server: at org.apache.ibatis.builder.xml.XMLConfigBuilder.env ironmentsElement(XMLConfigBuilder.java:222)
ERROR 2019-04-15 12:14:39,131 [Main Server Thread] Server: at org.apache.ibatis.builder.xml.XMLConfigBuilder.par seConfiguration(XMLConfigBuilder.java:100)
ERROR 2019-04-15 12:14:39,131 [Main Server Thread] Server: ... 9 more

I have tried different versions of the JDBC file, added the localhost to the security settings in Java, rebooted multiple times, etc. but I still cannot seem to get connected.

Has anyone else experienced this issue?

Thanks in advance.
Reply With Quote
  #2  
Old 05-06-2019, 12:38 PM
CHATCHJ CHATCHJ is offline
OBX.1 Kenobi
 
Join Date: Oct 2013
Posts: 30
CHATCHJ is on a distinguished road
Default

Were you able to solve this? We upgraded one of our 3.4 environments to 3.7.1 and I am getting this error as well using SQLSERVER with integrated security.
Reply With Quote
  #3  
Old 06-27-2019, 09:53 AM
kirbykn2's Avatar
kirbykn2 kirbykn2 is offline
Mirth Guru
 
Join Date: Sep 2014
Location: Michigan
Posts: 567
kirbykn2 is on a distinguished road
Default

Having the same issue with the 3.7.1 upgrade, any resolution to this?
__________________
Kirby

Mirth Certified|Epic Bridges Certified|Cloverleaf Level 2 Certified

Appliance Version 3.11.2
Mirth Connect Version 3.6.1
Java Version 1.6.0_45-b06
Java (64 bit) Version 1.6.0_45-b06
Java 7 (64 bit) Version 1.7.0_151-b15
Java 8 (64 bit) Version 1.8.0_121-b13
PostgreSQL Version 9.6.3
Reply With Quote
  #4  
Old 06-28-2019, 06:04 AM
agermano agermano is offline
Mirth Guru
 
Join Date: Apr 2017
Location: Indiana, USA
Posts: 857
agermano is on a distinguished road
Default

This is a bug with custom db drivers in 3.7 and fixed in 3.8

http://www.mirthcorp.com/community/i...wse/MIRTH-4414

As a workaround in 3.7, you need to add to your mirth.properties:
Code:
database-readonly.driver=com.microsoft.sqlserver.jdbc.SQLServerDriver
Reply With Quote
  #5  
Old 06-29-2019, 05:44 AM
AjayN AjayN is offline
What's HL7?
 
Join Date: May 2014
Posts: 3
AjayN is on a distinguished road
Default

For Nondefault drivers used in Database readers, this property doesnt help?Is anyone facing issue while using Nondefault drivers in mirth 3.7.1 version
Reply With Quote
Reply

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT -8. The time now is 11:17 AM.


Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2019, vBulletin Solutions, Inc.
Mirth Corporation