============================================================================= Run Date: FEB 22, 2021 Designation: XU*8*708 Package : XU - KERNEL Priority: Mandatory Version : 8 SEQ #586 Status: Released Compliance Date: MAR 25, 2021 ============================================================================= Subject: KAAJEE SSPI - REVISE DATABASE CONNECTION Category: - Informational Description: ============ This Kernel Authentication & Authorization for Java 2 Enterprise Edition (KAAJEE) - Single Sign-on Provider Interface (SSPI) patch, XU*8*708, addresses an issue on the WebLogic server side regarding a revised database connection method. The new version, WebLogic 10.3.6 has a built-in "SQLAuthenticationProvider" component which can be configured to fulfill SSPI's original functionality. The custom interface is no longer used, which eliminates the associated database (db) connectivity errors. This new functionality is a configuration item on the WebLogic server side. The patch is comprised of a database change to extend the length of a password field (a requirement for the new provider) and a Python script to construct the new SQLAuthenticationProvider in WebLogic. This is an INFORMATIONAL only patch. Patch Components: ----------------- N/A Files & Fields Associated: File Name (Number) Field Name (Number) New/Modified/Deleted ------------------ ------------------- -------------------- N/A Forms Associated: Form Name File # New/Modified/Deleted --------- ------ -------------------- N/A Mail Groups Associated: Mail Group Name New/Modified/Deleted --------------- -------------------- N/A Options Associated: Option Name Type New/Modified/Deleted ----------- ---- -------------------- N/A Protocols Associated: Protocol Name New/Modified/Deleted ------------- -------------------- N/A Security Keys Associated: Security Key Name ----------------- N/A Templates Associated: Template Name Type File Name (Number) New/Modified/Deleted ------------- ---- ------------------ -------------------- N/A Remote Procedures Associated: Remote Procedure Name New/Modified/Deleted --------------------- -------------------- N/A Parameter Definitions Associated: Parameter Name New/Modified/Deleted -------------- -------------------- N/A Additional Information: N/A New Service Requests (NSRs): ---------------------------- N/A Patient Safety Issues (PSIs): ----------------------------- N/A Defect Tracking System Ticket(s) & Overview: -------------------------------------------- 1. INC4482091 - Revise the datasource-obtaining method to avoid errors upon database restart. Problem: -------- The current custom KAAJEE SSPI establishes a database connection outside of WebLogic's data source management mechanism. This produces errors whenever the target database is being maintained or restarted. When this happens an admin server needs to be restarted in order to re-establish the connection, which then produces associated Application Not Responding (ANR) messages and down times which causes delays and work degradation. Resolution: ----------- Introduced with WebLogic 10.3.6 is a built-in "SQLAuthenticationProvider" component that can be configured to fulfill SSPI's functionality. The current custom software interface is no longer used, and this eliminates the associated database (DB) connectivity errors (upon DB restart). This new functionality is a configuration item on the WebLogic server side. Test Site: ========== Salem VA Medical Center Software and Documentation Retrieval Instructions: ================================================== This release includes software files. They can be obtained at location: /srv/vista/patches/SOFTWARE the software files can also be obtained by accessing the URL: https://download.vista.domain.ext/index.html/SOFTWARE File Title File Name Format --------------------------------------------------------------------- XU-8-708 XU_8_708.ZIP Binary Documentation describing the new functionality is included in this release. Documentation can be found on the VA Software Documentation Library at: https://www.domain.ext/vdl/. Documentation can also be obtained at https://download.vista.domain.ext/index.html/SOFTWARE Title File Name ========================================================================== Deployment Guide 1.3 (WebLogic 10.3.6 and higher) KAAJEE_SSPI_1_3_DIBR.PDF Installation Guide 1.3 (WebLogic 10.3.6 and higher) KAAJEE_SSPI_1_3_IG.PDF Release Notes 1.3 (WebLogic 10.3.6 and higher) KAAJEE_SSPI_1_3_RN.PDF Note: The SSPI Configuration Guide is embedded in the Installation Guide. Pre/Post Installation Overview: ------------------------------- N/A Pre-Installation Instructions: ------------------------------ N/A Installation Instructions: -------------------------- ****************************************************************** ** PLEASE NOTE: THERE IS NO INSTALLATION FOR THIS PATCH. ** ****************************************************************** Installation for KAAJEE patch, XU*8.0*708, is performed by Community Resource and Referral Center (CRRC) on a centralized web server. Post-Installation Instructions: ------------------------------- N/A Back-Out Plan: -------------- The back-out plan is found in the Installation Guide 1.3 (WebLogic 10.3.6 and higher) and will be sent to CRRC. Routine Information: ==================== No routines included. ============================================================================= User Information: Entered By : Date Entered : FEB 25, 2019 Completed By: Date Completed: FEB 22, 2021 Released By : Date Released : FEB 22, 2021 ============================================================================= Packman Mail Message: ===================== No routines included