Skip to main content
Question

Shape_Length in file geodatabase

Z
Forum|alt.badge.img
Hi,

 

 

Input data are in fgdb_1. Ouptut data will be in fgdb_2 which is acctually copy of fgdb_1. One of columns (attributes) is Shape_Length with already known values. In my workbench I am doing some string manipulation and populate some another attribute. Output values for this attribute are being populated without any problem as well as others without changes, except Shape_Length attribute which now has value <Null> for all objects. Right before writing output data I inserted Inspector to check If there is still values for Shape_Length, and yes, values are there. But after writing to fgdb they dissappear. Where is a problem, why values for shape_length are lost? Tips? Database overwrite is set to NO, transaction type is transactions, table drop no, table truncate yes, attribute names are the same of course, i don't know..

11 replies

david_r
Evangelist
  • david_rEvangelist
  • May 21, 2013
Hi,

 

 

The shape_length value is usually calculated by the fgdb, so you should't have to specify it yourself. What happens if you remove this attribute before the writer?

 

 

David
Z
Forum|alt.badge.img
  • z77
  • Author
  • May 21, 2013
Ok. I removed it and Shape_Length values are <Null> again...I never had before problems with shape fields. just for information, I use FME2013..
david_r
Evangelist
  • david_rEvangelist
  • May 21, 2013
Hi,

 

 

what happens if you delete the attribute "shape_length" from the Writer altogether?

 

 

David
Z
Forum|alt.badge.img
  • z77
  • Author
  • May 21, 2013
Uff. Nothing. Still <Null>.

 

 

david_r
Evangelist
  • david_rEvangelist
  • May 21, 2013
Have you tried with both the ArcObjects and the File API writer?

 

 

David
Z
Forum|alt.badge.img
  • z77
  • Author
  • May 21, 2013
With API fgdb I got following error:

 

 

"2013-05-21 15:21:18| 61.9| 0.0|STATS |Unexpected Input Remover(TestFactory): Tested 390252 input feature(s) -- 390252 feature(s) passed and 0 feature(s) failed

2013-05-21 15:21:18| 61.9| 0.0|STATS |Unexpected Input Remover Nuker(TeeFactory): Cloned 0 input feature(s) into 0 output feature(s)

2013-05-21 15:21:18| 61.9| 0.0|STATS |Source -> Generic(TeeFactory): Cloned 390252 input feature(s) into 390252 output feature(s)

2013-05-21 15:21:18| 61.9| 0.0|STATS |RiversA (GEODATABASE_FILE_1) Splitter(TeeFactory): Cloned 980 input feature(s) into 0 output feature(s)

2013-05-21 15:21:18| 61.9| 0.0|STATS |RiversL Feature Counter -1 59(TeeFactory): Cloned 389272 input feature(s) into 389272 output feature(s)

2013-05-21 15:21:18| 61.9| 0.0|STATS |ListBuilder_fme_type_remover(TeeFactory): Cloned 389272 input feature(s) into 389272 output feature(s)

2013-05-21 15:21:18| 61.9| 0.0|ERROR |BADNEWS: File C:\\apps\\FME\\metafile\\EvaluateExpression_func.fmf could not be opened (tabrdr.cpp:985)

2013-05-21 15:21:18| 61.9| 0.0|INFORM|Loaded module 'EvaluateExpression_func' from file 'C:\\apps\\FME\\plugins/EvaluateExpression_func.dll'

2013-05-21 15:21:18| 61.9| 0.0|INFORM|FME API version of module 'EvaluateExpression_func' matches current internal version (3.7 20121025)

2013-05-21 15:21:18| 61.9| 0.1|ERROR |BADNEWS: No MULTI_WRITER dataset name was specified (couldn't find a value for `MULTI_WRITER_DATASET') (writrimp.cpp:572)

2013-05-21 15:21:18| 62.0| 0.0|ERROR |BADNEWS: INCLUDE -- failed to evaluate Python script `parms = ["WORKBENCH_DEFLINE_PARMS \\\\"]

if (FME_MacroValues["FMEGEN_DIRECTION"] == "Destination"):

parms.append("\\"GUI CHOICE filegdb_drop_table YES%NO Drop Existing Table\\" \\"NO\\" \\\\")

parms.append("\\"GUI CHOICE filegdb_truncate_table YES%NO Truncate Existing Table\\" \\"NO\\" \\\\")

parms.append("\\"GUI TEXT filegdb_object_id_field Object ID Field\\" \\"OBJECTID\\" \\\\")

parms.append("\\"GUI TEXT filegdb_object_id_alias Object ID Alias\\" \\"OBJECTID\\" \\\\")

parms.append("\\"GUI TEXT filegdb_shape_field Shape Field\\" \\"SHAPE\\" \\\\")

parms.append("\\"GUI TEXT filegdb_shape_alias Shape Alias\\" \\"SHAPE\\" \\\\")

parms.append("\\"GUI TEXT filegdb_config_keyword Configuration Keyword\\" \\"DEFAULTS\\" \\\\")

parms.append("\\"GUI OPTIONAL FLOAT filegdb_xy_tolerance XY Tolerance\\" \\"\\" \\\\")

parms.append("\\"GUI FLOAT filegdb_z_tolerance Z Tolerance\\" \\"0.001\\" \\\\")

else:

parms.append("\\"GUI OPTIONAL TEXT filegdb_where WHERE Clause\\" \\"\\" \\\\")

return parms

' (tabrdr.cpp:1102)

2013-05-21 15:21:18| 62.0| 0.0|INFORM|Trying to find a DYNAMIC plugin for writer named `FILEGDB'

