Updating encrypted field using script causes crash (Doc ID 1255047.1)

Last updated on MARCH 02, 2017

Applies to:

Siebel Tools - Version 8.0 [20405] to SIA [23012] [Release V8]
Information in this document applies to any platform.
***Checked for relevance on 6-OCT-2016***


On : 8.1.1 SIA [21111] version, Siebel VB / eScript / COM

When attempting to create a new Contact record with encrypted field using scripts inside a Task UI step, the users are getting Server Time Out error and the below crash call stack is found when the behavior occurred:

sslcshar +0x1e65 = SSstring::operator unsigned short const *() +0x5
sscfdm +0xfc510 = CSSSqlObj::BldExtTableInsUpdStmts() +0x250
sscfdm +0xfe201 = CSSSqlObj::WriteRecord() +0x661
sscfom +0x214d2 = CSSBusComp::SqlWriteRecord() +0x22
sscacmbc +0x1677a = CSSBCBase::SqlWriteRecord() +0xafa
sscabcbc +0x3e128 = CSSBCUser::SqlWriteRecord() +0xb28
sscasabc +0x1657e = CSSBCContactSIS::SqlWriteRecord() +0x12e
sscfom +0x39868 = CSSBusComp::WriteRecord() +0xcc8
sscfomlg +0x6618 = CSSELBusCompImpl::WriteRecord() +0x48
sscfcli +0xea55e = CSSISenseInterface::`default constructor closure'() +0xa323e
sscfcli +0xeac12 = CSSISenseInterface::`default constructor closure'() +0xa38f2
sscfcli +0xe3f10 = CSSISenseInterface::`default constructor closure'() +0x9cbf0
sscfcli +0xea3c4 = CSSISenseInterface::`default constructor closure'() +0xa30a4
sscfcli +0xeac12 = CSSISenseInterface::`default constructor closure'() +0xa38f2
sscfcli +0x133b6 = CSSCLIJSMechInst::CallEvent() +0xc56
sscfel +0x723d = CSSELIface::ForwardEvent() +0x6d
sscfel +0xf539 = CSSELServiceIface::OnPreInvoke() +0x109
sscfom +0x17c54 = CSSService::ELEventPreInvoke() +0x94
sscfom +0x18432 = CSSService::InvokeMethod() +0x172
sscafwsv +0x4800f = CSSWfStep::Init() +0x1e3f
sscafwsv +0x48e9e = CSSWfStep::Init() +0x2cce
sscafwsv +0x494ff = CSSWfStep::Init() +0x332f
sscafwsv +0x4a1a0 = CSSWfStep::Init() +0x3fd0
sscafwsv +0x4a700 = CSSWfStepInst::RunOneStep() +0x130
sslctskctrlr +0x5e44 = CSSWfTaskLocalVsnCache::SetAt() +0xf74
sslctskctrlr +0x653e = CSSWfTaskLocalVsnCache::SetAt() +0x166e
sslctskctrlr +0xae9d = CSSWfTaskLocalVsnCache::~CSSWfTaskLocalVsnCache() +0x47ed
sslctskctrlr +0xe537 = CSSWfTaskController::InitPropValues() +0x8a7
sslctskctrlr +0xda81 = CSSWfTaskController::NavigateTask() +0x21
sscftuisv +0x56f2 = CSSSWECommandMgr::GetPrepareToolbarState() +0x3dd2
sscftuisv +0x7d58 = CSSSWECommandMgr::GetPrepareToolbarState() +0x6438
sscfom +0x1847a = CSSService::InvokeMethod() +0x1ba
sWcftuiwfr +0x2b6d = CSSSWEFrameTaskPlaybar::DoInvokeMethod() +0x7d
SSCASWBC +0x28de9 = CSSSWEFrame::InvokeMethod() +0xe9
SSCASWBC +0xc41b5 = CSSSWEFrameMgrInternal::InvokeAppletMethod() +0x9f5
SSCASWBC +0xa0a07 = CSSSWECmdProcessor::InvokeMethod() +0x557
SSCASWBC +0xa567f = CSSSWECmdProcessor::_ProcessCommand() +0x64f
SSCASWBC +0xa663d = CSSSWECmdProcessor::ProcessCommand() +0x76d
SSCASWBC +0xa6b42 = CSSSWECmdProcessor::ProcessCommand() +0xc2
SSCASWBC +0x1cb4a2 = CSSServiceSWEIface::Request() +0x2e2
SSCASWBC +0x1cc47e = CSSServiceSWEIface::DoInvokeMethod() +0x8fe
sscfom +0x1847a = CSSService::InvokeMethod() +0x1ba
sstcsiom +0x6d6a = CSSSIOMSession::ModInvokeSrvcMethod() +0x10a
sstcsiom +0x7534 = CSSSIOMSession::RPCMiscModel() +0x434
sstcsiom +0xe769 = CSSSIOMSession::HandleRPC() +0x369
sssasos +0x65e6 = CompCleanup() +0x3bb6
sssasos +0x5a95 = CompCleanup() +0x3065
sssasos +0x1a35 = CSSSISObject::operator=() +0x9f5
sssasos +0x2135 = CompHandleMsg() +0x485
siebmtshmw +0x47ae

The issue is intermittent and the following is the observed steps in customer's environment:
1) Login to Siebel Application and navigate to Accounts Screen
2) Click on the Tasks button and select Enrollment Wizard new Customer.
3) Select the Transaction Type = Switch
4) Enter the First Name, Last Name and a SSN that is not existing in the database.
5) Since the SSN is a new one, and the matching Account is not found in Siebel. When you click on next button here, the script in the custom business service will try to create a new account and contact and it crashes at this point.
6) Note the the Task UI works fine when there is SSN is not encrypted.

The issue has the following business impact:
Due to this issue, users cannot enroll new customers.


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