Some files never getting transferred to our FTP Server

Advertisement

We are moving configuration changes from one instance to another using 'Manage Implementation Projects' functionality. This PeopleTools functionality creates DM scripts to transfer functionality like Billing, Contracts, etc to another instance when you click 'Export'
It is supposed to send the scripts to 'FTP Server > psdata > PSFILEDIR' on a Windows system in Financials 9.1 using PT 8.53.04. We constantly get a 'Permission Denied' from this process when trying to do this.
This problem happens in all DEV instances, yet the process works fine  in the Prod instance. I have examined the permissions in the PSFILEDIR and compared them in DEV and PROD and find no differences

Advertisement

I guess you didn't like my last answer.  So I'll try again.  First off, forget FTP.  We don't even care about FTP and adding it to the Title of the question just confuses things and maybe gets you less responses.  In production, does this open a Dialog box/Save window when the  export finishes?
My assumption is that you have the variable PS_FILEDIR set to \\s-wpstbftp1\s$\psdata\PSFILEDIR for the app server.  Is that true?
You are failing on line 10 which is
&PROJECT_FILE = GetFile(&FILENAME, "W", %FilePath_Relative);
The PSAPPSRV process is trying to open a file in write mode.  It's using Relative Path which appends &FILENAME to the path which is determined by either PS_FILEDIR or PS_SERVDIR.  This part of the code is not even the part where the file is supposed to be placed at a final destination.  This is very initial step in creating the file, nothing is being written yet.  The PSAPPSRV process at this point knows nothing about FTP or other network transfer protocols, it simply knows that it should use \\s-wpstbftp1\s$\psdata\PSFILEDIR as the path. To the PSAPPSRV process this is a path that is locally available on the server,wWhen the system call comes through to the OS to attempt to open this file, the operating system is what allows this to seamlessly connect to a network resource.
There are two potential points where for this and they both relate to the user running the PSAPPSRV process.
You are using the Admin share for the S: drive on s-wpstbftp1.  This means any connection to this PATH must be made as a user that is an Administrator on server s-wpstbftp1.
The PSAPPSRV processes must be running as a user that is an Administrator on the other server.  This requires configuring the Oracle ProcMGR Windows service to run as a user that has access to the resources in question.
So to fix this you need to look at the ProcMGR service and set it to run as an Administrator user from s-wpstbftp1.  This may require additional tasks such as setting up that user on the PeopleSoft server.  Use task manager to look at what user is running the PSAPPSRV processes and make sure it's the user you need it to be.
In my humble opinion though, this is bad configuration:
You shouldn't be using Admin shares
I don't like relying on remote server paths that aren't redundant storage devices (NAS or SAN).  What if this server is down and other processes need to use this path?
You appear to be expecting this file at a location where it is created for further processing by the code, not the final destination.  The file is intended to be downloaded by the user.  I don't know why the developer decided to leave the file on the file system, but they may decide to clean up after themselves or change how this works in the future.  The file is created, inserted into the database, then read from the database, sent to the user, and deleted from the database.  The code calls DetachAttachment which the PeopleCode Language Reference book says:
Use the DetachAttachment function to download a file from its source storage location and save it locally on the end-user machine. The file is sent to the browser with appropriate HTTP headers to cause the browser to display a save dialog box to the user.

November 30, -0001

Some files never getting transferred to our FTP Server

We are moving configuration changes from one instance to another using 'Manage Implementation Projects' functionality. This PeopleTools functionality creates DM scripts to transfer functionality like Billing, Contracts, etc to another instance when y

I get this error message when I save some files "sty is null"

When I try to save some files I get an error message that says Unable to initialize the UI, sty is null. It happens mostly when saving files to an Aaptorefromtdotnet e commerce web site. If I click OK either it file saves or I get a second error mess

Receiver-File-Adatper creates empty files on FTP-Server

Hi experts, I have a problem with my IDOC-to-File-scenario. My Mapping converts IDOCs to XML-files. Then the xml-files should be send to a ftp-server in New York. but only the filename is created on the ftp-server in New York. but without any content

Java code to create a new .txt file in FTP server  --- Help

Hi, I wrote a standalone java app which creates a .txt file in my local machine and transfers it to FTP server. But my requirement now is to create a new .txt file with the same content in FTP server itself instead of creating locally with basic java

OBPM4 file path to FTP server

Hi Friends, I have a requirement. For the payment in F110, the output file should be moved to the FTP server. For that, i need to provide the FTP path to the OBPM4 tcode. My doubt is if we try to connect to FTP server, we need to provide the login de

