Issue with Dataset stage
Moderators: chulett, rschirm, roy
Issue with Dataset stage
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.
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.
ABHIJIT DUTTA
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?
Choose a job you love, and you will never have to work a day in your life. - Confucius
-
- Premium Member
- Posts: 258
- Joined: Tue Jul 04, 2006 10:35 pm
- Location: Toronto
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)
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)
Cheers,
Samyam
Samyam
-
- Premium Member
- Posts: 258
- Joined: Tue Jul 04, 2006 10:35 pm
- Location: Toronto
did you try creating a new job.
if this doesn't work. Then there is an issue for sure.
Code: Select all
rowgenerator---------10rows--------->dataset
Cheers,
Samyam
Samyam
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Premium Member
- Posts: 12
- Joined: Fri Jun 13, 2008 2:51 pm
Moved my post to separate topic
Last edited by John Corbin on Fri Jan 01, 2016 9:48 am, edited 1 time in total.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: