Regarding an issue we are facing from last sunday(26thmay2013) the following workflow is facing a scenario,
where the workflow continues to run but no data is getting inserted into the Shown Target Table.
we could see that the Process has run for nearly One whole day, but not even a single row has been inserted.
We tried creating a similar mapping with the same source and target tables, still facing the same issue.
Can you kindly provide your inputs in this regard?
Thanks for the update Veersh.
But can you kindly,be a little more clear and specific?
We cant figure out anywhere for a solution for this issue.
We have been stuck up with thiis for the past four days.
What exactly do we have to do, to sort this out.
But tell me how long that SQL took the time to get you the first row in toad?..Is there anything u missed out in Session log after this statement query issued to Database ?.If yes please post the remainging session log too.
If nothing remained in the session log then do these action itmes.
1)Check if there is any table lock happended on those source tables.
2)Abort the ongoing ETL process and mark as completed and then start the process freshly.Monitor operating system RAM utilization closely and hows RAM is getting utilized.