Mondrian Error:Internal error: Error while creating SQL connection (SQL Server)

I’m evaluation your Pivot Table Component for connecting to Mondrian/SQL Server. I have configured it to connect to Mondrian server via XMLA and everything it’s working perfectly.
I facing problems with the Flexmonster accelerator. I can start it with no errors, but when I access the WebPage I get the following error:
SEVERE: Mondrian Error:Internal error: Error while creating SQL connection: Jdbc=jdbc:sqlserver://mydbserver:1437
Here the complete Log:

[2018-07-12 08:02:26] INFO: Flexmonster Data Speed Accelerator for Pentaho Mondrian 3.12
[2018-07-12 08:02:26] INFO: Version 2.5.6
[2018-07-12 08:02:26] INFO:
log4j:WARN No appenders could be found for logger (mondrian.olap.MondrianProperties).
log4j:WARN Please initialize the log4j system properly.
[2018-07-12 08:02:26] INFO: Reading config…
[2018-07-12 08:02:26] INFO: Reading config – OK
[2018-07-12 08:02:26] INFO: Loading JDBC driver…
[2018-07-12 08:02:26] INFO: Driver path: jar:file:./mssql-jdbc-6.2.1.jre8.jar!/
[2018-07-12 08:02:26] INFO: Driver class name:
[2018-07-12 08:02:26] INFO: Loading JDBC driver – OK
[2018-07-12 08:02:26] INFO:
[2018-07-12 08:02:26] INFO: Testing connection…
[2018-07-12 08:02:27] INFO: jdbc:sqlserver://mydbserver:1437;databaseName=mytestdb;user=myuser;password=mypwd
[2018-07-12 08:02:27] INFO: Data Source connection [mytestdb] – OK
[2018-07-12 08:02:27] INFO:
[2018-07-12 08:02:27] INFO: Starting server…
2018-07-12 08:02:27.347:INFO::main: Logging initialized @686ms
2018-07-12 08:02:27.378:INFO:oejs.Server:main: jetty-9.2.z-SNAPSHOT
2018-07-12 08:02:27.888:INFO:oejsh.ContextHandler:main: Started o.e.j.s.ServletContextHandler@4a194c39{/,null,AVAILABLE}
2018-07-12 08:02:27.920:INFO:oejs.ServerConnector:main: Started ServerConnector@42463763{HTTP/1.1}{}
2018-07-12 08:02:27.920:INFO:oejs.Server:main: Started @1261ms
[2018-07-12 08:02:27] INFO: Starting server – OK
[2018-07-12 08:02:27] INFO: Server is running at http://localhost:50006/
[2018-07-12 08:03:34] INFO: Handshaking… 2.5.6
[2018-07-12 08:03:34] INFO: Loading dimensions…
[2018-07-12 08:03:34] SEVERE: Mondrian Error:Internal error: Error while creating SQL connection: Jdbc=jdbc:sqlserver://mydbserver:1437
And here the configuration File:
What I’m doing wrong? Thx for your support.

2 answers

Dmytro Zvazhii Flexmonster July 12, 2018

Hi MC!
Thank you for the question. 
It seems that Jdbc parameter in the connection string should be enclosed with quotes to prevent conflicts with semicolon delimiter (;).


Does it help?

MC July 12, 2018

Yes, now it’s working. Thank you very much!

Please login or Register to Submit Answer