An ORA-xxxxx error is not an OBIEE error but an Oracle database error. So if you at least want some hints you will need to be a bit more explicit and post some infos on the relative DB and at least look what kind of physical query OBIEE generated and compare it with the one generated on the other environments to identify…

Do you have the main one located at <your ORACLE_HOME>/bi/modules/oracle.bi.migration/scripts/migration-tool.sh? As I posted above the file you look for doesn't contain a lot, so as long as you have the main script just create the missing migration-tool.sh yourself with the content I posted above and give it a try ...

I don't have an AIX around, but I find it super weird that when you install OBIEE 11.1.1.7 you get the client of 11.1.1.9 inside, mainly because 11.1.1.9 didn't existed when the installer of 11.1.1.7 was created .... As 11.1.1.7 is old only 11.1.1.9 is available on the site online. Don't you maybe have multiple catalog…

Never ever mix versions! 11.1.1.9 is looking for the v10 of the WSDL while your OBIEE server only has 6, 7 or maybe 8 available. Catalog Manager is installed with the Admintool, the installer is available as link in the OBIEE homepage itself (the installer is stored locally in your OBIEE install, you can also find it there…

Well ... I assume it's worth to triple check the URL (the http:// in front, the saw.dll at the end, nothing before, nothing after and everything else in between). If OBIEE is installed and working there is no reason for catalog manager to not work as it's mainly does webservices calls to the server (in online mode). The…

Do you have some SSO in place or something like that?

What URL did you enter in the connection screen? What's the URL you use in your browser to connect to OBIEE from the host on which you have the issue with Catalog Manager?

When you are pissed to lose joins all the time you get creative

You can import offline as you can do it online. It all depends on your host where the Admintool is running as it's the one connection to the DB and doing the job (and not the server). Did you try the import? What happened? If the question is more "can you update the existing table", in case you start having weird things or…

3547198 wrote:Thanks for the reply. In my case, all the columns are coming from one dimension table. May be I have to separate them into different logical fact and dim tables and then create the level based measure. Remove the "maybe". The logical model is supposed to be a real model, a start schema. If all the columns…

Hi, Google is often helpful too .... First result is a reference to a thread here on OTN: Can anyone explain, crawlersys.lck on Web Catalog? Which ask the same thing and provide an answer. The filename "crawler" is a reference to a crawler parsing and indexing thing. So don't copy it and depending the settings on the new…

The key point is: forget the "cloud" cover of OAC, underneath it's at 95% the good (maybe not for everybody) old OBIEE (95% only because there are some new deployment scripts for the cloud side of things, but the core part is still "just" OBIEE). So connect by SSH to your instance and do things by command line there to…

Honestly? I don't remember if I had to change that or not (I did it long time ago once as a test ...). Can't you just look in the filesystem the name of the instance in case it isn't "ssi" ? That's how I generally do things (maybe not the most user friendly way but I know the filesystem never lie).

The alternative was to post him this: and and also remember him there is an internal Oracle rule which says employees aren't supposed to ask questions on public forums. But it's just the same if he would open a SR: they will ask him the logs. I have no problem with somebody posting pieces of logs looking for a solution,…

Hi, in your log you have the following: SQL: SET VARIABLE QUERY_SRC_CD='DashboardPrompt';SELECT MIN("Financials - AP Transactions"."Payables Invoicing Business Unit"."Payables Invoicing Business Unit Name") Looks like the query generating the issue from a dashboard prompt object. One possible option is that you have a…

Honestly you are optimistic ... I could list you many other reasons why the weblogic admin server doesn't start. Many being old reasons strictly weblogic and without any link with OBIEE itself or keystores. So I suggest the OP look at the log first before to edit config files randomly (not saying it didn't fix the issue…

Not wanting to annoy going back to something we discussed yesterday .... but isn't it worth to include security in your migration? (yes, you said you didn't want to look at that now, but ... you see that you have issues with permissions). What's the context of your operation? Is that a one-shot move or you are setting up…

Not really, the calendar view is really simple and just show a calendar without other options where you select 1 date. If you want to have the other options you need to stay on choice list or one of the "standard" types.

Hi, Do you have SampleApp 607? (OBIEE Samples ) There are some examples on how to reload/refresh pieces by javascript somewhere inside the SampleApp. It's done by javascript, so would match what you look for.

Hi, If you set your prompt to also store the selected values in a presentation variable it will just do it by itself. The variable will have all the selected values. So isn't your issue more on "how to use that variable with multiple values" instead of how to capture the multiple values in a variable?