Error: "ORA-21500: internal error code, arguments: [%s], [%s], [%s]" when pulling Spatial data from Oracle using Input data tool

[gtorres8]

Environment Details

Using the Input Data tool to connect to an Oracle table that contains spatial data, the following error occurs:

Input Data (1): Error OCIStmtFetch: ORA-21500: internal error code, arguments: [%s], [%s], [%s], [%s], [%s], [%s], [%s], [%s]

• Alteryx Designer
  • All versions
• Oracle database
  • 12c +
  • ST_Geometry data type

 

Cause

• The table containing the spatial data is stored using the ST_Geometry data type.
• Related to an internal Oracle error. For further information on the Oracle error please see Oracle's Metalink Note:49375.1.

Resolution

Workaround

Convert the Table or View to use the SDO_Geometry data type instead and create a new input tool to connect to the new Oracle object. Consult an Oracle DBA for assistance. See the Oracle documentation for more information.

Additional Information

• Oracle's Metalink Note:49375.1
  • (Requires active Oracle support account.)

• Oracle documentation on the SDO_Geometry data type.

 

[KJennings]

Good afternoon,

Has this issue ever been resolved to use the ST_Geometry data type?  Or will this data type be allowed to be used in a pending version?

Thanks,

Kevin Jennings

Kevin.jennings@tdstelecom.com