Oracle Analytics Cloud and Server

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Cloud and Server

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

OBIEE 12.2.1.3 analysis error

Received Response
71
Views
8
Comments
Joe_obieeoas
Joe_obieeoas Rank 5 - Community Champion
edited Aug 13, 2024 5:03PM in Oracle Analytics Cloud and Server

Hi Gurus,

when i ran an analysis ended up with this error. Please share any inputs on this.

 [nQSError: 46008] Internal error: File server\Utility\Server\Sort\SUProxyVirtualTable.cpp

screenshot below:


Thanks in advance.

Answers

  • Joe_obieeoas
    Joe_obieeoas Rank 5 - Community Champion

    Hi Gurus,

    Any update on this please..

    Thanks.

  • [Deleted User]
    [Deleted User] Rank 2 - Community Beginner

    Please share pertinent information so people can at least attempt to help you. How is that analysis constructed? What's the data source, what transformations are involved, etc etc

  • Joe_obieeoas
    Joe_obieeoas Rank 5 - Community Champion

    Hi Chris,

    In the analysis "edit" view (in answers), all the columns in criteria are direct columns from subject area (no calculations at answers level), it has 6 filters of which one is having a "TIMESTAMPADD" function and the rest are again simple filters like greater than, is equal to/is in, some date is equal to (a date value) etc.

    Hope this info makes sense.


    Thanks.

  • [Deleted User]
    [Deleted User] Rank 2 - Community Beginner

    And what about the visualization? What kind of viz do you use? When does the error appear? For a specific chart type or a table or a pivot?

  • Joe_obieeoas
    Joe_obieeoas Rank 5 - Community Champion

    Hi Chris,

    Its a simple table visualization. This error appears when i browse the catalog and hit "Open" on this report.

    Thanks.

  • Gianni Ceresa
    Gianni Ceresa Mod

    Did it ever work?

    Does it work when added to a dashboard page (where it maybe already is) or when navigated to (as it maybe it is used)?

    Aren't you just lacking default filters when opening it from the catalog vs. the real usage of the analysis that always filter things based on some values?

  • Joe_obieeoas
    Joe_obieeoas Rank 5 - Community Champion

    Hi Gianni,

    It is not on any dashboard. Its just an analysis in catalog and an agent used to deliver this report. Yesterday it did not got delivered. So we went into catalog and manually tried running and ended up with the error posted in the question.

    Data source is MS SQL Server 2016.


    Thanks

  • [Deleted User]
    [Deleted User] Rank 2 - Community Beginner

    By "when does it happen" I mean - as of which point in the construction? Without seeing the analysis, knowing your data model and the XML, without screenshots and details it's impossible to troubleshoot from here.

    Two simple error tracking choices: Clone the whole thing and test on a copy. Remove one attributes one to see whether it causes the issue. Then go back to the baseline analysis. Repeat with the next one.

    Remove one filter criteria to see whether it causes the issue. Go back to the baseline analysis. Repeat.

    Alternative choice: Try the bottom up approach. Start with a blank analysis. Add ONE attribute. Test it. Add the second attribute. Test it. Repeat until you have the full data set. Then add ONE filter criteria. Test it. Add the second filter criteria. Test it. Repeat. Then - and only then - reconstruct the visualization of the analysis. Your first test must always be whether the data arrives at all in a correct form and format.