ASG
IBM
Zystems
Cressida
Icon
Netflexity
 
  MQSeries.net
Search  Search       Tech Exchange      Education      Certifications      Library      Info Center      SupportPacs      LinkedIn  Search  Search                                                                   FAQ  FAQ   Usergroups  Usergroups
 
Register  ::  Log in Log in to check your private messages
 
RSS Feed - WebSphere MQ Support RSS Feed - Message Broker Support

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » Issue with SFTP

Post new topic  Reply to topic
 Issue with SFTP « View previous topic :: View next topic » 
Author Message
HJaber
PostPosted: Wed Mar 15, 2023 4:53 am    Post subject: Issue with SFTP Reply with quote

Newbie

Joined: 04 Aug 2022
Posts: 6
Hi,
I have a flow which should store a report on a file system through SFTP; all the processes of configuration the SFTP are made successfully and I test it by run several SFTP commands i.e. (sftp mqm@1.2.3.4:/TestMount/)

Then I execute the following command to create the security Identity: (mqsisetdbparms BrokerName -n sftp::ftpBroker -u mqm -i /var/mqm/public.pub -r Password )
Then I put the security Identity name "ftpBroker" on the configuration for the FTP inside the FileOutputNode beside the name of the base directory name and directory name
But I got the following Exception list all the time... So anyone could tell me what I missed or whats wrong with my processes?

ExceptionList
RecoverableException
File:CHARACTER:/build/S1000_slot1/S1000_P/src/DataFlowEngine/MessageServices/ImbDataFlowNode.cpp
Line:INTEGER:1251
Function:CHARACTER:ImbDataFlowNode::createExceptionList
Type:CHARACTER:ComIbmTryCatchNode
Name:CHARACTER:Test#FCMComposite_1_15
Label:CHARACTER:Test.Try Catch
Catalog:CHARACTER:BIPmsgs
Severity:INTEGER:3
Number:INTEGER:2230
Text:CHARACTER:Node throwing exception
Insert
Type:INTEGER:14
Text:CHARACTER:Test.Try Catch
RecoverableException
File:CHARACTER:/build/S1000_slot1/S1000_P/src/DataFlowEngine/SQLNodeLibrary/ImbComputeNode.cpp
Line:INTEGER:515
Function:CHARACTER:ImbComputeNode::evaluate
Type:CHARACTER:ComIbmComputeNode
Name:CHARACTER:Test#FCMComposite_1_9
Label:CHARACTER:Test.Test_Compute_PrepReq
Catalog:CHARACTER:BIPmsgs
Severity:INTEGER:3
Number:INTEGER:2230
Text:CHARACTER:Caught exception and rethrowing
Insert
Type:INTEGER:14
Text:CHARACTER:Test.Test_Compute_PrepReq
RecoverableException
File:CHARACTER:/build/S1000_slot1/S1000_P/src/DataFlowEngine/ImbRdl/ImbRdlStatementGroup.cpp
Line:INTEGER:792
Function:CHARACTER:SqlStatementGroup::execute
Type:CHARACTER:
Name:CHARACTER:
Label:CHARACTER:
Catalog:CHARACTER:BIPmsgs
Severity:INTEGER:3
Number:INTEGER:2488
Text:CHARACTER:Error detected, rethrowing
Insert
Type:INTEGER:5
Text:CHARACTER:.Test_Compute_PrepReq.Main
Insert
Type:INTEGER:5
Text:CHARACTER:93.5
Insert
Type:INTEGER:5
Text:CHARACTER:PROPAGATE TO TERMINAL 1 FINALIZE DEFAULT DELETE DEFAULT;
RecoverableException
File:CHARACTER:/build/S1000_slot1/S1000_P/src/DataFlowEngine/SQLNodeLibrary/ImbComputeNode.cpp
Line:INTEGER:515
Function:CHARACTER:ImbComputeNode::evaluate
Type:CHARACTER:ComIbmComputeNode
Name:CHARACTER:Test#FCMComposite_1_2
Label:CHARACTER:Test.Test_Compute_PrepResp
Catalog:CHARACTER:BIPmsgs
Severity:INTEGER:3
Number:INTEGER:2230
Text:CHARACTER:Caught exception and rethrowing
Insert
Type:INTEGER:14
Text:CHARACTER:Test.Test_Compute_PrepResp
RecoverableException
File:CHARACTER:/build/S1000_slot1/S1000_P/src/DataFlowEngine/ImbRdl/ImbRdlStatementGroup.cpp
Line:INTEGER:792
Function:CHARACTER:SqlStatementGroup::execute
Type:CHARACTER:
Name:CHARACTER:
Label:CHARACTER:
Catalog:CHARACTER:BIPmsgs
Severity:INTEGER:3
Number:INTEGER:2488
Text:CHARACTER:Error detected, rethrowing
Insert
Type:INTEGER:5
Text:CHARACTER:.Test_Compute_PrepResp.Main
Insert
Type:INTEGER:5
Text:CHARACTER:11.4
Insert
Type:INTEGER:5
Text:CHARACTER:PROPAGATE TO TERMINAL 2 FINALIZE DEFAULT DELETE DEFAULT;
RecoverableException
File:CHARACTER:/build/S1000_slot1/S1000_P/src/DataFlowEngine/TemplateNodes/ImbOutputTemplateNode.cpp
Line:INTEGER:303
Function:CHARACTER:ImbOutputTemplateNode::processMessageAssemblyToFailure
Type:CHARACTER:ComIbmFileOutputNode
Name:CHARACTER:Test#FCMComposite_1_3
Label:CHARACTER:Test.File Output
Catalog:CHARACTER:BIPmsgs
Severity:INTEGER:3
Number:INTEGER:2230
Text:CHARACTER:Caught exception and rethrowing
Insert
Type:INTEGER:14
Text:CHARACTER:Test.File Output
RecoverableException
File:CHARACTER:AbstractFileOutputNode.java
Line:INTEGER:988
Function:CHARACTER:locateOutputFile
Type:CHARACTER:
Name:CHARACTER:
Label:CHARACTER:
Catalog:CHARACTER:BIPmsgs
Severity:INTEGER:3
Number:INTEGER:3333
Text:CHARACTER:
Insert
Type:INTEGER:5
Text:CHARACTER:File Output
Insert
Type:INTEGER:5
Text:CHARACTER:Test
Insert
Type:INTEGER:5
Text:CHARACTER:tmp/



