Where are you executing BVT? (what environment, OS) If you increase the log level to "FINEST" you will get the details of the IOException that is generating that error.

https://community.oracle.com/tech/apps-infra/discussion/comment/16809998#Comment_16809998 Ok, but did you try to debug the query to find your error? Nobody here has your database to run your query against it and see where the issue is. Decompose all those conditions in small pieces, focus mainly on what tries to convert…

ORA-01843: not a valid month This is a database error, it isn't the BI server complaining, but the database receiving the query doesn't like it. Look at the generated physical query (you posted the logical query), and find the error there. It will lead you to easily fix your LSQL formula once you understand what the…

10-12 GB of free memory and 10 GB Swap Space for run-time requirements What I say is that it isn't like 10+ years ago when RAM was expensive and Swap was a cheap alternative (because being on disk, a slow and cheap device) and so a server was configured with as little RAM as possible and following those specs. Nowadays…

It's is created by the system. If OBIEE create the file, it isn't going to be an issue. OBIEE doesn't go read the file every time you run a query, you aren't going to see a performance impact on that side. As said: it's something fully managed by the system, you shouldn't even be there looking at what is created. Or,…

And what is the issue? If the issue is that a file is created in that folder, why are you even looking there? In OBIEE 12c, the RPD isn't to be placed physically in a given folder on the server. There is a utility to download and upload the RPD and what the server does with it, isn't your business (that's why you paid a…

You don't provide any context or details. What exact product name, version and bundle patch? What's the history of that environment? What did change before the issues started? Anything to let us, not seeing your system, have an idea of what the context is...

What is your OS?

You references a MOS document about 10.1.3.4, let's just say it doesn't apply anymore (please don't tell me you are trying to install that version or another no more supported version). As your sys admins told you, swap isn't for tmp files like the ones mentioned by the MOS document you linked. Swap is used when you run…

What for? You maybe want to provide some context about your question, because right now I don't really see what kind of "smart" reply could be given....

And the context is? Where are you running that? Did it ever work? What did you install in that place to have the "datamodel.sh" file?

By the way: you did open 3 thread for the same exact thing. It's against the forum rules to double post...

Hi, Your question sounds more related to a product different than OBIEE, even if OBIEE is maybe used for the job. You ask about pre-packaged metadata, if you name that product properly it is maybe possible to move this thread in the right place.

That piece of text is stored inside the agent in the catalog. You should find it if you read the XML of the agent. Catalog Manager does have a search & replace option, just keep in mind there isn't an "undo" function: once you did replace something, it's replaced. This means you should take a backup of your backup of your…

That's LSQL, now look at the physical SQL generated by those LSQL statements. Because 2 very similar LSQL can have very different physical SQL generated (that's the real power of Oracle Analytics with the RPD).

There is no magic in DV: everything is a query that retrieve some data. Look at the generated LSQL, look at the generated real SQL and adjust accordingly to fix your error. As it's based on your source and you don't say a word about it, where it is from and how it got there, nothing else can be said.

The easiest dirty solution crossing my mind is ... a virtualmachine 😐️ You could run it on your shared server: if on a desktop OS the Admin tool works fine with your RPD, that could be a workaround. It's not nice, not at all, but at some point there aren't tons of alternatives. Because the server OS isn't certified…

As far as I know no, because the concept of the Admin tool is to be a client tool, not a server tool. Therefore the certification is for clients OS (and not server OS).

That's what a 8 years old version gives you: even MOS updated their document to match newer versions. Still there are various blog posts on the topic. By reading the 12c MOS document you have an idea of what tasks could be involved, with that in mind you can read 2-3 of the blog posts about doing the job on 11g and see if…

There are MOS documents covering this topic, did you search in there? The question is: why do they bother to update their database to 19c but keep using an OBIEE 11.1.1.7, an 8 years old version that heavily require Flash to not look like a webpage of 20 years ago? Time to take updates seriously...