"Internal Server Error" received when saving a package to a deployment area on Spotfire Server 7.5.

"Internal Server Error" received when saving a package to a deployment area on Spotfire Server 7.5.

Product: TIBCO Spotfire Server

Version: 7.5

OS: All Supported Operating Systems

When attempting to save a package to a deployment area on TIBCO Spotfire Server 7.5 (after successfully adding and validating packages), a 500 error is logged and the package deployment save attempt fails with the following error: "Internal Server Error HTTP Error code: 500 Error message: An Internal Server Error has occurred. Error code: XXXXXXXX-XXXX-XXXX-XXXXXXXXXXXX" When updating the deployment areas in (Deployments & Packages > Software Packages), after successfully adding a package ("Add package" button) and validating the deployment area ("Validate" button), when attempting to save the changes with the "Save" button, the following popup error is reported. "Internal Server Error HTTP Error code: 500 Error message: An Internal Server Error has occurred. Error code: XXXXXXXX-XXXX-XXXX-XXXXXXXXXXXX"

In the Spotfire Server instance's "server.log" file, the following error and warning entries are seen: ================================================================ WARN 2016-02-25T10:58:05,305-0500 [support, #14, #59] ws.deployments.ClientDeploymentWorkspace: An error occured com.spotfire.server.config.services.ServiceConfigurationException: Unexpected error: Subqueries are not allowed in this context. Only scalar expressions are allowed. at com.spotfire.server.config.services.ServiceConfigurationManager.importDefaultConfiguration(ServiceConfigurationManager.java:520) at com.spotfire.ws.deployments.ClientDeploymentWorkspace.deployConfiguration(ClientDeploymentWorkspace.java:539) at com.spotfire.ws.deployments.ClientDeploymentWorkspace.deploy(ClientDeploymentWorkspace.java:390) at com.spotfire.ws.deployments.DeploymentService.saveDistribution(DeploymentService.java:560) at com.spotfire.rs.deployment.DeploymentController.saveDistribution(DeploymentController.java:453) ... Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: Subqueries are not allowed in this context. Only scalar expressions are allowed. ...

ERROR 2016-02-25T10:58:05,337-0500 [support, #14, #59] spotfire.rs.RestExceptionHandler: Intercepted exception in request to /rest/deployment/saveDistribution com.spotfire.server.deployment.DeploymentException: An Internal Server Error has occurred. at com.spotfire.ws.deployments.DeploymentService.saveDistribution(DeploymentService.java:566) at com.spotfire.rs.deployment.DeploymentController.saveDistribution(DeploymentController.java:453) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ... ===============================================================

Unsupported database server version. This TIBCO Spotfire Server 7.5 instance has been provided an unsupported database server version (such as Microsoft SQL Server 2005) to host its Spotfire database (the housekeeping database that stores Spotfire metadata, Spotfire package deployments, and the Spotfire library).

Check the version of the database server used by the TIBCO Spotfire Server application. If the Microsoft SQL Server version is not one of the supported versions (specifically, if it is Microsoft SQL Server 2005), then this error will be reported.

The following are the supported versions of Microsoft SQL Server: • Microsoft SQL Server 2014 • Microsoft SQL Server 2012 • Microsoft SQL Server 2008 R2 • Microsoft SQL Server 2008 To resolve this issue, upgrade the database version used by the TIBCO Spotfire Server to a supported version. See the attached (Filename:Internal_Server_Error_Message.jpg).