Hi,
I have a problem while execute a ST_Geometry functions! 😕
The error message is:
ORA-20005: Invalid (NULL) Lob locator (points).
ORA-06512: in "SDE.ST_GEOMETRY_SHAPELIB_PKG", line 325
ORA-06512: in "SDE.ST_GEOMETRY_SHAPELIB_PKG", line 1331
Anyone could help me?
Environment:
ArcGIS 10.4
Oracle: 11.2.0.1.0
OS: Oracle Linux Server release 6.6
Red Hat Enterprise Linux Server release 6.6 (Santiago)
Oracle Linux Server release 6.6
Thanks and regards,
Marcelo Edy Peinado
Environmental Engineer
Optimus GIS & IT Solutions
Solved! Go to Solution.
Dear Marcelo
Can you check if st_geometry has been configured correctly? Can you execute this query:
select sde.ST_AsText(SDE.ST_Geometry('POINT (10 10)', 0)) from dual;
without errors?
Or... did you configured anyway the ST_GEOM_LOG_STORAGE parameter? Take a look at:
ST_Geometry in Oracle—Help | ArcGIS Desktop
Hope this helps
Jesús de Diego
Dear Marcelo
Can you check if st_geometry has been configured correctly? Can you execute this query:
select sde.ST_AsText(SDE.ST_Geometry('POINT (10 10)', 0)) from dual;
without errors?
Or... did you configured anyway the ST_GEOM_LOG_STORAGE parameter? Take a look at:
ST_Geometry in Oracle—Help | ArcGIS Desktop
Hope this helps
Jesús de Diego
Hi Jesús,
Thanks for your assistance!
After create another tablespace and adjust the DBTUNE to store data on LOB_SEGMENT the problem was solved!
Best regards,
Marcelo E. Peinado
Environmental Engineer
Optimus GIS & IT Solutions
I would appreciate if you could have a look at the following BUG:
BUG-000090937
Here is link for reference :
http://support.esri.com/bugs/nimbus/QlVHLTAwMDA5MDkzNw==
Try using the workaround and let me know how it goes:
Use the following filter in SQL queries: WHERE SDE.ST_ISEMPTY(SHAPE) = 0; OR WHERE A.SHAPE.POINTS IS NOT NULL;
I am now seeing this error as well on sde 10.4.1 i believe it is recent that this has cropped up.Any resolutions out there?
BUG-000090937: Invalid (NULL) Lob locator (points) errors are retur..
Yes, as per the details in the Bug, it seems to be an issues since 10.3.1.
Alternate Solution
Use the following filter in SQL queries:
WHERE SDE.ST_ISEMPTY(SHAPE) = 0;
OR
WHERE A.SHAPE.POINTS IS NOT NULL;