Clarity

  • Private Community
 View Only

  • 1.  Missing Trending table - possibility to recreate them

    Posted Apr 07, 2020 07:06 AM
      |   view attached
    Hello,
    we were using trending with PPM 15.4.1. Last week we upgraded to 15.7.1 and recreated DWH from empty dump attached to install files of PPM.

    We are not able to make the Trending jobs working because of missing tables. Is there any possibility to recreate them?

    I tried following:
    1. disable attributes for trending
    2. run Load Data Warehouse as full load
    3. enable attributes for trending
    4. run load data warehouse as full load

    but it did not help.

    Could you please help me with this?

    Thank you in advance,
    Martin

    PS: we do not have backup of old DWH schema available

    Attachment(s)

    txt
    trending_error.txt   91 KB 1 version


  • 2.  RE: Missing Trending table - possibility to recreate them
    Best Answer

    Broadcom Employee
    Posted Apr 07, 2020 07:17 AM

    Hi Martin

    If you dont have backup of DWH you will not be able to get trending at all. This is the reason we say not to re import blank DWH if you are using trending




    ------------------------------
    Thanks & Regards
    Suman Pramanik
    Sr. Principal Support Engineer | Customer Success & Support, Enterprise Software Division
    Broadcom
    ------------------------------

    Original Message


  • 3.  RE: Missing Trending table - possibility to recreate them

    Posted Apr 14, 2020 07:48 AM
    Hello Suman,
    thank you for your answer. I solved it by taking a backup from a different (UAT) environment and reimporting it to DEV where we had the issue.
    Thank you and Regards,
    Martin
    Original Message