Header Ads

  • Recent Posts

    Release Label "x" of the current Database is incompatible with loaded System Data for Release "x" (218,122) Load correct set of Setup manager System Data before continuing.

    Problem:
    After installation of PeopleSoft HCM 9.1 with tools 8.50, on traversing to the navigation:
    PeopleTools > Setup Manager > Manage Implementation Projects, the below error message is encountered.

    Release Label "HRMS and Campus Solutions 9.10.00" of the current Database is incompatible with loaded System Data for Release "HRMS and Campus Solutions 8.90.00" (218,122)

    Load correct set of Setup manager System Data before continuing.


    Cause:
    If there is a mismatch of current database release label and system data release label then the above message gets triggered irrespective of the application release and tools version.


    In this above message,
    • System Data Release label is - HRMS and Campus Solutions 8.90.00.000
    • Current Database Release label is - HRMS and Campus Solutions 9.10.00.000


    System Data Release label is stored in the table PS_PTLT_INSTALL(Table for Setup Manager - Installation) and field RELEASELABEL.
    In the same table PS_PTLT_INSTALL the field PTLT_PK_ACTIVITY says "V2 UPGRADE COMPLETE" which is good.

    Current Database Release label is stored in the table Release Table - PSRELEASE and can be accessed from the below SQL Query.
    SELECT RELEASELABEL FROM PSRELEASE WHERE RELEASEDTTM = (SELECT MAX(RELEASEDTTM) FROM PSRELEASE)


    Solution:
    To fix this issue, run the below SQL after backing up the PS_PTLT_INSTALL table and then issue commit.
    UPDATE PS_PTLT_INSTALL SET RELEASELABEL =
    ( SELECT RELEASELABEL FROM PSRELEASE WHERE RELEASEDTTM = (SELECT MAX(RELEASEDTTM) FROM PSRELEASE) )

    No comments

    Please refrain for marketing messages and unnecessary back links.

    Post Top Ad

    Post Bottom Ad