Incorrect properties related to SAS Themes might generate various error messages.

For example, you might see an error message similar to the one shown below in the SASPortal4.4.log file that resides in the SAS-configuration-directory/Lev1/Web/Logs/SASServer1_1/ directory:

Or, you might see an error similar to the following in the SASPrincipalServices9.4.log that resides in SAS-configuration-directory/Lev1/Web/Logs/SASServer1_1/:

Errors such as these typically mean that you have incorrect information in regards to the configuration properties for your SAS Themes. For example, you might see these errors if you have Secure Sockets Layer (SSL) configured on your system but your SAS Themes configuration properties point to the a protocol or port that is not SSL. You can solve problem this by updating the properties in SAS^® Management Console or by updating the database manually.

To resolve this problem via SAS Management Console:

On the Plug-ins tab in SAS Management Console:

1. Select Application Management ► Configuration Manager ► SAS Themes ► SASTheme_default.
2. Right-click SASTheme_default and select Properties.
3. On the Connection tab, verify that the properties are correct and make changes, if necessary.

To resolve this problem by updating the database manually in Linux operating environments:

Run the following commands to set up your environment:

Run commands similar to the following to update the database as needed for your environment:

Note: You might be prompted to enter your password for the Shared Services user when you run these commands.

To resolve this problem by updating the database manually in Microsoft Windows operating environments:

Navigate to the SASHOME-Directory\SASHome\SASWebInfrastructurePlatformDataServer\9.4\bin directory.

Run commands like the following from that directory to update the database as needed for your environment:

psql -h localhost -p 9432 -U SharedServices -c "UPDATE public.sas_theme SET port_no='8343' WHERE theme_nm='SASTheme_default';"
psql -h localhost -p 9432 -U SharedServices -c "UPDATE public.sas_theme SET protocol_cd='https' WHERE theme_nm='SASTheme_default';"

Under Windows, you can also use the pgadmin utility to make changes to the database. That utility is located in the SASHOME-Directory\SASHome\SASWebInfrastructurePlatformDataServer\9.4\bin directory.

Operating System and Release Information