2013-05-21 15:21:18| 62.0| 0.0|INFORM|Loaded module 'FILEGDB' from file 'C:\\apps\\FME\\plugins/FILEGDB.dll'

2013-05-21 15:21:18| 62.0| 0.0|INFORM|FME API version of module 'FILEGDB' matches current internal version (3.7 20121025)

2013-05-21 15:21:18| 62.0| 0.0|INFORM|FME Configuration: No destination coordinate system set

2013-05-21 15:21:18| 62.0| 0.0|INFORM|FME API version of module 'FILEGDB' matches current internal version (3.7 20121025)

2013-05-21 15:21:18| 62.0| 0.0|INFORM|Writer `FILEGDB_1' of type `FILEGDB' using group definition keyword `FILEGDB_1_DEF'

2013-05-21 15:21:18| 62.0| 0.0|INFORM|FME API version of module 'FILEGDB' matches current internal version (3.7 20121025)

2013-05-21 15:21:18| 62.0| 0.0|ERROR |Geodatabase Error (-2147220965): This release of the GeoDatabase is either invalid or out of date.

2013-05-21 15:21:18| 62.0| 0.0|ERROR |Could not open File Geodatabase dataset `C:\\path\\fgdb.gdb' for writing.

2013-05-21 15:21:18| 62.0| 0.0|ERROR |BADNEWS: A fatal error has occurred. Check the logfile above for details (dynawch.cpp:107)

2013-05-21 15:21:18| 62.0| 0.0|ERROR |A fatal error has occurred. Check the logfile above for details

2013-05-21 15:21:18| 62.0| 0.0|ERROR |(fmecloakedwriter.cpp:794) - STFStupidGrouper::initialize(stpdgrpr.cpp:64) - STFWriter::attachGroup - (dynawch.cpp:107)

2013-05-21 15:21:18| 62.0| 0.0|ERROR |A fatal error has occurred. Check the logfile above for details

2013-05-21 15:21:18| 62.0| 0.0|ERROR |BADNEWS: A fatal error has occurred. Check the logfile above for details (multiwch.cpp:770)

2013-05-21 15:21:18| 62.0| 0.0|ERROR |A fatal error has occurred. Check the logfile above for details

2013-05-21 15:21:18| 62.0| 0.0|WARN |Abnormal termination of the Geodatabase reader

2013-05-21 15:21:18| 62.0| 0.0|INFORM|Closing the Geodatabase reader

2013-05-21 15:21:19| 63.4| 1.4|INFORM|=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-

2013-05-21 15:21:19| 63.4| 0.0|INFORM|Feature output statistics for `FILEGDB' writer using keyword `FILEGDB_1':

2013-05-21 15:21:19| 63.4| 0.0|STATS |=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-

2013-05-21 15:21:19| 63.4| 0.0|STATS | Features Written

2013-05-21 15:21:19| 63.4| 0.0|STATS |=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-

2013-05-21 15:21:19| 63.4| 0.0|STATS |==============================================================================

2013-05-21 15:21:19| 63.4| 0.0|STATS |Total Features Written 0

2013-05-21 15:21:19| 63.4| 0.0|STATS |=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-

2013-05-21 15:21:19| 63.4| 0.0|INFORM|Closing the Geodatabase reader

2013-05-21 15:21:19| 63.4| 0.0|ERROR |A fatal error has occurred. Check the logfile above for details

