DSXchange

Run stopped after 100 rows can only be caused by one thing; when the job run request is issued, a limit of 100 rows is imposed. Check the Limits tab on your Job Run Options dialog. ... No limit is set. It is very werid that when I run the batch from the designer, there is no problem. But when I run...

Run stopped after 100 rows can only be caused by one thing; when the job run request is issued, a limit of 100 rows is imposed. Check the Limits tab on your Job Run Options dialog. ... I will check the Run Options when I get back office tomorrow morning. But I run the sequence job from the director...

Hello, I have a job likes the following Source Stage -> TFM ---->(link1) Delete From Table 1(OCI Stage) -----> (link 2) Insert into Table 1(OCI Stage) I knows that the rows per transaction setting has big impact on the performance. Setting to 1 is much slower than setting it to 0. My question is if ...

I seperate the job into 2 jobs. A simple job loading from hashed file to Oracle table. I got the following log today:
Run stopped after 100 rows

No warning.

Just occasionally. But It happened today and last week.

ArndW wrote:Also, do you re-create the hashed file each run or append to it? Is the error visible on each run or just occasionally? Do other jobs use the same hashed file? If you turn off buffering on the write d ...

The file is used only in one job. File is recreated every job run. No write cache is used.

ArndW wrote:Also, do you re-create the hashed file each run or append to it? Is the error visible on each run or just occasionally? Do other jobs use the same hashed file? If you turn off buffering on the write d ...

No constraint used. The hashed file stage is used only for removing duplicate records.

ArndW wrote:Do you have a SELECT on your hashed file read or any warnings in the log file? ...

Thanks Ray. There is no warning.

ray.wurlod wrote:Look in the job log for Oracle warnings.

It's hashed file, not hash file. ...

No eror. only 100 rows went into OCI stage but has 10000 rows in the hash file

ArndW wrote:How many rows went "into" the OCI stage - perhaps you are getting insert errors due to constraints. Add a reject link in the job to ensure that this isn't causing your dropped records. ...

I have a job like this Folder stage -> XML stage -> Hash File stage(with input and output on the same file) -> OCI The reason I use Hash file stage is to remove duplicate data. Most of times it works fine and I have used a lot in my jobs with a hash file stage having input and output link for the sa...

I have the same lock issue. Most of the times it works fine. But sometimes it just hangs there waiting for lock to release. I am wondering if array size afffects the locks. Currently my array size is larger than 0 and rows per transaction are all set to 1. Thanks in advance. Hi , While doing Update/...

I have a bunch of records to be inserted into an informix database. But before the insertion, I need to call a stored procedure to generate an id and add the id to the records. Of course, each record will have a different id. How can I get this done? Thanks in advance for your help. I have not work...

Thanks all. I will try Kim's suggestion. But I am not sure if my Datastage admin will allow me to deploy some third party components to the production server. I will look into this first. Craig's method does not suit me because it will send out too many emails in one schedule run and I prefer to sen...

Hello, I have many jobs, including sequence jobs, in my projects. There are 4 layers of sequence jobs, that is one sequence calls other sequences and call call other sequences. If job failed in any of jobs down the road, I want to mail the user the reason of the failure in the top layer of sequence ...

Hi everybody, My objective is that i have to call Sqlplus statement using User & Pwd, once logged in i have to execute Pl/Sql procedure from that. For this I have called a script in before job subroutine which takes UserId,Pwd,Schema,Dsn & Date as parameter.this script actually calls sqlplu...