DOM_10215 Node is already running in domain

com.informatica.isp.corecommon.exceptions.ISPHardException: [DOM_10215] Node [node01_infoserver] is already running in domain [DOMAIN_INFOSERVER] at [biserver:6005].

Issue: My current project involves maintaining multiple Informatica servers like DEV, SIT, UAT and PROD. Mostly every month cloning activity will happen. So as part of this activity, DBA(Database Administrators) people clone some schema  from PROD database to rest of the databases.

 Ex:-  a) INFODOM (Informatica domain schema)
             b) INFOREP (Informatica repository schema)

 Basically they are taking the above schemas backup in ONLINE mode from PROD environment and placing them and restoring them in DEV(for example).

No need to mention, they obviously revert previous DEV database passwords.

Somehow, after restoring or cloning the Informatica schema, we are not able start Informatica services in DEV environment and when we verify the log(exception.log) from the below path.

D:\Informatica\9.0.1\logs

And getting the below error.

"FATAL [Domain Monitor] [DOM_10215] Node [node01_infoserver] is already running in domain [DOMAIN_INFOSERVER] at [biserver:6005]."

 We have spent lot of time to resolve this issue. But no luck, we haven't find exact solution to fix this issue. But alternatively we found some workaround.

Solution: Stop PROD Informatica services and try to start DEV Informatica services. Once the services are up and running try to update passwords and Database details. Finally start PROD Informatica services.

You are done.

Viewers inputs are highly appreciated if they can provide some inputs or resolution.

Currently I am doing some research on this issue, I can come with solution soon.

Backup Informatica repository with pmrep command

 Today I ran into a tricky situation where Informatica administrator(Admin console) page is not coming up. But repository service and integration service are running fine. I have verified this information by connecting to Informatica client tools.

 Now I have to take Informatica repository backup. How to get rid of this situation...!

 So here is an alternative way to take repository backup.

use pmrep utility.

Step 1: Open command prompt and type pmrep.

 

 Step 2: Enter the below command.  

 

connect -r Info_Rep -n Administrator -x Administrator -h etlserver -o 6005 

-r Repository name

-n Informatica username

-x Password

-h Host name

-o Repository port number

Change the values according to your environment.

 

 Step 3: Make sure you connect to the repository by checking the successful connect message.

 Step 4: Now perform repository backup using below command.

             backup -o Info_Rep_BKP.rep

 Step 5: It takes little to time complete the activity depending on size of your repository.

 

 Step 6: Go to Informatica server repository backup folder and verify your backup file.

 

Export Multiple Informatica workflows from different folders as single xml file

 Export Multiple Informatica workflows from different folders as single xml file

 I am sharing a technique where you can export multiple Informatica workflows from different folders. Usually you can export workflows from one folder at a time. But sometimes you need to export it as one xml file and this is not possible with regular approach. 

So for those people who got this requirement just follow this steps.

 I have already explained Usage of Informatica Query option, so by making use of this option we will complete this export activity.

Step 1: Create a query such that i will list out all the required workflows from different folders.

Step 2: Execute the query to create the output. You will see the output with workflows from different folders as marked in red color in the below image.

Step 3:  Use ctrl(key) to select all the workflow and do right click on it and select "Export to XML file" option.

Step 4: Now you can save all the workflows as single xml file from different workflows.

Related links:

Listing Informatica objects with Query Tool

Listing Informatica objects with Query Tool

Issue: List all Informatica objects(Mappings, Sessions, Workflows etc)

Solution: Use inbuilt "Queries" option in Informatica Powercenter Repository Manager tool.

Some of the uses of this "Queries" option.

a) Create list of objects such as Mappings, sessions, workflows etc.
b) Objects with their status( Valid or Invalid).

 In this post I will get the list of workflows in a particular folder using this option. Below are the steps to carryout this activity.

Step 1: Login to "Informatica Powercenter Repository Manager".

Step 2: From the file menu, go to "Tools" and select "Queries".

Step 3: From the file menu, go to "Tools" and select "Queries".

Step 4: Click on the "New" button to create a query and start composing a query like this.

Note: - Use  these button to create a query.

Step 5: Click on the "Execute" button to list the required objects and the output will be displayed as below.

Step 6: Click on the "Save" button to save the list. You can later process this data in to an Excel sheet.

Related links:

Analyzing Informatica objects properties with Excel

Verify Informatica objects properties with MS Excel accurately

Today we will discuss some trick or tip...whatever you call it...But this will really helps a lot.

 People who works on Informatica might come across this situation frequently. Just spend some time on this post to gain knowledge. This will really helps you a lot.

Issue: I have developed 100 mappings for a project requirement. This includes, 

100 mappings design -200 sessions( One for incremental and one for Full load) - 200 workflow.

 Before moving to Testing phase, I need to verify the above developed objects accurately.

Verification includes the below.

1) Mapping Level: 

    a) Need to verify "sql override"
    b) Mapping name according my project naming convention.

2) Session Level:

    a) Incremental and full load session naming convention.
    b) Session Log File Name
    c) Parameter File name
    d) Recovery Strategy
    e) DTM buffer size
    f) Default buffer block size
    g) Source and Target connection values
    h) Target load type
    i) Truncate target table option
    j) Reject file name

