ArcPad 10 - error 80040E2F: ST_LENGTH(SHAPE)

[SandraSimmert]

Hallo,
we changed our Software and now I have a problem to save Lines and polygons in ArcPad.
Old: Oracle, ArcGIS 9.1, ArcPad 7.1.1
New: PostGres, ArcGIS 10 SP3, ArcPad 10.0.3
I checked out data with the function GetDataForArcPad. Then I opened the axf with ArcPad and draw a line. And when I click on the ok button an error occurred.
[INDENT]Unable to save data due to error 80040E2F: A specified value violated the integrity constraints for a column or table.
The column cannot contain null values. [Column name=ST_LENGTH(SHAPE), Table nameGEWAESSERSEGMENT ][/INDENT]
When I open the axf with ArcPadStudio, there is a new field ST_LENGTH(SHAPE), that can be added to the forms. The hotline told me to add this field and fill it with any value.
For old axf files it works fine, but when I check out new data, the problem is still there.
(We work with a master axf for our cutomized forms. And with every checkout the master ist put on the actual data. We checkout data everyday.)
I hope anyone can help me.

[DeniseKing]

Hi SanSim,

The "Unable to save data due to error 80040E2F" can occur for various data constraints. I have found the best way to try to track down cause of the error is by validating the data in ArcMap prior to exporting to ArcPad project via ArcPad Data Manager.

1 - Open the MXD in ArcMap and Zoom Out to full extent of the data to be validated
2 - Start Editing (Editor toolbar) and Select Features (usually use Select Features by Rectangle tool)
3 - Once all features are selected/highlighted, select Validate Features option from Editor toolbar dropdown options
Results are usually either:
- All features are valid, OR
- Validation of Features failed with additional explanation (ex: The subtype code does not exist. [Lights2] Item not found in this collection.)

When all invalid features have been corrected in database and Validate Features process no longer returns error, this is when you should attempt to export project to ArcPad via ArcPad Data Manager. Be sure that 'Validate feature classes before checking out' checkbox is checked on Get Data For ArcPad - Select Output Options panel. This will also run a feature validation process, yet results are more descriptive and feature specific than Editor's Validate Features process.

If you are current in ArcPad maintenance and need further assistance tracking down the invalid data features, please submit your support issue with Esri Support so you can be connected with an ArcPad specialist.

Thanks,
Denise

[SandraSimmert]

Hallo,
thanks for your answer Denise.
I tested the features and all were valid.

It is a problem with PostGres. The field ST_LENGTH(SHAPE) is not null, but ArcPad is not able to write values in it.
When you set the field properties of ST_LENGTH(SHAPE) in ArcGIS to not visible and GetDataForArcpad with the option 'Only get fields specified as visible in layer's properties', the field will not be in the axf-file. So: no field-no missing value-no problem
When you checkout data on a customized way:
ArcPadExchangeLib.IGetDataForArcPadUIDefaults3.VisibleFieldsOnly = true;

[geogeekgeogeek]

is there any solution using the ArcPad tool box , because i'm using the checkout function and it checks all fields included invisible ones, is there any manner to use arcpad toolbox and avoid this problem of ST_ fields

[ErnestinePhelps]

I followed the steps as recommended below and it resolved my error. I just unchecked the box to make the field ST_LENGTH(SHAPE) not visible. I also made other fields that were not edited by the field crew not visible which cut down on the length of the forms in ArcPad also.



It is a problem with PostGres. The field ST_LENGTH(SHAPE) is not null, but ArcPad is not able to write values in it.
When you set the field properties of ST_LENGTH(SHAPE) in ArcGIS to not visible and GetDataForArcpad with the option 'Only get fields specified as visible in layer's properties', the field will not be in the axf-file. So: no field-no missing value-no problem
When you checkout data on a customized way:
ArcPadExchangeLib.IGetDataForArcPadUIDefaults3.VisibleFieldsOnly = true;

Thanks for posting!