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
Close

Welcome! Check out the Getting Started with Red Hat page for quick tours and guides for common tasks.