Not able to read from Dataset
Posted: Mon Jul 05, 2004 8:53 am
We are writing to a Dataset from job1, but we are not able to read from it in job2. We get a message "Null value in <field> which is not null". When we make the nullability of the column to 'Yes', it fetches data, however there are no null values in this date field.
Another interesting thing is that job1 fetches data when we do 'View data' on an input link writing to Dataset, but gives an error when we change the link from input to output.
Different options that we have tried out unsuccessfully include
1.creating a new Dataset and using it in a different job.
2.copying the Stage, Dataset and pasting it in a different job and trying to read data from it.
This happens in only a few cases where we are writing and reading from datasets. And quite erraticaly as well. Any idea what the issue could be?
Another interesting thing is that job1 fetches data when we do 'View data' on an input link writing to Dataset, but gives an error when we change the link from input to output.
Different options that we have tried out unsuccessfully include
1.creating a new Dataset and using it in a different job.
2.copying the Stage, Dataset and pasting it in a different job and trying to read data from it.
This happens in only a few cases where we are writing and reading from datasets. And quite erraticaly as well. Any idea what the issue could be?