US and Worldwide: +1 (866) 660-7555
Results 1 to 3 of 3

Thread: getting a "No Table found for fact name" message

  1. #1
    Join Date
    Oct 2013
    Posts
    6

    Default getting a "No Table found for fact name" message

    I have inherited the maintenance of a pentaho/mondrian data warehouse. I am trying to add a new cube to the list of cubes and it depends upon a new fact table I have created in oracle. The fact table and the aggregates are present and I have modified the needed xml table for defining the cubes. However when the xml is read/parsed in the pentaho log I get the message "WARN [mondrian.rolap.aggmatcher.AggTableManager] : No Table found for fact name=" and the name of the fact table. I cannot determine what this means. I know that the fact table is indeed present and in the same schema as all the other fact tables. Any suggestions?

    Thanks,
    Steve

  2. #2
    Join Date
    Jan 2013
    Posts
    796

    Default

    Mondrian retrieves the list of tables from the jdbc connection. That warning will be logged if the table name is not in the list retrieved via the metadata call. You've probably already done this, but I'd want to triple check naming and permissions.

  3. #3

    Default

    Hi Team,

    Quote Originally Posted by mcampbell View Post
    Mondrian retrieves the list of tables from the jdbc connection. That warning will be logged if the table name is not in the list retrieved via the metadata call. You've probably already done this, but I'd want to triple check naming and permissions.

    I am also facing the same problem, infact the original post clearly says,


    "The fact table and the aggregates are present"
    "I know that the fact table is indeed present and in the same schema as all the other fact tables."


    I did not find proper response for this question, so posting it again. Hope someone is looking into it as this is very old post (year 2013)


    In my case also, the face table is very well exists (no spelling mistakes).


    Please look at the link below.
    http://forums.pentaho.com/archive/in...p/t-47693.html


    Which says, "One with the dimensions (the fact table) and a one-to-one relationship with the second table that contains the levels" I meant "One with the MEASURES (the fact table) and a one-to-one relationship with the second table that contains the levels"


    Even tried this, but same error


    07 Mar 2017 11:12:54,946 WARN [Session ] mondrian.recorder.AbstractRecorder#logMessage: : No Table found for fact name=trendday_old


    Other observations:
    1. If I keep only measures, there are no issues. Mondrian is able to fetch the meta data for measures.
    2. I tired the exact schema with MY SQL, interestingly it is working fine for both dimensions and measures. But for MS SQL it is not able to identify the fact table. For me it looks like a bug, or we have define the xml file for cube definition in some different way (not sure), please help.


    Regards
    Vishwanath
    Last edited by vishwanathbk; 03-07-2017 at 01:35 AM.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •