tag:blogger.com,1999:blog-3676448.post4269808064505661148..comments2023-06-17T12:47:19.240+01:00Comments on Subclassed: Oracle Hyperion EPM 11.2 - first impressionstoyghttp://www.blogger.com/profile/04499664589774142384noreply@blogger.comBlogger8125tag:blogger.com,1999:blog-3676448.post-31799793989542907852020-01-20T08:05:44.076+00:002020-01-20T08:05:44.076+00:00Hi Giacomo,
I would agree with most of your commen...Hi Giacomo,<br />I would agree with most of your comments too, except I have not deployed on Oracle DB, only on SQL server 2016, RCU with one DB, standard EPM DBs for the products, that all worked, even changing DB config for foundation to a different SQL db owner user worked too.<br /><br />I have carried out migration for the common EPM products from 11.1.2.4 (latest patches), all worked, HSS, HFM, FDMEE, Planning, Essbase, CalcMan. I followed the documented steps partly but also used HFMcopyapp followed by running the HFMapplicationUpgrade.exe (fine). For Essbase apps I used Copy App in EAS, for Planning apps I used LCM for everything. <br /><br />The main confusions I found was around getting WL admin server to deploy workspace with foundation, as this did not work until after I had OHS configured.<br /><br />Also I find as you said, the documentation is ambiguous about how RCU has to be used in a multi-server environment, because if you have to run RCU on each server (it says), surely you cannot re-create those WL databases for each machine with EPM components. Once those schemas are created, you could only perhaps point the other servers at those WL DBs (can you?) I deployed on a single VM with SQL separate.<br /><br />Another issue I had was after installing/running EAS console and Essbase studio (having changed the files to use Java8, as per readme's), the old java JRE6 deployed itself and messed up running standard start / setenv / config tool scripts, as the setJavaRuntime.bat (provided by oracle) then picked up that java JRE 1.6.0 on the system. I had to edit the .bat to force java8 for everything.<br /><br />rgds,<br />KarinKarin Aungernoreply@blogger.comtag:blogger.com,1999:blog-3676448.post-54069024524969654422020-01-15T07:10:15.598+00:002020-01-15T07:10:15.598+00:00Hi,
If you have prepared prerequisites for HFM an...Hi,<br /><br />If you have prepared prerequisites for HFM and SQL database installation in windows server, please provide me the prerequisites to babji.mba@gmail.com<br /><br />Appreciate your help, thanks in advance.<br /><br />Regards,<br />Bharath KumarReddyhttps://www.blogger.com/profile/01351768697821481763noreply@blogger.comtag:blogger.com,1999:blog-3676448.post-15602906568698812622020-01-13T20:52:53.197+00:002020-01-13T20:52:53.197+00:00It worked, this time the WLS deployment finished s...It worked, this time the WLS deployment finished successfully (using SQLServer Express 2017 in compatibility mode 2016). Thanks for your insights.<br />FranciscoFrancisco Fernandez Burgoshttps://www.linkedin.com/in/ffernandezburgos/noreply@blogger.comtag:blogger.com,1999:blog-3676448.post-84499037403889539922020-01-13T18:15:52.618+00:002020-01-13T18:15:52.618+00:00Good point, thank you Giacomo. That is probably th...Good point, thank you Giacomo. That is probably the issue: the WLS domain folder was first created without any previous RCU DB, then later I created the RCU DB and retried the WLS deployment but it keep failing, due too somehow the WLS domain folder was incorrect. I'll recheck again deleting that folder and recreating a new RCU DB before re-running the EPM config tool. Cheers. FranciscoFrancisco Fernandez Burgoshttps://www.linkedin.com/in/ffernandezburgos/noreply@blogger.comtag:blogger.com,1999:blog-3676448.post-86549408209469342852020-01-13T15:45:53.855+00:002020-01-13T15:45:53.855+00:00@Francisco another thing to remember is that you n...@Francisco another thing to remember is that you need to delete your Weblogic domain folder if you run the configtool after changing RCU properties, since those details are read only when that folder is created; and that failed deployments might edit your RCU database in ways that prevent redeployment - so you'll have to get familiar with backing up and reverting that db...toyghttps://www.blogger.com/profile/04499664589774142384noreply@blogger.comtag:blogger.com,1999:blog-3676448.post-80474119222324447982020-01-13T15:42:09.787+00:002020-01-13T15:42:09.787+00:00@Francisco:
For SQLServer (Express or otherwise) ...@Francisco:<br /><br />For SQLServer (Express or otherwise) you need to have at least two databases - one for the traditional EPM products (or more than one, in production setups) and one for RCU. This way you can have separate collation settings, and both RCU and Configtool are happy. Note that these databases can live on the same SQLServer instance, of course. <br /><br />Btw, RCU should never be pointed at the EPM databases - the structures it creates are simply meant to hold metadata stuff about the Weblogic domain, which can live separately. This mirrors what happens with Oracle, where RCU creates its own schemas that will live alongside any EPM ones.<br /><br />@ Corrado:<br /><br />Great to hear from you, been a long time! I've not had a chance to test migrations yet - I don't have any up-to-date and realistic HFM application, and typically that's where you see issues. The official position is likely to remain that everything has to be rebuilt or reimported via LCM. I noticed that Planning (and only Planning) is supposed to be LCM-compatible with 11.1.2.4 (as per official matrix), which to me suggests Essbase should also be easy enough; I expect the good old FR import/export might also work. I've not checked HFM, just noticed the "upgrade" option in configtool has gone.toyghttps://www.blogger.com/profile/04499664589774142384noreply@blogger.comtag:blogger.com,1999:blog-3676448.post-58974782004200945212020-01-13T13:52:04.616+00:002020-01-13T13:52:04.616+00:00Hi Giacomo, thanks for your post & feedback. I...Hi Giacomo, thanks for your post & feedback. I agree with most of your comments. <br />I've been also "playing" with 11.2 and was able to deploy a working environment using Oracle 12c, however, using SQL Server Express 2017 I was not able to complete the WLS deployment (it always fails), even after creating the EPM112_RCU database with RCU tool. <br />The documentation steps when using SQL Server is not clear at all or at least I was not able find the way.<br /><br />May I ask you whether you used the RCU for creating (populating) the standard DBs? (I mean, once created the DBs at SQLServer did you run the RCU over them - selecting the WLS and the other AS Common Schemas- for creating the HSS, HFM, PLNSYS, etc databases?)<br /><br />The problem I saw was that while running the RCU with these "standards" DB it is require the collation: LATIN1_GENERAL_CS_AS, however this collation is not accepted when configuring them via Config tool (since SQL_Latin1_General_CP1_CI_AS is required).<br /><br />Anyway I'll create an SR but any hint on this from your side is highly appreciated.<br /><br />Thanks,<br />Francisco Francisco Fernandez Burgoshttp://www.linkedin.com/in/ffernandezburgosnoreply@blogger.comtag:blogger.com,1999:blog-3676448.post-54393096799930677122020-01-13T07:04:16.864+00:002020-01-13T07:04:16.864+00:00Ciao Giacomo, bello leggerti.
Stiamo facendo test ...Ciao Giacomo, bello leggerti.<br />Stiamo facendo test anche noi, con speciale focus alle migrazioni. Sembra tutto molto piĆ¹ complicato, peggio forse della 11.1.2.0. Avete fatto qualcosa anche voi? A presto. Ciao. Corrado.<br />ENG: Hi Giacomo, nice to read you again.<br />We are performing some tests, particularly on the migrations from previous version. Did you do something similar as well? Any findings? Thanks. Corrado. Corradohttps://www.blogger.com/profile/10066444876372479849noreply@blogger.com