Results 1 to 1 of 1
  1. #1
    Join Date
    May 2003

    Unanswered: OLAP summary advisor problem

    Seems like a strange problem, no google results I found...
    The summary advisor throws a java.lang.NumberFormatException whenever I try to run it. I tried to do it trough the pl/sql procedures (DBMS_OLAP.RECOMMEND_MVIEW_STRATEGY) and the result is the same (sorry for the spanish):
    ERROR en línea 1:
    ORA-29532: llamada Java terminada por una excepción Java no resuelta:
    java.lang.NumberFormatException: ,02
    ORA-06512: en "SYS.DBMS_SUMADVISOR", línea 1101
    ORA-06512: en "SYS.DBMS_SUMMARY", línea 96
    ORA-06512: en línea 9

    It even throws the exception when I only call DBMS_OLAP.CREATE_ID...

    I have Olap Services Running, all the involved tables are analyzed, does not work even for the sample cubes...
    It's oracle 9i, for windows. I installed a second oracle in my laptop, and got the same results...

    I'm lost, right now... any clue?
    Last edited by luisdom; 05-12-03 at 04:14.

Posting Permissions

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