nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Oracle Communities

Oracle AI and Analytics

Child Item

OBIEE 12.2.1.3 analysis error

Joe_obieeoas

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.

Find more posts tagged with

Accepted answers

All comments

Joe_obieeoas

Hi Gurus,

Any update on this please..

Thanks.

[Deleted User]

https://community.oracle.com/tech/apps-infra/discussion/4503461/obiee-12-2-1-3-analysis-error

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

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]

https://community.oracle.com/tech/apps-infra/discussion/comment/16847206#Comment_16847206

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

Hi Chris,

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

Thanks.

Gianni Ceresa

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

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]

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.

Upcoming Event

AI Data Platform - Creating High Code Agents and Using Developer Tools in AI Data Platform
Explore how to build agents using code in AI Data Platform. We'll create an agent that examines and analyzes the contents of a Github repository and reports its findings. The session demonstrates how to use different developer tools to create agents including the AIDP extension for VS Code and Codex. Using these tools we…

Top Leaders

Mallikarjuna Kuppauru-Oracle 80