Shape_Length in file geodatabase

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

Page 1 / 1

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

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

Hi,

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

David

Uff. Nothing. Still <Null>.

Have you tried with both the ArcObjects and the File API writer?

David

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_MacroValuese"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 .

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

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?

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.

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.

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

Community Stats

Reply

Community Stats

Sign up

An FME Account is required to contribute

Login to the community

An FME Account is required to contribute

Scanning file for viruses.

This file cannot be downloaded