This discussion is archived
3 Replies Latest reply: Dec 6, 2012 10:43 PM by Vasavya Chowdary RSS

Report script error

956939 Newbie
Currently Being Moderated
Getting error while running the report : "The number of Columns in the Report exceed the allowed maximum of [256]".
"
  • 1. Re: Report script error
    TimG Guru
    Currently Being Moderated
    I think that one means exactly what it says, and I don't think there's a way to get around that restriction with a Report Script.

    Could you post your report script (or at least the part relevant to <COLUMN selection)?
  • 2. Re: Report script error
    917588 Newbie
    Currently Being Moderated
    It's a bit likely a excel error :), Is it your report is an excel document?
    if not, maybe you can find line of essbase.properties like
    service.olap.dataQuery.grid.maxColumns=255
    increase the number then restart service and try.
  • 3. Re: Report script error
    Vasavya Chowdary Expert
    Currently Being Moderated
    ACtual error would be

    Internal Error : query is too large and cannot execute
    if its report script which you trigger from EAS
    i guess you can breck the scripts in to 2 or 3 or 4 parts and run them
    like if ur selecting all accounts go one by one and see the diffrence

    or ir excel
    try 914585 solution

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points