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

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

book

Article ID: KB0074610

calendar_today

Updated On:

Products Versions
Spotfire Server 7.5

Description

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)

Issue/Introduction

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

Resolution

The cause for this is a the use of an unsupported database server version for the TIBCO Spotfire Server application database.

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).

Additional Information

Attachments

"Internal Server Error" received when saving a package to a deployment area on TIBCO Spotfire Server 7.5. get_app
Powered by Wolken Software