Skip to main content
Planview Customer Success Center

Intelligent Forms does errors out or does not launch (blank page appears)

Changepoint 2022 R12

Symptoms

In Changepoint 2022 R12, Intelligent Forms form errors out or does not launch (blank page appears).

Possible event log errors:

Application: w3wp.exe
CoreCLR Version: 6.0.1322.58009
.NET Version: 6.0.13
Description: The process was terminated due to an unhandled exception.
Exception Info: Microsoft.Data.SqlClient.SqlException (0x80131904): A connection was successfully established with the server, but then an error occurred during the login process. (provider: SSL Provider, error: 0 - The certificate chain was issued by an authority that is not trusted.)
Application: w3wp.exe
CoreCLR Version: 6.0.1322.58009
.NET Version: 6.0.13
Description: The process was terminated due to an unhandled exception.
Exception Info: System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation.
 ---> Microsoft.Data.SqlClient.SqlException (0x80131904): A connection was successfully established with the server, but then an error occurred during the login process. (provider: SSL Provider, error: 0 - The target principal name is incorrect.)
 ---> System.ComponentModel.Win32Exception (0x80090322): The target principal name is incorrect…..
Exception: 
System.Exception: Verify User failed.  Error Code: -4 Message: Invalid Changepoint connection string
Reason

The SQL Server connection is configured to enforce connection encryption when using a Windows default certificate or wild card certificate.

Resolution

To resolve this issue, you must add a parameter to the connection string to allow the certificate.

  1. On the web server, update the appsettings.json located in the \Intelligent Forms\Websites\Manage folder and the \Intelligent Forms\Websites\Produce folder by adding the following to the end of the connection strings:

    ;Encrypt=True;TrustServerCertificate=True

    Example:

    "DboConnection": "Persist Security Info=False;Initial Catalog=InfinitiDB;Data Source=SQLServerName;User Id=xxx;Password=xxx;Encrypt=True;TrustServerCertificate=True",
    "DefaultConnection": "Persist Security Info=False;Initial Catalog=InfinitiDB;Data Source= SQLServerName;User Id=xxx;Password=xxx;Encrypt=True;TrustServerCertificate=True"

  2. In SmartIQ Manage, update the Changepoint Connection String under Settings > Changepoint > Changepoint Connection String:

    'Password=xxx;User ID=xxx;Initial Catalog=Changepoint;Data Source=SQLServerName;Encrypt=True;TrustServerCertificate=True'

  3. Double check the Changepoint Connection String in the InfinitiDB database in SQL server and add  “;Encrypt=True;TrustServerCertificate=True” at end of existing connection strings if there are any.

    ConnectorSettings_ElementType.ElementValue

    ConnectorSettings_BusinessUnit.ElementValue

  4. Update Data Connections in SmartIQ by adding “;Encrypt=True;TrustServerCertificate=True” at end of Connection Attributes.

    Example:

    Initial Catalog=Changepoint;Data Source=SQLServerName;Encrypt=True;TrustServerCertificate=True