Problem in JDBC to JDBC scenario

[konchada_saikrishna]

Hello all,

I am working on a JDBC 2 JDBC Scenario.

Everything gone fine, data is picked from source, but it is not updated in the destination.

I could not see any message related to this in SXMB_MONI it shows only messages related to IDOC, on search I fould, we need to add trace level,etc in SXMB_ADM but still couldnot found any message (I restarted the system, cleared cache also).

In RWB(communication channel monitoring) I could find that sender is sucessful, but no message for receiver.

In RWB (message monitoring) I checked my business system, i could see sender entries but no receiver entries, there is only one error message as :

<b> transmitting the message to endpoint http://xisystem:50100/sap/xi/engine?type=entry using connectio</b>

For which I found we need to change XI businesssystem's pipeline port no from some 54+++ to 4+++ (but I could see only 50100 in the pipeline so i did'nt)

we are using R/3, was7.0 sp11,XI3.0,

Can any body help me in this regard

Thanks,

Sai.k.k

[Former Member · Accepted solution]

Check this thread.

You need to use HTTP port 8001

The changes must be done in

1. SXMB_ADM-->Specific Configuration -->IS_URL -->Change the port here

2. Exchange Profile -->Connections -->

com.sap.aii.connect.integrationserver.r3.httpport

Change the value of this parameter to 8001.

Regards,

Jai Shankar

[konchada_saikrishna · Accepted solution]

Hi Sankhar,

1) I could not see IS_URL or any URL in SXMB_ADM, where exactly URL reside SXMB_ADM.

2) (Exchange Profile -->Connections -->

com.sap.aii.connect.integrationserver.r3.httpport) how / where to navigate this ..

Regards,

Sai.k.k

[Former Member · Accepted solution]

>>1) I could not see IS_URL or any URL in SXMB_ADM, where exactly URL reside SXMB_ADM.

SXMB_ADM-->Integration Engine Configuration -->Specific Information.

Here you can find an entry IS_URL

>>2) (Exchange Profile -->Connections -->

com.sap.aii.connect.integrationserver.r3.httpport) how / where to navigate this ..

XI Home page -->Administration --> Exchange Profile -->Connections -->

com.sap.aii.connect.integrationserver.r3.httpport

May be your BASIS team should help you with this.

Regards,

Jai Shankar

[konchada_saikrishna · Accepted solution]

Hi,

As said, I dont have any IS_URL entry in SXMB_ADM, when I create that new entry what all parameters to be given like :

SubParameter :

Current Value:

In

XI Home page -->Administration --> Exchange Profile -->Connections -->

com.sap.aii.connect.integrationserver.r3.httpport = "8001"

Regards,

Sai.k.k

[Former Member · Accepted solution]

Category: RUNTIME

Parameter : IS_URL

Current value : http://<host>:8001/sap/xi/engine?type=entry

I guess the post installation part is not done. Check the installation guide and complete the post installation activities.

Regards,

Jai Shankar

[konchada_saikrishna · Accepted solution]

Hi Shankar,

Thanks,

Now after changing the port no: I could see my errors in SXMB_MONI.

In Message monitoring I could see the sender message as sucessfull, in message data there is no entry for the receiver party / service . The audit log says it is sucessful.

There is no message for receiver in the message mapping...

_________________________________________

The error in sxmb_moni is :

<b> com.sap.aii.utilxi.misc.api.BaseRuntimeException thrown during application mapping com/sap/xi/tf/_JDBC2JDBC_MM_: RuntimeException in Message-Mapping transformatio~</b>

The receiver data type is the one like the IDOC2JDBC but it says there is an error in mapping where it might be wrong.

Regards,

Sai.k.k

[Former Member · Accepted solution]

Hi ,

Did you test your message mapping through test tab??

Sekhar

[konchada_saikrishna · Accepted solution]

Yes,

It is sucessful ..., but when I copy the payload from sxmb_moni,paste it in the mapping source, it gives an error.

I am not getting where wud be the error...

Regards,

Sai.k.k

[Former Member · Accepted solution]

what is the error you get?>

regards

krishna

[Former Member · Accepted solution]

can u give the structure of data type of both sender and receiver and how u mapping.. so we can tell where u gone in mapping. Let me tell u that structure for sender and receiver different..

[konchada_saikrishna · Accepted solution]

Hi,

<pre>

sender :

sender_jdbc_mt

-row

|_Name

|_Country

|_DOB

Receiver :

Receiver_jdbc_mt

-Statement

|_dbTable

|_action

|_table

|_access

|_Name

|_Country

|_Flag

mapping :

action -->insert (constant)

table -->employee (constant)

Name --> Name

Country-->Country

DOB-->Flag

</pre>

Regards,

Sai.k.k

[konchada_saikrishna · Accepted solution]

Hi,

Error in SXMB_MONI :

com.sap.aii.utilxi.misc.api.BaseRuntimeException thrown during application mapping com/sap/xi/tf/_JDBC2JDBC_MM_: RuntimeException in Message-Mapping transformatio~

Error in Integration repository when I test with the payload :

<pre>

13:01:52 Start of test

Document start

Start tag [ns0:Receiver_JDBC_MT]

Add raw attribute [ xmlns:ns0="http://xyz.com/JDBC2JDBC_NMSP"]

Start tag [Statement]

Start tag [dbTable]

Add attribute: [action]=[INSERT]

Start tag [table]

Put value [Example]

Close tag [table]

Fatal Error: com.sap.engine.lib.xml.parser.ParserException: XML Declaration not allowed here.(:main:, row:1, col:8)com.sap.aii.utilxi.misc.api.

BaseRuntimeException: Fatal Error: com.sap.engine.lib.xml.parser.ParserException:XML Declaration not allowed here.(:main:, row:1, col:8)

at com.sap.aii.mappingtool.tf3.rt.xparser.MTSaxHandler.run(MTSaxHandler.java:157)

at com.sap.aii.mappingtool.tf3.rt.xparser.XParser.run(XParser.java:73)

at java.lang.Thread.run(Thread.java:534) Root Cause: com.sap.engine.lib.xml.parser.NestedSAXParserException:Fatal

Error: com.sap.engine.lib.xml.parser.ParserException: XML Declaration not allowed here.(:main:, row:1, col:8)(:main:, row=1, col=8) ->

com.sap.engine.lib.xml.parser.ParserException: XML Declaration not allowed here.(:main:, row:1, col:8)

at com.sap.engine.lib.xml.parser.XMLParser.scanPI(XMLParser.java:2126)

at com.sap.engine.lib.xml.parser.XMLParser.scanProlog(XMLParser.java:2774)

at com.sap.engine.lib.xml.parser.XMLParser.scanDocument(XMLParser.java:2830)

at com.sap.engine.lib.xml.parser.XMLParser.parse0(XMLParser.java:229)

at com.sap.engine.lib.xml.parser.AbstractXMLParser.parseAndCatchException(AbstractXMLParser.java:145)

at com.sap.engine.lib.xml.parser.AbstractXMLParser.parse(AbstractXMLParser.java:160)

at com.sap.engine.lib.xml.parser.AbstractXMLParser.parse(AbstractXMLParser.java:261)

at com.sap.engine.lib.xml.parser.Parser.parseWithoutSchemaValidationProcessing(Parser.java:280)

at com.sap.engine.lib.xml.parser.Parser.parse(Parser.java:342)

at com.sap.engine.lib.xml.parser.SAXParser.parse(SAXParser.java:125)

at javax.xml.parsers.SAXParser.parse(SAXParser.java:345)

at com.sap.aii.mappingtool.tf3.rt.xparser.MTSaxHandler.run(MTSaxHandler.java:155)

at com.sap.aii.mappingtool.tf3.rt.xparser.XParser.run(XParser.java:73)

at java.lang.Thread.run(Thread.java:534) -

---

at com.sap.engine.lib.xml.parser.SAXParser.parse(SAXParser.java:144)

at javax.xml.parsers.SAXParser.parse(SAXParser.java:345)

at com.sap.aii.mappingtool.tf3.rt.xparser.MTSaxHandler.run(MTSaxHandler.java:155)

at com.sap.aii.mappingtool.tf3.rt.xparser.XParser.run(XParser.java:73)

at java.lang.Thread.run(Thread.java:534) Caused by: com.sap.engine.lib.xml.parser.ParserException: XML Declaration not allowed here.(:main:, row:1, col:8)

at com.sap.engine.lib.xml.parser.XMLParser.scanPI(XMLParser.java:2126)

at com.sap.engine.lib.xml.parser.XMLParser.scanProlog(XMLParser.java:2774)

at com.sap.engine.lib.xml.parser.XMLParser.scanDocument(XMLParser.java:2830)

at com.sap.engine.lib.xml.parser.XMLParser.parse0(XMLParser.java:229)

at com.sap.engine.lib.xml.parser.AbstractXMLParser.parseAndCatchException(AbstractXMLParser.java:145)

at com.sap.engine.lib.xml.parser.AbstractXMLParser.parse(AbstractXMLParser.java:160)

at com.sap.engine.lib.xml.parser.AbstractXMLParser.parse(AbstractXMLParser.java:261)

at com.sap.engine.lib.xml.parser.Parser.parseWithoutSchemaValidationProcessing(Parser.java:280)

at com.sap.engine.lib.xml.parser.Parser.parse(Parser.java:342)

at com.sap.engine.lib.xml.parser.SAXParser.parse(SAXParser.java:125) ... 4 more Fatal Error: com.sap.engine.lib.xml.parser.ParserException: XML Declaration not allowed here.(:main:, row:1, col:8)

13:01:52 End of test

</pre>

Query : Select * from Employee fetches all the fields

Payload :

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

- <resultset>

- <row>

<PerNer>t</PerNer>

<Initials>t</Initials>

<Name>t</Name>

<DOB>t</DOB>

<State>t</State>

<Country>t</Country>

</row>

</resultset>

</pre>

Regards,

Sai.k.k

[Former Member · Accepted solution]

Check your msg mapping as per the blog

/people/michal.krawczyk2/blog/2005/09/16/xi-how-to-test-your-mapping-in-real-life-scenarios

Regards,

Jai Shankar

[Former Member · Accepted solution]

Give your message type name and namespace in the sender JDBC Adapter instead of resultset.

[konchada_saikrishna · Accepted solution]

Hi Shankar,

I tested it in the same way...

It is giving an error, I posted that error too in the previous post.

is there a problem in the data structure ?

Regards,

Sai.k.k

[Former Member · Accepted solution]

Give your sender message type name and namespace in sender JDBC Adapter's processing parameters(DocumentName and Namespace).

[Former Member · Accepted solution]

Do what Sekhar has suggested. You have used"recordset" in "Document anme" parameter of sender JDBC communication channel . It should be your Message Type name. Also use the name space name correctly.

One other thing is map your <row> of source to <access> of target>.

Regards,

Jai Shankar

[MichalKrawczyk]

hi,

pipleline URL in (both in SXMB_ADM)

and in SLD (for business system XI)

must have http port (it's 80XX)

you can find this port in SMICM and goto - services

Regards,

michal

-

---

<a href="/people/michal.krawczyk2/blog/2005/06/28/xipi-faq-frequently-asked-questions"><b>XI / PI FAQ - Frequently Asked Questions</b></a>

[konchada_saikrishna]

Michal,

In SXMB_ADM I could see only one entry Engine type, Seeing your blog I added other 4 entries also, but still I could not see any of the messages other than IDOC in SXMB_moni.

In SXMB_ADM --> specific configuration I could not any pipeline entry, where exactly it resides....

I have gone through(smicm) go to-->service I could se port no is 8001 so I should change XI Business System's port number to 8001 right.

Regards,

Sai.k.k