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 8.1.1.8 SIA [23012] [Release V8]
Information in this document applies to any platform.
***Checked for relevance on 6-OCT-2016***

Symptoms


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:

CRASH CALL STACK:
-----------------------
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


STEPS
-----------------------
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.

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

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