Author |
Message
|
HJaber |
Posted: Wed Mar 15, 2023 4:53 am Post subject: Issue with SFTP |
|
|
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 |
|
 |
HJaber |
Posted: Thu Mar 16, 2023 12:20 am Post subject: quick reply is highly appreciated |
|
|
Newbie
Joined: 04 Aug 2022 Posts: 6
|
I need quick reply cause i have deadline  |
|
Back to top |
|
 |
fjb_saper |
Posted: Thu Mar 16, 2023 5:15 am Post subject: Re: quick reply is highly appreciated |
|
|
 Grand High Poobah
Joined: 18 Nov 2003 Posts: 20756 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 |
|
 |
HJaber |
Posted: Mon Mar 20, 2023 12:45 am Post subject: Re: quick reply is highly appreciated |
|
|
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 |
|
 |
mgk |
Posted: Mon Mar 20, 2023 2:33 am Post subject: |
|
|
 Padawan
Joined: 31 Jul 2003 Posts: 1642
|
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 |
|
 |
|