latitude values must be between -90 and 90 degrees

Question

I am using FME to write convert and write CAD data to a SQL dbase which uses the geography data type. I made a copy of this dbase on a new server, (the original server is being phased out). In the same FME file I have a new writer writing to the new dbase on the new server. FME throws a SQL error:

fme_log_previous_message MS SQL Server (Spatial) Writer: Failed to write a feature of type `DBO.DESIGN_Cable' to the database. Provider error `A .NET Framework error occurred during execution of user-defined routine or aggregate "geography": System.FormatException: 24201: Latitude values must be between -90 and 90 degrees.System.FormatException:    at Microsoft.SqlServer.Types.GeographyValidator.ValidatePoint(Double x, Double y, Nullable`1 z, Nullable`1 m)   at Microsoft.SqlServer.Types.Validator.BeginFigure(Double x, D

As I mentioned the new database is a copy of the original so all the setting should be the same. FME is still writing without error to the original database so it shouldnt be the source data. Any help is appreciated.

Answer 1

Do you have the details of the particular row that's throwing the error? It should be relatively easy to catch via the FME inspector or in the logs)

---

twitter: @alastaira blog: http://alastaira.wordpress.com/