Skip to main content
Question

Reading geodatbase error on attribute width

  • June 28, 2018
  • 7 replies
  • 10 views

boubcher
Contributor
Forum|alt.badge.img+11

Hello There

we are reading Geodatabase and writing to PostGIS DB , the DGB reader is showing attribute width with 0 value and when we open it in ArcMap, the same attribute do have 50 value as a width, no idea why FME is not reading the value?

arc Map view

FME geoDB reader

This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.

7 replies

david_r
Celebrity
  • 8394 replies
  • June 28, 2018

Which version of FME and ArcGIS are you running?

For what it's worth, I've never seen this issue before.


takashi
Celebrity
  • 7843 replies
  • June 28, 2018

Do the two screenshots (ArcMap and FME) show the schema of an identical table? Not only data types, but also most attribute names are different. I don't think those illustrate the same table definition.

Repost your screenshots.


boubcher
Contributor
Forum|alt.badge.img+11
  • Author
  • Contributor
  • 212 replies
  • June 28, 2018

@david_r

we are running FME 18 and Arc MAP 10.1


boubcher
Contributor
Forum|alt.badge.img+11
  • Author
  • Contributor
  • 212 replies
  • June 28, 2018

@takashi

Sorry I have done a new print screen for the same data

printarc-issue-read-text-lenght-2.png


boubcher
Contributor
Forum|alt.badge.img+11
  • Author
  • Contributor
  • 212 replies
  • June 28, 2018

Do the two screenshots (ArcMap and FME) show the schema of an identical table? Not only data types, but also most attribute names are different. I don't think those illustrate the same table definition.

Repost your screenshots.

we did find a way to get the with, by reading from source gdb and write to dgb

 

then we take the new gdb and use it as a reader, now all the with the attribute are fixed

 

but during the translation when writing to PostGIS we get this error

 

( Error executing SQL command ('CREATE INDEX "Cadastral_Dataset_Buildings_geom_153019375278" ON "Tansiq"."Cadastral_Dataset_Buildings" USING GIST ("geom")'): 'ERROR: relation "Tansiq.Cadastral_Dataset_Buildings" does not exist

 

')

 

 

 

 

 


boubcher
Contributor
Forum|alt.badge.img+11
  • Author
  • Contributor
  • 212 replies
  • June 28, 2018

Do the two screenshots (ArcMap and FME) show the schema of an identical table? Not only data types, but also most attribute names are different. I don't think those illustrate the same table definition.

Repost your screenshots.

Just for the info we are using a dynamic transformation

 

this is the reader configuration

 

dynamic-config.png

 

 


david_r
Celebrity
  • 8394 replies
  • June 28, 2018
Just for the info we are using a dynamic transformation

 

this is the reader configuration

 

dynamic-config.png

 

 

In your place my first option would be to re-create the reader in a blanc workspace. If that doesn't work, you may have to consider contacting Safe support.