Troubleshooting
Problem
Attempts to use any SFTP commands after successfully logging on to the WPG Integrated SFTP server result in a "Permission Denied" error.
Symptom
If customer uses WPG SFTP client or a different SFTP client they can successfully log on to the WPG Integrated server but a "Permission Denied" error occurs if any SFTP commands are run.
Cause
The drive letter in the root directory path was in lowercase
Diagnosing The Problem
When reviewing the sftp.log located under \<sftp server installed path>\conf\log see the following error:
[03/13/12 20:39:03] source=com.ibm.bcg.sshd.sftp.common.SFTPUtils thread=[Thread-7] Creating Error Response. requestId = 256 errorCode = 3 msg = Permission Denied
K:/WPG/Common/Model/ftp/data/conf/<username>/Documents
In the WPG console for property bcg.ftp.config.rootdirectory located under System Administration > FTP Administration > Other Properties the value is k:/WPG/Common/Model/ftp/data
The difference in the root directory values is the case of the drive letter.
Resolving The Problem
When setting up FTP/SFTP Integrated Server please use the appropriate case (upper/lower) to indicate the correct path for property bcg.ftp.config.rootdirectory
In this specific problem when attempting to change the lower case "k" to a upper case "K" for property bcg.ftp.config.rootdirectory the customer changed just the letter and saved the value (ie K:/WPG/Common/Model/ftp/data), but the value changed back to the lowercase "k". It was observed that a single letter case value could not be changed.
In cases that this problem could occur there are two workarounds:
1) From the WPG console navigate to property bcg.ftp.config.rootdirectory and change the value, for example if value is "k:/WPG/Common/Model/ftp/data" simply drop the "data" and save, then edit again and make the appropriate changes that may include changing the case of 1 or more letters.
2) Follow the instructions to use the database command below, this is for DB2 only:
a. Stop FTP management server
b. Connect to application DB (ie db2 connect to <database name> user password)
c. Run the command below:
db2 "update db_sysproperties set PROPVALUE='K:/WPG/Common/Model/ftp/data' where
PROPNAME='bcg.ftp.config.rootdirectory'"
db2 commit
Was this topic helpful?
Document Information
Modified date:
16 June 2018
UID
swg21591620