ORA-20005: Invalid (NULL) Lob locator (points). ORA-06512: "SDE.ST_GEOMETRY_SHAPELIB_PKG", line 325...

[MarceloEdy_Peinado]

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

[Anonymous User · Accepted 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

[MarceloEdy_Peinado]

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

[ManviLather1]

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;

[Asrujit_SenGupta]

Correct link:

BUG-000090937: Invalid (NULL) Lob locator (points) errors are retur.. 

[KevinGooss]

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?

[Asrujit_SenGupta]

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;