Hi,
My o.s is windows xp,datastage version is :7.5x2.
I created the simple job which take the data from sequential file and it copies to target sequential file.It was compiling well.But it was not running and was aborted.
I am getting the error when i view the data in sequential file.
>##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.
For this job i am passing the parameters.I went and checked in Administrator for the location of configuration file,it was set to default.apt.
In director i got the error as "main_program: File archive: Trouble creating file "/tmp/APTcs9752481310b8",main_program: Fatal Error: Null archive."
Could u please look into this issue?
Cheers,
ds
Error in Viewing the data
Moderators: chulett, rschirm, roy
Re: Error in Viewing the data
There could be 2 possibilities...
There might be something wrong on specifying apt config file..
did u specify the parameter as $PROJDEF or something else
Try to give the whole server path where your config file resides.
the "trouble Creating file" error may occur if you don't have sufficient permission on the Project..
check your Rights on the Project..you may not be able to execute it..
Edi
There might be something wrong on specifying apt config file..
did u specify the parameter as $PROJDEF or something else
Try to give the whole server path where your config file resides.
the "trouble Creating file" error may occur if you don't have sufficient permission on the Project..
check your Rights on the Project..you may not be able to execute it..
Edi
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
APT_CONFIG_FILE was not set. What could be clearer?
Bring $APT_CONFIG_FILE into your job as a job parameter, set its default value to $PROJDEF. Make sure that the pathname given for this environment variable in the Administrator client is valid.
To test, use a hard-coded pathname in the job parameter's default value.
Bring $APT_CONFIG_FILE into your job as a job parameter, set its default value to $PROJDEF. Make sure that the pathname given for this environment variable in the Administrator client is valid.
To test, use a hard-coded pathname in the job parameter's default value.
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.
Details of parameters
Hi all,
I went and check in the properties for the paramter name,everything was set as u suggested.I am giving the details of parameters,if anything i am missing please let me know?
In the director i am getting the error as
main_program: File archive: Trouble creating file "/tmp/APTcs4084b81a0771"
main_program: Fatal Error: Null archive.
In the sequential file if i view the data it was throwing the error as
##I TOSH 000002 09:17:24(001) <main_program> orchgeneral: loaded
##I TOSH 000002 09:17:24(002) <main_program> orchsort: loaded
##I TOSH 000002 09:17:24(003) <main_program> orchstats: loaded
##W TCOS 000049 09:17:24(004) <main_program> Parameter specified but not used in flow: Targetdirectory
##W TCOS 000049 09:17:24(005) <main_program> Parameter specified but not used in flow: CDR_DIR
##W TCOS 000049 09:17:24(006) <main_program> Parameter specified but not used in flow: Sourcefile
##W TCOS 000049 09:17:24(007) <main_program> Parameter specified but not used in flow: _PWD
##W TCOS 000049 09:17:24(008) <main_program> Parameter specified but not used in flow: _APT_CONFIG_FILE
##W TCOS 000049 09:17:24(009) <main_program> Parameter specified but not used in flow: _APT_ORCHHOME
##W TCOS 000049 09:17:24(010) <main_program> Parameter specified but not used in flow: Targetfile
##W TCOS 000049 09:17:24(011) <main_program> Parameter specified but not used in flow: Sourcedirectory
##W TCOS 000049 09:17:24(012) <main_program> Parameter specified but not used in flow: DSProjectMapName
##I TFSC 000001 09:17:25(002) <main_program> APT configuration file: F:/Configurations/default.apt
sed: not found
print: F:/PXEngine/etc/vsvars32.ksh 69: F:/PXEngine/etc/standalone.sh: writing: The pipe is being closed.
##W TFAR 000000 09:17:28(000) <main_program> File archive: Trouble creating file "/tmp/APTcs4932b6722719"
>##F TFPX 000002 09:17:28(001) <main_program> Fatal Error: Null archive.
My parameters are:
Targetdirectory Enter the targetpath pathname f:\Datastage Targets
CDR_DIR Value string $PROJDEF
Sourcefile Enter the sourcefile string data.txt
$PWD Directory String $PROJDEF
$APT_CONFIG_FILE Configurationfile pathname $PROJDEF
$APT_ORCHHOME Parallelhomedirectory pathname $PROJDEF
Targetfile Enter the targetfilename string para.txt
Sourcedirectory Enter the sourcepath path f:\Datastage Source
In the Administrator my configuration file value is f:/Configurations/default.apt
Kindly let me know if anything is missing?
Cheers,
ds
I went and check in the properties for the paramter name,everything was set as u suggested.I am giving the details of parameters,if anything i am missing please let me know?
In the director i am getting the error as
main_program: File archive: Trouble creating file "/tmp/APTcs4084b81a0771"
main_program: Fatal Error: Null archive.
In the sequential file if i view the data it was throwing the error as
##I TOSH 000002 09:17:24(001) <main_program> orchgeneral: loaded
##I TOSH 000002 09:17:24(002) <main_program> orchsort: loaded
##I TOSH 000002 09:17:24(003) <main_program> orchstats: loaded
##W TCOS 000049 09:17:24(004) <main_program> Parameter specified but not used in flow: Targetdirectory
##W TCOS 000049 09:17:24(005) <main_program> Parameter specified but not used in flow: CDR_DIR
##W TCOS 000049 09:17:24(006) <main_program> Parameter specified but not used in flow: Sourcefile
##W TCOS 000049 09:17:24(007) <main_program> Parameter specified but not used in flow: _PWD
##W TCOS 000049 09:17:24(008) <main_program> Parameter specified but not used in flow: _APT_CONFIG_FILE
##W TCOS 000049 09:17:24(009) <main_program> Parameter specified but not used in flow: _APT_ORCHHOME
##W TCOS 000049 09:17:24(010) <main_program> Parameter specified but not used in flow: Targetfile
##W TCOS 000049 09:17:24(011) <main_program> Parameter specified but not used in flow: Sourcedirectory
##W TCOS 000049 09:17:24(012) <main_program> Parameter specified but not used in flow: DSProjectMapName
##I TFSC 000001 09:17:25(002) <main_program> APT configuration file: F:/Configurations/default.apt
sed: not found
print: F:/PXEngine/etc/vsvars32.ksh 69: F:/PXEngine/etc/standalone.sh: writing: The pipe is being closed.
##W TFAR 000000 09:17:28(000) <main_program> File archive: Trouble creating file "/tmp/APTcs4932b6722719"
>##F TFPX 000002 09:17:28(001) <main_program> Fatal Error: Null archive.
My parameters are:
Targetdirectory Enter the targetpath pathname f:\Datastage Targets
CDR_DIR Value string $PROJDEF
Sourcefile Enter the sourcefile string data.txt
$PWD Directory String $PROJDEF
$APT_CONFIG_FILE Configurationfile pathname $PROJDEF
$APT_ORCHHOME Parallelhomedirectory pathname $PROJDEF
Targetfile Enter the targetfilename string para.txt
Sourcedirectory Enter the sourcepath path f:\Datastage Source
In the Administrator my configuration file value is f:/Configurations/default.apt
Kindly let me know if anything is missing?
Cheers,
ds
Hi all,
Thank you very much for all.I resolve the issue with the help of following thread in our forum by using search.
viewtopic.php?t=102175&highlight=Datast ... +Interface
Once again thank you very much for all,for giving this kind of valuable help by spending your valuable time to solve these type of issues.It was really appreciable.
Kindly let me know how to put this issue as resolved one?
Cheers,
ds_sai
Thank you very much for all.I resolve the issue with the help of following thread in our forum by using search.
viewtopic.php?t=102175&highlight=Datast ... +Interface
Once again thank you very much for all,for giving this kind of valuable help by spending your valuable time to solve these type of issues.It was really appreciable.
Kindly let me know how to put this issue as resolved one?
Cheers,
ds_sai