Database Adapter Execution Results in the Error: [EclipseLink-6044] Primary keys must not contain null (Doc ID 1262880.1)

Last updated on JUNE 21, 2013

Applies to:

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

Symptoms

You have an installation of Oracle Fusion Middleware 11g where you are developing a composite application to run within the Oracle SOA Suite technology and within the implementation of your composite you have leveraged the Database Adapter component.

You have successfully developed and deployed the composite to the SOA managed server but at run-time, when testing the composite you encounter an error similar to the following:

java.lang.Exception: oracle.sysman.emSDK.webservices.wsdlapi.SoapTestException:
Exception occured when binding was invoked.
Exception occured during invocation of JCA binding:
"JCA Binding execute of Reference operation 'searchListOfSubscribersSelect'
failed due to:
DBReadInteractionSpec Execute Failed Exception. Query name: [searchListOfSubscribersSelect], Descriptor name: [searchListOfSubscribers.Topic].
Caused by Exception [EclipseLink-6044] (Eclipse Persistence Services - 2.0.2.v20100323-r6872): org.eclipse.persistence.exceptions.QueryException Exception Description:
The primary key read from the row [DatabaseRecord( TOPIC.NAME => NAME#1 TOPIC.ENDPOINT => topicendpoint_1 => SUBSCRIBER#1 => filter_1)]
during the execution of the query was detected to be null. Primary keys must not contain null. Query: ReadAllQuery(name="searchListOfSubscribersSelect"
referenceClass=Topic sql="select T.NAME, T.ENDPOINT, S.SUBSCRIBER, F.FILTER from TOPIC T inner join SUBSCRIBER S on T.TOPIC_ID = S.TOPIC_ID left outer join FILTERS F on s.SUBSCRIBER_ID = F.SUBSCRIBER_ID where upper( s.status ) ='ACTIVE' and (T.NAME = ?)"). ".
The invoked JCA adapter raised a resource exception. Please examine the above error message carefully to determine a resolution.
at oracle.sysman.emas.model.wsmgt.WSTestModel.invokeOperation(WSTestModel.java:575)
at oracle.sysman.emas.view.wsmgt.WSView.invokeOperation(WSView.java:381)
at oracle.sysman.emas.view.wsmgt.WSView.invokeOperation(WSView.java:298)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.
   invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at com.sun.el.parser.AstValue.invoke(AstValue.java:157)
at com.sun.el.MethodExpressionImpl.invoke(MethodExpressionImpl.java:283)
...

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