11 Replies Latest reply on Nov 12, 2018 8:47 AM by Nico Heinze

    Informatica Admin Console Environment Variables

    Amit Jain Active Member

      Hello Team,

       

      I have defined an environment variable in my Integration Service properties as follows.

       

      Environment Variable Name: PMHomeDir

      Value: /home/gdint/wdint

       

      I am calling that environment variable in the Command task.

       

      $PMHomeDir/.infa.sh

       

      Command Task throws an error.

       

      Error Message: Command task instance [Command_execute_create_param]: execution of command [Prompt and execute] did not complete successfully with exit code [32256]

       

      If I used the below path in the Command Task:

      /home/gdint/wdint/.infa.sh

      Then Command Task is executed successfully.

       

      Could you please tell me what I have missed or any solution for this problem?

       

      Thank You!

       

      Best Regards:

      Amit Jain

        • 1. Re: Informatica Admin Console Environment Variables
          Guru

          Hi Amit,

           

          You might have to check the complete workflow log and the Integration service log to see why the command task failed.

           

          Could you verify if the Integration service is able to expand the environment variable: PMHOMEDIR

           

          You can include a command as below to verify:

           

          echo $PMHOMEDIR > /home/user1/echo.txt

           

          Also, did you recycle the Integration service after setting the environment variable?


          Regards,

          Sujata

          • 2. Re: Informatica Admin Console Environment Variables
            Guru

            Hi Amit,

             

            You would need to run the above command in command task and check if the variable is expanded.

             

            Also, as mentioned kindly check the Integration service log as well.

             

            if this is critical, we advise you to open a support case so that you can directly work with one of the support engineer and resolve this issue.

             

            Regards,

            Sujata

            • 3. Re: Informatica Admin Console Environment Variables
              Guru

              Hi Amit,

               

              This clarifies that the variable is expanded correctly.

               

              I did a similar test and the command failed in-house as well.

              Following this, I checked the Integration service log which I has suggested and it gave me the cause:

               

              serviceTypeserviceNameseveritytimestampthreadNamemessageCodemessage
              ISIS3$_:_$INFO05/29/2014 16:18:35.253 PM140569214961408CMN_1954[Command task instance [cmd]:] Process id 7039. Standard output and error:

              sh: /home/user1/.infa.sh: No such file or directory

               

               

              So, the command failed because there is no file as .infa.sh.

               

              Then, I modified the command task as:

              sh $PMHOMEDIR/infa.sh

               

              and it succeeded.

               

              request you to kindly try the same. In case it fails, you can always check the IS log for more details.

               

              Let us know if this helps you.

               

              Regards,

              Sujata

              • 4. Re: Informatica Admin Console Environment Variables
                Amit Jain Active Member

                Hi Sujata,

                 

                File .infa.sh is present on the exact loaction.

                 

                When i run the command task with this command /home/gdint/wdint/.infa.sh then it is executed successfully. But when I used the variable and run this command $PMHomeDir/.infa.sh then it is throws an error.

                 

                You told that as well that variable is also expanded successfully then why the commnad task is falling ?

                 

                Can you please tell me from where i will get the Intergration Service log because i do not have the permission on Admin Console ? Do i need to contact to my informatica admin guys to get the log file?

                 

                I don't able to undestand what i have missed in this.

                 

                Regards;

                Amit Jain

                • 5. Re: Informatica Admin Console Environment Variables
                  Guru

                  Could you please also try making one more Integration Service and retry the logic?

                  • 6. Re: Informatica Admin Console Environment Variables
                    Guru

                    Hi Amit,

                     

                    You can fetch the IS log from the admin console-> logs.

                     

                    OR

                    You can use :infacmd isp GetLog to get the Integration service log.

                     

                    Kindly refer the Client help guide to get details on this command.

                     

                    Regards,

                    Sujata

                    • 7. Re: Informatica Admin Console Environment Variables
                      Amit Jain Active Member

                      Hello Adtiya,

                       

                      I have tried the same logic in two integration service(DEV, INT) but it didn't work at all. I am getting the same error in both places.

                       

                      Do you have any idea why it is not running ?

                       

                      Regards:

                      Amit Jain

                      • 8. Re: Informatica Admin Console Environment Variables
                        Deepak Sinha Guru

                        Hi Amit,

                         

                        Try to set the PMHomeDir under general properties tab instead of setting it in environment properties and see what happens.

                        • 9. Re: Informatica Admin Console Environment Variables
                          Guru

                          Amit- Do you have any specific reason that you are setting the root/home directory under env variables rather general properties of IS

                           

                          If you keen on env variable why to set at application service level , you can set on the box itself.

                          • 10. Re: Informatica Admin Console Environment Variables
                            Guru

                            I'm not Amit, but there are good reasons why setting environment variables globally may not be appropriate.

                            First they may negatively impact other applications running on the same box.

                            Second you cannot always set environment variables globally; for example, when using PowerExchange for Essbase on a machine where you also work with Oracle databases, you have to set a couple of environment variables (such as PATH and LD_LIBRARY_PATH resp. its relatives on other Unix systems) differently for those Integration Services running against an Essbase server than for all other Integration Services exchanging data with Oracle. Unfortunately several library files exist with identical names for both products, the Oracle client and the Essbase client software, so you have to cleanly distinguish between these two.

                            Third there are environment variables which you might want to set only for specific services (such as LD_PRELOAD on HP-UX). Setting these globally may turn your whole system unusable.

                             

                            Regards,

                            Nico

                            • 11. Re: Informatica Admin Console Environment Variables
                              Nico Heinze Guru

                              Hi Amit,

                               

                              you can find the server logs (in this case, the log file of the Integration Service) in the file system. Unfortunately the exact location depends on the PowerCenter version, so you might have to look around a bit in order to find them.

                              You will most likely find them in some subdirectory named (for the example case of today, Nov 12th 2018) 2018-11-12 ; under 10.1 this is in the subdirectory $INFA_HOME/isp/logs, under other versions this will often differ a bit.

                              In this subdirectory there's one further level of subdirectories per node in the INFA domain.

                              Here you will find loads of files named 0_0.dat & 0_0.dat.idx and so forth.

                              You can translate these files to readable versions using the command infacmd.sh (resp. infacmd.bat on Windows) with its subfunction ConvertLogFile, like in this example:

                                  infacmd.sh ConvertLogFile -in 0_0.dat -fm text -lo 0_0.txt

                              ("-in" = input file for the conversion, "-fm" = format of output file, "-lo" = log goes to named output file)

                               

                              Of course that requires that you have access to the file system.

                              If you can't access the file system but you have infacmd.bat installed locally (namely on your Windows PC running the PowerCenter clients), you might be able to use the following command on your PC in a cmd.exe shell window (after having done a "cd" into the subdirectory where infacmd.bat is located):

                                infacmd GetLog -dn DomainName -un UserName -pd Password -ro -fm text -lo intsvc.log -st IS -sn IntSvcName

                              (of course you have to enter the correct details instead of "DomainName" and so on)

                               

                              Regards,

                              Nico