Product: TIBCO Spotfire®
"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).
Comments
0 comments
Article is closed for comments.