Upgrading Spotfire 7.0 to 7.6 (High Level)

This is a quick guide for upgrading to the latest version of Spotfire. I’m going to write this at a high-level so that Spotfire admins can benefit from a brief installation guide.

  1. Apply the latest hotfix to Spotfire 7.0.1 (HF-007 in my case)
    1. Download hotfix package
    2. Turn off Spotfire server
    3. Run hotfix.bat
    4. Turn on Spotfire server to check
  2. Install Spotfire 7.6
    1. Pick a new port
    2. Remember those node ports from the installation
    3. Run the upgrade tool
  3. Upgrade Spotfire upgrade tool

At this point I want to talk about some debugging I did:

  • After executing the upgrade tool, I got a fatal error saying that there was a duplicate row in the groups database. The duplicate row was the Automation Services group. At the expense of AS, I decided to go into the Administration Manager and simply delete that group. I’m not sure if AS will work after the upgrade but that was OK for me.
  • I got a bunch of warnings after the installation, one saying that I must install a MySQL5 database driver. I’ll check this afterward.

After the database has been successfully upgraded

  1. Run nm-setup.exe from the 7.6 installation folder
  2. Go into the deployment section of <your server>:<your port>/
  3. Upload the 7.6 deployment
  4. Upload the node deployment

Presto!

Including Point Sets in 3D Subsurface Visualization

A point is a spot in space. In the world of geologic mapping, or mapping in general, it is represented by co-ordinates: X, Y on a plane; and X, Y, Z in 3-dimensions.

Using Ruths.ai 3D Subsurface Visualization, it is easy to identify/add a point in a spatial environment for reservoir management or geologic applications – marking a pick location of interest. A point can be marked along a wellbore, on a surface, in a seismic imagery, or in an empty space. What defines the positioning of a point is its X, Y, Z co-ordinates.

Read More

Fatal Police Shootings: A Multifaceted Issue

Issues of race, police brutality, and gun control have been at the forefront of America’s list of hotly debated topics. Earlier this month, Dallas police officers were killed by an individual seeking payback for recent police shootings, and just yesterday three officers were killed in Baton Rouge– a city in strife after white officers shot and killed a black man earlier in July. Black Lives Matter demonstrators argue that police are targeting black Americans. These issues are complex and multifaceted, but thanks to the Washington Post, we have data that covers police shootings from 2015 to present day.

Read More

How to Debug a Spotfire Data Function in RStudio?

Have you ever come across problems and errors while running the TERR scripts in Spotfire Data Functions which you didn’t have while running the same code as an R script outside Spotfire? There is a way to troubleshoot this issue by debugging your TERR code outside of Spotfire, i.e., in RStudio. Generally speaking, you need to enable your RStudio to run the TERRengine instead of R. Then, you want to be able to access your TERR Data Function Input Parameters from RStudio so that you can run and debug your TERR script there. How to do all that? It’s not that complicted. Please follow the steps below.

Read More

Including Formation Tops in Well Log Visualization

It is quite easy to include formation tops in the Ruths.ai Well Log Visualization. The neatest way to do that is to have a data table that contains the formation top depth for each well contained in the data table that has the well log data. In its most basic form, the formation tops data table should contain at least 3 columns: Formation Name, Top Depth and Well Name. Here is a video of how to add formation tops to Ruths.ai Well Log Visualization:

Read More

Adding Collaboration to Spotfire using SharePoint

Spotfire is a powerful BI tool but lacks some fundamental collaborative functions. As a core principle of BI, tools are meant to report on and not change systems of record. Of course, anyone who has built BI solutions knows that in the real world you want to add the ability for users to capture their findings or edit/adjust key values without adjusting or talking to source vendor systems. Enter SharePoint! Here’s a quick guide for creating a collaborative analytics dashboard in Spotfire using SharePoint.

Read More