Overview

Your users may receive the Error An error occurred while executing the application. Please try again or contact the administrator message when trying to validate their registration through your portal. Your users also may be unsuccessful completing an event registration.

Solution

This issue is caused by the Java key store not picking up new intermediate certificates from the server. By following the steps in this article, you will be able to manually add the intermediate certificates to Java and resolve the error messages.

Prerequisites

This solution is for customers using the ColdFusion Server service. Customer must have access to the key store file and (any) passwords required.

Steps

1. To get intermediate certificates, enter into Powershell on the ColdFusion server:

openssl s_client - showcerts -verify 5 -connect [put domain here]

This will return all certificates. ONLY the certificates BETWEEN the beginning certificate (the first one listed) and the root certificate (last one) are needed.

2. For each certificate:

Copy the text of the certificate, making sure it begins with the Begin Certificate section and includes everything up to and including the End Certificate, as seen in this screenshot:

Create a new text document and change the file extension to .cer. Open with Notepad and paste the certificate text.

3. Run the following command for each certificate in Powershell on the ColdFusion server:

C:\ColdFusion11\jre-patched\lib\security> ..\..\bin\keytool.exe -keystore cacerts -import -alias sectigorsa1 -file import\sectigorsa1.cer

Replace [sectigorsal] (located in two places in command) with the certificate filename.

4. Reboot the ColdFusion server

Testing

Test portal to ensure users can now validate their event registration without error messages.