My Oracle Support Banner

Errors SBL-DAT-00215, SBL-BPR-00162 and SBL-DAT-00500 while invoking service 'FINS Data Transfer Utilities', method 'DataTransfer' (Doc ID 755136.1)

Last updated on AUGUST 19, 2022

Applies to:

Siebel Energy Sales - Version 7.5.2 SIA [16007] and later
Information in this document applies to any platform.


The following errors are observed in the Workflow Process Manager (WfProcMgr) log file when the custom workflow process "CNE Deal Manager - Create Contract - Quote" runs the "FINS Data Transfer Utilities" Business Service to copy a Quote into an Agreement.

Issue 1

The copy operation fails with the following error:

Error invoking service 'FINS Data Transfer Utilities', method 'DataTransfer' at step 'Auto Contract'.(SBL-BPR-00162)
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)

The workflow successfully INSERTs into the S_DOC_AGREE table, which is from the Header component of the data map. However it does not INSERT into the S_AGREE_ITEM table, which is the second component in the data map.

Issue 2

A query is performed on the Service Agreement business component which brings back more than 10000 records. This leads to the following messages in the log file:

ObjMgrSqlCursorLog Trace 5 0 2008-11-19 14:46:40 SQL Cursor with ID 16353AA0 Fetch Rows: 10000, Fetch All Time: 6.312 seconds.
ObjMgrSqlCursorLog Close 5 0 2008-11-19 14:46:40 End: Close Sql Cursor at 16353aa0
ObjMgrBusCompLog Error 1 0 2008-11-19 14:46:40 There were more rows than could be returned. Please refine your query to bring back fewer rows
ObjMgrBusCompLog Warning 2 0 2008-11-19 14:46:40 (sqlobj.cpp (29074)) SBL-DAT-00500: There were more rows than could be returned. Please refine your query to bring back fewer rows




To view full details, sign in with your My Oracle Support account.

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

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.