DSXchange

We have a job which is supposed to source data from a SQL Server table and create one Sequential file and one Dataset stage.

Job runs fine if we do not include the Dataset Stage.
If we include it keeps on running and the performance statistics shows that it is not pulling any data from the source.

The program runs fine in development. But we are having the problem in production environment. Apparently, I did not find any difference in environment setup.

Any help on this will be appreciated.

That is strange. As of now I cannot think of any reason it would happen. What is the longest amount of time you have let the job run? Does it eventually complete or give any errors or warnings? Can you do a test job #2 to read the file and write to a Data Set OK, or does it have the same problem?

We have tried to make a second job and run it. We had the same issue.

Have you tried a job with just a row generator writing into a dataset.
then another job reading that dataset into a peek.

Is this the only job that uses dataset in your project.
what about other jobs.

has this been happening only now or has it been happening from a long time.(begining of this datastage environment)

This was the only job that is using dataset stage. but it ran so many times before.

One question, what kind of configuratuion, I need to have to make dataset stage work. If I know that, So, I can look for the existence of that component.

Look at your APT file.

Go look at the "resource disk" settings. Ensure that the paths are valid, the space is sufficient and you have read/write authority to them.

I checked everything looks fine.

But it still does not work.

did you try creating a new job.
if this doesn't work. Then there is an issue for sure.

And you are saying that if you switch out the dataset stage to a PEEK stage or Seq File stage, the job runs fine?!?

What error/warning messages were logged?

Moved my post to separate topic

Are you using any unbounded string data types (Char or VarChar)?