Skip to Main Content
Forums

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Oracle DB 19c: AVG function and wrong results. Already known BUG, or something else?

S-MaxAug 5 2020 — edited Aug 6 2020

Hi all,

after upgrade from 12c to 19c I have problems with select statements including AVG function.

Without any regularity it brings 0 or correct value, and it is dependent on the place in the select clause and/or selected columns!

If you would like to test this case I have attached 2 files with create table, insert rows, create view and select statements I use.

On the 11g and 12g all select statements are workíng fine!

Anyone any ideas?

Comments

663750
hello Micros,

If you have small project its beneficial to use Single repository

and the main advantage to have a Single repository is the execution speed ,

If you are using multiple rep its difficult to merge them and the speed is very low
631335
Hello Micros

I have made an installation with one BI Server with multiple repositories, served by multiple presentation services, on Oracle Unbreakable R4. It is a little bit tricky but it works.
663712
Can you share how you did it? What was the tricky part?
631335
Answer
I'm going to write a document about this sometime in the future.
Right now these are some basic steps:

1. Deploy a new version of analytics application on OC4J using the analytics.war on $ORACLEBI/web/
2. Edit file $ORACLEBI/oc4j_bi/j2ee/home/applications/analytics_<new>/WEB-INF/web.xml and change value for "oracle.bi.presentation.sawserver.port"to 9711
3. Add new repository on NQSConfig.Ini and restart BI Server
4. Create a new entry on $ORACLEBI/setup/odbc.sh as a copy of AnalyticsWeb, that should point to the new repository
5. Create a new catalog folder on $ORACLEBIDATA/web/catalog
6. Create a new instanceconfig.xml and add <Listener port=”9711″ />after the <DNS .../> entry.
7. On the new instanceconfig.xml change the Catalogpath to point to the new catalog folder created on step 5, and DNS to the one created on step 4
8. Create new scripts to start the sawserver with parameter the complete path to the new instanceconfig.xml.
9. Restart OC4J and BI Server and start the new Presentation Services with the scripts you made.

This is not a complete guide but the outline of the procedure. I 'm planning to make it complete sometime (if I find some free time)
You can also check the following links
[http://www.be-ice.eu/2007/09/11/managing-multiple-presentation-services-on-the-same-unix-box]
[http://bvellinger.blogspot.com/2008/01/obiee-10132-and-multiple-presentation.html]

Giorgio
Marked as Answer by 663712 · Sep 27 2020
663712
Awesome! Thanks
David_T
Wow. After all that, no points for Giorgio?!
667465
Hi Giorgio
Do you have the document, since i have tried almost everything but i am still not able to do it.
Here is the link where i have written all the steps please correct them if you find any mistake or please add steps if in case you find it missing.
link : 3715965

I badly need to try this, because people dont believe that this can be actually done.

thanks
1 - 7

Post Details

Added on Aug 5 2020
#general-database-discussions
11 comments
1,632 views