DSXchange

Could anyone help me....

thanks.

In the target table, the key is "water_id", and the SQL statement is as follow: UPDATE bisbas.dbo.cus_water_main SET water_id=?,custom_id=?,big=?,mid=?,use=?,....... WHERE water_id=?; INSERT INTO bisbas.dbo.cus_water_main (water_id,custom_id,big,mid,use,......) VALUES (?,?,?,?,?,?......); ...

In the job, source stages and target stage are all SYBASEOC stage. There are three tables: 1.the source table, named "master_mstr", the table definition is create table master_mstr ( big char(1) not null, mid char(2) not null, useno char(7) not null, ...... constraint pk_master_mstr primar...

the error log message: Sybase Server message 3621 (severity 10) from stored procedure 'Input_1', line 1: Command has been aborted. At row 36844, link "DSLink2" Sybase Server warning 2601 (severity 14) from stored procedure 'Input_1', line 1: Attempt to insert duplicate key row in object 'c...

It is urgent to resolve, so I have recompiled the job and run OK.
Now, I can't reset it and can not get the reset messages.

This error happened first time.
It run OK all the previous run.

Hi, Chulett,

Excuse me, I don't catch your meaning.

Is your meaning that I post the previous run log of the job to you.

Thanks

Atan Chen

Email: atan003@163.com
MSN: atan003@163.com
Skype: atan003

Abnormal termination of a Stored Procedure stage When a sequence called a job (Allow Multiple Instance, and named "sp_make_id") to execute a stored procedure, it is aborted with log message "Abnormal termination of stage sp_make_id.account.sp_etl_makeId detected" Could anyone tel...

I called dsjob.exe to run a job, and return error code 81015.
what is wrong?
can you help me?

thanks!

Thank you very much.

the sequence log is : ------------------------- 11:53:30: StartLoop_Activity_dailbigX_btm_source loop iteration 4 started 11:53:30: dailbigX_to_btm_source_main_prev6 (JOB dailbigX_to_btm_source_main_prev6) started 11:54:29: Exception raised: @dailbigX_to_btm_source_main_prev6, Error calling DSRunJob...

I run it OK at the first time, and failed when I run it again.

when it run failed, I recompiled the job again, then try again, but it is failed.

There have an error in sequence:
Exception raised: @job1, Error calling DSRunJob(job1), code=-99 [General repository interface 'other error']

Can you help me?

Yes, and it is OK.

Thanks.

Hi, There have 29 jobs and an User Variable Activity in the server job. When I compiled, it was failed with a message as following: "Error calling subroutine: DSR_RECORD (Action=2); check DataStage is set up correctly in project BISETL (Internal Error (81021))" But I don't know what is wro...