problem in text file to xml scenario

[Former Member]

hi,

while executing the Flat file (txt) to xml file scenario, the txt file picked up from my source directory, but i could not find in my target directory.

when i check message monitoring, it is showing successful.

Audit Log for Message: af840930-3fa2-11dc-a345-000423c7753d

Time Stamp Status Description

2007-07-31 16:14:47 Success Channel CC_sender: Entire file content converted to XML format

2007-07-31 16:14:47 Success Send text file "xi_input.txt" from FTP server "64.72.230.130:/praba_source", size 353 bytes with QoS EO

2007-07-31 16:14:47 Success Application attempting to send an XI message asynchronously using connection AFW.

2007-07-31 16:14:47 Success Trying to put the message into the send queue.

2007-07-31 16:14:47 Success Message successfully put into the queue.

2007-07-31 16:14:47 Success The application sent the message asynchronously using connection AFW. Returning to application.

2007-07-31 16:14:47 Success The message was successfully retrieved from the send queue.

2007-07-31 16:14:47 Success File "xi_input.txt" deleted after processing

2007-07-31 16:14:47 Success The message status set to DLNG.

2007-07-31 16:14:48 Success The message was successfully transmitted to endpoint http://xiserver1:8000/sap/xi/engine?type=entry using connection AFW.

2007-07-31 16:14:48 Success The message status set to DLVD.

2007-07-31 16:14:48 Success The message was successfully delivered.

I followed the Venkat Donela blog

/people/venkat.donela/blog/2005/03/02/introduction-to-simplefile-xi-filescenario-and-complete-walk-through-for-starterspart1

/people/venkat.donela/blog/2005/03/03/introduction-to-simple-file-xi-filescenario-and-complete-walk-through-for-starterspart2

IN sender CC, i used file content conversion(mesage protocol), file name scheme xi_input.txt

In receiver CC , I used file (message protocol),file name scheme xi_output.xml

In both CC , transport protocol is FTP.

so i gave server name, port, username, password.

could you help me out to find the error for this scenario also?

Thanks in advance

[Former Member · Accepted solution]

Hello,

Check the Log for your receiver CC.

Regards,

[Former Member · Accepted solution]

hi,

one more doubt:

if i want to receive *.txt file in target directory then also i have to use file content conversion in Receiver CC?

[agasthuri_doss · Accepted solution]

Hi,

>>if i want to receive *.txt file in target directory then also i have to use file content conversion in Receiver CC?

Yes ( If the Receiver excepts )

Regards

Agasthuri Doss

[justin_santhanam · Accepted solution]

Praba,

Why u want to give *.txt in receiver comm.channel. Do u want the same file name as in sender? Then check the adapter specific message attributes -Filename in both sender/Receiver channels. U can give any name in receiver comm.channel, bcoz of the ASMA settings, it will take the name automatically as sender file name.

Best regards,

raj.

[Former Member · Accepted solution]

hi raj,

I am not giving *.txt, i gave xi_output.xml as my output file

input file as xi_input.txt , just for my clarfication i asked this question.

as sri hari told me to check the Log for your receiver CC?

I have to check in message monitoring for log in receiver CC or what?

sorry to ask to basic question in expert forum.

[Former Member · Accepted solution]

hi,

In sender CC

name and value are like this

row.fieldNames: FirstName,LastName,MiddleName,City,Place,State,Country

row.fieldSeperator: ,

row.processConfiguration: FromConfiguration

row.endSeperator: 'nl'

[justin_santhanam · Accepted solution]

Praba,

There is nothing like expert/basic forum. We are all freshers in this university of XI , except lot of experienced friends are there. We have to enjoy learning, so don't feel we can ask any sort of questions.

Ok, lets come to the issue. Praba, Did u checked the SXMB_MONI, did u got the message chere? Check the Inbound message payload and see whether its in your expecteed format. Also scroll down and on left side expand the Request Message Mapping node and check the payload there , it will show u the output after mapping process. If you completely satisfy with your results, then finally check in receiver comm channel, audit logs, check receiver comm.channel is active or u gave correct "/" slashes in the directory path etc...

Please post back ur findings!!!

