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_messageMS 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.