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

Last updated on MARCH 03, 2017

Applies to:

Siebel Marketing - Version 8.1.1.11 [IP2013] and later
Information in this document applies to any platform.

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

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