Issue with Dataset stage

anajitKS · Post by **anajitKS** » Wed Dec 16, 2015 11:53 am

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.

qt_ky · Post by **qt_ky** » Wed Dec 16, 2015 2:59 pm

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?

anajitKS · Post by **anajitKS** » Wed Dec 16, 2015 3:27 pm

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

samyamkrishna · Post by **samyamkrishna** » Wed Dec 16, 2015 3:37 pm

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)

anajitKS · Post by **anajitKS** » Wed Dec 16, 2015 4:17 pm

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.

PaulVL · Post by **PaulVL** » Wed Dec 16, 2015 4:23 pm

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.

anajitKS · Post by **anajitKS** » Thu Dec 17, 2015 3:34 pm

I checked everything looks fine.

But it still does not work.

samyamkrishna · Post by **samyamkrishna** » Thu Dec 17, 2015 3:38 pm

did you try creating a new job.

Code: Select all

rowgenerator---------10rows--------->dataset

if this doesn't work. Then there is an issue for sure.

PaulVL · Post by **PaulVL** » Fri Dec 18, 2015 9:58 am

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

ray.wurlod · Post by **ray.wurlod** » Sat Dec 19, 2015 12:18 am

What error/warning messages were logged?

John Corbin · Post by **John Corbin** » Wed Dec 30, 2015 8:34 am

Moved my post to separate topic

ray.wurlod · Post by **ray.wurlod** » Fri Jan 01, 2016 1:25 am

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