DSXchange

I faced the same issue and tried the command provided by Ray. The output says,

Active Record Locks:
Abnormal termination of DataStage.
Fault type is 13. Layer type is Unknown.


Any solution?

I am guessing it is something introduced in 8x. What do you think, Ray?

May be. But the problem here is how to get the row count. The log has the orchestrate, configuration details and also the peek values but doesn't have any information on the row count. This is job is not writing to any file/DS/tables. It just has peek stages as the final output. Is this the reason w...

In the job log I can see all the details except for the no. of rows processed.

Is there a way I can take the count of the links from my previous run of a job? The job was run again yesterday after 1 month and the -linkinfo is giving me the count of the recent most run. Also there is no information on the row count from the logs.

the exit status is 1.

Sequencer Log ---------------- JobScr1..JobControl (@Execute_Command_31): Executed: /data/user/prod/script/run_j1.ksh Reply=1 Output from command ====> JobScr1..JobControl (@Execute_Command_31): Command /data/user/prod/script/run_j1.ksh did not finish OK, reply = '1' Unix Log ---------- Function cre...

Hi,
I am triggering a UNIX script from my sequencer using the execute command activity but it is failing with a return code of 127. But when I run this script manually from the command line it runs successfully. Any ideas why it is failing thru sequencer?

Yes, I think the job got exported successfully. I can see the code and logic.

I am trying to export few jobs from 1 project into import it back into another. But no job is getting imported. There is a message coming up saying that

'The job 'job name' cannot be found in repository.

Any idea what can be the issue?

Thanks for your help. The command which I mentioned in the last post is successfully executing now. There was an access issue for that. I was wondering if anyone can help me in executing the same command thru a Command Activity Stage thru sequencer. Command: Parameters: What do I put in above 2 cols...

Yeah. I tried the following,


begin schema.stored_procedure_name(parameter); end;

Error- Fatal Error: Invalid close command

Hi, I want to execute a stored procedure as soon as I load the data in a table thru Oracle Enterprise Stage thru Load-Append method. I tried using the close command and after sub-routine options also. None of them is working. I tried using EXEC and CALL options in Close command. Any help on this is ...

Hi, I have a job which is extracting data from an Oracle table using Oracle Enterprise stage and loading into another table using the load append method using an enterprise stage again. I want to invoke an Oracle stored procedure as soon as the load is complete in the same job. I can't use the Store...

Thanks for the updates. I just checked the link which Chulett provided and it helped me in getting the commit size to 10000. I am still exploring other possibilities of tuning my job further as it is taking huge amount of time.