My Oracle Support Banner

The "Product Import" Siebel Inbound Web Service crashes after 2nd invocation in same Siebel Object Manager session / task (Doc ID 1503838.1)

Last updated on MARCH 02, 2017

Applies to:

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

Symptoms

The "Upsert" method of the standard Business Service: "Product Import" (published as Siebel standard Inbound Web Service: "Product Import") will CRASH when it is invoked within same Siebel Application session MORE THAN ONE TIME.

Note: In recent Siebel Fix Pack release, the "StateLless" or "Statefull" mode invocation of the "Product Import" Web Service may not crash, but still behave incorrectly: perform NO product import  AND return NO SOAP response.

Sample Siebel EAI Object Manager log one can observe:

The 1st WS-Call (works properly: performs product import/update and returns a SOAP Response with a product message):
...
ObjMgrBusServiceLog InvokeMethod 4  ... Begin: Business Service 'Web Engine Interface' invoke method: 'Request' ....
...
WebSvcInbound WSInboundTrace 3 ... Executing web service operation 'Product Import Upsert' by calling method 'Upsert' of business service 'Product Import' ...
ObjMgrBusServiceLog InvokeMethod 4 ... Begin: Business Service 'Product Import' invoke method: 'Upsert' ...
GenericLog GenericInfo 3 ... Entering into CSSSWIObjectWebSvc::DoInvokeMethod()
GenericLog GenericInfo 3 .. Entering into CSSCMUProdWebSvc::LoadPropSet()
...
ObjMgrSqlObjLog    WriteRecord 5 ... Begin: WriteRecord for SqlObj 'ISS Joint Workspace BusComp' ....
ObjMgrSqlLog Detail 4 ... INSERT/UPDATE statement with ID: Unknown
 INSERT INTO SIEBEL.S_ISS_JWS  (
      CONFLICT_ID,
      DB_LAST_UPD_SRC,
      DB_LAST_UPD,
      LAST_UPD,
      CREATED,
      LAST_UPD_BY,
      CREATED_BY,
      MODIFICATION_NUM,
      ROW_ID,
      JWS_NAME)
VALUES (:1, :2, current_date, :3, :4, :5, :6, :7, :8, :9)
ObjMgrSqlLog    Detail    4    0000005a507e1080:0    2012-10-17 09:27:35    Bind variable 1: 0
ObjMgrSqlLog    Detail    4    0000005a507e1080:0    2012-10-17 09:27:35    Bind variable 2: Object Manager - Default
...
ObjMgrSqlLog    Debug    5    0000005a507e1080:0    2012-10-17 09:27:35    sscfdm +0x114d4c = CSSSqlObj::WriteRecord() +0xd1c
sscfom +0x21852 = CSSBusComp::SqlWriteRecord() +0x22
...
kernel32 +0x2482f = GetModuleHandleA() +0xdf
ObjMgrSqlLog Detail 4 ...
***** SQL Statement Write Time: 0.001 seconds *****
ObjMgrSqlObjLog    WriteRecord ... 5 ... End: WriteRecord for SqlObj ....
ObjMgrDBConnLog EndTransaction 4 ... EndTransaction (COMMIT) was called on DB connection ...
GenericLog GenericInfo 3 ... Entering into CSSCMUProdWebSvc::ExecuteDefinition()
...
ObjMgrBusServiceLog InvokeMethod 4 ... Begin: Business Service 'EAI Siebel Adapter' invoke method: 'Upsert' ....
...
EAISiebAdptPerf EAISiebAdptPerfStat 3 ... Upsert|5|141
EAISiebAdptPerf EAISiebAdptPerfStat 3...CMU ISS Product Details BusComp|UpdateRecord|1|...
EAISiebAdptPerf EAISiebAdptPerfStat 3...CMU ISS Product Details BusComp|Execute|...
EAISiebAdptPerf EAISiebAdptPerfStat 3...CMU ISS Product VOD BusComp|UpdateRecord|...
EAISiebAdptPerf EAISiebAdptPerfStat 3...CMU ISS Product VOD BusComp|Execute|...
EAISiebAdptPerf EAISiebAdptPerfStat 3...CMU ISS Product Versions BusComp|UpdateRecord|...
EAISiebAdptPerf EAISiebAdptPerfStat 3...CMU ISS Product Versions BusComp|Execute|...
EAISiebAdptPerf EAISiebAdptPerfStat 3...CMU Internal Product VOD|UpdateRecord|...
EAISiebAdptPerf EAISiebAdptPerfStat 3...CMU Internal Product VOD|Execute|...
EAISiebAdptPerf EAISiebAdptPerfStat 3...CMU Internal Product Organization|...
EAISiebAdptPerf EAISiebAdptPerfStat 3...CMU Internal Product Organization|...
...
ObjMgrBusServiceLog InvokeMethod 4 ... End: Business Service 'EAI Siebel Adapter' invoke method: 'Upsert'...
...
WebSvcPerf WebSvcPerfInbound 3 ... Product Import Upsert|...
...
ObjMgrBusServiceLog InvokeMethod 4 End: Business Service 'Web Engine Interface' invoke method: 'Request' ...
2nd WS-Call (DOES NOT work properly: perform NO product import and delivers NO SOAP response):
....
ObjMgrBusServiceLog InvokeMethod 4  ... Begin: Business Service 'Web Engine Interface' invoke method: 'Request' ....
...
WebSvcInbound WSInboundTrace 3 ... Executing web service operation 'Product Import Upsert' by calling method 'Upsert' of business service 'Product Import' ...
...
ObjMgrSqlObjLog    WriteRecord 5 ... Begin: WriteRecord for SqlObj 'ISS Joint Workspace BusComp' ....
ObjMgrSqlLog Detail 4 ... INSERT/UPDATE statement with ID: Unknown
 INSERT INTO SIEBEL.S_ISS_JWS  (
      CONFLICT_ID,
      DB_LAST_UPD_SRC,
      DB_LAST_UPD,
      LAST_UPD,
      CREATED,
      LAST_UPD_BY,
      CREATED_BY,
      MODIFICATION_NUM,
      ROW_ID,
      JWS_NAME)
