Results 1 to 13 of 13

Thread: Session Error in Informatica

Hybrid View

Previous Post Previous Post   Next Post Next Post
  1. #1
    Junior Member
    Join Date
    Jul 2008
    Answers
    2

    Session Error in Informatica

    Hi,

    While running the session i got the below mentioned error msg,Can any help me on this?

    Error:The session log file was not created for session instance [id=83]
    in folder [dev],workly[test][run id=217],worklet[run id=0](possibly because the session failed during initialization.

    Thanks in adv,


  2. #2
    Contributing Member
    Join Date
    Dec 2007
    Answers
    34

    Smile Re: Session Error in Informatica

    Hi,

    Try to analyse the Error, wht kind of error u r facing?

    There is some standard Error codes.

    RR - Relational Reader (This is for Relation Source(Any Database source))
    FR - File Reader (This is for Flat Files)
    RR_4035 -- There is some problem in ur Source

    WRT - Relational Writer
    WRT_8229 --- There is problem in ur Target

    Please get back to me in case of queries.

    Thx & Regards,
    Prakash Chandran


  3. #3
    I am the DON
    Join Date
    Apr 2006
    Answers
    99

    Re: Session Error in Informatica

    Quote Originally Posted by chandrp View Post
    Hi,

    While running the session i got the below mentioned error msg,Can any help me on this?

    Error:The session log file was not created for session instance [id=83]
    in folder [dev],workly[test][run id=217],worklet[run id=0](possibly because the session failed during initialization.

    Thanks in adv,
    Vague error message -
    Can you try to keep it completely...! Not all the log - only the error code.

    Sanghala

    If you are satisfied with my reply. Please click “Thanks” button which increases the reputation and can serve you better.

  4. #4
    Junior Member
    Join Date
    Jul 2008
    Answers
    2

    Re: Session Error in Informatica

    Hi chandrp,

    You will get this kind of msg when the workflow fails during the initialization and when you try to open the session log (Right click on session->Session log). You need to check the workflow log not session. Because the workflow is failed at the starting itslef. You will find all the details i.e error msg in workflow logs (Right click on workflow->workflow log).

    Cheers,
    Naveen


  5. #5
    Junior Member
    Join Date
    Jul 2008
    Answers
    2

    Re: Session Error in Informatica

    Quote Originally Posted by chandrp View Post
    Hi,

    While running the session i got the below mentioned error msg,Can any help me on this?

    Error:The session log file was not created for session instance [id=83]
    in folder [dev],workly[test][run id=217],worklet[run id=0](possibly because the session failed during initialization.

    Thanks in adv,
    Hi chandrp,

    You will get this kind of msg when the workflow fails during the initialization and when you try to open the session log (Right click on session->Session log). You need to check the workflow log not session. Because the workflow is failed at the starting itslef. You will find all the details i.e error msg in workflow logs (Right click on workflow->workflow log).

    Cheers,
    Naveen


  6. #6
    Junior Member
    Join Date
    Jul 2008
    Answers
    4

    Re: Session Error in Informatica

    Pls check ur log file is created or not.Then only we have to find the solution


  7. #7
    Junior Member
    Join Date
    Aug 2008
    Answers
    2

    Re: Session Error in Informatica

    plz check the sessionlog path..


  8. #8
    I am the DON
    Join Date
    Apr 2006
    Answers
    99

    Re: Session Error in Informatica

    Quote Originally Posted by chandrp View Post
    Hi,

    While running the session i got the below mentioned error msg,Can any help me on this?

    Error:The session log file was not created for session instance [id=83]
    in folder [dev],workly[test][run id=217],worklet[run id=0](possibly because the session failed during initialization.

    Thanks in adv,
    Just try to recover it as it failed at initialization and please keep the error message clearly

    Sanghala

    If you are satisfied with my reply. Please click “Thanks” button which increases the reputation and can serve you better.

  9. #9
    Junior Member
    Join Date
    Sep 2008
    Answers
    4

    Re: Session Error in Informatica

    Hi
    There are multiple reason for getting this error.
    One of the most common error is you session could have been invalid or it is not validated after making any changes.
    Some time you have mentioned parameter file in the session but not pointing to correct location. please check the workflow log which will give you enough idea regarding error.


  10. #10
    Junior Member
    Join Date
    Jan 2009
    Answers
    1

    Re: Session Error in Informatica

    Hi...
    there are possibly multiple reasons for the above said error as the session log itself unable to create.please look into the following issues
    (i)please disconnect from the repository ,login again and validate the workflow.
    (ii)check for workflow variables or mapping variables,if checked persistent disable it.
    (iii)check for the paths mentioned for session log file
    seems to be u have used a worklet kindly check all the paths of log file


  11. #11
    Junior Member
    Join Date
    Feb 2009
    Answers
    4

    Re: Session Error in Informatica

    I had faced lots of such issues and there were only two reasons:
    1> Invalidated sessions:

    Please validate the session and run the workflow.

    2> Invalid source/target connections

    Please correct the connections and run the workflow


  12. #12
    Junior Member
    Join Date
    Nov 2009
    Answers
    2

    Re: Session Error in Informatica

    hi
    while i While running the session i got succeeded.but data not loaded to target. the below mentioned error msg,Can any help me on this?
    CMN_1053 : Target table T_EMP: Data Target table T_EMP: Data conversion overflow/error: Rowdata: ( RowType=-11(error) Src Rowid=1 Targ Rowid=1
    EMPNO (EMPNO:Char.3: "(NULL)" overflow/error: Rowdata: ( RowT


  13. #13
    Junior Member
    Join Date
    Nov 2009
    Answers
    2

    Re: Session Error in Informatica

    when am start to session running i got succeeded but data not lode to target,the error is
    mag code is wrt_8124,


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
About us
Applying for a job can be a stressful and frustrating experience, especially for someone who has never done it before. Considering that you are competing for the position with a at least a dozen other applicants, it is imperative that you thoroughly prepare for the job interview, in order to stand a good chance of getting hired. That's where GeekInterview can help.
Interact