Upgrading from FootPrints 10 to 11 Linux MYSQL

Version 1
    Share This:

    This document contains official content from the BMC Software Knowledge Base. It is automatically updated when the knowledge article is modified.


    PRODUCT:

    FootPrints


    APPLIES TO:

    FootPrints 10.x - 11.x



    PROBLEM:

    You may receive the following error while upgrading from footprints 10 to 11.6.xx:-

    Could not execute SQL (ALTER TABLE MASTER1_IssueActivityFact ADD CONSTRAINT MASTER1_IssActFact_FK_Iss FOREIGN KEY (mrID) REFERENCES MASTER1 (mrID)): Can't create table `Footprints_2`.`#sql-677_a` (errno: 150 "Foreign key constraint is incorrectly formed") 2019-01-30 14:16:47  |  

     


    CAUSE:

    This issue occurs if upgrade is performed from FootPrints 10 to 11.6.xx


    SOLUTION:

    There are lots of database procedure and table changes after version 11.5.1 .
    Do not upgrade directly from FootPrints 10.x to 11.6.x

    First upgrade FootPrints 10.x to FootPrints 11.5.1

     


    Article Number:

    000165259


    Article Type:

    Solutions to a Product Problem



      Looking for additional information?    Search BMC Support  or  Browse Knowledge Articles