Informatica Unable to fetch log

Quite often, you might come across the following error when you try to get the session log for your session.

The first place to start debugging this error would be one-level up from the session log, which is the workflow log.

The most common reasons I have seen this happen is because of the following .

a ) One or more of the following parameters have been specified incorrectly.

  • Session Log File directory
  • Session Log File Name
  • Parameter Filename (at the session (and/or) workflow level)

b) You do not have the necessary privileges on the directory to create and modify (log) files.

Whatever be the case , the workflow log is your next point of debugging. In my test scenario , I entered the following parameters for the log file name and directory to simulate this error.

Session Log File directory : $InvalidLogDir

Session Log File Name : s_m_test_cannot_fetch_log.log

When I ran the workflow, the session failed and I could not get the session log (becuase it was never created) . The error in the workflow log is as follows.

There seems to be too much guesswork to fix this error based on the posts on internet forums . Somehow, developers seem to think of this error as something wrong with the Informatica client installation.

The next time you get this error, please check your workflow log.

If you have seen this happen before for another reproducible case , please comment and I’ll modify the post to include the same if needed.

Hope this helps….
Rajesh.

  • himanshu

    Thnx it resolved my problem…..

    • jeevan

      My wf run properly when i dont have sp trans but when i add sp of any kind it will give me error [lgs 10052][lgs 10052] the log service has no record of the requested session or workflow.

      • Rajesh

        Have you tried executing the stored procedure directly (from your database tool itself) and make sure it worked?
        Example, If you are calling an Oracle Stored procedure, have you tried running that procedure from SQLPLUS or TOAD or some other client tool?

  • sagana

    Nice Work Rajesh.It has been greate help

  • Amri

    Hi, sorry I have the same error but I had been running my workflow and ran well but now is not be. In my log I obtained :
    FATAL ERROR : Caught a fatal signal or exception.
    FATAL ERROR : Aborting the DTM process due to fatal signal or exception.
    FATAL ERROR : Signal Received: SIGSEGV (11)

    Sometimes I get the error ‘Unable to Fetch Log.The Log Service has no record of the requested session or workflow run.’, Could you said me if I’m doing something wrong?

    Thanks, regards 🙂

    • Rajesh

      Amri,

      This might be one of those internal errors. If that’s the case, you will need to contact Informatica support.
      In any case, make sure that you check the actual log file (operating system file). Sometimes, it has more details than what you see in the workflow monitor.

  • pranav garg

    Do check $Source connection value and $Target connection value in properties tab of the session.

  • pramod

    When I run different session with different mapping, it writes session log but when I run a session with parameter file it gives error and even doesn’t show the folder I am working.