Skip navigation
Contact Us
1434 Views 5 Replies Latest reply: Oct 29, 2013 9:06 PM by venkat sai RSS
Abinash Jena Novice 47 posts since
Apr 28, 2011
Currently Being Moderated

Dec 31, 2011 3:19 AM

issue : when running workflow

Severity    Timestamp    Node    Thread    Message Code    Message

 

INFO    31-12-2011 16:41:16    node01_shivanand-HP    MAPPING    SORT_40419    For Transformation [SRTTRANS], memory used is [16777216] bytes and row size is 172 bytes.

 

 

when I am starting workflow, it is running always.

 

I am finding above message in session log .

 

I have implemented 1 -1 mapping with sorter transformation .

 

OS : windows 7,64 bit , informatica 8.6.1

 

Please help me, how to solve this issue.

  • Mariappan Kannapiran Apprentice 143 posts since
    Jan 29, 2011
    Currently Being Moderated
    Dec 31, 2011 7:03 AM (in response to Abinash Jena)
    issue : when running workflow

    Whether your session causes any failure or displays error message.Because the above mentioned

    message doesn't displays any error.it just shows the memory occupied by the sorter

    transformation

      • Mariappan Kannapiran Apprentice 143 posts since
        Jan 29, 2011
        Currently Being Moderated
        Jan 1, 2012 10:53 PM (in response to Abinash Jena)
        issue : when running workflow

        As per my knowledge,Sorter Transformation requires atleaset 16 MB of Physical memory to

        cache the data.

         

        1.Check whether you have suffient memory in the database.

        2.Check whether you have set to Auto for all the cache related fields(sorter cache size) in properties,so let

            the IS takes the necessary space,even if we doesn't allocate.

         

        Let we check whether it works.....

        • Ummed Mahala Newbie 6 posts since
          Nov 17, 2012
          Currently Being Moderated
          Nov 17, 2012 3:16 PM (in response to Mariappan Kannapiran)
          issue : when running workflow

          Hi,

           

          I am also facing the same issue....my workflow is running continously even if in the source there are only 4 rows......but when i do not use sorter or aggregator its running absolutely fine and completes in 2 seconds.....but when i use aggregator or sorter its running forever ...and in session log last line is ..

          For transformation [agg_trans], memory used is [121151248] bytes and row size is 20 bytes.....

           

          Please help

More Like This

  • Retrieving data ...

Bookmarked By (0)

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points