nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

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

Vind meer berichten getagd met

Accepted answers

Anonymous User

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

All comments

Anonymous User

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

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;

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

Doe mee aan het gesprek

Aangemelde leden kunnen berichten plaatsen, updates volgen en meer. Nieuw hier? Registreer een gratis account.

Snelle Links

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.