Invalid object name 'information_schema.sequences' in BRMS / BPM Suite

Solution Verified - Updated -

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 of over 48,000 articles and solutions.

Current Customers and Partners

Log in for full access

Log In