Generate Triggers and Workflow Jobs Fail with error SBL-SEC-10018 After Upgrade to 8.1.1.11

(Doc ID 1603872.1)

Last updated on OCTOBER 12, 2016

Applies to:

Siebel CRM - Version 15.10 [IP2015] to 15.10 [IP2015] [Release V15]
Siebel Workflow - Version 8.1.1.11 [IP2013] and later
Information in this document applies to any platform.

Symptoms

Generate Trigger component failed with the following error message after upgrading to version 8.1.1.11

SBL-ESC-00006: Unable to connect to the database.
[DataDirect][ODBC Oracle driver][Oracle]ORA-01017: invalid username/password; logon denied

This error appears when a Job is submitted but it works fine if srvrmgr is used

e.g.

start task for comp GenTrig with EXEC=True, Remove=False, PrivUser=siebel, PrivUserPass=siebel


Same behavior can be observed for WFProcMgr when submitting a job for this component using different username/password values (different than sadmin). The log would show the following errors in that case:

ObjMgrLog Error 1 0000072153581804:0 2014-04-24 13:25:50 (oracon.cpp (3896)) SBL-DAT-00446: You have entered an invalid set of logon parameters.  Please type in your logon parameters again.

GenericLog GenericError 1 0000072153581804:0 2014-04-24 13:25:50 (secmgr.cpp (2768) err=4597538 sys=0) SBL-SEC-10018: You have entered an invalid set of logon parameters.  Please type in your logon parameters again.(SBL-DAT-00446)

This can also cause a crash when it tries to evaluate the passwod for this process.

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