VALUES (:1, :2, current_date, :3, :4, :5, :6, :7, :8, :9)
ObjMgrSqlLog    Detail    4    0000005a507e1080:0    2012-10-17 09:27:35    Bind variable 1: 0
ObjMgrSqlLog    Detail    4    0000005a507e1080:0    2012-10-17 09:27:35    Bind variable 2: Object Manager - Default
...
ObjMgrSqlLog    Debug    5    0000005a507e1080:0    2012-10-17 09:27:35    sscfdm +0x114d4c = CSSSqlObj::WriteRecord() +0xd1c
sscfom +0x21852 = CSSBusComp::SqlWriteRecord() +0x22
...
kernel32 +0x2482f = GetModuleHandleA() +0xdf
ObjMgrSqlLog Detail 4 ...
***** SQL Statement Write Time: 0.001 seconds *****
ObjMgrSqlObjLog    WriteRecord ... 5 ... End: WriteRecord for SqlObj ...
ObjMgrDBConnLog EndTransaction 4 ... EndTransaction (COMMIT) was called on DB connection ...
GenericLog GenericInfo 3 ... Entering into CSSCMUProdWebSvc::ExecuteDefinition()
<NO ANY FURTHER TRACES AND ACTIVITIES HERE>
WebSvcPerf WebSvcPerfInbound 3 ... Product Import Upsert|...
...
ObjMgrBusServiceLog InvokeMethod 4 End: Business Service 'Web Engine Interface' invoke method: 'Request' ...

 

Sample Siebel Client log and call stack on of a crash at the 2nd call of the "Product Import" BS:

ObjMgrBusServiceLog InvokeMethod 4 ... Begin: Business Service 'Product Import' invoke method: 'Upsert' ...
GenericLog GenericInfo 3 ... Entering into CSSSWIObjectWebSvc::DoInvokeMethod()
GenericLog GenericInfo 3 ... Entering into CSSSWIObjectWebSvc::DoCanInvokeMethod()
GenericLog GenericInfo 3 ... Exiting from CSSSWIObjectWebSvc::DoCanInvokeMethod()
GenericLog GenericInfo 3 ... Entering into CSSCMUProdWebSvc::Execute()
...
ObjMgrSqlObjLog    WriteRecord    5 ... Begin: WriteRecord for SqlObj 'ISS Joint Workspace BusComp' at ...
ObjMgrSqlLog    Detail    4 ... INSERT/UPDATE statement with ID: Unknown
 INSERT INTO SIEBEL.S_ISS_JWS  (
      CONFLICT_ID,
      DB_LAST_UPD_SRC,
      DB_LAST_UPD,
      LAST_UPD,
      CREATED,
      LAST_UPD_BY,
      CREATED_BY,
      MODIFICATION_NUM,
      ROW_ID,
      JWS_NAME)
