View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0003327 | SymmetricDS | Improvement | public | 2017-12-04 14:03 | 2018-05-08 20:09 |
| Reporter | mmichalek | Assigned To | mmichalek | ||
| Priority | normal | ||||
| Status | closed | Resolution | fixed | ||
| Product Version | 3.9.0 | ||||
| Target Version | 3.9.7 | Fixed in Version | 3.9.7 | ||
| Summary | 0003327: Support SQL Server geography type | ||||
| Description | Currently, 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: | ||||
| Tags | No tags attached. | ||||
|
|
This code is from a community commit from lyamin626. https://github.com/JumpMind/symmetric-ds/pull/72 |
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2017-12-04 14:03 | mmichalek | New Issue | |
| 2018-04-04 14:21 | mmichalek | Note Added: 0001161 | |
| 2018-04-04 14:22 | mmichalek | Assigned To | => mmichalek |
| 2018-04-04 14:22 | mmichalek | Status | new => resolved |
| 2018-04-04 14:22 | mmichalek | Resolution | open => fixed |
| 2018-04-04 14:22 | mmichalek | Fixed in Version | => 3.9.7 |
| 2018-04-04 14:22 | mmichalek | Target Version | => 3.9.7 |
| 2018-04-04 15:00 | mmichalek | Changeset attached | => SymmetricDS 3.9 173081d5 |
| 2018-05-08 20:09 | mmichalek | Status | resolved => closed |