My Oracle Support Banner

TBUI: MultiRecord TBC Failed With "This operation is not valid when executed in setup only mode.(SBL-DAT-00395)" (Doc ID 3031097.1)

Last updated on SEPTEMBER 19, 2024

Applies to:

Siebel CRM - Version 23.11 and later
Information in this document applies to any platform.

Symptoms

When invoking a Task with "MultiRecord TBC", the following error message below occurred when trying to update or insert the record in a Task Base UI Process.

INSERT INTO SIEBEL.S_TU_LOG (
CONFLICT_ID,
DB_LAST_UPD_SRC,
DB_LAST_UPD,
LAST_UPD,
CREATED,
LAST_UPD_BY,
CREATED_BY,
MODIFICATION_NUM,
ROW_ID,
FLD_VAL_V255_2,
FLD_VAL_V255_1,
TASK_ID_VAL,
TBL_NAME,
REC_MOD_NUM,
BC_NAME,
OPERATION,
SAVE_POINT_NUM,
TASK_ROW_ID_VAL,
TASK_BC_ID_VAL,
BASE_TBL_NAME)
VALUES (:1, :2, current_date, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14, :15, :16, :17, :18, :19)

SQLParseAndExecute Bind Vars 4 000013e166711d64:0 2024-06-24 12:04:56 1: 0
SQLParseAndExecute Bind Vars 4 000013e166711d64:0 2024-06-24 12:04:56 2: ScriptingService_PreInvokeMethod
SQLParseAndExecute Bind Vars 4 000013e166711d64:0 2024-06-24 12:04:56 3: 06/24/2024 19:04:56
SQLParseAndExecute Bind Vars 4 000013e166711d64:0 2024-06-24 12:04:56 4: 06/24/2024 19:04:56
SQLParseAndExecute Bind Vars 4 000013e166711d64:0 2024-06-24 12:04:56 5: 0-1
SQLParseAndExecute Bind Vars 4 000013e166711d64:0 2024-06-24 12:04:56 6: 0-1
SQLParseAndExecute Bind Vars 4 000013e166711d64:0 2024-06-24 12:04:56 7: 0
SQLParseAndExecute Bind Vars 4 000013e166711d64:0 2024-06-24 12:04:56 8: 1-1PD47
SQLParseAndExecute Bind Vars 4 000013e166711d64:0 2024-06-24 12:04:56 9: Test - 23157
SQLParseAndExecute Bind Vars 4 000013e166711d64:0 2024-06-24 12:04:56 10: ABC 23157
SQLParseAndExecute Bind Vars 4 000013e166711d64:0 2024-06-24 12:04:56 11: 1-1PD42
SQLParseAndExecute Bind Vars 4 000013e166711d64:0 2024-06-24 12:04:56 12: S_TU_LOG
SQLParseAndExecute Bind Vars 4 000013e166711d64:0 2024-06-24 12:04:56 13: -10000
SQLParseAndExecute Bind Vars 4 000013e166711d64:0 2024-06-24 12:04:56 14: Task MultiRcord TBC Test
SQLParseAndExecute Bind Vars 4 000013e166711d64:0 2024-06-24 12:04:56 15: T
SQLParseAndExecute Bind Vars 4 000013e166711d64:0 2024-06-24 12:04:56 16: -10000
SQLParseAndExecute Bind Vars 4 000013e166711d64:0 2024-06-24 12:04:56 17: 0-1-1PD47
SQLParseAndExecute Bind Vars 4 000013e166711d64:0 2024-06-24 12:04:56 18: No Match Row Id
SQLParseAndExecute Bind Vars 4 000013e166711d64:0 2024-06-24 12:04:56 19: S_TU_LOG

SQLParseAndExecute Statement 4 000013e166711d64:0 2024-06-24 12:04:56 FinishWriteRecord: SQLEndTran() - SQL_COMMIT
ObjMgrBusCompLog Warning 2 000013e166711d64:0 2024-06-24 12:04:56 (sqlobj.cpp (44314)) SBL-DAT-00395: This operation is not valid when executed in setup only mode.
ObjMgrBusCompLog Warning 2 000013e166711d64:0 2024-06-24 12:04:56 (buscomp.cpp (17891)) SBL-DAT-00395: This operation is not valid when executed in setup only mode.
ObjMgrBusServiceLog InvokeMethod 4 000013e166711d64:0 2024-06-24 12:04:56 End: Business Service 'Test Simple BS' invoke method: 'FillContactData' at 27e831b8
ObjMgrLog Error 1 000013e166711d64:0 2024-06-24 12:04:56 (stepexec.cpp (1598)) SBL-BPR-00162: Error invoking service 'Test Simple BS', method 'FillContactData' at step 'Test Simple BS'.
PrcExec PropSet 4 000013e166711d64:0 2024-06-24 12:04:56 Setting runtime value of property 'Namespace: 'USER' Name: 'Error Code' Datatype: 'String'' to:
PrcExec PropSet 4 000013e166711d64:0 2024-06-24 12:04:56 (SBL-BPR-00162)--(SBL-DAT-00395)
PrcExec PropSet 4 000013e166711d64:0 2024-06-24 12:04:56 Setting runtime value of property 'Namespace: 'USER' Name: 'Error Message' Datatype: 'String'' to:
PrcExec PropSet 4 000013e166711d64:0 2024-06-24 12:04:56 Error invoking service 'Test Simple BS', method 'FillContactData' at step 'Test Simple BS'.(SBL-BPR-00162)
-
This operation is not valid when executed in setup only mode.(SBL-DAT-00395)

 

Steps to Reproduce:

1. Create a simple test case with the following:

Start > Query with the task context below > Update Contact with the input Arg below > Custom BS(Test Simple BS) > TaskView > END.

Task Step Contexts:

Name: Last Name
Type: Expression
Search Spec: [Last Name] LIKE "ABC*"
Is User Search Spec: Checked

 

Input Arg:

Field Name: Last Name
Type: Business Component
Business Component: Contact
Business Component Field: Last Name

Field Name: First Name
Type: Business Component
Business Component: Contact
Business Component Field: First Name

 

2. The Business Service 'Test Simple BS' has the following Script below:

 

Cause

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
Symptoms
Cause
Solution
References


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