VALUES (...)
...
ObjMgrSqlLog Debug 5 sscfdm +0x114d4c = CSSSqlObj::WriteRecord() +0xd1c
sscfom +0x21852 = CSSBusComp::SqlWriteRecord() +0x22
SSCACMBC +0x1749e = CSSBCBase::SqlWriteRecord() +0xb0e
sscfom +0x3d55b = CSSBusComp::WriteRecord() +0xeab
sscacmussv +0xd67f = CSSCMUProdWebSvc::Execute24() +0x9af
sscacmussv +0x10ba1 = CSSCMUProdWebSvc::Execute() +0x101
sscacmussv +0x1c05e = CSSSWIObjectWebSvc::DoInvokeMethod() +0xde
sscfom +0x189d4 = CSSService::InvokeMethod() +0x204
SSCASTBC +0x6676 = CSSBCVBusSvcTest::DoInvokeMethod() +0x6a6
sscfom +0x2fd39 = CSSBusComp::InvokeMethod() +0x169
sscaswbc +0x30f29 = CSSSWEFrame::DoInvokeMethod() +0x8a9
sscaswbc +0x9cb36 = CSSSWEFrameList::DoInvokeMethod() +0x2f6
SWCASFR +0x208c = CSSSWEBCVBusSvcTestApplet::DoInvokeMethod() +0x31c
sscaswbc +0x2a389 = CSSSWEFrame::InvokeMethod() +0xe9
sscaswbc +0xc9b59 = CSSSWEFrameMgrInternal::InvokeAppletMethod() +0xa19
sscaswbc +0xa4e96 = CSSSWECmdProcessor::InvokeMethod() +0x5e6
sscaswbc +0xa9b8a = CSSSWECmdProcessor::_ProcessCommand() +0x69a
sscaswbc +0xaab7d = CSSSWECmdProcessor::ProcessCommand()

Exception 0xc0000005 at ...
Thread: ...
...
- CALL STACK -
sslcshar +0x1cf3 = SSstring::GetReadBuffer() +0x3
sscacmussv +0xa170 = CSSCMUProdWebSvc::ExecuteDefinition() +0xbd0
sscacmussv +0xdaf9 = CSSCMUProdWebSvc::Execute24() +0xe29
sscacmussv +0x10ba1 = CSSCMUProdWebSvc::Execute() +0x101
sscacmussv +0x1c05e = CSSSWIObjectWebSvc::DoInvokeMethod() +0xde
sscfom +0x189d4 = CSSService::InvokeMethod() +0x204
SSCASTBC +0x6676 = CSSBCVBusSvcTest::DoInvokeMethod() +0x6a6
sscfom +0x2fd39 = CSSBusComp::InvokeMethod() +0x169
sscaswbc +0x30f29 = CSSSWEFrame::DoInvokeMethod() +0x8a9
sscaswbc +0x9cb36 = CSSSWEFrameList::DoInvokeMethod() +0x2f6
SWCASFR +0x208c = CSSSWEBCVBusSvcTestApplet::DoInvokeMethod() +0x31c
sscaswbc +0x2a389 = CSSSWEFrame::InvokeMethod() +0xe9
sscaswbc +0xc9b59 = CSSSWEFrameMgrInternal::InvokeAppletMethod() +0xa19
sscaswbc +0xa4e96 = CSSSWECmdProcessor::InvokeMethod() +0x5e6
sscaswbc +0xa9b8a = CSSSWECmdProcessor::_ProcessCommand() +0x69a
sscaswbc +0xaab7d = CSSSWECmdProcessor::ProcessCommand() +0x76d
sscaswbc +0xab082 = CSSSWECmdProcessor::ProcessCommand() +0xc2
sscaswbc +0x1e0176 = CSSServiceSWEIface::Request() +0x306
sscaswbc +0x1e1dde = CSSServiceSWEIface::DoInvokeMethod() +0xd2e
sscfom +0x189d4 = CSSService::InvokeMethod() +0x204
siebel +0x25f5c = siebel_xmlns::ElemContainer::GetLocation() +0x260c
siebel +0x27279 = siebel_xmlns::ElemContainer::GetLocation() +0x3929
siebel +0x9d87
MFC71U +0x33992 = Ordinal3942() +0x6a

 

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!


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