Troubleshooting
Problem
Error -937 (USE14) when loading spatial data into a table
Symptom
You may get the following error when loading spatial data into a table even if the SRID does exist in your spatial_references table:
937: User Defined Routine error.
(USE14) - Unknown spatial reference identifier XX.
where, XX is the SRID number.
Cause
The error can occur when the spatial_references table is updated right before the spatial data is to be loaded because the metadata cache of the spatial blade module has not been updated to include the newly added rows.
Diagnosing The Problem
To diagnose the problem, you need to check the spatial_references table to make sure the spatial reference identifier does exist in the table. If it is in the table, it is most likely that the cache of the spatial blade metadata has not been updated.
Resolving The Problem
To update the spatial blade metadata cache, you can run the se_metadatainit() function and re-run the load command:
For example,
execute function se_metadatainit();
Was this topic helpful?
Document Information
Modified date:
06 April 2023
UID
swg21616971