FTPS to RFC scenario with FORK

[yajjala1]

Hello,

I have  FTPS to RFC scenario.

I am using BPM.

I would like to archive file on destination server.

I am planning to use FORK option so that I can use two paths:

FTPS  -------------->>>   RFC

            ------------->>>>  File

Some one can guide me how to use FORK to archive source file at Destination.

Or is there any simple method to archive file at Destination.

Could you please help me how many directory objects for FORK scenario ?

I have attached pics  current and proposed one ..

Thank you

John

[former_member184720 · Accepted solution]

Hi John -

Or is there any simple method to archive file at Destination.

>>> Why don't you add another system/interface as receiver and process the file to that location ?

If you add it as a new receiver, during the receiver determination  add another system as receiver without any routing logic

Incase if you like to add it as another interface, you can handle it in the interface determination..

For fork usage: below blog, have a look at the below blog-

[yajjala1 · Accepted solution]

Hello Hareesh,

Please explain me steps for:

If you add it as a new receiver, during the receiver determination  add another system as receiver without any routing logic

[former_member184720 · Accepted solution]

As it would be a pass through(without mapping)

create/find a business system/service which you want to use as a receiver and create a file receiver channel for it..

Go to your Receiver determination ->add the system as a receiver..

Create a new interface determination for your sender system and the newly added system

     -> just give dummy values under the inbound interface details..

create the receiver agreement and select the file receiver channel..

[yajjala1 · Accepted solution]

Hello Hareesh,

I have created one more channel for email notification.

I am receiving email with .xml attachment.

Is there any way I can convert it as CSV in the attachment with mail adapter attributes ?

Thank you

john

[former_member184720 · Accepted solution]

Hi John - So the requirement has changed? what is the scenario now?

You just want to rename the attachment and convert the xml to CSV?

[yajjala1 · Accepted solution]

Hello Hareesh,

I have added extra step for email.

I need email attachment with .csv, now it is .xml

Is there easy way?

Thank you

John

[former_member184720 · Accepted solution]

Hi John - Please refer to the below thread -

[yajjala1 · Accepted solution]

Hello Hareesh,

My input file is:

SA*00*          *00*          *01*204084198      *12*6042947126     *120605*0733*U*00300*003539098*0*P*:

GS*RA*CPA-BPTROYAL*6042947126*120605*0733*120605608*X*003030

ST*820*000000001

BPR*C*121.81*C*X12*CBC*04*000271506*DA*1414***04*000300320**0000141*120604

TRN*1*283720120604230927105

REF*RR*00022837201206042309271060002

DTM*097*120605

DTM*107*120605***20

N1*PR*TELESCOTIA

N1*PE*BURNABY (CITY) METERED WATER A*ZZ*90042591

ENT*271061

N1*PR*AYALA, CARIDAD

RMR*CR*09003736000000*FL*121.81

REF*TN*0002R76MA019

My Archive file:

SA*00*          *00*          *01*204084198      *12*6042947126     *120605*0733*U*00300*003539098*0*P*:

GS*RA*CPA-BPTROYAL*6042947126*120605*0733*120605608*X*003030

ST*820*000000001

BPR*C*121.81*C*X12*CBC*04*000271506*DA*1414***04*000300320**0000141*120604

TRN*1*283720120604230927105

REF*RR*00022837201206042309271060002

DTM*097*120605

DTM*107*120605***20

N1*PR*TELESCOTIA

N1*PE*BURNABY (CITY) METERED WATER A*ZZ*90042591

ENT*271061

N1*PR*AYALA, CARIDAD

RMR*CR*09003736000000*FL*121.81

REF*TN*0002R76MA019

My Email attachment is:

<?xml version="1.0" encoding="utf-8"?>

