com.microsoft.sqlserver.jdbc.SQLServerException: Invalid object name 'information_schema.sequences'.

[Jiayin Chen]

Trying to use sql server as db. Followed instruction https://developer.jboss.org/wiki/StepByStepProcessToConnectJBPM-620ToMicrosoftSQLSERVER2008R2. Can't have the jbpm up running, error message say invalid object name "Information_schema.sequences". I looked up in google, and it says might still thinking using H2 database. Couple of lines above the error message, I do see 

2017-05-05 17:03:02,180 INFO  [org.jboss.as.jpa] (MSC service thread 1-5) WFLYJPA0002: Read persistence.xml for org.jbpm.domain

2017-05-05 17:03:02,850 WARN  [org.jboss.jca.core.connectionmanager.pool.strategy.OnePool] (ServerService Thread Pool -- 64) IJ000407: No lazy enlistment available for MSSQLDS

2017-05-05 17:03:02,945 INFO  [org.hibernate.dialect.Dialect] (ServerService Thread Pool -- 64) HHH000400: Using dialect: org.hibernate.dialect.H2Dialect

2017-05-05 17:03:02,949 WARN  [org.hibernate.dialect.H2Dialect] (ServerService Thread Pool -- 64) HHH000431: Unable to determine H2 database version, certain features may not work

But I have configured in the persistence file to use sqlserver dialect. I don't know where this message comes from.I have the complete log attached.

[Maciej Swiderski]

You need to provide the hibernate dialect via system property:

-Dorg.kie.server.persistence.dialect=org.hibernate.dialect.SQLServerDialect

Maciej

--
You received this message because you are subscribed to the Google Groups "jBPM Setup" group.
To unsubscribe from this group and stop receiving emails from it, send an email to jbpm-setup+...@googlegroups.com.
To post to this group, send email to jbpm-...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/jbpm-setup/13a361b6-44d4-4607-8996-ab185702a9c6%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
<server.log.2017-05-05>

[Jiayin Chen]

Hi Maciej,

I added that to build.xml, still same error message and also still shows using H2Dialect

2017-05-08 15:33:34,216 INFO  [org.hibernate.dialect.Dialect] (ServerService Thread Pool -- 76) HHH000400: Using dialect: org.hibernate.dialect.H2Dialect

2017-05-08 15:33:34,219 WARN  [org.hibernate.dialect.H2Dialect] (ServerService Thread Pool -- 76) HHH000431: Unable to determine H2 database version, certain features may not work

2017-05-08 15:33:34,254 INFO  [org.hibernate.Version] (ServerService Thread Pool -- 64) HHH000412: Hibernate Core {5.0.7.Final}

2017-05-08 15:33:34,255 INFO  [org.hibernate.cfg.Environment] (ServerService Thread Pool -- 64) HHH000206: hibernate.properties not found

2017-05-08 15:33:34,257 INFO  [org.hibernate.cfg.Environment] (ServerService Thread Pool -- 64) HHH000021: Bytecode provider name : javassist

2017-05-08 15:33:34,281 INFO  [org.hibernate.orm.deprecation] (ServerService Thread Pool -- 64) HHH90000001: Found usage of deprecated setting for specifying Scanner [hibernate.ejb.resource_scanner]; use [hibernate.archive.scanner] instead

2017-05-08 15:33:34,287 INFO  [org.hibernate.annotations.common.Version] (ServerService Thread Pool -- 64) HCANN000001: Hibernate Commons Annotations {5.0.1.Final}

2017-05-08 15:33:34,449 INFO  [org.hibernate.engine.transaction.internal.TransactionFactoryInitiator] (ServerService Thread Pool -- 76) HHH000268: Transaction strategy: org.hibernate.engine.transaction.internal.jta.CMTTransactionFactory

2017-05-08 15:33:34,452 INFO  [org.hibernate.hql.internal.ast.ASTQueryTranslatorFactory] (ServerService Thread Pool -- 76) HHH000397: Using ASTQueryTranslatorFactory

2017-05-08 15:33:34,756 INFO  [org.hibernate.tool.hbm2ddl.SchemaUpdate] (ServerService Thread Pool -- 76) HHH000228: Running hbm2ddl schema update

