Destination Path too Long error while copying the 7.9.6.4 Catalog

 

Hi All,

After extracting and copying the 7.9.6.4 catalog to catalog folder faced an error like Destination Path too long for the destination folder.

ScreenShot007

Resolution:

Check the check box and click on skip let the process continues.

Now open the two catalog from catalog manager in offline mode.Now copy the files from neatly extracted catalog to our catalog by using catalog manager.

Keep the Catalog path in the Enterprise Manager(EM) and restart the services.

 

 

By bidevatapraveenkumar Posted in OBIEE 11g

BI APPS 7.9.6.4 RPD & Catalog

 

Hi All,

Oracle Business Intelligence Applications 7.9.6.4 is released.We can get the Apps Installer from the below link.

http://www.oracle.com/technetwork/middleware/bi-enterprise-edition/downloads/bi-downloads-1525270.html

BI APPS 7.9.6.4 RPD is shared in the below location.

https://docs.google.com/file/d/0B5hhXh5H6a8CMmlTa0p0WEdnOHM/edit

BI APPS 7.9.6.4 Catalog is shared in the below location.

https://docs.google.com/file/d/0B5hhXh5H6a8CR0FRbDBWTjk3QnM/edit

 

 

 

 

 

 

By bidevatapraveenkumar Posted in OBIEE 11g

Installation of ODI 11.1.1.6 on Windows 64-bit

Hardware and System Configuration Requirements for Oracle Data Integrator:

  • Disk Space: 5GB or more
  • Available Memory: 2GB or more

 

Database Requirements for Oracle Data Integrator:

  • Master Repository: 60 MB of Storage Space
  • Work Repository: 80 MB of Storage Space

System Requirements and Supported Platforms for Oracle Data Integrator:

Step 1: Need to install jdk1.7.0+

Download the jdk1.7.0 from

http://www.oracle.com/technetwork/java/javase/downloads/java-se-jdk-7-download-432154.html

and install the Java in C:\Program Files\Java

Step2: Download the ODI 11.1.1.6 software from

http://www.oracle.com/technetwork/middleware/data-integrator/downloads/index.html

Step3: Unzip the entire software and go to

Disk1\install\win64 and click on setup, it will ask for a JDK location.

Step4: Give the path up to jdk1.7.0 and press enter.

This will open up the Welcome Screen of Oracle Data Integrator.

Skip Repository Configuration and we can create Master and Work Repositories later.

Now we can see the Installation was successful.

Go to Start–>All Programs–>Oracle–>Oracle Data Integrator–>ODI Studio.

It will opens the Starting Page Oracle Data Integrator.

By bidevatapraveenkumar Posted in ODI

Moving View Selector to Left Side in OBIEE 11g

Issue : Need to change View Selector to Left Side from Center.

Resolution :

Need to add

VSelSelector{padding-bottom:2px;text-align:left;}. line in views.css file from the below mentioned paths.

E:\Middleware\Oracle_BI1\bifoundation\web\app\res\s_blafp\b_mozilla_4\rtl\views.css

E:\Middleware\Oracle_BI1\bifoundation\web\app\res\s_blafp\b_mozilla_4\views.css

E:\Middleware\user_projects\domains\bifoundation_domain\servers\bi_server1\tmp\_WL_user\analytics_11.1.1\7dezjl\war\res\s_blafp\b_mozilla_4\rtl\views.css

E:\Middleware\user_projects\domains\bifoundation_domain\servers\bi_server1\tmp\_WL_user\analytics_11.1.1\7dezjl\war\res\s_blafp\b_mozilla_4\views.css

Save the files and restart OPMNCTL then we can see View Selector changes to the Left from center.

By bidevatapraveenkumar Posted in OBIEE 11g

Stream Closed Error when Click on coreapplication in Enterprise Manager in OBIEE 11g

Stream Closed Error when Click on coreapplication in Enterprise Manager in OBIEE 11g:

Recently when I tried to click on coreapplication in Enterprise Manager in OBIEE 11g, I am getting an error like Stream Closed.

Resolution:

Go to the below mentioned path

