Informix - Problem description
Problem IT33050 | Status: Closed |
LAST RECORD CONTAINS A NULL VALUE FOR THE SPATIAL COLUMN, LOADSHP UTILITY FAILED TO LOAD THE SHAPEFILE | |
product: | |
INFORMIX SERVER / 5725A3900 / C10 - IDS 12.10 | |
Problem description: | |
An issue when loading shapes with the loadshp command. Whenever the last record contains a null value for the spatial column of shapefile. This makes it impossible to load the generated shapefile with the loadshp command. loadshp -o create -l test_avl,geom -f test_avl -D dwh -srid 5 -log /tmp Rejecting rows 941 ... seeing the following errors: -1213: A character to numeric conversion process failed | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * Users of Informix Server prior to 12.10.xC15 and 14.10.xC5. * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to Informix Server 12.10.xC15 (when available) or * * 14.10.xC5. * **************************************************************** As part of this fix we have introduced a new option -fla to ingest the *.dbf files which contains '*' symbols in them in NUMERIC fields. The loadshp utility can be used as below for example: loadshp -o create -l test_avl,geom -f test_avl -D dwh -srid 5 -log /tmp -fla | |
Local Fix: | |
Solution | |
Workaround | |
**************************************************************** * USERS AFFECTED: * * Users of Informix Server prior to 12.10.xC15 and 14.10.xC5. * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to Informix Server 12.10.xC15 (when available) or * * 14.10.xC5. * **************************************************************** As part of this fix we have introduced a new option -fla to ingest the *.dbf files which contains '*' symbols in them in NUMERIC fields. The loadshp utility can be used as below for example: loadshp -o create -l test_avl,geom -f test_avl -D dwh -srid 5 -log /tmp -fla | |
Comment | |
Fixed in Informix Server 12.10.xC15 and 14.10.xC5. | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 02.06.2020 29.12.2020 29.12.2020 |
Problem solved at the following versions (IBM BugInfos) | |
Problem solved according to the fixlist(s) of the following version(s) |