Hi,
We have installed OAS 2023 but facing some issues and want to downgrade it to OAS 5.9.
Kindly suggest some steps to downgrade the RPD used in OAS 2023 to OAS 5.9
Thanks & Regards,
Lalit Bisht
You would require to Uninstalling and Reinstalling Oracle Analytics Server:
https://docs.oracle.com/en/middleware/bi/analytics-server/install-config-oas/uninstalling-or-reinstalling-product.html#GUID-3FC6A4E1-4684-4BAC-9760-DA308A114FE7
Hi @User_F707D ,
To downgrade the RPD you can use the nqgenoldverrpd.exe utility of the Model Administration Tool:
nqgenoldverrpd.exe -P RepositoryPassword -I PathToInputRepository -O PathToOutputRepository -V DesiredVersionNumber
The utility can be found in the following location:
%OA_CLIENT_HOME%\domains\bi\bitools\bin
@User_F707D ,
OAS 5.9 is out of support, why would you use that?
In another question you said :
We are doing one upgrade to OAS 2023 for OBIEE 11.1.1.7.0 to OAS 2023
Are you expecting OAS 5.9 to work with BVT? Still no, the tool is gone and wasn't developed for OAS at all.
You should look at fixing the issues, mostly because if you jumped from OBIEE 11.1.1.7 to OAS, there are more than 10 years of evolutions there inside and the tool changed a lot, mostly with RPD where developers took a lot of freedom at modelling things not in the correct way. The new versions got more and more strict and generate queries in a more predictable way (while with 11g it was possible to just be lucky that a weird model started generated the expected query).
Referencing your prior post
https://community.oracle.com/products/oracleanalytics/discussion/20699/bvt-tool-error-for-generating-result-for-oas-2023
Additionally, the starting point to migrate from OBI 11g is 11.1.1.9, not 11.1.1.7 ;-)
About the Starting Points for Migration and Upgrade -> Migrating from Oracle Business Intelligence 11g
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…
What is wrong with this code
Am I missing something or is there no way to search through previous posts to make sure I don't duplicate a question? All I see on the filter options are tags or status… a general search for a word or phrase would be helpful.
We were under the impression that when exporting a visualization in DV to CSV format hidden columns would be include from the grammar panel. This is not happening. See below for a screenshot showing 3 hidden columns that do not appear when exporting the pivot table to CSV. This seems to have worked a month or so back but…
Migrated RPD from obiee12c to OAS 2024. post migration when we try to access dashboards on OAS we are getting below error: State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred. (HY000) State: HY000. Code: 43275. [nQSError: 43275] Message returned from OBIS…
There is no option for legend title in many visualization types.