Gianni Ceresa wrote:The OP is lying as the 2 pages aren't the same. Yep!! I did wonder what drove that comment as the new home is very VA based. We are building up our new 12c environments as we speak and have used css to hide that link as we didn't want users to get confused with where "home" is.

All very fair points Christian. My apologies. For what it's worth, I got a giggle out of this: "Furthermore it is as a result also supposed to be their "profession" - if that word still has any value today." Ain't that the truth!!

Thanks for your response Christian. I have installed and configured OBI using a domain account with admin privs. Unfortunately for this account, there is a possibility that it gets logged off the system and when that happens, OBI is stopped. I attempted to use start.cmd using the local admin account but it only starts up…

Wow... Appreciate you as a poster on here Christian but surely it would have been easier to just answer his or her question (if you know the answer) instead of giving him or her a lecture? It comes across to me like the poster's first language is not English. Maybe they did copy the questions because it was easier than…

Can confirm that this is an issue between our OHS and Application server as I have replicated the error logging directly into the OHS and attempting to create a formula using "CASE (IF)". The error message returned is: Formula syntax is invalid. There was a problem retrieving the response data: Service Temporarily…

A bit more information. This from the ohs.log file straight after attempting to run the case statement. [2018-02-07T10:18:43.8369+11:00] [OHS] [ERROR:32] [OHS-9999] [core.c] [host_id: SERVERNAME] [host_addr: xx.xx.xx.xx] [pid: 5544] [tid: 2308] [user: SYSTEM] [VirtualHost: SERVERNAME.DMZ.INT:4443] ap_proxy: trying POST…

This seems to work if you're making a small change but if you're removing/adding say 5 lines of code, it will give the error I mentioned in the OP.

Looks like I can shut down and restart just the biserver using the WLS console which takes a fraction of the time. Still a few minutes but better than 15. Thanks all, Adam

The first option sorry.

Because I was migrating an 11g environment, I copied the brandingskins folder onto a SAN and then created the deployment.

Worked it out. The answer was that I had to run sync_midtier_db.cmd on both nodes (while the nodeManager was running).

Environment is: Windows 2012 server R2 (64bit) Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production Java 1.8.0_111 EDIT: Another thing I should mention is that I had to rename "simplefan.jar" on both nodes to avoid ONS issues.

Hi guys, Yeah had already considered that luckily. I have just had the DBA drop the schemas via the RCU, recreated them and started the config again when I realised that it was going to fail again due to the following:…

Thanks for your reply Christian, Would you say the best step from here is to get the DBA team to drop the schemas (via the RCU), re-create the schemas and then re-run the config?

Hi Robert, That would definitely be a cleaner solution. In the interest of time, I will be leaving what I have but appreciate your suggestion nevertheless. Asim, In my criteria, I have one query that retrieves the raw data for each branch, product and their debit/credit columns. I have then added a union where I have added…

Worked it out guys... For those with a similar issue, you can use the Filter function instead of the Case function and for some weird reason, it works as intended. The formula I used for my amount measure is as follows: FILTER("Transactions"."Tran Amount - Including Reversals" USING ("Transactions"."Debit Credit" =…

Hi Asim, This is fine but as mentioned, I need the Variance field to remain the last column in the pivot. Robert, Could you please advise how you would do this in the RPD?

Ok so it seems that i'm still missing something. I've simplified it down to one branch to see if I can see what is happening. I start off with this (Note: I have multiplied the Debits by -1 so that they're shown as negatives instead of positives): Branch Product Debit/Credit…

I have already tried your suggestion above but for some reason instead of subtracting one from the other, it adds them together. I have also tried multiplying one by -1 so that when it adds together, it effectively does the subtraction but it still adds the figures together but results in a negative of the value instead of…

Just a thought but could the threads be stuck because OPMN crashed and not the cause of the crash itself? Also, what is your Java Heap Size set to?