Appian Community
Site
Search
Sign In/Register
Site
Search
User
DISCUSS
LEARN
SUCCESS
SUPPORT
Documentation
AppMarket
More
Cancel
I'm looking for ...
State
Not Answered
Replies
12 replies
Subscribers
5 subscribers
Views
5263 views
Users
0 members are here
Share
More
Cancel
Related Discussions
Home
»
Discussions
»
Plug-Ins
We are using the Receive File Over FTP plug in to grab a .txt file. We configure
colleeny
Certified Associate Developer
over 10 years ago
We are using the Receive File Over FTP plug in to grab a .txt file. We configured the username and password in the third party credentials and tried running the process and did not receive any errors and did not get the file as well. What steps do we need to take to receive error codes when running the proccess?
OriginalPostID-138403
OriginalPostID-138403
Discussion posts and replies are publicly visible
0
Sathya Srinivasan
Appian Employee
over 10 years ago
These plugins need the credentials passed in as a part of their parameter. Try adding them to the data input of these plugins to see if that resolves the issue. A good suggestion for this, as you mentioned, is to modify these plugins to. Use third party credential store.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
colleeny
Certified Associate Developer
over 10 years ago
Yes Sathya all the data inputs that are required have been entered. Modify these plug-ins how?
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
colleeny
Certified Associate Developer
over 10 years ago
External System Key: ="ftp.credential"
Use Per User Credentials: False
Server Hostname: ="10.60.67.209"
Server Port: =21
Remote File URL: ="\\"
(I've also tried putting the .txt file name in the remote file URL)
After running the process, I do not get any status or error codes. I'm wondering if anyone else had this issue.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
Sathya Srinivasan
Appian Employee
over 10 years ago
I didn't realise that the plugin in was already using third party credential store. In that case, can you check the ftp log to find out if you are getting a connection attempt from Appian into your ftp server?
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
colleeny
Certified Associate Developer
over 10 years ago
Hmm... The only thing I see regarding to FTP is
15:47:48,897 INFO [stdout] (Appian Work Item - 1056 - ProcessExec01 : UnattendedJavaActivityRequest) 2015-02-13 15:47:48,896 [Appian Work Item - 1056 - ProcessExec01 : UnattendedJavaActivityRequest] ERROR com.appian.ps.plugins.sftpsmartservices.ReceiveFileOverFTP - Error getting message for code missing.scs.field from bundle SFTPSmartServices.ReceiveFileOverFTP15:47:48,898 INFO [stdout] (Appian Work Item - 1056 - ProcessExec01 : UnattendedJavaActivityRequest) java.util.MissingResourceException: Can't find bundle for base name SFTPSmartServices.ReceiveFileOverFTP, locale en_US
(But this was before I even configured and ran the FTP process!) ... Could you help me decypher this error?
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
Sathya Srinivasan
Appian Employee
over 10 years ago
Have you tried enabling debug on the plugins ( debug is added to Appian_log4j.properties under resources directory) and checked the log for details?
Also, have you checked that the ftp is able to establish a connection and fetch information from the server. You can install a simple ftp client such as FileZilla or something similar to make sure there are no connection restrictions in place between the two.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
colleeny
Certified Associate Developer
over 10 years ago
Yes, I was able to check the ftp and establish a connection and get information from the server using command prompt and filezilla.
Could you give me more directions on enabling debug on the plug in? Is there another file I ened to add under _admin/plugins
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
Sathya Srinivasan
Appian Employee
over 10 years ago
See the section titled Customizing logging
forum.appian.com/.../Customizing_Application_Logging.html
You need to add appenders for the class within the plug-in.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
colleeny
Certified Associate Developer
over 10 years ago
###### Default
log4j.rootLogger=ERROR, CONSOLE, APPLICATION_SERVER, SFTPSMARTSERVICE
#log4j.debug=true
###### SFTPSMARTSERVICE appender
log4j.appender.SFTPSMARTSERVICE.layout=com.appian.ps.plugins.sftpsmartservices.ReceiveFileOverFTP
log4j.appender.SFTPSMARTSERVICE.layout.ConversionPattern=%d{ABSOLUTE} %-5p [%c{1}] %m%n
log4j.appender.SFTPSMARTSERVICE=org.apache.log4j.RollingFileAppender
log4j.appender.SFTPSMARTSERVICE.File=${AE_LOGS}/sftp_logs.log
log4j.appender.SFTPSMARTSERVICE.MaxFileSize=10MB
log4j.appender.SFTPSMARTSERVICE.MaxBackupIndex=<b>1000</b>
###### 3rd-Party Loggers
log4j.logger.org.apache=ERROR
log4j.logger.org.apache.struts.action.ActionServlet=ERROR
log4j.logger.org.jboss=INFO
added this to the Appian_log4j.properties and ran the process and did not see anything in the log. Is there an issue with the appenders?
sftp_logs.log
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
colleeny
Certified Associate Developer
over 10 years ago
correction*
enabled log4.j.debug = true (not commented out)
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
>