OBIEE 11g (BI Scheduler) Error nQSError: 75005

This error generally will come if we have specified the username and password while configuring the mail server in EM page.

We can’t delete the username and password from this page directly. To remove this from here , we need to go to below  path,

Enterprise manager > Weblogic Domain > Right click on bifoundation_domain> Security > Credentials >oracle.bi.enterprise>mail.server

Delete the mail.server from here, it will automatically delete from the mail configuration page. Restart the BI services once.

Enjoy and stay well !! :)

Informatica Error: Repository Mismatch

After migration of Informatica repository from one environment to another environment (Like DEV to UAT server), when we will try to run the Workflow we usually get an error, like repository mismatch. Error will looks like as below:

This kind of error comes because even after repository migration, Integration service of UAT still pointing to DEV Integration service.You need to reassign the Integration service to UAT one.

To do the same you need to login to UAT Informatica Workflow  Manager. click on  Service -> Assign Integration Service.

Them just select all workflows and choose Integration service you want to assign.

Enjoy and Stay Well !!. :)

OBIEE 11g: Admin Server Restart Issue

Sometime we will get an error while restarting the BI server like, Admin server port is being used by another process, and because of this we won’t be able to restart the BI server.

There can be many reasons behind of this issue. Sometime Admin port or BI analytics ports are being blocked and Admin server is not able to access the same. Or sometime If someone is trying to access BI EM/Console/Analytics page during the restart of BI server, that time also we will end up with this kind of issue.

Anyway we can solve this issue by two different ways.

1.      We can restart the entire BI application server so that locked ports will be released and then try to restart the BI server, it should pass through.

2.      To avoid the application server restart we can kill the specific process where these ports are running on.

a.      To find the process ID (PID) for a specific port, type the below command on putty session.

                                                netstat -p -nlp|grep 7001

b.      Once you get the PID then kill the process using below command.

Kill -9 12306

c.       Now try to restart the BI server. Hope it will solve your issue.

Enjoy and stay well!! J

OBIEE 11g Issue: BEA-280061

Sometime we will get an error (BEA-280061) while restarting the BI server.

Error:

BEA-280061 The persistent store “_WLS_AdminServer” could not be deployed

Cause:

.DAT file and .LOK files are not able to accessed by Admin and Managed server.

Solution:

We need to delete the existing .DAT and .LOK files from the below path.

 For Admin server
$DOMAIN_HOME/servers/<server name>/tmp/Adminserver.lok
$DOMAIN_HOME/servers/<server name>/data/ldap/ldapfiles/Embedded.lok
$DOMAIN_HOME/servers/<server name>/data/store/default/_WLS_ADMINSERVER000000.DAT
$DOMAIN_HOME/servers/<server name>/data/store/diagnostics/WLS_DIAGNOSTICS000000.DAT

For Managed servers

$DOMAIN_HOME/servers/<server name>/tmp/<servername>.lok
$DOMAIN_HOME/servers/<server name>/data/ldap/ldapfiles/Embedded.lok
$DOMAIN_HOME/servers/<server name>/data/ldap/store/default/_WLS_<servername>000000.DAT
$DOMAIN_HOME/servers/<server name>/data/ldap/store/diagnostics/WLS_DIAGNOSTICS000000.DAT


Now try to restart the BI server. Hope it will work now.


Enjoy and Stay Well !! :)

Informatica Workflow Succeeded But Session Failed

Sometime it happens like Informatica session got failed but Workflow will show as succeeded. If you are running mappings though DAC , DAC will not stop execution as Workflow got succeeded. So in that case it is very difficult to find out the failed mappings. So to control the DAC and to get the actual status of mapping we need to enable a option , "Fail parent if this task failed" in session level.

Open session and enable the below showed options.

Enjoy and stay well !! :)

Informatica Issue: ORA-01438

Sometime we used to get an error while running an Informatica workflow as below.

Error:

ORA-01438 : Value larger than specified precision allowed for this column.

Cause:

Datatype defined for the column is not as per the data from coming from source.

Solution:

Change the datatype NUMBER(x,y) to NUMBER.


Enjoy and stay well !! :)

OBIEE 11g: Tool-tips

We can have the tool-tips in multiple places in BI. Tool-tips show the preview with a bit of description which will help user to know about the dashboards or reports whenever they will move the mouse over it.  We can put tool-tips in Dashboard, Dashboard page, Report title, Column heading, etc.  Developer can provide a brief description about the dashboard/reports.

To provide the tool-tips in dashboard level, go to catalog and select the particular dashboard then go to properties of the same. You will get a section called “Description”, where you can write down the brief description about it.  Need to do the same for dashboard page or report title as well.

Now if you want to provide tool-tips on a column heading you need to write a bit of HTML code.

You need to write the below code in Column heading and check the Contain HTML heading option .

<span title="Difference between PR Approval Date and PO Approval Date">Days Taken</span>

Here, "Difference between PR Approval Date and PO Approval Date" will show as preview on column heading.
           "Days Taken" will be the column name. 

Enjoy and stay well !! :)