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  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.
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
1. When my mapping is without SRTER ie 1 -1 like ------ SQ----> Target , it is running fine immediately.
2. When I am using SRTER in mapping like ---- SQ----> SRT-----> Target , I am finding status in workflow moniter like RUNNING / in PROGRESS for long time AND also not showing FAILURE / SUCCESS .
Its like my running of my workflow is hanged.
When I am looking session log , I am find above message.
SRC file contains only 2 records.
Inftk Version -- 8.6.x
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.....
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  bytes and row size is 20 bytes.....
are you able to sort your problem?
I'm also facing same issues with my Informatica 8.6.0.
Was suggested some hot fix by some of my friends yesterday. but, no guarantee that it might be resolved