Shop

Your Notifications (0)

There are currently no notifications. You're all set!

Demos Trials
Knowledge Base
ChemDraw and ChemOffice+ Products Signals Notebook E-Notebook and ChemBioOffice Enterprise Spotfire and Signals Spotfire Products Columbus Signals Image Artist
Downloads
Downloads
Community
Support Forums Ideas Portal Product Basics
About Support
Legal Resources Support and Maintenance Plans Product Life Cycle Support News
Contact Support

Supported data types for spatial data

Rich Talbot
  • Updated
Date Posted:
Product: TIBCO Spotfire®

Problem:

Supported data types for spatial data


Solution:

When imported to TIBCO Spotfire, a shape using the SDE.ST_GEOMETRY data type will display as [..] instead of displaying the actual shape.  This is because many data sources use SDE.ST_GEOMETRY as the data type for the polygon column, which is not supported in Spotfire.

For example, when trying to read SDE.ST_GEOMETRY data through an Oracle data connector, you might also encounter the following error: 

ImportException at Spotfire.Dxp.Data:
An error occurred when executing a query in the external data source.
External error:
ORA-28578: protocol error during callback from an external procedure
ORA-06512: at "SDE.ST_GEOMETRY_SHAPELIB_PKG", line 67
ORA-06512: at "SDE.ST_GEOMETRY_OPERATORS", line 118

  To resolve, use the SDO_GEOMETRY data type instead. This site outlines how to convert SDE.ST_GEOMETRY to SDO_GEOMETRY, which will import successfully into Spotfire: External: ST_GEOMETRY to SDO_GEOMETRY

Related articles