<ns:MCIRBC_MT xmlns:ns="http://mcirbc.cob.ca">

  <MCIRBCRecordSet>

  <MCIRBCRecords>ISA*00*          *00*          *01*204084198      *12*6042947126     *120605*0733*U*00300*003539098*0*P*:</MCIRBCRecords>

  </MCIRBCRecordSet>

  <MCIRBCRecordSet>

  <MCIRBCRecords>GS*RA*CPA-BPTROYAL*6042947126*120605*0733*120605608*X*003030</MCIRBCRecords>

  </MCIRBCRecordSet>

  <MCIRBCRecordSet>

  <MCIRBCRecords>ST*820*000000001</MCIRBCRecords>

  </MCIRBCRecordSet>

  <MCIRBCRecordSet>

  <MCIRBCRecords>BPR*C*121.81*C*X12*CBC*04*000271506*DA*1414***04*000300320**0000141*120604</MCIRBCRecords>

  </MCIRBCRecordSet>

  <MCIRBCRecordSet>

  <MCIRBCRecords>TRN*1*283720120604230927105</MCIRBCRecords>

  </MCIRBCRecordSet>

  <MCIRBCRecordSet>

  <MCIRBCRecords>REF*RR*00022837201206042309271060002</MCIRBCRecords>

  </MCIRBCRecordSet>

  <MCIRBCRecordSet>

  <MCIRBCRecords>DTM*097*120605</MCIRBCRecords>

  </MCIRBCRecordSet>

  <MCIRBCRecordSet>

  <MCIRBCRecords>DTM*107*120605***20</MCIRBCRecords>

  </MCIRBCRecordSet>

  <MCIRBCRecordSet>

  <MCIRBCRecords>N1*PR*TELESCOTIA</MCIRBCRecords>

  </MCIRBCRecordSet>

  <MCIRBCRecordSet>

  <MCIRBCRecords>N1*PE*BURNABY (CITY) METERED WATER A*ZZ*90042591</MCIRBCRecords>

  </MCIRBCRecordSet>

  <MCIRBCRecordSet>

  <MCIRBCRecords>ENT*271061</MCIRBCRecords>

  </MCIRBCRecordSet>

  <MCIRBCRecordSet>

  <MCIRBCRecords>N1*PR*AYALA, CARIDAD</MCIRBCRecords>

  </MCIRBCRecordSet>

  <MCIRBCRecordSet>

  <MCIRBCRecords>RMR*CR*09003736000000*FL*121.81</MCIRBCRecords>

  </MCIRBCRecordSet>

  <MCIRBCRecordSet>

  <MCIRBCRecords>REF*TN*0002R76MA019</MCIRBCRecords>

I have attached  pi my email configuration:

I am expecting my email attachment should be normal file with out XML tags..

Thank you

John

[former_member184720 · Accepted solution]

Hi John - Please check the below blog..

http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/603a7bd8-a6a0-2e10-388b-fc9cb9dae...

[yajjala1 · Accepted solution]

Hello Hareesh,

What is wrong in my mail adapter configuration above ?

[former_member184720 · Accepted solution]

Hi John - I think first module should be MTB and then call adapter.. change the sequence and try..

[yajjala1 · Accepted solution]

Hello Hareesh,

I am sorry could please little elaborate what you are suggesting me.

What is MTB?

What do you mean first module should be MTB and then call adapter ?

[former_member184720 · Accepted solution]

Hi John - As shown in your screenshot, change the adapter module processing sequence..(top portion)

first one should be your message transformation bean module and then call adapter(standard module).

Just change the order using the "move up and down" options..

If it doesn't work they follow the blog which i shared

[yajjala1 · Accepted solution]

Hello Hareesh,

I am getting this error:

Message processing failed. Cause: com.sap.aii.af.sdk.xi.adapter.trans.TransformException: Transformer Conversion3.0.5226 Error initializing Class: java.lang.Exception: java.lang.Exception: java.lang.Exception: Error(s) in XML conversion parameters found: (4408) Parameter 'xml.fieldFixedLengths' or 'xml.fieldSeparator' is missing (4409) ; nested exception caused by: java.lang.Exception: java.lang.Exception: java.lang.Exception: Error(s) in XML conversion parameters found: (4408) Parameter 'xml.fieldFixedLengths' or 'xml.fieldSeparator' is missing (4409)

