Search found 7 matches

by mourya33
Tue May 05, 2009 6:50 am
Forum: General
Topic: Invalid Precision Error in parameter
Replies: 2
Views: 7145

Invalid Precision Error in parameter

We are running a parallel job which loads data from oracle database to oracle database. We have not used any transformations anywhere.The job is aborting with the folowing error. "APT_CombinedOperatorController(0),2:[Data Direct][ODBC Wire Protocol Driver] Invalid Precision Value. Error in Para...
by mourya33
Wed Apr 29, 2009 12:27 am
Forum: General
Topic: Invalid Precision Value . Error in Parameter 9
Replies: 1
Views: 1409

Invalid Precision Value . Error in Parameter 9

We are running a parallel job which loads data from oracle database to oracle database. We have not used any transformations anywhere.The job is aborting with the folowing error. "APT_CombinedOperatorController(0),2:[Data Direct][ODBC Wire Protocol Driver] Invalid Precision Value. Error in Para...
by mourya33
Wed Apr 15, 2009 2:19 am
Forum: General
Topic: Unable to insert into teradata table
Replies: 2
Views: 1891

Unable to insert into teradata table

We are trying to insert data into teradata tables through datastage parallel jobs. The job ran successfully and inserted data for the first time. after that when we tried to run it for the next time, it is aborting with the message - "unable to start Teradata multiload. Please refer to XXX.rpt ...
by mourya33
Thu Apr 09, 2009 2:54 am
Forum: General
Topic: Invalid Characters
Replies: 1
Views: 1490

Invalid Characters

Im receiving the folloing warning while running a parallel job which loads data into oracle database from an oracle database: main_program: Invalid character(s) ([xB0]) found converting string (code point(s): HOLD_TYPE_DESCRIPTION[x00][x00][x00][x00][x00][x00][x00][x00][x00][x00][x00][xB0][x09]![x08...
by mourya33
Fri Mar 20, 2009 4:46 am
Forum: General
Topic: How to capture error message of a job and send it in mail
Replies: 6
Views: 2799

How to capture error message of a job and send it in mail

We have a requirement to capture the error message of an aborted job and send the message by email. We need to capture the exact error message that is displayed in the director log. Please provide any inputs on this.


Thanks in advance
by mourya33
Fri Mar 20, 2009 4:07 am
Forum: General
Topic: appropriate use of exception handler stage
Replies: 2
Views: 3631

appropriate use of exception handler stage

We have a requirement of using the exception handler stage. We have a sequence of jobs and if any of the job fails, we have to capture the error message and error code and send a mail. We tried using the exception handler as it had parameters $ErrMessage and $ErrCode that can be used to pass in the ...
by mourya33
Fri Mar 20, 2009 4:03 am
Forum: General
Topic: how to pass the start timestamp of one job to another job
Replies: 5
Views: 2026

how to pass the start timestamp of one job to another job

we have a requirement of capturing the Start Timestamp of a job and pass it to a shared container after the target table is loaded, as the target stage is not supporting output (stream links), we have split the job into two. Now , we want to pass the Start Timestamp of Job 1 to the Job 2. Any pointe...