Can not send emails calling Outbound Communications Manager BS method SendMessage, but F9 works fine. (Doc ID 1565142.1)

Last updated on SEPTEMBER 01, 2017

Applies to:

Siebel Financial Services CRM - Version 7.5.3 SIA [16157] to 8.2.2.3 SIA [23021] [Release V7 to V8]
Information in this document applies to any platform.

Symptoms

When attempting to send emails using a custom code that call Business Services Outbound Communications Manager method SendMessage the following error occurs.

Please execute a query that returns at least one record or add a new record.(SBL-DAT-00215)
Please execute a query that returns at least one record or add a new record.(SBL-DAT-00215) (0x7500d7))
GenericLog GenericError 1 00002d3c51c315b0:0 2013-06-20 22:19:32 ( (0) err=2818155 sys=7667927) SBL-OMS-00107: Object manager error: ([0] This operation is not allowed when there are no records displayed.
Please execute a query that returns at least one record or add a new record.(SBL-DAT-00215) (0x7500d7))


The issue can be reproduced at will with the following steps:
1) Go to Site Map>Administration - Business Service>Simulator and test the Outbound Communications Manager Business Service and Method SendMessage
2) Create a record on Simulator applet with columns Service Name = Outbound Communications Manager and Method Name = SendMessage.
3) On child applet Input Arguments create a record and add a Property Name/Property Value MVF  with the Input Argument for SendMessage method that is:
MsgSubject="Test"
MsgToList="myemail@mail.com"
ProcessMode="Remote"
CommProfile="My Internet SMTP/POP3 Server User Profile"
4) Click on Run

The emails is not received by the recipient and we can see the errors in CommOutboundMgr compoent log.

When using a Siebel Dedicated Client with the same SRF connected to the same Server Database everything works fine. Only when the Business Service Outbound Communications Manager method SendMessage is used from a Web Client or other server components the problem occurs on this particular environment.



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