Best regards,

raj.

[Former Member · Accepted solution]

Hello Praba,

Go to Runtime Workbench

click component monitoring

go to commu. channel monitoring

and give the sender and receiver cc and check

I think there might be error in channels

Regards,

Ramesh P

[Former Member · Accepted solution]

hi raj,

Thanks for ur reply.

I went to sxmb_moni and then executed " monitor for processed XML messages " (there is no flag) with my namespace. ( i mean there is no messages)

when i will message in sxmb_moni?

the file is taken from source directorty means i should get message in sxmb_moni?

[agasthuri_doss · Accepted solution]

Hi,

>>I went to sxmb_moni and then executed " monitor for processed XML messages " (there is no flag) with my namespace. ( i mean there is no messages)

Yes

>>when i will message in sxmb_moni?

When your message pass thru integration engine

>>the file is taken from source directorty means i should get message in sxmb_moni?

Check out whether mapping is sucess..( by F7 )

FCC might be wrong..check it in RWB

Regards

Agasthuri Doss

[Former Member · Accepted solution]

Hi praba,

I think there is some problem in ur sending comm channel, the file has been picked but there is some error content conversion i think.

Go to RWB and in comm channel monitoring select your sender file channel and check what it is the error.

you can see messages in sxmb_moni only the message enters XI CENTRAL.

Regards,

Ramesh P

[Former Member · Accepted solution]

hi,

To check communication channel monitoring I have to go like this,

u mean in RWB..>component monitoring...>i selected option for componenets with status all..>

is it right?

I am getting message like Central CCMS monitor not available

below this i am getting like this message

Components

domain.00.xiserver1

Integration Server

Integration Engine XXI

Business Process Engine XXI

Mapping Runtime xiserver1

Adapter Engine xiserver1

Integration Engines

Proxy Runtime SAP_EC7_411

Proxy Runtime ZZ_SystemA

Non-Central Adapter Engines

J2SE Adapter

Tools

[Former Member · Accepted solution]

hi,

<i>>>Integration Engine XXI </i>

double click on that. and you can see <b>communication channel monitor</b> button, click it and select your sender comm channel name and press <b>use filter</b>

you can your comm channel status

regards

Ramesh P

[Former Member · Accepted solution]

Hey

first of all make sure <i>Adapter Engine xiserver1 </i> is not red in color,secondly,double click it and then it will pop up a page where you can see all the adapters,have alook at the sender file adapter and please let us know what it says.

Thanx

Aamir

[Former Member · Accepted solution]

hi,

when i click on this adapeter engine xiserver1, it is changing to green color,

if i double click nothing is happening as u said

but it is showing like this Central CCMS monitor not available

anyway i giving all my values in sender CC:

in sender communication channel

TP : FTP

MP: File content conversion

AE: IS

File access parameters:

sD: /praba_source

FN: xi_input.txt

FTP access parameters:

server: xx.xx.xxx.xxx

port: xx

username: xxxxx

password: xxxx

connection mode: permanently

transfer mode: Binary

Processing Parameters:

QoS: exactly once

poll interval: 60

Processing mode: Test

File type: Binary

Content Conversion Parameters:

Document name dt_outbound

Document namespace urn:xxxxxx

record name: record

recordset str: row,*

recordset seq:Ascending

key fiedl type: string(case-sensitive)

name: value

row.fieldNames: FirstName,LastName,MiddleName,City,Place,State,Country

row.fieldSeperator: ,

row.processConfiguration: FromConfiguration

row.endSeperator: 'nl'

my input file which i kept in source directory is xi_input.txt

content of this file (xi_input.txt) is

Samuel,J,Jackson,Lakefront Drive,Earth City,Missouri,USA

Kenny,m,George,North Beauregard street,Alexandria,Virginia,USA

my dt_outbound structure like this,

dt_outbound (complex type)

then lower element is record

then lower elemnt is row

then FirstName

LastName

MiddleName

City

Place

State

Country

anyway i pasted my sxd dt_outbound type

<?xml version="1.0" encoding="ISO-8859-1"?>

<xsd:schema xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns="urn:praba_flatfile2xml07"

