DSXchange

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

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

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.

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

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

There are two buttons at the very top of any post you create, one marks the thread as Resolved and the other marks it as a Workaround.