Skip to main content
  • EN

Hello,

 

I’m trying to migrate data from a SQL Server 2016 spatial to a ArcSDE on SQL Server 2022. Using ArcGIS Pro 3.2 on same machine. I am using FeatureReader with schema and featureWriter with dynamic writer. 

 

 I don’t get any errors but I get thousands of this warning:

GEODATABASE_SDE Writer: Renamed user attribute 'attribute{109}.name' to 'attribute_109__name' based on format constraints for invalid characters, length, and case

If this waring occure the feature with this schema will not be written to the database, so it should yield an error not warning. 

yield waring on FME version 2023.2

yields none-traceable error in version 2024.1

Anyway I can’t figure out what it means.

 

Any clues?
 

 

The ‘{‘ character is an illegal character and therefore you’re being warned that for it to be written its replaced those characters with ‘_’

I’m assuming your writer is set to automatic. Its probably best to either set it to manual, or clean up your features to be written with an attributekeeper.

It may also be beneficial to look at a dynamic workflow: https://docs.safe.com/fme/html/FME-Form-Documentation/FME-ReadersWriters/!FeatureTypeProperties/workspaces_dynamic_about.htm

Reply


Community Stats

30,149
Posts
114,438
Replies
37,793
Members
Terms & ConditionsCookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.