How to correlate which Deployment Area ID corresponds to which Deployment Area name on Spotfire Server in case of multiple deployment areas.

How to correlate which Deployment Area ID corresponds to which Deployment Area name on Spotfire Server in case of multiple deployment areas.

book

Article ID: KB0080681

calendar_today

Updated On:

Products Versions
Spotfire Server All Versions

Description

How to correlate which Deployment Area ID corresponds to which Deployment Area name on Spotfire Server in case of multiple deployment areas created on Spotfire server.

Environment

OS: All Supported Windows Operating Systems

Resolution

- Run the following SQL query on the Spotfire Database to find the AREA ID of the deployment area.

    SELECT AREA_ID
    FROM DEP_AREAS_DEF
    WHERE DEP_AREA_NAME='<Replace me with actual Area Name>'
    Replace <> with the Area Name on which new packages were deployed. e.g Production, Test, etc.

- Go to the Spotfire Server machine and browse the following folder/directory.

              For Spotfire server 7.0 and lower versions:

              <Server Installation folder>\tomcat\temp\deploy\

              For Spotfire server 7.5 and higher versions:
               
             <Server Installation folder>\tomcat\temp\TIBCO\TSS\deploy

In this directory there will be multiple folders having name with deployment area ID's.

- Now you can correlate your deployment area name with actual AREA ID returned in above SQL query.

Issue/Introduction

How to correlate which Deployment Area ID corresponds to which Deployment Area name on Spotfire Server in case of multiple deployment areas.