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.
Any update on this please..
Thanks.
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
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.
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?
Its a simple table visualization. This error appears when i browse the catalog and hit "Open" on this report.
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?
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
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.
Description: Join our Product Management team to learn about new features that are part of 26.R3 Application release of Fusion Data Intelligence (ERP). The session will cover updates on Finance, Projects, and Procurement. Presented by: Ashlesh Bajpai - Vice President, Product Management, Fusion Data Intelligence Shobana…
I scheduled the report in OTBI and the agent was run successfully. However, I do not receive the report after the run in my inbox. The addresses are properly recorded, and the report is in an excel format and saved as a pivot table in otbi. What can be the cause?
Anyone has any idea why the OAC documentation on custom viz is not available now? I was able to access till last week - https://docs.oracle.com/en/cloud/paas/analytics-cloud/acsdv/build-package-extension.html. Does this mean OAC doesnt support custom viz or custom workbook extensions?
Does Oracle Analytics Server 2026 include AI features such as a built-in chatbot or AI Assistant? If not, are there any plans or indications that these AI capabilities will be introduced in a future OAS release?
Here is my calculation CAST(COUNT(SAAR_ID) AS VARCHAR(50)) || ' SAARs pending as of: ' || CAST(CURRENT_TIMESTAMP(5) AS VARCHAR(50))
In OAC when I am creating a dataset, How can I pass a Filter from the "Dashboard filters to the SQL? I attached a image like it was don in BIP Publisher
