Not able to View data from dataset
Moderators: chulett, rschirm, roy
Not able to View data from dataset
Hi,
We are trying to read data from a dataset in one project which gets created in other project and the "update policy" property is "Append".
When we read this dataset in our job, there are no records from that link.
Can somebody what could be the error?
Thanks in advance
Vij
We are trying to read data from a dataset in one project which gets created in other project and the "update policy" property is "Append".
When we read this dataset in our job, there are no records from that link.
Can somebody what could be the error?
Thanks in advance
Vij
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Why do you think there's an error? One possibility is that there are no rows in the Data Set. More likely, though, is that you are trying to read the Data Set with a configuration file that is incompatible with the one with which the Data Set was written. Can you access the Data Set with the Data Set Management utility in both projects?
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
use "orchadmin describe -c {dataset}" to get the APT_CONFIGuration from the dataset, then compare that with your dataset as used in the job.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
When I do "orchadmin describe -c {dataset name}", i am getting the following error:
##E TFPA 000021 $APT_CONFIG_FILE was not set, and config.apt was not found in the working directory or in $APT_ORCHHOME/etc.
##F TFCF 000009 Fatal Error: Cannot continue without a configuration file.
I tried for different datasets which are created and I can view the data also from the designer. But I am not sure why I am getting this error.
Some of the datasets I tried for has got $APT_Config_Fil parameter value assigned from the job and for some, we pass value from the unix script.
But the error is same, though the dataset exists and view data was also possible.
##E TFPA 000021 $APT_CONFIG_FILE was not set, and config.apt was not found in the working directory or in $APT_ORCHHOME/etc.
##F TFCF 000009 Fatal Error: Cannot continue without a configuration file.
I tried for different datasets which are created and I can view the data also from the designer. But I am not sure why I am getting this error.
Some of the datasets I tried for has got $APT_Config_Fil parameter value assigned from the job and for some, we pass value from the unix script.
But the error is same, though the dataset exists and view data was also possible.
When I do "orchadmin describe -c {dataset name}", i am getting the following error:
##E TFPA 000021 $APT_CONFIG_FILE was not set, and config.apt was not found in the working directory or in $APT_ORCHHOME/etc.
##F TFCF 000009 Fatal Error: Cannot continue without a configuration file.
I tried for different datasets which are created and I can view the data also from the designer. But I am not sure why I am getting this error.
Some of the datasets I tried for has got $APT_Config_Fil parameter value assigned from the job and for some, we pass value from the unix script.
But the error is same, though the dataset exists and view data was also possible.
##E TFPA 000021 $APT_CONFIG_FILE was not set, and config.apt was not found in the working directory or in $APT_ORCHHOME/etc.
##F TFCF 000009 Fatal Error: Cannot continue without a configuration file.
I tried for different datasets which are created and I can view the data also from the designer. But I am not sure why I am getting this error.
Some of the datasets I tried for has got $APT_Config_Fil parameter value assigned from the job and for some, we pass value from the unix script.
But the error is same, though the dataset exists and view data was also possible.
-
- Premium Member
- Posts: 783
- Joined: Mon Jan 16, 2006 10:17 pm
- Location: Sydney, Australia
Re: Not able to View data from dataset
Try to set the dataset to the sequence mode,then check if there are any rows.
vij wrote:Hi,
We are trying to read data from a dataset in one project which gets created in other project and the "update policy" property is "Append".
When we read this dataset in our job, there are no records from that link.
Can somebody what could be the error?
Thanks in advance
Vij
As mentioned earlier, you will need to set the UNIX env variables and also run the ". $DSHOME/dsenv" file. I am not at a datastage site right now, but I think that the Config file used to create the dataset is a different one from the active one. This command will display the APT_CONFIG settings used to create your dataset.vij wrote:When I do "orchadmin describe -c {dataset name}", i am getting the following error:
##E TFPA 000021 $APT_CONFIG_FILE was not set...
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>