Skip to main content
Question

error text(2147483647) While writing Lines data

rakeshreddy0996
Forum|alt.badge.img

GEOPACKAGE writer: Creating layer 'roadnetwork_full' with geometry type 'wkb_unknown'

GEOPACKAGE writer: Wrong field type for id

GEOPACKAGE writer: Unable to create attribute 'id' of type 'text(2147483647)' on feature type 'roadnetwork_full'

GEOPACKAGE Writer: In Feature Type 'roadnetwork_full', 'fme_table_handling' has invalid value 'CREATE_IF_MISSING'. Possible values include: 'CREATE_IF_MISSING', 'DROP_CREATE', 'USE_EXISTING'

A fatal error has occurred. Check the logfile above for details

... Last line repeated 2 times ...

GEOPACKAGE writer: Committing transaction of 535 features to feature types 'roadnetwork'...

2 replies

sigtill
Supporter
Forum|alt.badge.img+25
  • sigtillSupporter
  • Supporter
  • October 18, 2019

Try to use a AttributeKeeper and select no attributes before the GeoPackage writer. To see if something gets written. If it works - then there is an error with some of the attributes. Can you supply the inputfiles and the workspace?

The real SigTill
oscarwillems
Contributor
Forum|alt.badge.img+17
  • oscarwillemsContributor
  • Contributor
  • October 19, 2019

It appears that your roadnetowrk_full uses a parameterized (attribute based) fme_table_handling, this contains an error. Or that error gets generated because it can't store your provided id, into the id definition of your writer. By the looks of it it tries to convert your input id number into text, make sure that you use the right datatype and length for the id attribute in your output featuretype.

Reply


Helpful Members This Week

Community Stats

31,725
Posts
120,444
Replies
39,363
Members

Latest FME

Terms & ConditionsCookie settingsAccessibility statement

Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

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