My Oracle Support Banner

Automated Campaigns In Siebel Marketing Error SBL-DBC-00111 SBL-DBC-00107 (Doc ID 2060765.1)

Last updated on SEPTEMBER 09, 2021

Applies to:

Siebel Marketing - Version 8.1.1.11 [IP2013] and later
Information in this document applies to any platform.
Reviewed for Relevance Jan, 13 - 2020

Symptoms

On : 8.1.1.11 [23030] version, Siebel Marketing

ACTUAL BEHAVIOR
---------------

Scheduled campaigns are failing with the following error

 

MktgCampaignLoadEvent Info 4 0000000355d00c1c:0 2015-08-17 10:30:06 CAMPAIGN EXECUTION: error while executing executing method UpdateActivity
ObjMgrBusServiceLog InvokeMethod 4 0000000355d00c1c:0 2015-08-17 10:30:06 Business Service 'Campaign Execution' invoke method 'UpdateActivity' Execute Time: 1.352 seconds.ObjMgrBusServiceLog InvokeMethod 4 0000000355d00c1c:0 2015-08-17 10:30:06 End: Business Service 'Campaign Execution' invoke method: 'UpdateActivity' at 19aadef8
ObjMgrLog Error 1 0000000355d00c1c:0 2015-08-17 10:30:06 (stepexec.cpp (1586)) SBL-BPR-00162: Error invoking service 'Campaign Execution', method 'UpdateActivity' at step 'Update Schedule Activity'.
PrcExec PropSet 4 0000000355d00c1c:0 2015-08-17 10:30:06 Setting runtime value of property 'Namespace: 'USER' Name: 'Recurring Request' Datatype: 'String'' to:
PrcExec PropSet 4 0000000355d00c1c:0 2015-08-17 10:30:06 true
PrcExec PropSet 4 0000000355d00c1c:0 2015-08-17 10:30:06 Setting runtime value of property 'Namespace: 'USER' Name: 'Error Code' Datatype: 'String'' to:
PrcExec PropSet 4 0000000355d00c1c:0 2015-08-17 10:30:06 (SBL-BPR-00162)--(SBL-DBC-00111)--(SBL-DBC-00107)
PrcExec PropSet 4 0000000355d00c1c:0 2015-08-17 10:30:06 Setting runtime value of property 'Namespace: 'USER' Name: 'Error Message' Datatype: 'String'' to:
PrcExec PropSet 4 0000000355d00c1c:0 2015-08-17 10:30:06 Error invoking service 'Campaign Execution', method 'UpdateActivity' at step 'Update Schedule Activity'.(SBL-BPR-00162)

 

An error has occurred writing to a record.
Please continue or ask your systems administrator to check your application configuration if the problem persists.(SBL-DBC-00111)--ORA-06550: line 45, column 7:PL/SQL: ORA-00957: duplicate column nameORA-06550: line 6, column 2:PL/SQL: SQL Statement ignored

 





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


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