Server Manager - Managing Extensions - Error - Pair INF_TYPE INF_SUB_TYPE must be unique

This page provides assistance when getting the error: “Properties CAST_AvoidLongTableAndColumnNames.avoidLongTableAndColumnNames and CAST_RelatedJpaEntity.jpaname both defines same (INF_TYPE,INF_SUB_TYPE) value.

Pair (INF_TYPE,INF_SUB_TYPE) must be unique.” as shown in the below screenshot:

1. Install JEE 1.2.3 with Spring Data extension which is below version 1.0.3
2. Error during installation

Perform the below actions

1. Generally this problem has been observed at this point only when installing JEE 1.2.3 Functional Release extension with a Spring Data Extension which is below version 1.0.3.  The solution to the issue is to install JEE 1.2.3 with Spring Data 1.0.3 or higher.
2. If you have other cases of this error that is not specifically related to the above issue(s), then run the following query to see if there is a corruption in the MetaModel:
   1.  run the following query on the local database/KB:

   2. SELECT   p.IdProp  AS SHARING_PROPERTY_ID  ,
               p.PropNam AS SHARING_PROPERTY_NAME,
               SHARED_PROPERTIES.INF_TYPE        ,
               SHARED_PROPERTIES.INF_SUB_TYPE    ,
               SHARED_PROPERTIES.SHARING_ORDER
      FROM     (SELECT  it.IntVal  AS INF_TYPE    ,
                        ist.IntVal AS INF_SUB_TYPE,
                        COUNT(1)   AS SHARING_ORDER
               FROM     PropAttr ist
                        JOIN PropAttr it
                        ON       it.IdProp  = ist.IdProp
                        AND      it.AttrNam = 'INF_TYPE'
                        JOIN PropCat pc
                        ON       pc.IdProp = ist.IdProp
                        JOIN Prop p
                        ON       p.IdProp = ist.IdProp
               WHERE    ist.AttrNam       = 'INF_SUB_TYPE'
               GROUP BY it.IntVal, 
                        ist.IntVal
               HAVING   COUNT(1) > 1 
               ) 
               SHARED_PROPERTIES
               JOIN PropAttr ist
               ON       ist.AttrNam = 'INF_SUB_TYPE'
               AND      ist.IntVal  = SHARED_PROPERTIES.INF_SUB_TYPE
               JOIN PropAttr it
               ON       it.IdProp  = ist.IdProp
               AND      it.AttrNam = 'INF_TYPE'
               AND      it.IntVal  = SHARED_PROPERTIES.INF_TYPE
               JOIN PropCat pc
               ON       pc.IdProp = ist.IdProp
               JOIN Prop p
               ON       p.IdProp = ist.IdProp
      ORDER BY SHARED_PROPERTIES.INF_TYPE, 
               SHARED_PROPERTIES.INF_SUB_TYPE;

   3. Then report your problem to CAST Technical Support and provide the following relevant input in addition to the query results and that you followed the steps on this page.   Any results from this query generally confirm corruption in the metamodel.
      1. For CAST Technical Support only please refer to the page to see if this may resolve the issue  - CMS Assessment model - AMT Inconsistency - Information - Fix duplicate categories or types or properties - CAST Internal
3. If you do not find the information you are looking for or solution for your problem, in this page, report your problem to CAST Technical Support and provide the following relevant input