Thank you Christian. Yup, that makes sense. Unfortunately, we did not take a backup of the repository database, and it looks like it made some changes. That's the reason why I am hoping there is another alternative to downgrade. Thanks! Sean

Hi Shams, Yes, after the restart, all services came up. The only thing is I couldn't log into BI anymore. Couldn't access online RPD neither. I just got some instructions from Oracle support. It looks like I need to run some sync command after pointing to the new RCU database. I haven't tried it yet, but it looks…

Thank you Shams. Yeah, I tried that today. Used RCU to create new schema in new database. Changed all connection pools to use the new schema and database. Unfortunately, after stop and restart the services, I could not log into BI any more...even with weblogic username. Not exactly sure what went worng :-( Switched the…

@Joel Acha config.cmd/sh did not work. This can only setup/create for new BI domain. @rmoff It's different schema (prefix). Would that make difference?

Yes, exactly. Thanks!

Joel, I believe BAR file was introduced in 12c. From 11g, you generate a .jar file from the migration tool. Did I miss something? Machiel, Are you only experiencing this after upgrade to 12.2.1.1? It works fine in 12.2.1.0? We had this issue earlier with 12.2.1.0 when our administrator manually imported in RPD and webcat…

Thank you Cesar for pointing me to the direction. I have tried it. Comparing to AGO function, it seems to be much faster. The only thing I need to be careful of is the "order by". I need to make sure I have the right dimensions included in the "order by" clause and they are in the proper order. Thanks, Sean