Skip to Content

Webi Rich Client: many occurrences of message ORA-00937

Hi,

We have a BOXI 3.1 SP3. The server running over a Red Hat 5.3 in a machine with:

  • 4 GB de RAM
  • 2 GB swap

We using a WebSphere 6.1.0.19.

Almost once a week (and appears to be happening more often now, nearly all the days), a user report us a Webi Rich Client (WRC) problem.

When he refreshes any report, the WRC shows the error: "

Query 1 -

A database error occurred. The database error text is: ORA-00937 not a single-group group function. (WIS 10901)

This error is produced with several universes, but just for this user: we, as support team, can't reproduce the error.

According to notes, this is due to a corruption of the universe; so we used to recommend delete the local corrupted universe and force to reimport the universe. After this, the Webi Rich Client behaviour is correct. But just for a while; next day, the problem apparears again. The user is a important and valuable person in the organization, and he's very "unhappy"

Why are the universes corrupted so often for this specific user? How can we avoid this?

Best regards

ORA-00937.JPG (82.0 kB)
Add a comment
10|10000 characters needed characters exceeded

Related questions

3 Answers

  • Best Answer
    Posted on Dec 02, 2013 at 04:36 PM

    Hi,

    We've been doing a lot of testing with different computers, permissions and users. And the pattern remains.

    What we have found the problem of the SQL query is reported as a ADAPT01537176 error: The 'GROUP BY' statement is missing in the generated SQL statement When creating or editing a WebIntelligence report

    The only option is to upgrade to a higher SP. So I will have to happen to SP5 or SP6

    Thanks everybody

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Nov 05, 2013 at 01:52 PM

    That's really strange. Are you sure the user isn't modifying the SQL in the report? 😊

    Is it possible to have him use WebI Rich Client (WRC) in 3-tier mode so it uses the server instead of local connection to run the query? That maybe help avoid the issue occurring so frequently.

    You may also want to trace his WRC for a short period and review the logs - see if the SQL is changing or if any errors are reported that indicate why this is happening so frequently.

    Is there a back-up or virus scan that is occurring that locks/corrupts the local files while he's working with them?

    Carly

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Nov 05, 2013 at 02:07 PM

    Hi Adolfo,

    The universe which is kept in repository is used by all users; therefore, if the file is corrupt, every user should face this issue.

    Does this user belongs to a specific group? If yes, do other users have similar issue?

    Compare the SQL when error comes with the SQL when the refresh is successful.

    This might help us in narrowing down till any corrupt object or filter in universe.

    Or you can remove objects one by one from the query and check due to which object the issue is coming.

    It seems to be specific to a particular object.

    Also let me know if there is any universe row level restriction.

    Regards,

    Yuvraj

    Add a comment
    10|10000 characters needed characters exceeded

    • Since his end user is using WebI Rich Client, it will download a local copy of the .unv and report off of this.

      It should check the version if connected to the CMS to update if the server copy is updated, but if it has not been updated & the local copy is corrupted, they could potentially run into problems.

      It could also be the local copy of the .wid as well if the SQL stored in the report is somehow changed or corrupted and the user is not importing and overwriting his local copy when running the report.

      Carly

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.