2013-05-21 15:21:19| 63.4| 0.0|ERROR |(stftrans.cpp:288) - (simptran.cpp:749) - (stftrans.cpp:318) - (pipeline.cpp:823) - (fctlist.cpp:326) - (fctlist.cpp:381) - (factory.cpp:1112) - (factory.cpp:1023) - (pipeline.cpp:982) - (pipeline.cpp:723) - (factory.cpp:431) - (fcttee.cpp:283) - (factory.cpp:1023) - (pipeline.cpp:982) - (pipeline.cpp:723) - (factory.cpp:431) - (fcttee.cpp:283) - (factory.cpp:1023) - (pipeline.cpp:982) - (pipeline.cpp:723) - (factory.cpp:431) - (fcttee.cpp:283) - (factory.cpp:1023) - (pipeline.cpp:982) - (pipeline.cpp:723) - (factory.cpp:431) - (fcttee.cpp:283) - (factory.cpp:1023) - (pipeline.cpp:982) - (pipeline.cpp:723) - (factory.cpp:431) - (fcttee.cpp:283) - (factory.cpp:1023) - (pipeline.cpp:982) - (pipeline.cpp:723) - (factory.cpp:431) - (fcttee.cpp:283) - (factory.cpp:1023) - (pipeline.cpp:982) - (pipeline.cpp:723) - (factory.cpp:431) - (fcttest.cpp:477) - (factory.cpp:1112) - (factory.cpp:1023) - (pipeline.cpp:982) - (pipeline.cpp:723) - (factory.cpp:431) - (fcttest.cpp:471) - (factory.cpp:1112) - (factory.cpp:1023) - (pipeline.cpp:982) - (pipeline.cpp:723) - (factory.cpp:431) - (fcttee.cpp:283) - (factory.cpp:1023) - (pipeline.cpp:982) - (pipeline.cpp:723) - (factory.cpp:431) - (fcttee.cpp:283) - (factory.cpp:1023) - (pipeline.cpp:982) - (pipeline.cpp:723) - (factory.cpp:431) - (fcttee.cpp:283) - (factory.cpp:1023) - (pipeline.cpp:982) - (pipeline.cpp:723) - (factory.cpp:431) - (fcttest.cpp:471) - (factory.cpp:1112) - (factory.cpp:1023) - (pipeline.cpp:982) - (pipeline.cpp:723) - (factory.cpp:431) - (fcttee.cpp:283) - (factory.cpp:1023) - (pipeline.cpp:982) - (pipeline.cpp:723) - (factory.cpp:431) - (fcttee.cpp:283) - (factory.cpp:1023) - (pipeline.cpp:982) - (pipeline.cpp:723) - (factory.cpp:431) - (fcttee.cpp:283) - (factory.cpp:1023) - (pipeline.cpp:982) - (pipeline.cpp:723) - (factory.cpp:431) - (fctelem.cpp:726) - (factory.cpp:1112) - (factory.cpp:1023) - (pipeline.cpp:982) - (pipeline.cpp:723) - (factory.cpp:431) - (fcttee.cpp:283) - (factory.cpp:1023) - (pipeline.cpp:982) - (pipeline.cpp:723) - (factory.cpp:431) - (fcttee.cpp:283) - (factory.cpp:1023) - (pipeline.cpp:982) - (pipeline.cpp:723) - (factory.cpp:431) - (fcttee.cpp:283) - (factory.cpp:1023) - (pipeline.cpp:982) - (pipeline.cpp:723) - (factory.cpp:431) - (fcttee.cpp:283) - (factory.cpp:1023) - (pipeline.cpp:982) - (pipeline.cpp:723) - (factory.cpp:431) - (fcttest.cpp:471) - (factory.cpp:1112) - (factory.cpp:1023) - (pipeline.cpp:982) - (pipeline.cpp:732) - (pipeline.cpp:789) - (simptran.cpp:1077) - (multiwch.cpp:770)

2013-05-21 15:21:19| 63.4| 0.0|INFORM|FME Session Duration: 1 minute 5.0 seconds. (CPU: 58.0s user, 5.3s system)

2013-05-21 15:21:19| 63.4| 0.0|INFORM|END - ProcessID: 5800, peak process memory usage: 1441272 kB, current process memory usage: 1423632 kB

 

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

Program Terminating

 

Translation FAILED.

"

 

 

too bad. I apologize for long post. I just wanted to introduce you with error. Admin can delete it .
david_r
Evangelist
  • david_rEvangelist
  • May 21, 2013
Strange error, makes me suspect something's wrong with the database.

 

 

Try writing to an empty File Geodatabase to see if you get the same error.

 

 

David
fmelizard
Contributor
Forum|alt.badge.img+17
  • fmelizardContributor
  • Contributor
  • May 21, 2013
Hi,

 

 

I was wondering why are you using the API gdb writer, it has less capabilities than the ArcObjects writer.

 

As David suggests did you try the ArcObjects writer?
Z
Forum|alt.badge.img
  • z77
  • Author
  • May 21, 2013
Actually, I use ArcObjects fgdb. That was generated error after Davids question whether I use ArcObjects and API. So II used API in this case only to see how it works. :(
Z
Forum|alt.badge.img
  • z77
  • Author
  • May 23, 2013
Hi,

 

 

please could someone try to create one very simple workspace to translate data from one fgdb to another by using ListBuilder and ListExploder and check what happens with Shape_length field. I need this information to check if it has something to do with Lists.

 

Thank you.
Z
Forum|alt.badge.img
  • z77
  • Author
  • May 24, 2013
Hello, It is me again...It seems to be that by using lists, geometry data are lost. I know that there are some transformers which output features do not have geometry. So the same is with lists. I hope Safe Software support will confirm this.

 

Today I find another solution how to accomplish my task instead of using lists. It works well.

 

Thank you for your response.

Reply


Helpful Members This Week

Community Stats

30,908
Posts
117,105
Replies
38,708
Members

Latest FME

Terms & ConditionsCookie settings

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.