Middleware\user_projects\domains\bifoundation_domain\sysman\mds\partition1\ai\bi\mdssys\cust\user\weblogic

Here you can find instance.jspx file.

Delete this file and restart all the services then you can resolve this issue.

By bidevatapraveenkumar Posted in OBIEE 11g

Exceeded configured maximum number of allowed output prompts in OBIEE 11g

Error : Exceeded configured maximum number of allowed output prompts, sections, rows in OBIEE 11g.

When we are drilling from main report to detail report we are getting an error like Exceeded configured maximum number of allowed output prompts, sections, rows this is because of huge data in the report.

So in order to resolve this issue we need to add the below mentioned  tags in instanceconfig.xml file which is located under

\Middleware\instances\instance1\config\OracleBIPresentationServicesComponent\coreapplication_obips1

The tags which needs to be added are

By bidevatapraveenkumar Posted in OBIEE 11g

Usage Tracking in OBIEE 11g

Hi All,

While Implementing Usage Tracking in OBIEE 11g,I came to know that the given default RPD and Catalog is a bug in 11.1.1.5.

So updating you all with correct RPD and Catalog for implementing Usage Tracking in OBIEE 11g.

you can get the correct RPD and catalog from here.

https://docs.google.com/open?id=0B5hhXh5H6a8CM09WZXY5czdSckNJTnVscnJLVkk3dw

https://docs.google.com/open?id=0B5hhXh5H6a8COV9OdDIwbWhRQUNrdTlmSnRHNVZxUQ

Step by Step procedure of Implementing Usage Tracking in OBIEE 11g:

Usage Tracking:

Used to monitor system and ad hoc query performance and to provide input on usage details.  Used for determining user queries that are creating performance, based on query frequency and response time.Usage tracking Presentation Catalog provides prebuilt requests and a dashboard built to provide common analysis—for example, analyzing  usage patterns by users, groups, and queries; daily and weekly peak usage patterns and load variance;time series comparisons to help compare current usage over previous weeks or months; and major contention points for troubleshooting, including, for example, top long-running queries.

Before implementing Usage Tracking we need to run the following scripts.

Step 1 :

Create the following sql scripts:

  • Oracle_create_nQ_Calendar—Create table scripts
  • Oracle_create_nQ_Clock—Create Table Scripts
  • Oracle_nQ_Calendar—Insert Scripts
  • Oracle_nQ_Clock—Insert Scripts
  • Also create S_NQ_ACCT table
  • We need to even create NQ_LOGIN_GROUP view also using the following syntax:

CREATE OR REPLACE VIEW nq_login_group AS SELECT DISTINCT user_name AS login, user_name AS resp FROM s_nq_acct;

Grant select on nq_login_group to public;

We can get the scripts from Middleware/instances/instance1/bifoundation/OracleBIServerComponent/coreapplication_obis1/sample/usagetracking/SQL_Server_Time

We can get the S_NQ_ACCT table from

Middleware/instances/instance1/bifoundation/OracleBIServerComponent/coreapplication_obis1/schema

Note : Don’t forget to commit the changes after creating the tables and inserting the data.

Step 2 : We can get the upgraded Usage Tracking RPD and Catalog from the below path after installing OBIEE 11g.

Middleware/instances/instance1/bifoundation/OracleBIServerComponent/coreapplication_obis1/sample/usagetracking/

As mentioned it is a bug so you can get the RPD and Catalog from the above mentioned links.

Step 3 : Upload the RPD and Catalog in the Enterprise Manager (EM) to make it online.

you can get how to upload RPD and Catalog in to EM from https://bidevata.wordpress.com/2011/11/23/how-to-keep-rpd-and-catalog-in-online-mode-in-obiee-11g/

Step 4 : Open the RPD in online mode and change the Usage Tracking Writer Connection Pool settings to your database credentials.

Update the row count and check whether data was populating or not.

Step 5: OBIEE 11g Usage Tracking Server Configuration:

To configure the server configuration parameters, perform the following steps:

a)  Open Middleware\instances\instance1\config\OracleBIServerComponent\

