copy stage is not working

syamv · Post by **syamv** » Mon Jan 08, 2007 1:35 pm

Hi,

I am pulling data from a sequential file and using copy stage to copy the data to another seq file ( I tried the dataset too). But the data is not copied to the out put file.I could see data in the first seq file and then from copy stage no data is pushed to the output file.

Program is not aborted.

Let me know if any body can help me with this.

Thanks,
SV

Krazykoolrohit · Post by **Krazykoolrohit** » Mon Jan 08, 2007 1:38 pm

did you see the logs in the director? any warnings there? i think your problem lies in the output sequential file. Copy stage is relatively easy to use with few settings

DSguru2B · Post by **DSguru2B** » Mon Jan 08, 2007 1:41 pm

Are you sure your looking at the correct sequential file/ data set?

Krazykoolrohit · Post by **Krazykoolrohit** » Mon Jan 08, 2007 1:50 pm

DSguru2B wrote:Are you sure your looking at the correct sequential file/ data set?

I think hes talking about not being able to see any rows progressed in the job.

You are right, He never said anything about the seeing data in second sequential file. I assumed he must have tried to see it

syamv · Post by **syamv** » Mon Jan 08, 2007 2:27 pm

I put the dataset file as out put now data is populated but not for the sequential file yet?. But I could not see the data statistics on the output link from the first seq file ---> copy ----> datatset file. AIn all other places I am able to see the no of rows processed on the link.

ray.wurlod · Post by **ray.wurlod** » Mon Jan 08, 2007 2:28 pm

Copy stage does not have the ability to drop rows. On what basis do you assert that "no data is pushed to the output file"?

Are there any "import failure" messages in the job log? Were any row counts reported?

syamv · Post by **syamv** » Mon Jan 08, 2007 2:50 pm

no there are no import failures and I could see the the empty file in unix directory.

Krazykoolrohit · Post by **Krazykoolrohit** » Mon Jan 08, 2007 2:52 pm

syamv wrote:I put the dataset file as out put now data is populated but not for the sequential file yet?. But I could not see the data statistics on the output link from the first seq file ---> copy ----> datatset file. AIn all other places I am able to see the no of rows processed on the link.

As i Said you must have had warnigns in manager. Please post them here.

Try and create same file manually(use touch command in unix) to see if you have right permissions on the folder (use the same user id to login to the server as you used to login to datastage).

kumar_s · Post by **kumar_s** » Mon Jan 08, 2007 4:51 pm

Check if you have columns been mapped to the second link.

Krazykoolrohit · Post by **Krazykoolrohit** » Tue Jan 09, 2007 12:58 pm

kumar_s wrote:Check if you have columns been mapped to the second link.

lolz

DSXchange