targetNamespace="urn:praba_flatfile2xml07">

<xsd:complexType name="dt_outbound">

<xsd:annotation>

<xsd:appinfo source="http://sap.com/xi/TextID">

2bc3c190404611dc88a3000423c7753d

</xsd:appinfo>

</xsd:annotation>

<xsd:sequence>

<xsd:element name="record">

<xsd:annotation>

<xsd:appinfo source="http://sap.com/xi/TextID">

35982b703f7911dc871cd71bc0a8016d

</xsd:appinfo>

</xsd:annotation>

<xsd:complexType>

<xsd:sequence>

<xsd:element name="row"

maxOccurs="unbounded">

<xsd:annotation>

<xsd:appinfo

source="http://sap.com/xi/TextID">

359f57603f7911dcca2ed71bc0a8016d

</xsd:appinfo>

</xsd:annotation>

<xsd:complexType>

<xsd:sequence>

<xsd:element

name="FirstName" type="xsd:string">

<xsd:annotation>

<xsd:appinfo source="http://sap.com/xi/TextID">

359f57613f7911dc8d9cd71bc0a8016d

</xsd:appinfo>

</xsd:annotation>

</xsd:element>

<xsd:element

name="LastName" type="xsd:string">

<xsd:annotation>

<xsd:appinfo source="http://sap.com/xi/TextID">

359f57623f7911dca6e8d71bc0a8016d

</xsd:appinfo>

</xsd:annotation>

</xsd:element>

<xsd:element

name="MiddleName" type="xsd:string">

<xsd:annotation>

<xsd:appinfo source="http://sap.com/xi/TextID">

359f57633f7911dcc31ed71bc0a8016d

</xsd:appinfo>

</xsd:annotation>

</xsd:element>

<xsd:element

name="City" type="xsd:string">

<xsd:annotation>

<xsd:appinfo source="http://sap.com/xi/TextID">

359f57643f7911dc8c7ad71bc0a8016d

</xsd:appinfo>

</xsd:annotation>

</xsd:element>

<xsd:element

name="Place" type="xsd:string">

<xsd:annotation>

<xsd:appinfo source="http://sap.com/xi/TextID">

359f57653f7911dca7dbd71bc0a8016d

</xsd:appinfo>

</xsd:annotation>

</xsd:element>

<xsd:element

name="State" type="xsd:string">

<xsd:annotation>

<xsd:appinfo source="http://sap.com/xi/TextID">

359f57663f7911dcbd52d71bc0a8016d

</xsd:appinfo>

</xsd:annotation>

</xsd:element>

<xsd:element

name="Country" type="xsd:string">

<xsd:annotation>

<xsd:appinfo source="http://sap.com/xi/TextID">

359f57673f7911dca78ad71bc0a8016d

</xsd:appinfo>

</xsd:annotation>

</xsd:element>

</xsd:sequence>

</xsd:complexType>

</xsd:element>

</xsd:sequence>

</xsd:complexType>

</xsd:element>

</xsd:sequence>

</xsd:complexType>

</xsd:schema>

[Former Member · Accepted solution]

Hey

>>but it is showing like this Central CCMS monitor not available

CCMS is not a problem,its used for monitoring and alerting and has nothing to do with your scenario.

i dont have access to XI server right now so can't tell you the exact path,but i m pretty sure there is something wrong with the sender adapter and you can see that in RWB under adapter monitoring

Thanx

Aamir

[Former Member · Accepted solution]

hi,

Thanks for all helps. I rewarded the points.

I tried to develop again newly to develop txt file to xml scenario. this time the file did not pick from source directory.

I will try to check this error and i will rectify as per past discussion.

i have one doubt in ID...scenarios, left side of my scenario name(which i created ) is orange color , round shape, showing some pencil inside and some lines inside circles that means my scenario is not active in ID or what?

if i check in my standard change list there is no inactive componets, i activated all the components.( totally 9 componets)

[Former Member · Accepted solution]

hi raj,

I gave / correctly in my source and target directory. I did not make that mistake this time.

how to give input pay load..u mean i tested my messaage mapping in test option. that is one u are saying.

could you explain me how to give payload?