FTP server file path

Hi Experts, I need to place the file in "C:/CacheSys/PI" in FTP server. what is the target directory i must specify in Communication channel. Kind Regards, kiranHi you can use the same name in the target directory. but the folder that you create

How to use 2 FTP Server in ALSB 3.0

We want to provide ftp tunneling functionality to any Billing System for ftping files to Payment Gateway System.For this we have one FTP server at Billing System and another FTP server at Payment gateway.We first need to pick the file from File Syste

Ftp to a local ftp server doesn't work for VIREX 7.7

Has anyone else experienced this and know of a work-around? I have mac 10.3.9 machines not connected to the internet and running Virex 7.7. I have them setup to access signature files I download to a local ftp server on our subnet. This works fine. W

I take a .NEF file and a .JPG file with every click. When I transfer the files using a flash drive to another computer I never get all of the files to transfer. I get some of the .NEF and some of the .JPGs but not all

I take a .NEF file and a .JPG file with every click. When I transfer the files using a flash drive to another computer I never get all of the files to transfer. I get some of the .NEF and some of the .JPGs but not all. How come?If you're exporting a

Some files in "DOCUMENTS" icon in dock won't open. Get msg saying You need a newer version of Pages to open this document." Have Pages 4.1 installed.  Same files will open ok from Finder, Pages App. Recently sync'd with ipad2 (Pages) after iOS5 installed.

Some files in "DOCUMENTS" icon in dock won't open. Get msg saying "You need a newer version of Pages to open this document." Already have Pages 4.1 installed.  Same files will open ok from Finder/Pages App./selected file. Prob not note

Ikeep getting a message that my start up disc is full and i don't know how to free up space..  also when i o to download some files i am told there is no space left to download     i bought this macbook pro used an receiver no discs..  what can i do??   t

ikeep getting a message that my start up disc is full and i don't know how to free up space..  also when i o to download some files i am told there is no space left to download     i bought this macbook pro used an receiver no discs..  what can i do?

I am not able to download ITunes. I had some problems with ITunes and had to uninstall but now when I reinstall iTunes after I click on download iTunes and save the File, I get this message"Thank you for downloading iTunes" and nothing else happens. I don

I had some problems with ITunes and had to uninstall but now when I reinstall iTunes after I click on download iTunes and save the File, I get this message"Thank you for downloading iTunes" and nothing else happens. I don't see any thing else. N

HT1492 Hmm, I was deleting some files last night and when I came to booting up this morning my Macbookpro (5 years old) i was greeted with a user login screen? put in my password, but all i get is the space screen and no further action...? cant get apps o

mm, I was deleting some files last night and when I came to booting up this morning my Macbookpro (5 years old) i was greeted with a user login screen? put in my password, but all i get is the space screen and no further action...? cant get apps o my

File not getting picked up by the FTP Adapter.............URGENT

Hi Experts, I have created simple File to File scenario to archive a xml file of size 640 MB with in a FTP server. I monitored the channel for 2 hrs, it started but didn't picked the source file. Is it because of the huge file size? Please give your

Reading and transfering FTP server files

Hi Everybody, I will be really thankful if anybody can guide me for following- 1. How to read/access a file on FTP server ? 2.How file on FTP sever can be downloaded on presentation server? Thanks.Hi , Check Function Group SFTP from se80. Check this

Will I never get BT Infinty?

Hi, I've been looking forward to getting BT Infinity for quite some time now (after our connection speed having being a terrible 1.1mb, even though BT said we could get 2.5mb) and I've been watching the Infinity checker like a hawk to see when we can

Writting attached file from SOAP message to a FTP folder

Hi everybody, Our scenario is an interface which receives a SOAP message with a file attached. As we don't need to do any mapping into the attachment, we are supposed to deliver that file as it is into a FTP folder. Our problem is that we cannot find

Reading a file from ftp server

Hi I am able to put file on ftp server using ftp adapter.But same settings are not working while polling file on ftp. Do i need to do some settings for get operation??Hi, Check the file permissions and for testing give all read/write/execute permissi

How to attatchment some files that are in other server to send an email?

Hi I need to send an enmail with sql, but i have to attatchment some files, those files are in anohter server, so I want to know, how attatchment those files?  Thanks in advance Yeah, I don't know if you can attach a file on a remote server.  Why not

"..cannot be partitioned because some files cannot be moved."

So here's what happened.. I had WinXP SP2 running on a 20GB partition with my leopard on the other. I needed a little more space on my XP partition, so I erased the partition so I could create another. However, when I try to create a 30GB partition,