Error executing View Data command in Parallel--##F TFPX 0000

vinodn · Post by **vinodn** » Mon Mar 17, 2008 2:55 am

I cannot able to view the data after loading in sequential stage or oracle stage in Parallel.But no problems with the server.It shows the following error.Please anyone kindly help me how to resolve this problem.

##I TOSH 000002 18:33:33(001) <main_program> orchgeneral: loaded
##I TOSH 000002 18:33:33(002) <main_program> orchsort: loaded
##I TOSH 000002 18:33:33(003) <main_program> orchstats: loaded
##W TCOS 000049 18:33:33(004) <main_program> Parameter specified but not used in flow: DSProjectMapName
##I TFSC 000001 18:33:33(009) <main_program> APT configuration file: D:/Ascential/DataStage/Configurations/default.apt
##W TFAR 000000 18:33:34(000) <main_program> File archive: Trouble creating file "/tmp/APTcs2468234c5ebf"
##F TFPX 000002 18:33:34(001) <main_program> Fatal Error: Null archive.

ArndW · Post by **ArndW** » Mon Mar 17, 2008 3:02 am

You APT_CONFIG_FILE specifies a UNIX pathname for the resource scratchdisk which doesn't exist on your windows machine.

hamzaqk · Post by **hamzaqk** » Mon Mar 17, 2008 3:15 am

the folder TMP should be present at the location, in your case D:\TMP. If not, Create a folder TMP at this location

vinodn · Post by **vinodn** » Mon Mar 17, 2008 3:34 am

Thanx for ur reply,

I created TMP file,But the problem can not resolved.
i am getting same error again,actually i installed datastage in F-Drive in Windows 2003 environment.
If any alternate process send me.

Thanks

Regards,
Vonid

vinodn · Post by **vinodn** » Mon Mar 17, 2008 3:41 am

Hi,

I created TMP Folder in F_drive because i installed datastage in that drive.
I dont know if the process is correct or wrong.Pls help me for this query.
How can i get temp file and how to create that File.

Thanks

ArndW · Post by **ArndW** » Mon Mar 17, 2008 3:52 am

I hope that your F:\ drive is local to the server. What does your APT_CONFIG_FILE read for the scratch path?

vinodn · Post by **vinodn** » Mon Mar 17, 2008 6:41 am

Hi ArndW,
This is the my default.apt file:
{
node "node1"
{
fastname "IITBOMBA-RCBGR8"
pools ""
resource disk "E:/Ascential/DataStage/Datasets" { pools "" }
resource scratchdisk "E:/Ascential/DataStage/Scratch" { pools "" }
}
}

ArndW · Post by **ArndW** » Mon Mar 17, 2008 7:35 am

Ok, does ""E:/Ascential/DataStage/Scratch"" exist and does your userid have RWD access to it?

ArndW · Post by **ArndW** » Mon Mar 17, 2008 7:42 am

I just realized that it is using "/TMP", this would be the value for the TEMP directory as specified in the uvconfig file. Try creating "C:\TMP" (use the correct case, just in case) and see if it works then. Either that, or change your uvconfig to point to a correct location.

vinodn · Post by **vinodn** » Tue Mar 18, 2008 10:59 am

Hi Arndw,

I tried for all the ways watever u told,but i will get same error agian.
Atlast i uninstall the software agian i installed in C-drive know its working
Fine.

Thanks for ur replies.

Regards,
Vinodn