Invalid object name - SIP10322: SQLException while fetching data in EAP 7

Solution Verified - Updated -

Issue

  • During deployment, an error is generated with tables of the database and implementation is not completed.
DataAccessException: SIP10322: SQLException while fetching data
        SELECT NAME_TABLE_XYZ_V.* FROM NAME_TABLE_XYZ_V ORDER BY ABC_NAME ASC
        Caused by SQLException: sqlState=S0002  errorCode=208   Invalid object name 'NAME_TABLE_XYZ_V'.
        at DataAccessObjectDirectorForDatabaseAdapter.executeQuery(DataAccessObjectDirectorForDatabaseAdapter.java:261)
        at access.DataAccessObjectDirectorForDatabaseAdapter.loadDataObjects(DataAccessObjectDirectorForDatabaseAdapter.java:740)
        ... 34 more
Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: Invalid object name 'NAME_TABLE_XYZ_V'.
        at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1515)
<...>
com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:1715)
        at org.jboss.jca.adapters.jdbc.WrappedStatement.executeQuery(WrappedStatement.java:397)

Environment

  • Red Hat JBoss Enterprise Application Platform (EAP)
    • 7

Subscriber exclusive content

A Red Hat subscription provides unlimited access to our knowledgebase, tools, and much more.

Current Customers and Partners

Log in for full access

Log In

New to Red Hat?

Learn more about Red Hat subscriptions

Using a Red Hat product through a public cloud?

How to access this content