Do you have any partitioned tables in your data warehouse? Also, just a quick description of your environment ... version numbers, etc. Regards, Charles

Hi 2907462/Babu - If you are still seeing this issue, please reply with some addtional details. You could start with your version number(s). Also, which step, in the load plan, is spending the most time? We would need to narrow this down some to make any progress. If you have taken this to support, kindly close this thread…

Good discussion, all. Here is a pretty good blog that talks about some of this: uksanjay.blogspot.com/2014/11/wid-warehouseid-in-obiee.html Regards, Charles

Hi mmrsherf, One thing, why are you using the 12c client tools? Also, that note is saying to "regenerate" the source files. It is implying that you have already done this before (i.e.. generated them previously). That is why I am asking you what documentation you are following to do this. If you look at the link I…

Hi mmrsherf. You still working on this?

Hi mmrsherf - I'm going to say that they are referring to this: https://docs.oracle.com/cd/E63231_01/doc/BIASA/GUID-8E9904B5-E498-40E7-88BB-6F36B309CF37.htm#BIASA24666 But, so we are all aware, could you post your versions of ODI & OBIA (please include the bi admin tool and catalog manager versions as well)? Also, what…

Hi Gianni, Thanks for the guidance on this. I would have preferred to go manually with this. But, after looking over the RPD I wasn't sure I could get it right this time. So, I decided to experiment a bit. Here's what I did: I went for a 3-way full merge. Basically, I got the original RPD, then made a copy of it. I took…

Thanks very much, Gianni. I'll start working on this ... Regards, Charles

Thanks Gianni. Based on your observation, I am inclined to use the "do it by hand" approach. (depends of course on what you did in the meantime and so what is the real delta between the current RPD and that old one) > It looks like the RPD was trimmed in the very beginning of the project. The delta is enormous ...…

Hi - Can you review the below parameter in your BIACM: My understanding is that this can be set to 0/null. I'd invite further discussion from the group to understand if this is the ideal solution for your issue - 6 seems a bit high. I have mine set at 2 ... and we have some very large tables/indexes. Do you have access to…

Sure, you are welcome. Charles

Hi - One way you could do this is to have a look at the WebLogic LDAP file(s). Specifically, 'DefaultAuthenticator.dat'. This is a text file. You can "export"' the file(s) back to the O/S, from the WebLogic Administration Console. For example, got to: Home >Summary of Security Realms >myrealm > Migration > Export. Provide…

I found out how to do this. The following links apply to OBIA 11.1.1.10.1: https://docs.oracle.com/cd/E63231_01/doc/BIAET/GUID-3101BE58-5639-4F38-AF2B-98358EDBFC41.htm#BIAET-GUID-3101BE58-5639-4F… https://docs.oracle.com/cd/E63231_01/doc/BIAET/GUID-3101BE58-5639-4F38-AF2B-98358EDBFC41.htm#BIAET-GUID-3101BE58-5639-4F……

Update: I did open the 'Data Integrator Console', from the BIACM, and drill into the load plan. But, I was still unable to find any "download" of this data. If anyone has any ideas, please let me know. Thanks, Charles

Hi Mahesh, You will certainly need to make changes from the WebLogic Admin Console. For example, find your data sources for the ODI repository(ies) [Home >bifoundation_domain >Summary of JDBC Data Sources > odiMasterRepository | Home >bifoundation_domain >Summary of JDBC Data Sources >odiWorkRepository]. Locate the…

Hi - Can you see if there is any additional information in the ODI Agent log? /{$MW_HOME}/user_projects/domains/bifoundation_domain/servers/odi_server1/logs/oracledi/odiagent.log Regards, Charles

Hi - I worked on a similar task to replicate our entire OBIA (version 11.1.1.10.1; including ODI) instance to a different server. In this case the target database was already existing, and synched-up with the source database. So, I can't speak to the database portion of your question - I would say to consult your…

Hi - I am not clear on what you are asking. Could you clarify the details of this requirement? Charles

Hi - You can start with this reference: OBIEE 12c: Quick Reference For Architecture, Lifecycle Management and File Locations (Doc ID 2067527.1). I am on 11g, but you're going to need to look at the "managed server" logs for BI. These are located in: $MW_HOME/user_projects/domains/bifoundation_domain/servers/bi_server1/logs…

Hi - We are on 11.1.1.10.1, with an EBS source of 12.2.5 (originally, it was 12.2.3 when we installed OBIA). I didn't do the functional configuration, but we have a value of '999'. I didn't see much on MOS for this, but I did find a link to an Oracle blog from a note:…