Why session fails when running a workflow

Could anyone tell me why session fails when running a workflow? I do not see any records being inserted to target table though source table has data. There are sufficient permissions to the user who is running workflow and relational connections are pointing to the correct databases. This whole exercise is taking place on windows xp pro and backend database is oracle 10 EE. Any help is appreciated.
  • Interview Candidate
  • 5
  • 2493

Showing Answers 1 - 5 of 5 Answers

Motilal

  • Jun 30th, 2006
 

Hi Kamalnayan,

You please check the target properties in workflow manager and turn the 'target load type' to normal . By deefault it remains Bulk which might be the cause.

Lemme know the updates.

-regards,

Motilal

  Was this answer useful?  Yes

praveen

  • Jul 3rd, 2006
 

Hi all,

As one of our friend said that due to option that normal loading was selected it is correct but unless if we can't check log file it is difficult to say what it exacly reason for failure kindly make sure where it has been fail and what is reason

regards

praveen

rajesh kumar

  • Jul 23rd, 2006
 

hi kamal ,it can't be said totally why a session fails . There are several instances in which u r session fails if u could send the message of error displayed in properties window of session workflow it could be found easily waiting 4 u r reply bye srk (sai rajesh kumar)

  Was this answer useful?  Yes

anupama2000

  • May 26th, 2008
 

Hi,Kamal1.check the preview data option in your source in mapping if the data comes to your srce then go for second stepif the data is not previewed check the source DSN2.check username of your source and target then go toworkflow manager and check the sessions by double clicking itafter tht go to mappings tab check the srce connection name if it differs there then modify similarly for target second

  Was this answer useful?  Yes

rohit1505

  • Mar 21st, 2011
 

Read the session log file, and also do check weather your target table is generated or not because if you are getting the result as 'now rows selected' then this might be one of the reason. You need to generate target table in designer itself.

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions