on 05-25-2007 6:33 AM
<pre>
Hi All,
I am doing a JDBC to IDOC Scenario. When I done this I am getting following Error when I checked in SXMB_MONI
XML IDoc conversion: No known segments identified
Here is my JDBC Structure
Occurences Type
MURTHY_JDBCSENDER_MT 1..1 MURTHY_JDBCSENDER_DT
 Row 1..1
o Name 1..1 xsd:String
o City 1..1 xsd:String
o District 1..1 xsd:String
Here is my IDOC Structure Mapping is Like this
ADRMAS02
IDOC
BEGIN -
Constant(1)
EDI_DC40
SEGMENT -
Constant(1)
TABNAM -
Constant(EDI_DC40)
DIRECT
IDOCTYP -
Constant(ADRMAS02)
MESTYP -
Constant(ADRMAS)
SNDPOR -
Constant(NA)
SNDPRT -
Constant(NA)
SNDPRN -
Constant(NA)
RCVPOR -
Constant(NA)
RCVPRN -
Constant(NA)
E1ADRMAS
SEGMENT -
Constant(1)
OBJ_TYPE
OBJ_ID
--
--
--
 E1BPAD1VL
SEGMENT -
Constant(1)
NAME -
Mapped to Name from JDBC structure
CITY -
Mapped to City from JDBC structure
DISTRICT---Mapped to District from JDBC structure
---
---
-
 E1BPAD1VL1
 E1BPADTEL
 E1BPADFAX
 E1BPADTTX
 E1BPADTLX
 E1BPADSMTP
 E1BPADRML
 E1BPADX400
 E1BPADRFC
 -
 --
 --
 --
For all the remaining segments I have given Constant Value 1
When I checked in SXMB_MONI I found the error message as
<?xml version="1.0" encoding="UTF-8" standalone="yes" ?>
- <!--
Call Adapter
-->
- <SAP:Error xmlns:SAP="http://sap.com/xi/XI/Message/30" xmlns:SOAP="http://schemas.xmlsoap.org/soap/envelope/" SOAP:mustUnderstand="">
<SAP:Category>XIAdapter</SAP:Category>
<SAP:Code area="IDOC_ADAPTER">ATTRIBUTE_IDOC_RUNTIME</SAP:Code>
<SAP:P1>XML IDoc conversion: No known segments identified</SAP:P1>
<SAP:P2 />
<SAP:P3 />
<SAP:P4 />
<SAP:AdditionalText />
<SAP:ApplicationFaultMessage namespace="" />
<SAP:Stack>Error: XML IDoc conversion: No known segments identified</SAP:Stack>
<SAP:Retry>M</SAP:Retry>
</SAP:Error>
Message in SXMB_MONI in Payloads from Inbound Messges
Resultant message is like this..
<?xml version="1.0" encoding="utf-8" ?>
- <ns:MURTHY_JDBCSENDER_MT xmlns:ns="http://murthy.com/JDBC2IDOC">
- <row>
<Name>AA</Name>
<City>AA</City>
<District>A</District>
<Flag>1</Flag>
</row>
- <row>
<Name>AAC</Name>
<City>CC</City>
<District>B</District>
<Flag>1</Flag>
</row>
</ns:MURTHY_JDBCSENDER_MT>
Message in payloads from Request message mapping .....
<?xml version="1.0" encoding="UTF-8" ?>
- <ADRMAS02>
- <IDOC BEGIN="1">
- <EDI_DC40 SEGMENT="1">
<TABNAM>EDI_DC40</TABNAM>
<DIRECT>2</DIRECT>
<IDOCTYP>ADRMAS02</IDOCTYP>
<MESTYP>ADRMAS</MESTYP>
<SNDPOR>NA</SNDPOR>
<SNDPRT>N</SNDPRT>
<SNDPRN>NA</SNDPRN>
<RCVPOR>NA</RCVPOR>
<RCVPRN>N</RCVPRN>
</EDI_DC40>
</IDOC>
</ADRMAS02>
</pre>
Your mapping is the issue here,
Map the ROW from the JDBC source to E1ADRMAS and E1BPAD1VL .
Regards
Bhavesh
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Bhavesh,
This mapping is working now. Thanks for the reply.
But I have a doubt why do we need to map ROW to these E1ADRMAS and E1BPAD1VL, WHAT ABOUT OTHERS.
Now I checked in SXMB_MONI and message is showing succesful.
Now I just want to know where to check the data that we sent just now to IDOC in R3. Means where does it is stored in R3.
If you had a look at your earlier output XML, the Segement were not getting created because you had not mapped them to the target.
Now, after ,apping the segments to the ROW, every Row creates these Segements and thereby the elements under them as well.
To see the idoc in your R3 system go to transaction We02 , give the time stamp and you will see the Idoc.
Regards
Bhavesh
PS : If you are new to SDN, please mark points for helpful answers so that anyone reading this thread understand which answer solved your problem.
Hi Bhavesh,
<i> To see the idoc in your R3 system go to transaction We02 , give the time stamp and you will see the Idoc</i>
I have checked in transaction we02 , It is showing the status as....
<b>EDI: Partner profile inbound not available
Message no. E0337
Diagnosis
An inbound partner profile could not be found with the following key:
/MRTLS/LS//ADRMAS////
This involves the key fields of table EDP21:</b>
I have created partner profile for my logical system "MRTLS" Also.
Can you tell me which configurations is left....
Look into the Idoc Control Record in WE02. What is the Sender Partner Name?
The partner profile has to be created for this Partner Name in we20
or,
Go to the Sender business System in your Integaration Directory , Docuble Click on it, Business System --> Adapter Specific Identifiers and add the "MRTLS" as the Logical System name, save changes and activate and now the Sender Partner Name when the Idoc reaches R3 will be MRTLS.
Regards
Bhavesh
Bhavesh,
I have checked in WE02
This is the Info
SENDER INFORMATION
Port -
SAPPRO
Partner number -
MRTLS
Partner Type -
LS
Partner Profile has already created for this Partner Name
I have checked in -
<b><i>Sender business System in your Integaration Directory , Docuble Click on it, Business System --> Adapter Specific Identifiers</i></b>
I found MRTLS entry in LogicalSystem.
What else the things I might left....
Thanks
Murthy
Check the IDX1 entry , RFC destination entry. I think, it is not pointing correctly . in XI system
Also delete the Idoc metadata from the in Transaction IDX2 and reimport the same.
Have a look into this SAP Note- 742093
Regards,
Prateek
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
86 | |
10 | |
10 | |
9 | |
7 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.