Support Article
Database locks cause SSO failure
SA-97951
Summary
On executing the below SQL, database blocks are generated occasionally. Hence, user is unable to log in to the application.
@P0 varchar(8000),@P1 datetime2,@P2 varchar(8000),@P3 varchar(8000),@P4 datetime2,@P5 datetime2,@P6 varchar(8000),@P7 varchar(8000))MERGE INTO mypegadata.pr_data_saml_authreqcontext
t USING (VALUES (@P0 , @P1 , @P2 , @P3 , @P4 , @P5 , @P6 , @P7)) AS inputs ("pzInsKey" , "pxCreateDateTime" , "pxInsName" , "pxObjClass" , "pxSaveDateTime" , "pxUpdateDateTime" , "pyAuthServiceName" , "pyUniqueRequestAuthId") ON (t.pzInsKey = inputs."pzInsKey") WHEN MATCHED THEN UPDATE SET "pxCreateDateTime" = inputs."pxCreateDateTime" , "pxInsName" = inputs."pxInsName" , "pxObjClass" = inputs."pxObjClass" , "pxSaveDateTime" = inputs."pxSaveDateTime" , "pxUpdateDateTime" = inputs."pxUpdateDateTime" , "pyAuthServiceName" = inputs."pyAuthServiceName" , "pyUniqueRequestAuthId" = inputs."pyUniqueRequestAuthId" , pxCommitDateTime = CURRENT_TIMESTAMP WHEN NOT MATCHED THEN INSERT (pzInsKey , pxCommitDateTime , "pxCreateDateTime" , "pxInsName" , "pxObjClass" , "pxSaveDateTime" , "pxUpdateDateTime" , "pyAuthServiceName" , "pyUniqueRequestAuthId") VALUES (inputs."pzInsKey" , CURRENT_TIMESTAMP , inputs."pxCreateDateTime" , inputs."pxInsName" , inputs."pxObjClass" , inputs."pxSaveDateTime" , inputs."pxUpdateDateTime" , inputs."pyAuthServiceName" , inputs."pyUniqueRequestAuthId");
Error Messages
Not Applicable
Steps to Reproduce
Set up the application running on Pega Platform 8.2.2 to use Single Sign-On (SSO).
Root Cause
This occurs while executing the Obj-Save on the AuthRequestContext activity with 'OnIfNew' set as false. Due to the check, a Select query is run on the table to determine if the context is already present and then attempts to insert.
Resolution
- Apply the following hotfixes.
a. HFix-57968
b. HFix-59291
- Perform a restart.
Published February 10, 2020 - Updated December 2, 2021
Have a question? Get answers now.
Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.