3) Workflow Level:

   a) Failure strategy 

      - Fail parent if this task fails
      - Fail parent if this task does not run

I was worried on how to verify these many options individually for each and every objects.

After spending some time found some clues to do it quickly. This saves me lot of time and was so happy after this.

Solution: All just we need to open the exported xml using Ms-Excel and create report on the Informatica objects.

Follow the below steps to verify your informatica objects.

Step 1: Connect to Repository manager, open the folder and select your workflows and export it.

Step 2: Right click on file and select 

"Open with" -> "Microsoft Office Excel" 

Note: Before opening, remove the below line from the XML document.

<!DOCTYPE POWERMART SYSTEM "powrmart.dtd">

Step 3: Now the excel popups a window saying select option. Just select last option "Use the XML Source task pane".

Step 4: All elements existing XML file be displayed as Tree structure at right pane shown as below.

Step 5: Now we are almost done. All just we need to know intelligently to select the XML elements. Basically XML document contains every information. As shown in the below image, I am going to select some session properties.

Step 6: Place your cursor in the first cell and double click the desired XML tag in the Right pane. Repeat the same steps for other Tags.

Step 7: Finally Click on "Refresh All" button in the Data tab of Excel.

Step 8: This will fetch complete information based on the selected as follows. Apply filter on the properties column and select the properties you want to verify.

 Here I am selecting "Source connection value","Target connection value","Session Log file name".

Step 9: Finally you will get the report as show below.

Cool trick right..!!! 

When you have bunch of objects to verify the properties, this option will help you a lot.

CHEERS :)

Configuring Informatica client tools for the first time

In the earlier post we have seen creating Informatica repository service, Integration service and Installed Informatica client tools

So that's cool...Nothing much to do on the Informatica server again.

Now it's time to configure Informatica client tools to connect Informatica Server.

Please follow the below steps.

Step 1: From the start menu, navigate to the below path.

Start  -> Informatica 9.0.1 -> Client -> PowerCenter Client -> Power center repository Manager

Step 2: From the start menu, navigate to the below path.

Step 3: Configure domain window will be opened. Click on "dot lined square" button to add domain. Give the below details.

              Domain Name: Domain_win2008server

              Gateway Host: win2008server

              Gateway Port: 6005

 Click on "OK".

Step 4: Previously created Informatica repository will be displayed to select. Select it. Then click on "OK".

Step 5: Now we are almost done. You can find the "InfoREP" repository is available in Informatica Repository manager to connect.

With this we have successfully configured repository in Informatica repository manager.

CHEERS :)

Installing Informatica client tools

Installing Informatica client tools

Step 1: From the Software dump directory run "install.bat" file to start installation.

Step 2: Select select "Install or upgrade to Informatica" and click "start" button.

Step 3: Pre-requisites window will be displayed. Just click "Next" to continue.

Step 4: Let the default option be there as is. Click "Next" button.

Step 5: Select the installation directory and click "Next".

Step 6: Installation summary will be displayed. Click "Next" to continue.

Step 7: Let the installation continue.

Step 8: Upon successful installation, success summary page will be displayed. Click "Done" button.

With this Informatica Client installation is completed. In the next post we will see how to configure Informatica clients for the first time.

CHEERS :)

Creating Informatica Repository and Integration Service

In the earlier post we have completed Informatica server installation.

Now we will see how to create Informatica Repository Service as well as Integration Service.

Step 1: Login to Informatica Admin Console page using below url .( differs in your machine)

              URL:  http://win2008server:6007/administrator
              User Name: Administrator
              Password: Administrator

Step 2:  Here no Repository and Integration services are defined.( Marked with red color area).

Step 3: Click on Domain name, click "Action" -> "New" -> "Power Center Repository Service" to start creating Repository service.

Step 4:  Give repository name like "InfoREP" and select Licence and Node from the drop down boxes. Click "Next"

Step 5:  Provide the below details and Click "Finish" button.

              Database Type: Oracle

              User Name: inforep

              Password: Admin$1234

              Connection String: ORADB

Note: Before starting Informatica server installation, we have created two schemas.

           a) Infodom ( This will be used for domain configuration while Informatica server installation)

           b) Inforep  ( We are using this schema for creating repository service now)

Step 6: It will take few minutes to complete the process.

Step 7: Once the Repository service created, Make "Operating Mode" to "Normal" from "Exclusive".

Step 8: Now the repository will run in Normal mode.

Normal Mode: Normal mode provides full access to users with permissions and privileges to use a PowerCenter Integration Service.

Exclusive Mode: Safe mode limits user access to the PowerCenter Integration Service and workflow activity during environment migration or PowerCenter Integration Service maintenance activities.

We have successfully created Informatica repository service. Now we have to create "Integration service" to complete

Step 9: Click on Domain name, click "Action" -> "New" -> "Power Center Integration Service" to start creating Integration service.

Step 10: Give Name to Integration service, select Licence and Nod from the drop down box. Click "Next" to complete.

Step 11: Select previously created Repository, and give Username and Password. Finally click "Finish".

               Administrator/Administrator

Step 12: Click on domain to see whether Integration service is running or not.

 With this, we have completed creating Informatica Repository service and Integration service.

 Now the Informatica Service is ready to connect using Informatica Client tools.

In the next post we will learn about Informatica Client tools.

CHEERS :)