Uploaded image for project: 'OpenIDM'
  1. OpenIDM
  2. OPENIDM-14044

Oracle relationship query identifiers too long.

    Details

    • Target Version/s:
    • Verified Version/s:
    • Story Points:
      3
    • Sprint:
      2019.15 - IDM

      Description

      Earlier versions of Oracle have restrictions on the length of aliases that can be used to reference any identifier.

      IDM currently fails to start on oracle versions 12.1 or less.  Runs ok on 12.2+

       

      On startup the failed SQL looks like this:

      SELECT
      	innerObj.fullobject,
      	innerObj.objectid,
      	innerObj.rev,
      	innerObj.s_0,
      	innerObj.s_1
      FROM
      	(
      	SELECT
      		obj.fullobject AS fullobject,
      		obj.objectid AS objectid,
      		obj.rev AS rev,
      		orderby0propgenericobjectproperties.propvalue AS s_0,
      		obj.objectid AS s_1,
      		ROW_NUMBER() OVER (
      	ORDER BY
      		orderby0propgenericobjectproperties.propvalue ASC,
      		obj.objectid ASC ) rn
      	FROM
      		openidm.genericobjects obj
      	INNER JOIN openidm.objecttypes objobjecttypes ON
      		((obj.objecttypes_id = objobjecttypes.id)
      		AND (objobjecttypes.objecttype = 'reconprogressstate'))
      	LEFT OUTER JOIN openidm.genericobjectproperties orderby0propgenericobjectproperties ON
      		((orderby0propgenericobjectproperties.genericobjects_id = obj.id)
      		AND (orderby0propgenericobjectproperties.propkey = '/startTime'))
      	WHERE
      		1 = 1
      	ORDER BY
      		s_0 ASC,
      		s_1 ASC ) innerObj
      WHERE
      	rn BETWEEN ('0' + 1) AND ('0' + '2147483647') 

      Note that "orderby0propgenericobjectproperties" is too long.

       

       

        Attachments

          Activity

            People

            • Assignee:
              jason.vincent jason vincent
              Reporter:
              jason.vincent jason vincent
            • Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: