Category Archives: Berry van den Heuvel

October 20, 2015   Berry van den Heuvel

The Level has a primary key whose columns are variable based

Problem: Model Check Error No. 38160

Screenshot;

Level has a primary key whose columns are variable based. Aggregate Persistence will not be able to create any aggregates at this level

Screenshot text:

[38160] The Level [BUSINESS MODEL].[HIERARCHY].[LEVEL] has a primary key whose columns are variable based. Aggregate Persistence will not be able to create any aggregates at this level.

Possible solution:

  • open Logical Table Source

Level has a primary key whose columns are variable based. Aggregate Persistence will not be able to create any aggregates at this level 2

  • click Content
  • remove WHERE clause
  • click OK
  • check model

The Model Error is gone

Twitt

Het bericht The Level has a primary key whose columns are variable based verscheen eerst op OBIEE 24/7 | Oracle Business Intelligence.

Read More
October 20, 2015   Berry van den Heuvel

Start commands

Start Node manager (press enter after appending output …);

nohup /u01/app/oracle/fmw/wlserver_10.3/server/bin/startNodeManager.sh &

Start Weblogic server (press enter after appending output …);

nohup /u01/app/oracle/fmw/user_projects/domains/bifoundation_domain/startWebLogic.sh &

Run the command

tail -f nohup.out

Wait until the message  UNTIL this message appears;

<WebLogicServer> <BEA-000360> <Server started in RUNNING mode>

Press CTRL+C to quit tail

Start Managed server (press enter after appending output …);

nohup /u01/app/oracle/fmw/user_projects/domains/bifoundation_domain/bin/startManagedWebLogic.sh bi_server1 &

Start Oracle BI processes;

/u01/app/oracle/fmw/instances/instance1/bin/opmnctl startall

Follow the steps in Stop commands to stop everything

Twitt

Het bericht Start commands verscheen eerst op OBIEE 24/7 | Oracle Business Intelligence.

Read More
October 19, 2015   Berry van den Heuvel

Stop commands

Stop Oracle BI processes;

/u01/app/oracle/fmw/instances/instance1/bin/opmnctl stopall

Stop Managed server;

/u01/app/oracle/fmw/user_projects/domains/bifoundation_domain/bin/stopManagedWebLogic.sh bi_server1

Stop Weblogic server;

/u01/app/oracle/fmw/user_projects/domains/bifoundation_domain/bin/stopWebLogic.sh

Stop Node manager;

ps -ef | grep fmw
kill -9 running processes:
/u01/app/oracle/fmw/wlserver_10.3/server/bin/startNodeManager.sh
/u01/app/oracle/fmw/jrockit_160_29_D1.2.0-10/bin/java -jrockit .....

Follow the steps in Start commands to start everything

Twitt

Het bericht Stop commands verscheen eerst op OBIEE 24/7 | Oracle Business Intelligence.

Read More
July 15, 2015   Berry van den Heuvel

Invalid Subject Area

Problem: Message Invalid Subject Area when editing column formula

Screenshot:

Edit Column Formula

Screenshot text:

Invalid Subject Area

The selected request cannot be performed because it references an unknown subject area named [NAME].

Solution:

  • close Edit Column Formula tab
  • select Advanced tab

Advanced2

  • enter the name of the right Subject Area
  • click Apply SQL

Advanced SQL Clauses

  • click Criteria tab
  • edit column

Edit Column Formula2

The message is gone. Now you can select objects from the subject area.

Twitt

Het bericht Invalid Subject Area verscheen eerst op OBIEE 24/7 | Oracle Business Intelligence.

Read More
July 15, 2015   Berry van den Heuvel

Kill running queries

To kill running queries, follow these steps;

  • open rpd in online mode
  • click Manage
  • click Manage Sessions

Session Manager

  • select Session in upper section
  • select Request in lower section
  • click Kill request
Twitt

Het bericht Kill running queries verscheen eerst op OBIEE 24/7 | Oracle Business Intelligence.

Read More
« Older posts
Newer posts »