Select using sdo_cs.transform fails with ORA-13282: failure on initialization of coordinate transformation

(Doc ID 2236799.1)

Last updated on MARCH 17, 2017

Applies to:

Oracle Spatial and Graph - Version 11.2.0.4 and later
Information in this document applies to any platform.

Symptoms

On : 12.1.0.2 version, Query Issues

When attempting to run

select sdo_cs.transform(sdo_cs.make_3d(mdsys.sdo_geometry(2001, 20289921, null, mdsys.sdo_elem_info_array(1, 1, 1), mdsys.sdo_ordinate_array(0, 400000))), 20000151) from dual

the following error occurs.

ERROR
-----------------------
select sdo_cs.transform(sdo_cs.make_3d(mdsys.sdo_geometry(2001, 20289921, null, mdsys.sdo_elem_info_array(1, 1, 1), mdsys.sdo_ordinate_array(0, 400000))), 20000151) from dual

-- Output bij Oracle
--SDO_CS.TRANSFORM(SDO_CS.MAKE_3D(MDSYS.SDO_GEOMETRY(2001,20289921,NULL,MDSYS.SDO_
--------------------------------------------------------------------------------
SDO_GEOMETRY(3001, 20000151, NULL, SDO_ELEM_INFO_ARRAY(1, 1, 1), SDO_ORDINATE_ARRAY(3.15138659, 51.5675296, 44.1344457))
 
--1 row selected.

-- At Gasunie we get the following error message:
ORA-13282: failure on initialization of coordinate transformation
ORA-06512: at "MDSYS.SDO_CS", line 122
ORA-06512: at "MDSYS.SDO_CS", line 172
ORA-06512: at "MDSYS.SDO_CS", line 5726
ORA-06512: at "MDSYS.SDO_CS", line 3140

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms