SOA 11g Log Files are Full of JDBC Errors [OWLS][SQLServer JDBC Driver][SQLServer]Invalid object name (Doc ID 1173979.1)

Last updated on OCTOBER 25, 2016

Applies to:

Oracle SOA Platform - Version 11.1.1.1.0 to 11.1.1.4.0 [Release 11gR1]
Information in this document applies to any platform.
***Checked for relevance on 21-June-2013***

Symptoms

In SOA 11.1.1.x with SQL Server 2005 as the database repository, you are getting errors as below for several tables in the SOA repository:

Exception [TOPLINK-4002] (Oracle TopLink - 11g Release 1 (11.1.1.3.0) (Build 100323)): oracle.toplink.exceptions.DatabaseException
Internal Exception: java.sql.SQLSyntaxErrorException: [OWLS][SQLServer JDBC Driver][SQLServer]Invalid object name 'MEDIATOR_DEFERRED_MESSAGE'.
Error Code: 208
Call: SELECT CASE_ID, CONTAINER_ID, STATUS, MSG_ID, COMPONENT_DN, OPERATION, LOCK_TIME, PRIORITY, IS_EVENT, QNAME_LOCAL_PART, CREATION_DATE, QNAME_NAMESPACE, CASE_INFO, SOURCE_URI, COMPONENT_STATUS, INSTANCE_CREATED FROM MEDIATOR_DEFERRED_MESSAGE WHERE (((STATUS = ?) AND (LOCK_TIME = ?)) AND (CONTAINER_ID = ?))
bind => [1, 2010-08-09 15:26:53.343, 48814E41A3EB11DFBF9BD53E7A248ED1]
Query: ReadAllQuery(oracle.tip.mediator.common.persistence.MediatorDeferredMessage)
.
.
.
.
Caused by: java.sql.SQLSyntaxErrorException: [OWLS][SQLServer JDBC Driver][SQLServer]Invalid object name 'MEDIATOR_DEFERRED_MESSAGE'.



Log files are full of these types of JBDC errors.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms