spotfire shapefile loading issue

[Pablo Madrid]

When i try to load the attached shapefile into spotfire i get the error below. Note this shapefile loads just fine into QGIS and arcgis. please help

 

 

Error message: Failed to create DataTable

ImportException at Spotfire.Dxp.Data:

Failed to create DataTable (HRESULT: 80131500)

Stack Trace:

at Spotfire.Dxp.Data.ColumnFactory.CreateColumns(DataRowReader reader, String documentTitle, IDataPropertyContainer properties, GlobalMethodRegistry globalMethodRegistry, CxxSession session, Boolean addNewProperties, PartialDataLoadReport report, Func`2 resultPropertiesCreator, UInt64 maxRowsToConsume)

at Spotfire.Dxp.Data.Producers.SourceColumnProducer.c__DisplayClass73_0.b__0()

at Spotfire.Dxp.Framework.ApplicationModel.Progress.ExecuteSubtask(String title, ProgressOperation operation)

at Spotfire.Dxp.Data.Producers.SourceColumnProducer.CreateView(CxxSession session, GlobalMethodRegistry globalMethodRegistry, DataSourceConnection connection, DataRowReader initialReader, IDataPropertyContainer defaultColumnProperties, UInt64 maxRowsToConsume, Boolean disableReset, PartialDataLoadReport& partialLoadReport)

at Spotfire.Dxp.Data.Producers.SourceColumnProducer.GetColumnsAndProperties(DataSourceConnection connection)

at Spotfire.Dxp.Data.Persistence.DataItem.PerformUpdate(SourceColumnProducer producer, DataSourceConnection connection)

at Spotfire.Dxp.Data.Persistence.DataItem.Update(SourceColumnProducer producer, DataSourceConnection connection)

at Spotfire.Dxp.Data.Persistence.DataPool.d__15.MoveNext()

at Spotfire.Dxp.Data.Producers.SourceColumnProducer.OnConfigure()

at Spotfire.Dxp.Framework.DocumentModel.Node.ConfigureSubTree()

at Spotfire.Dxp.Framework.DocumentModel.Node.c.b__47_0(Node node)

at Spotfire.Dxp.Framework.DocumentModel.UndoableListAvlLeaf`1.ForEachChild(Action`1 action, Boolean includeFrozen)

at Spotfire.Dxp.Framework.DocumentModel.Node.ConfigureSubTree()

at Spotfire.Dxp.Framework.DocumentModel.Node.c.b__47_0(Node node)

at Spotfire.Dxp.Framework.DocumentModel.UndoableList`1.ForEachChild(Action`1 action, Boolean includeFrozen)

at Spotfire.Dxp.Framework.DocumentModel.Node.ConfigureSubTree()

at Spotfire.Dxp.Framework.DocumentModel.Node.c.b__47_0(Node node)

at Spotfire.Dxp.Framework.DocumentModel.State.NodeState.c__DisplayClass92_0.b__0(IDocumentNodeChild documentNodeChild)

at Spotfire.Dxp.Framework.DocumentModel.State.NodeState.ForEachChild(IDocumentNodeChild[] children, Action`1 action)

at Spotfire.Dxp.Framework.DocumentModel.Node.ConfigureSubTree()

at Spotfire.Dxp.Framework.ApplicationModel.Progress.ExecuteSubtask(String title, IndeterminateProgressFormatter progressFormatter, ProgressOperation operation)

at Spotfire.Dxp.Framework.DocumentModel.DocumentNode.ConfigureAndAttachFromNew()

at Spotfire.Dxp.Framework.DocumentModel.DocumentNode.AttachSubTreeWhileExecuting(UndoableNodeBase newOwner)

at Spotfire.Dxp.Framework.DocumentModel.UndoableNode.Spotfire.Dxp.Framework.DocumentModel.IUndoableNode.AttachItemToUndoableNode(Object item)

at Spotfire.Dxp.Framework.DocumentModel.UndoableKeyedCollection`2.c__DisplayClass43_0.b__0()

at Spotfire.Dxp.Framework.DocumentModel.Node.InternalTransaction(Executor executor, Boolean rollbackNestedInternalTransactionAtException, Boolean isStreamingProperty)

at Spotfire.Dxp.Framework.DocumentModel.UndoableKeyedCollection`2.Insert(Int32 index, TNode item)

at Spotfire.Dxp.Data.DataTableCollection.c__DisplayClass88_0.b__0()

at Spotfire.Dxp.Framework.DocumentModel.Node.InternalTransaction(Executor executor, Boolean rollbackNestedInternalTransactionAtException, Boolean isStreamingProperty)

at Spotfire.Dxp.Data.DataTableCollection.Add(DataTable dataTable)

at Spotfire.Dxp.Data.DataRecommendations.DataSourceInput.c__DisplayClass26_0.b__0(SourceColumnProducer p)

at Spotfire.Dxp.Data.DataRecommendations.DataSourceInput.Execute[T](Func`2 action)

at Spotfire.Dxp.Data.DataRecommendations.AddDataInput.AddDataTable(DataManager dataManager, String tableName, Boolean autoCreateFilters)

at Spotfire.Dxp.Data.DataRecommendations.AddTableAction.Execute(AddDataInput input, DataColumnProducer target, ExecuteSettings settings)

at Spotfire.Dxp.Data.DataRecommendations.NewTableOutputConfiguration.Execute(Boolean autoCreateFilters)

at Spotfire.Dxp.Data.Access.AddData.AddDataSummary.c__DisplayClass25_0.b__0()

 

InvalidOperationException at Spotfire.Dxp.Application:

Record shape type '-465122705' differs from reader shape type 'PolygonZ'. (HRESULT: 80131509)

Stack Trace:

at Spotfire.Dxp.Application.Visuals.MapComponents.Readers.GeometryReader.Parse()

at Spotfire.Dxp.Application.Visuals.MapComponents.ShapeFileDataRowReader.GeometrySetter.MoveNext()

at Spotfire.Dxp.Application.Visuals.MapComponents.ShapeFileDataRowReader.MoveNextCore()

at Spotfire.Dxp.Data.Cxx.CxxDataTransfer.c__DisplayClass9_1.b__0()

at Spotfire.Dxp.Framework.ApplicationModel.Progress.ExecuteSubtask(String title, IndeterminateProgressFormatter progressFormatter, ProgressOperation operation)

at Spotfire.Dxp.Data.Cxx.CxxDataTransfer.CreateTable(DataRowReader dataRowReader, CxxSession session, PartialDataLoadReport report, Advancer rowAdvancer, Boolean needsReset, Int64 exclusiveStartRowIndex, UInt64 maxRowsThatWillBeRead)

at Spotfire.Dxp.Data.Cxx.CxxDataTransfer.CreateTable(DataRowReader dataRowReader, CxxSession session, PartialDataLoadReport report, Boolean needsReset, UInt64 maxRowsToConsume)

at Spotfire.Dxp.Data.Cxx.CxxCreateViewResult.Create(DataRowReader reader, IDataPropertyContainer defaultProperties, String documentTitle, CxxSession session, Boolean addNewProperties, PartialDataLoadReport loadReport, UInt64 maxRowsToConsume)

at Spotfire.Dxp.Data.ColumnFactory.CreateColumnsPrivate(DataRowReader reader, String documentTitle, IDataPropertyContainer properties, GlobalMethodRegistry globalMethodRegistry, CxxSession session, Boolean addNewProperties, PartialDataLoadReport report, Func`2 resultPropertiesCreator, UInt64 maxRowsToConsume)

at Spotfire.Dxp.Data.ColumnFactory.CreateColumns(DataRowReader reader, String documentTitle, IDataPropertyContainer properties, GlobalMethodRegistry globalMethodRegistry, CxxSession session, Boolean addNewProperties, PartialDataLoadReport report, Func`2 resultPropertiesCreator, UInt64 maxRowsToConsume)

[Khushboo Rabadia]

While saving shapefile if you select Geometry as "Polygon" excluding z dimension then

it will open up successfully in Spotfire

https://community.spotfire.com/wiki/creating-custom-shapefiles

Currently, your shape file has geometry set as "PolygonZ" which is causing this issue.