I just installed Knowage-CE version 7.0
I built a metamodel using an MS SQL server datasource and when I run it, I get the following error.
An unpredicted error occurred while executing GET_TREE_ACTION service. The root cause of the error is: org.hibernate.dialect.ExtendedSQLServerDialect
When I look at the exception in the log file, it appears the class file is missing, I am assuming from one of the Hibernate jar files.
Here is the culprit
Caused by: org.hibernate.HibernateException: Dialect class not found: org.hibernate.dialect.ExtendedSQLServerDialect at org.hibernate.dialect.resolver.DialectFactory.constructDialect(DialectFactory.java:159)at org.hibernate.dialect.resolver.DialectFactory.buildDialect(DialectFactory.java:99)at org.hibernate.cfg.SettingsFactory.buildSettings(SettingsFactory.java:130)at org.hibernate.cfg.Configuration.buildSettingsInternal(Configuration.java:2836)at org.hibernate.cfg.Configuration.buildSettings(Configuration.java:2832)at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1843)at org.hibernate.ejb.Ejb3Configuration.buildEntityManagerFactory(Ejb3Configuration.java:903)
---
I have seen two other posts on this but no answer.
When I tried to create the model using a MySQL datasource to foodmart, it works fine. So there must be something specific when building the model against an MS SQL datasource, when it references the Dialect org.hibernate.dialect.ExtendedSQLServerDialect