Message processing failed. Cause: javax.ejb.TransactionRolledbackLocalException: ASJ.ejb.005043 (Failed in component: sap.com/com.sap.aii.af.mod.trans.app, BC-XI-CON-AFW-MP) Exception raised from invocation of public com.sap.aii.af.lib.mp.module.ModuleData com.sap.aii.af.modules.trans.MessageTransformBean.process(com.sap.aii.af.lib.mp.module.ModuleContext,com.sap.aii.af.lib.mp.module.ModuleData) throws com.sap.aii.af.lib.mp.module.ModuleException method on bean instance com.sap.aii.af.modules.trans.MessageTransformBean@dc8279d for bean sap.com/com.sap.aii.af.mod.trans.app*xml|com.sap.aii.af.mod.trans.ejb.jar*xml|MessageTransformBean in application sap.com/com.sap.aii.af.mod.trans.app.; nested exception is: java.lang.NullPointerException: while trying to invoke the method java.lang.Object.getClass() of an object loaded from local variable 'data'; nested exception is: javax.ejb.EJBException: ASJ.ejb.005043 (Failed in component: sap.com/com.sap.aii.af.mod.trans.app, BC-XI-CON-AFW-MP) Exception raised from invocation of public com.sap.aii.af.lib.mp.module.ModuleData com.sap.aii.af.modules.trans.MessageTransformBean.process(com.sap.aii.af.lib.mp.module.ModuleContext,com.sap.aii.af.lib.mp.module.ModuleData) throws com.sap.aii.af.lib.mp.module.ModuleException method on bean instance com.sap.aii.af.modules.trans.MessageTransformBean@dc8279d for bean sap.com/com.sap.aii.af.mod.trans.app*xml|com.sap.aii.af.mod.trans.ejb.jar*xml|MessageTransformBean in application sap.com/com.sap.aii.af.mod.trans.app.; nested exception is: java.lang.NullPointerException: while trying to invoke the method java.lang.Object.getClass() of an object loaded from local variable 'data'; nested exception is: javax.ejb.EJBTransactionRolledbackException: ASJ.ejb.005043 (Failed in component: sap.com/com.sap.aii.af.mod.trans.app, BC-XI-CON-AFW-MP) Exception raised from invocation of public com.sap.aii.af.lib.mp.module.ModuleData com.sap.aii.af.modules.trans.MessageTransformBean.process(com.sap.aii.af.lib.mp.module.ModuleContext,com.sap.aii.af.lib.mp.module.ModuleData) throws com.sap.aii.af.lib.mp.module.ModuleException method on bean instance com.sap.aii.af.modules.trans.MessageTransformBean@dc8279d for bean sap.com/com.sap.aii.af.mod.trans.app*xml|com.sap.aii.af.mod.trans.ejb.jar*xml|MessageTransformBean in application sap.com/com.sap.aii.af.mod.trans.app.; nested exception is: java.lang.NullPointerException: while trying to invoke the method java.lang.Object.getClass() of an object loaded from local variable 'data'; nested exception is: javax.ejb.EJBException: ASJ.ejb.005043 (Failed in component: sap.com/com.sap.aii.af.mod.trans.app, BC-XI-CON-AFW-MP) Exception raised from invocation of public com.sap.aii.af.lib.mp.module.ModuleData com.sap.aii.af.modules.trans.MessageTransformBean.process(com.sap.aii.af.lib.mp.module.ModuleContext,com.sap.aii.af.lib.mp.module.ModuleData) throws com.sap.aii.af.lib.mp.module.ModuleException method on bean instance com.sap.aii.af.modules.trans.MessageTransformBean@dc8279d for bean sap.com/com.sap.aii.af.mod.trans.app*xml|com.sap.aii.af.mod.trans.ejb.jar*xml|MessageTransformBean in application sap.com/com.sap.aii.af.mod.trans.app.; nested exception is: java.lang.NullPointerException: while trying to invoke the method java.lang.Object.getClass() of an object loaded from local variable 'data'

[yajjala1 · Accepted solution]

I have added two missing fields in Mail adapter stll I am getting this error:

java.lang.Exception: Error(s) in XML conversion parameters found: (4408) Parameter 'xml.fieldFixedLengths' or 'xml.fieldSeparator' is missing (4409)

[yajjala1 · Accepted solution]

Hello Hareesh,

finally this worked..

XML2Plain	Transform.Class	com.sap.aii.messaging.adapter.Conversion
XML2Plain	Transform.ContentType	text/plain;charset=utf-8
XML2Plain	xml.MCIRBCRecordSet.fieldFixedLengths	1000
XML2Plain	xml.MCIRBCRecordSet.fieldSeparator	\t
XML2Plain	xml.MCIRBCRecordSet.fixedLengthTooShortHandling	Cut
XML2Plain	xml.addHeaderLine	0
XML2Plain	xml.conversionType	StructXML2Plain
XML2Plain	xml.recordsetStructure	MCIRBCRecordSet

[Former Member]

Hi John ,

I faced the same condition in my project .  I used very simple concept.

1 sender and 2 receiver (without BPM ) and it worked .

Sender :-  FTPS ---------> Receiver 1:- RFC

                                     Receiver 2:- File

It might can help you .

[Former Member]

Hello,

Why don't u use below method to archive ur files?

Thanks

Amit Srivastava