Product: TIBCO Spotfire®
"Internal Server Error" received when saving a package to a deployment area on TIBCO Spotfire Server 7.5.
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
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)
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).
- System requirement page for TIBCO Spotfire Server:
Comments
0 comments
Article is closed for comments.