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

2588
6
Jump to solution
02-16-2017 09:09 AM
MarceloEdy_Peinado
New Contributor II

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

Tags (1)
0 Kudos
1 Solution

Accepted Solutions
by Anonymous User
Not applicable

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


					
				
			
			
				
			
			
				
			
			
				

View solution in original post

6 Replies
by Anonymous User
Not applicable

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
New Contributor II

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

0 Kudos
ManviLather1
Occasional Contributor

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
MVP Regular Contributor
KevinGooss
Occasional Contributor

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?

0 Kudos
Asrujit_SenGupta
MVP Regular Contributor

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;