Thanks in advanced
Back to top
View user's profile Send private message
HJaber
PostPosted: Thu Mar 16, 2023 12:20 am    Post subject: quick reply is highly appreciated Reply with quote

Newbie

Joined: 04 Aug 2022
Posts: 6
I need quick reply cause i have deadline
Back to top
View user's profile Send private message
fjb_saper
PostPosted: Thu Mar 16, 2023 5:15 am    Post subject: Re: quick reply is highly appreciated Reply with quote

Grand High Poobah

Joined: 18 Nov 2003
Posts: 20768
Location: LI,NY
HJaber wrote:
I need quick reply cause i have deadline


Access problems to the /tmp directory?
_________________
MQ & Broker admin
Back to top
View user's profile Send private message Send e-mail
HJaber
PostPosted: Mon Mar 20, 2023 12:45 am    Post subject: Re: quick reply is highly appreciated Reply with quote

Newbie

Joined: 04 Aug 2022
Posts: 6
fjb_saper wrote:
HJaber wrote:
I need quick reply cause i have deadline


Access problems to the /tmp directory?


I do not think it is access problem; since i already run the sftp inside the server itself...
Back to top
View user's profile Send private message
mgk
PostPosted: Mon Mar 20, 2023 2:33 am    Post subject: Reply with quote

Padawan

Joined: 31 Jul 2003
Posts: 1647
The full message BIP3333 you are getting in syslog would read:

Code:
The File node 'File Output' in message flow 'test' cannot resolve the relative file path 'tmp/'.
Relative file paths are resolved by using the absolute directory path in the 'MQSI_FILENODES_ROOT_DIRECTORY' environment variable.
 This environment variable is not set correctly and cannot be used to resolve the path.
Either ensure that the 'MQSI_FILENODES_ROOT_DIRECTORY' environment variable contains an absolute directory path and that the directory exists and can be accessed by the integration node, or change the node configuration to use absolute directory paths.
 See the IBM App Connect Enterprise online documentation topic "FileInput node" or "FileOutput node" for more information.


So it looks like either you meant to use /tmp rather than tmp/ or you need to set the MQSI_FILENODES_ROOT_DIRECTORY directory.

I hope that helps.
_________________
MGK
The postings I make on this site are my own and don't necessarily represent IBM's positions, strategies or opinions.
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic  Reply to topic Page 1 of 1

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » Issue with SFTP
Jump to:  



You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
Protected by Anti-Spam ACP
  
 


Theme by Dustin Baccetti
Powered by phpBB © 2001, 2002 phpBB Group

Copyright © MQSeries.net. All rights reserved.