× Heads up!

Aqua Data Studio / nhilam

Follow
IDE for Relational Databases
×
Raghvendra Singh
raghavsingh reported 2014-05-26T10:47:05Z  · nhilam last modified 2018-03-13T17:52:31Z

A .NET Framework error occurred when we import data for different datatypes on SQL SERVER 2008 database.


PM
Dev
QA
Priority Major
Complexity Unknown
Component Tools - Import Tool
Version Future
Product: Aqua Data Studio
Version: 15.0.0-dev-290
Build #: 38013
Build Date: 2014-May-20 05:34:12 PM
Operating Environment: Windows NT (unknown) (6.2, amd64) /
Database : SQL SERVER 2008
 
 
A .NET Framework error occurred when we import data for different datatypes on SQL SERVER2008 database.
 
Step to Reproduce:
 
Create and Insert scripts for separate datatypes:
 
CREATE TABLE [dbo].[Geometry]  ( 
    [geometry_col] geometry NULL 
    )
GO
 
INSERT INTO "dbo"."Geometry" VALUES ( geometry::STGeomFromText('LINESTRING (90 100, 20 180, 180 180)', 0))
INSERT INTO "dbo"."Geometry" VALUES ( geometry::STGeomFromText('LINESTRING (90 100, 20 180, 180 180)', 0))
 
CREATE TABLE [dbo].[geographyy]  ( 
[geography_col] geography NULL 
)
GO
 
INSERT INTO "dbo"."geographyy" VALUES ( geography::Point(-47.6475, -122.1393, 4326))
INSERT INTO "dbo"."geographyy" VALUES ( geography::Point(-47.6475, -122.1393, 4326))
 
CREATE TABLE [dbo].[Hierarchyid]  ( 
[hierarchyid_col] hierarchyid NULL 
)
GO
 
INSERT INTO "dbo"."Hierarchyid" VALUES ( '/1/')
INSERT INTO "dbo"."Hierarchyid" VALUES ( '/2/')
 
 
Exported a (.txt) file and save given data to seperate files. Used attached (.txt) files for seperate datatypes.
 
Now when import this data in created table with "select transaction type= Batch in the Transaction tab" its thrown expection.
 
 
Execute batch failed: A .NET Framework error occurred during execution of user-defined routine or aggregate "geography": 
System.FormatException: 24114: The label e6100000010c7b14ae47 in the input well-known text (WKT) is not valid. Valid labels are POINT, LINESTRING, POLYGON, MULTIPOINT, MULTILINESTRING, MULTIPOLYGON, or GEOMETRYCOLLECTION.
System.FormatException: 
   at Microsoft.SqlServer.Types.OpenGisWktReader.ParseTaggedText(OpenGisType type)
   at Microsoft.SqlServer.Types.OpenGisWktReader.Read(OpenGisType type, Int32 srid)
   at Microsoft.SqlServer.Types.SqlGeography.GeographyFromText(OpenGisType type, SqlChars taggedText, Int32 srid)
   at Microsoft.SqlServer.Types.SqlGeography.STGeomFromText(SqlChars geometryTaggedText, Int32 srid)
   at Microsoft.SqlServer.Types.SqlGeography.Parse(SqlString s)
 
3 attachments
  •  
  •  
  • No shares
  •  
All Comments (3) Change History
Sort 

Issue #12200
New
 
 
Completion
No due date
No fixed build
No time estimate

About AquaClusters Privacy Policy Support Version - 19.0.2-4 AquaFold, Inc Copyright © 2007-2017