View Issue Details

IDProjectCategoryView StatusLast Update
0003327SymmetricDSImprovementpublic2017-12-04 09:03
ReportermmichalekAssigned To 
PrioritynormalSeverityminorReproducibilityhave not tried
Status newResolutionopen 
Product Version3.9.0 
Target VersionFixed in Version 
Summary0003327: Support SQL Server geography type
DescriptionCurrently, it appears that the "geometry" type works, but not the "geography" type.

**SETUP**

CREATE TABLE test (
    ID INT NOT NULL PRIMARY KEY
    , GEOGRAPHY geography
);

INSERT INTO test VALUES (
    001, geography::Parse('POINT(34.1790991 -84.1217773)'));

--or use the syntax

INSERT INTO test VALUES (
    002, 'POINT(44.1790991 -84.4412174563)');
--Sent Schema to target
--Setup triggers/routers
--Send load data

**ACTUAL ERROR**
2017-11-28 14:23:05,185 ERROR [corp] [AcknowledgeService] [qtp267760927-16] The outgoing batch 001-18 failed: [S1000,6522] A .NET Framework error occurred during execution of user-defined routine or aggregate "geography":
System.ArgumentException: 24204: The spatial reference identifier (SRID) is not valid. The specified SRID must match one of the supported SRIDs displayed in the sys.spatial_reference_systems catalog view.
System.ArgumentException:
TagsNo tags attached.

Activities

There are no notes attached to this issue.

Issue History

Date Modified Username Field Change
2017-12-04 09:03 mmichalek New Issue