Hitachi Vantara Pentaho Community Forums
Results 1 to 4 of 4

Thread: Error in log "ERROR BatchLoader$Batch:1432 - AggGen failed"

  1. #1
    Join Date
    Aug 2016
    Posts
    290

    Default Error in log "ERROR BatchLoader$Batch:1432 - AggGen failed"

    Everytime Mondrian is queried about a fact table, the following message is logged:

    WARN AggGen:279 - Init: For fact table "FACT_IP_ADDRESS", could not get column name for RolapStar.Column: Fact Count (22): count(null)
    ERROR BatchLoader$Batch:1432 - AggGen failed

    Why is this the case?

    The database tables do not have a column named "FACT_COUNT", instead they have a column named "VALUE".

    How to resolve this problem? Everything seems to work fine, but the error continues to be logged.
    Last edited by Sparkles; 10-03-2016 at 09:51 AM.

  2. #2
    Join Date
    Mar 2017
    Posts
    5

    Default

    I'm suffering from same problem..
    if you solved them, could you let me know how solved?
    thank you in advance..T^T

  3. #3
    Join Date
    Aug 2016
    Posts
    290

    Default

    Found no solution or support to the problem. Scrapped entire Mondrian OLAP server and replaced with Microsoft's SSAS. That was how I solved it.

  4. #4
    Join Date
    Apr 2008
    Posts
    4,696

    Default

    You need to have a count of the facts to be able to work out things like averages.

    Think for a moment that you have facts:
    Dim1 | Dim2 | Fact | Unique
    1 | 1 | 1 | 1
    1 | 1 | 1 | 2
    1 | 1 | 1 | 3

    When you aggregate it, you get:
    Dim1 | Dim2 | Value
    1 | 1 | 3

    So... What's the average? Is this total of 3 better than a block that has a value of 8?
    What if the AGG table looks like:
    Dim1 | Dim2 | Value | Fact_Count
    1 | 1 | 3 | 3
    1 | 2 | 8 | 16

    Now what information can you determine?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Privacy Policy | Legal Notices | Safe Harbor Privacy Policy

Copyright © 2005 - 2019 Hitachi Vantara Corporation. All Rights Reserved.