Friday, 8 May 2015

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 !!. :)



Monday, 4 May 2015

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

Sunday, 3 May 2015

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 !! :)



Power BI: Show Last Data Refresh on Dashboard

 To show last data refresh on Power BI report follow the below steps. 1. Open Report Query Editor Mode. 2. Clink on Get Data -> Blank...