1455254 - After installation of SAP integration kit SP2 CMS crashes upon login with secSAPR3 users

• After installing XI 3.1 Service Pack P2 for SAP Integration kit the cms crashes during attempting a secSAPR3 logon
• Enterprise and other logon types work fine
• SAP plugin and role mapping work fine
• SAP users cannot login CMS.exe removed from memory and requires SIA restart to restore
• Also noted that SAP role mapping may not work fine
• SAP users do not show up after mapping roles

• The issue does not occur prior to IK SP2 being installed.
• All XI 3.x versions prior to IK SP2 do not have this issue
• Issue occurs on all patches after IK SP2 (was reproduced on SP2 and FP 2.5)

zie XI3 XIR3 XI 3.x GUI client install The following was the thread in the logs where the CMS crashed 2010/03/31 13:39:31.851|==| | | 3984|2600| |||||||||||||||ServantObMgr::remove_service(BYPASSSEC_HANDLE) before: service(0x4290235940) of (IDL:OCA/OCAi/InfoStoreEx4:4.0) has refcount of 3
2010/03/31 13:39:31.851|==| | | 3984|2600| |||||||||||||||ServantObMgr::remove_service(BYPASSSEC_HANDLE) after: service(0x4290235940) of (IDL:OCA/OCAi/InfoStoreEx4:4.0) has refcount of 2. cleanup succeeded=true
2010/03/31 13:39:50.445|==| | | 3984|2600| |||||||||||||||BatchQuery: Processing query 'SELECT SI_ID, SI_PLACEHOLDERS, SI_NAME, SI_KIND FROM CI_SYSTEMOBJS WHERE SI_KIND='Install' AND PARENTS("SI_NAME='Install-EnterpriseNode'", "SI_KIND='EnterpriseNode' AND SI_ID=820")'
2010/03/31 13:39:50.445|>=| | | 3984|2600|{|||||||||||||||CInfoStoreSubsystem::Query
2010/03/31 13:39:50.445|>=| | | 3984|2600| |||||||||||||||CInfoStoreSubsystem::Query:[UID=0;USID=0] SELECT SI_ID, SI_PLACEHOLDERS, SI_NAME, SI_KIND FROM CI_SYSTEMOBJS WHERE SI_KIND='Install' AND PARENTS("SI_NAME='Install-EnterpriseNode'", "SI_KIND='EnterpriseNode' AND SI_ID=820") : (proc=false,chk=true,srv=true)
2010/03/31 13:39:50.445|==| | | 3984|2600| |||||||||||||||METADATARECORDTAG: CInfoStoreSubsystem::Query(proc=SELECT SI_ID, SI_PLACEHOLDERS, SI_NAME, SI_KIND FROM CI_SYSTEMOBJS WHERE SI_KIND='Install' AND PARENTS("SI_NAME='Install-EnterpriseNode'", "SI_KIND='EnterpriseNode' AND SI_ID=820"),chk=false,srv=true,qry=true): Start
2010/03/31 13:39:50.445|==| | | 3984|2600| |||||||||||||||querystring (SELECT SI_ID, SI_PLACEHOLDERS, SI_NAME, SI_KIND FROM CI_SYSTEMOBJS WHERE SI_KIND='Install' AND PARENTS("SI_NAME='Install-EnterpriseNode'", "SI_KIND='EnterpriseNode' AND SI_ID=820"))
2010/03/31 13:39:50.445|==| | | 3984|2600| |||||||||||||||Query(): Adding query to the cache, current size = 13
2010/03/31 13:39:50.445|>=| | | 3984|2600|{|||||||||||||||CObjectSS::GetRelated 1
2010/03/31 13:39:50.445|==| | | 3984|2600| |||||||||||||||(.\MySQLStatement.cpp:257) ExecDirect: SQL: SELECT  DISTINCT RELTABLE.PARENTID, CMS_InfoObjects6.ObjectID FROM CMS_RELATIONS6 RELTABLE, CMS_InfoObjects6 WHERE RELTABLE.RELATIONSHIPID IN (157) AND ((CMS_InfoObjects6.TypeID = 53 AND SI_PLUGIN_OBJECT = 0) AND CMS_InfoObjects6.SI_TABLE = 2 AND CMS_InfoObjects6.SI_HIDDEN_OBJECT = 0) AND RELTABLE.PARENTID = CMS_InfoObjects6.ObjectID AND RELTABLE.CHILDID IN (SELECT CMS_InfoObjects6.ObjectID FROM CMS_InfoObjects6 WHERE ((CMS_InfoObjects6.TypeID = 59 AND SI_PLUGIN_OBJECT = 0) AND CMS_InfoObjects6.ObjectID = 820 AND CMS_InfoObjects6.SI_TABLE = 2 AND CMS_InfoObjects6.SI_HIDDEN_OBJECT = 0)) ORDER BY CMS_InfoObjects6.ObjectID ASC
2010/03/31 13:39:50.445|==| | | 3984|2600| |||||||||||||||(.\DatabaseSubsystem_impl.cpp:208) SQL executed on connection 4097 (transaction 0): SELECT  DISTINCT RELTABLE.PARENTID, CMS_InfoObjects6.ObjectID FROM CMS_RELATIONS6 RELTABLE, CMS_InfoObjects6 WHERE RELTABLE.RELATIONSHIPID IN (157) AND ((CMS_InfoObjects6.TypeID = 53 AND SI_PLUGIN_OBJECT = 0) AND CMS_InfoObjects6.SI_TABLE = 2 AND CMS_InfoObjects6.SI_HIDDEN_OBJECT = 0) AND RELTABLE.PARENTID = CMS_InfoObjects6.ObjectID AND RELTABLE.CHILDID IN (SELECT CMS_InfoObjects6.ObjectID FROM CMS_InfoObjects6 WHERE ((CMS_InfoObjects6.TypeID = 59 AND SI_PLUGIN_OBJECT = 0) AND CMS_InfoObjects6.ObjectID = 820 AND CMS_InfoObjects6.SI_TABLE = 2 AND CMS_InfoObjects6.SI_HIDDEN_OBJECT = 0)) ORDER BY CMS_InfoObjects6.ObjectID ASC
2010/03/31 13:39:50.445|==| | | 3984|2600| |||||||||||||||DatabaseSubsystem::GetObjectIds: End: Count(1), SQL(SELECT  DISTINCT RELTABLE.PARENTID, CMS_InfoObjects6.ObjectID FROM CMS_RELATIONS6 RELTABLE, CMS_InfoObjects6 WHERE RELTABLE.RELATIONSHIPID IN (157) AND ((CMS_InfoObjects6.TypeID = 53 AND SI_PLUGIN_OBJECT = 0) AND CMS_InfoObjects6.SI_TABLE = 2 AND CMS_InfoObjects6.SI_HIDDEN_OBJECT = 0) AND RELTABLE.PARENTID = CMS_InfoObjects6.ObjectID AND RELTABLE.CHILDID IN (SELECT CMS_InfoObjects6.ObjectID FROM CMS_InfoObjects6 WHERE ((CMS_InfoObjects6.TypeID = 59 AND SI_PLUGIN_OBJECT = 0) AND CMS_InfoObjects6.ObjectID = 820 AND CMS_InfoObjects6.SI_TABLE = 2 AND CMS_InfoObjects6.SI_HIDDEN_OBJECT = 0)) ORDER BY CMS_InfoObjects6.ObjectID ASC)
2010/03/31 13:39:50.445|>=| | | 3984|2600|}|||||||||||||||CObjectSS::GetRelated 1: 0
2010/03/31 13:39:50.445|>=| | | 3984|2600| |||||||||||||||CInfoStoreSubsystem::Query result set count estimate is 1
2010/03/31 13:39:50.445|>=| | | 3984|2600|}|||||||||||||||CInfoStoreSubsystem::Query: 0
2010/03/31 13:39:54.070|==| | | 3984|2600| |||||||||||||||ServantObMgr::remove_service(BYPASSSEC_HANDLE) before: service(0x4272222900) of (IDL:OCA/OCAi/InfoStoreEx4:4.0) has refcount of 3
2010/03/31 13:39:54.070|==| | | 3984|2600| |||||||||||||||ServantObMgr::remove_service(BYPASSSEC_HANDLE) after: service(0x4272222900) of (IDL:OCA/OCAi/InfoStoreEx4:4.0) has refcount of 2. cleanup succeeded=true
2010/03/31 13:40:04.680|==| | | 3984|2600| |||||||||||||||ServantObMgr::add_service(BYPASSSEC_HANDLE): service(0x4272222068) of (IDL:OCA/OCAi/InfoStoreEx4:4.0) added to the list. refcount of 3
2010/03/31 13:40:24.023|==| | | 3984|2600| |||||||||||||||ServantObMgr::add_service(2033J382TFg3BkefCEso): service(0x4272221860) of (IDL:OCA/OCAi/InfoStoreEx4:4.0) added to the list. refcount of 3
2010/03/31 13:42:07.258|==| | | 3984|2600| |||||||||||||||(.\sessionmgr.cpp:3056) CSessionMgr::AcceptLogonEx(logonPropertyBag:3&ca=0:0:0:0:0:0:0:1,8P&cY,8P&cb=server.com,8P&cZ,8P, inAuthMethod:secSAPR3)
2010/03/31 13:42:07.320|==| | | 3984|2600| |||||||||||||||Plugin secSAPR3 doesn't have optional function NeedCanonicalUserName. , KBA , BI-BIP-ADM , BI Servers, security, Crystal Reports in Launchpad , BI-BIP-IK , Integration; Integration kits for SAP, Baan, PeopleSoft, Sie , BI-BIP-IK-AUT , Authentication for integration kits , Problem