Invalid object name 'information_schema.sequences' in BRMS / BPM Suite
Issue
- When we started BRMS 5.3.1 server with or without custom applications wars it throws the following exception:
com.microsoft.sqlserver.jdbc.SQLServerException: Invalid object name 'information_schema.system_sequences'.
- When I build a project in BPM Suite 6, I get the following error:
08:43:57,317 WARN [org.hibernate.engine.jdbc.spi.SqlExceptionHelper] (EJB default - 8) SQL Error: 208, SQLState: S0002
08:43:57,317 ERROR [org.hibernate.engine.jdbc.spi.SqlExceptionHelper] (EJB default - 8) Invalid object name 'information_schema.sequences'.
08:43:57,325 WARN [org.jbpm.kie.services.impl.KModuleDeploymentService] (EJB default - 8) Unexpected error while deploying unit com.example:myproject:1.0.0:mykbase:myksession: [Error: could not create constructor: null]
[Near : {... new org.drools.persistence.jpa.mar ....}]
^
[Line: 1, Column: 5]
at org.mvel2.optimizers.impl.refl.ReflectiveAccessorOptimizer.optimizeObjectCreation(ReflectiveAccessorOptimizer.java:1245)
...
Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: Invalid object name 'information_schema.sequences'.
at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:217)
...
Environment
- Red Hat JBoss BRMS
- 5.3.1
- Red Hat JBoss BPM Suite
- 6
- MS SQL Server
Subscriber exclusive content
A Red Hat subscription provides unlimited access to our knowledgebase, tools, and much more.