2017-05-08 15:33:34,757 INFO  [org.hibernate.tool.hbm2ddl.SchemaUpdate] (ServerService Thread Pool -- 76) HHH000102: Fetching database metadata

2017-05-08 15:33:34,762 ERROR [org.hibernate.tool.hbm2ddl.SchemaUpdate] (ServerService Thread Pool -- 76) HHH000319: Could not get database metadata: com.microsoft.sqlserver.jdbc.SQLServerException: Invalid object name 'information_schema.sequences'.

at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:217)

at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1635)

at com.microsoft.sqlserver.jdbc.SQLServerStatement.doExecuteStatement(SQLServerStatement.java:865)

at com.microsoft.sqlserver.jdbc.SQLServerStatement$StmtExecCmd.doExecute(SQLServerStatement.java:762)

at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:6276)

at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:1794)

at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:184)

at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:159)

at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeQuery(SQLServerStatement.java:661)

at org.jboss.jca.adapters.jdbc.WrappedStatement.executeQuery(WrappedStatement.java:397)

at org.hibernate.tool.hbm2ddl.DatabaseMetadata.initSequences(DatabaseMetadata.java:177)

at org.hibernate.tool.hbm2ddl.DatabaseMetadata.<init>(DatabaseMetadata.java:91)

at org.hibernate.tool.hbm2ddl.DatabaseMetadata.<init>(DatabaseMetadata.java:83)

at org.hibernate.tool.hbm2ddl.SchemaUpdate.execute(SchemaUpdate.java:221)

at org.hibernate.tool.hbm2ddl.SchemaUpdate.execute(SchemaUpdate.java:203)

at org.hibernate.internal.SessionFactoryImpl.<init>(SessionFactoryImpl.java:509)

at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1799)

at org.hibernate.ejb.EntityManagerFactoryImpl.<init>(EntityManagerFactoryImpl.java:96)

at org.hibernate.ejb.Ejb3Configuration.buildEntityManagerFactory(Ejb3Configuration.java:915)

at org.hibernate.ejb.Ejb3Configuration.buildEntityManagerFactory(Ejb3Configuration.java:900)

at org.hibernate.ejb.HibernatePersistence.createContainerEntityManagerFactory(HibernatePersistence.java:76)

at org.kie.server.services.jbpm.JbpmKieServerExtension.build(JbpmKieServerExtension.java:562)

at org.kie.server.services.jbpm.JbpmKieServerExtension.init(JbpmKieServerExtension.java:162)

at org.kie.server.services.impl.KieServerImpl.<init>(KieServerImpl.java:111)

at org.kie.server.services.impl.KieServerImpl.<init>(KieServerImpl.java:90)

at org.kie.server.services.impl.KieServerLocator.<clinit>(KieServerLocator.java:20)

at org.kie.server.services.Bootstrap.contextInitialized(Bootstrap.java:49)

at io.undertow.servlet.core.ApplicationListeners.contextInitialized(ApplicationListeners.java:187)

at io.undertow.servlet.core.DeploymentManagerImpl.deploy(DeploymentManagerImpl.java:198)

at org.wildfly.extension.undertow.deployment.UndertowDeploymentService.startContext(UndertowDeploymentService.java:100)

at org.wildfly.extension.undertow.deployment.UndertowDeploymentService$1.run(UndertowDeploymentService.java:82)

at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)

at java.util.concurrent.FutureTask.run(FutureTask.java:266)

at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)

at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)

at java.lang.Thread.run(Thread.java:748)

at org.jboss.threads.JBossThread.run(JBossThread.java:320)

[Maciej Swiderski]

that indicates it's somehow is not being used. Please double check if the system property is set. 

Maciej

To unsubscribe from this group and stop receiving emails from it, send an email to jbpm-setup+unsubscribe@googlegroups.com.

To post to this group, send email to jbpm-...@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msgid/jbpm-setup/64313736-ac64-4523-b6d0-b8043c4938f8%40googlegroups.com.

[Jiayin Chen]

Maciej, I found the problem, I only updated the .win part not .linux part. After changing that and specify dialect to 2008 I'm good, thank you for your help!