There is no way to transform from the value's spatial reference system to the specified target.

This error can occur when you attempt to call ST_Transform between two spatial reference systems and one or both do not have a TRANSFORM DEFINITION in the SRS definition (specified using a PROJ.4 projection description using the TRANSFORMATION DEFINITION clause of the ALTER SPATIAL REFERENCE SYSTEM statement). You can also get this error while performing a CAST from one SRID to another. You need to add TRANSFORMATION DEFINITION to the SRSs involved. Alternatively, if both SRIDs use the same coordinate system, you can use the ST_SRID method to change a value's SRID without changing the values.