topic Re: ORA-20005: Invalid (NULL) Lob locator (points). ORA-06512: "SDE.ST_GEOMETRY_SHAPELIB_PKG", line 325... in ArcGIS Enterprise Questions

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

MarceloEdy_Peinado — Thu, 16 Feb 2017 17:09:47 GMT

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

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

Anonymous User — Mon, 20 Feb 2017 09:43:01 GMT

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

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

ManviLather1 — Tue, 21 Feb 2017 18:29:51 GMT

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;

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

Asrujit_SenGupta — Tue, 21 Feb 2017 18:37:17 GMT

Correct link:

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

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

KevinGooss — Thu, 02 Mar 2017 20:03:59 GMT

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?

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

Asrujit_SenGupta — Thu, 02 Mar 2017 20:09:13 GMT

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;

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

MarceloEdy_Peinado — Thu, 02 Mar 2017 20:40:42 GMT

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