coreapplication_obis1\NQSConfig.ini in Notepad and edit.

b) Next, set the usage tracking options. Scroll to the Usage Tracking section. Set Enable = Yes; to enable usage tracking.

c) In the section that lists parameters used for inserting data into a table, set the

PHYSICAL_TABLE_NAME = “OBI Usage Tracking”.”Catalog”.”dbo”.”S_NQ_ACCT” ; 

d) The table name is the fully qualified name as it appears in the Physical layer of the Server Administration Tool. The general structure of this parameter depends on the type of database being used. For Oracle, the structure is PHYSICAL_TABLE_NAME = “<Database>”.”<Schema>”.”<Table>”.]

e) Set the CONNECTION_POOL parameter to specify the connection pool to use for inserting records into the usage tracking table. The setting is CONNECTION_POOL = “OBI Usage Tracking”.“Usage Tracking Writer Connection Pool”. Leave the default settings for BUFFER_SIZE, BUFFER_TIME_LIMIT_SECONDS, NUM_INSERT_THREADS, and MAX_INSERTS_PER_TRANSACTION. Your configuration file should look like this:

The connection pool name is the fully qualified name as it appears in the Physical layer of the repository.

f)Save and close the NQSConfig.ini configuration file.

Step 6 : Login to analytics http://<hostname&gt;: <port >/analytics/  by using Administrators credentials.

Check the Usage Tracking dashboards .

By bidevatapraveenkumar Posted in OBIEE 11g

BI Publisher shows Blue Page

We recently faced an issue while opening BI Publisher it shows only blue page,the content is not displaying.

Resolution:

Step 1 : : Login to answers page http://<hostname&gt;: <port >/analytics/ by using the credentials.

Step 2 : Go to Administration –> Manage privileges–> Access to SOAP.

Here the permissions should be given to BI Consumer Role.

Now we are able to see the BI Publisher.

By bidevatapraveenkumar Posted in OBIEE 11g

Column Header Mouse Over In OBIEE 11g

You can set Mouse Over functionality over column header of the table.

Step1: Go to column format and check custom heading.

Step2: Add html tag like <b title=”DNAME”>DNAME</b>

Step3: Go to instanceconfig.xml.

Step4: Edit it and add tag – <HardenXSS>false </HardenXSS> in the Server Instance.

Step5: Restart the Services.

Now we can see the Mouse Hover for Column Heading.

By bidevatapraveenkumar Posted in OBIEE

Log Files in OBIEE 11g

Log Files in OBIEE 11g:

 

In Enterprise Manager Console you can find the Most Recent Errors and Most Recent Warnings. After warning messages, you can also see all the log files grouped by categories using Log Viewer.

Available files:


• Presentation Services Log
• Server Log
• Scheduler Log
• JavaHost Log
• Cluster Controller Log
• Action Services Log
• Security Services Log
• Administrator Services Log

The log files for OBIEE components are found under /instances/instance1/diagnostics/logs

Different type of log files:


Presentation Server log files:


/instances/instance1/diagnostics/logs/OracleBIPresentationServicesComponent/coreapplication_obips1
Files: sawlog0.log, webcatupgrade0.log
BI Server log files:
/instances/instance1/diagnostics/logs/OracleBIServerComponent/coreapplication_obis1
Files: nqquery.log, nqserver.log, servername_NQSAdminTool.log, servername_nQUDMLExec.log, servername_obieerpdmigrateutil.log
Scheduler log:
/instances/instance1/diagnostics/logsOracleBISchedulerComponent/coreapplication_obisch1
Files: nqscheduler.log

Cluster Controller log:
/instances/instance1/diagnostics/logs/OracleBIClusterControllerComponent\coreapplication_obiccs1
Files: nqcluster.log
ODBC log:
/instances/instance1/diagnostics/logs/OracleBIODBCComponent/coreapplication_obips1
OPMN log:


/instances/instance1/diagnostics/logs/OPMN/opmn
Files: debug.log, logquery~NUMBER.log, opmn.log, opmn.out, service.log

By bidevatapraveenkumar Posted in OBIEE