Two-Way SSL and Problematic Certificates

If two-way SSL is set up with problematic certificates between Oracle Smart View for Office and other Oracle Enterprise Performance Management System data providers, Smart View will prompt for the client-side certificate with every request. For example, the user will be prompted when connecting to the data source, connecting to an application, connecting to a database, and at every refresh, submit, or zoom operation.

To avoid this situation, you must update the properties.xml file on each end user machine to add the clientCert name tag. For example:

<cfg>
    <provider>
        <url>http://server:port/workspace/SmartViewProviders</url>
    </provider>
    <helpurlcontext></helpurlcontext>
    <extensionupdatelist>http://server:port/extensionupdatelist/UpdateList.xml|%SVCLIENTINSTALLPATH%/extensions/UpdateList.xml</extensionupdatelist>
    <!-- Require Smart View to prompt the user for the client-side certificate -->
    <clientCert name="PROMPT-ONLY"/>
</cfg>