can't be converted into xml

[Former Member]

I am having problem in converting xml.

oracle(7.2.3) -> xi -> sap

SELECT MANDT FROM TEMP1

-

---

result : MANDT(100)

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

<ns:MT_Businesstrip_Document_Req xmlns:ns="http://xi.ssc.co.kr/XI/PDS_Businesstrip_Document">

<row>

<>100</>

</row>

</ns:MT_Businesstrip_Document_Req>

Root cause:

MESSAGE ID: com.sap.aii.utilxi.misc.api.BaseRuntimeException

com.sap.aii.utilxi.misc.api.BaseRuntimeException: Fatal Error: com.sap.engine.lib.xml.parser.ParserException: Name expected: 0x3e(:main:, row:4, col:4)

at com.sap.aii.mappingtool.tf3.Transformer.checkParserException(Transformer.java:37)

at com.sap.aii.mappingtool.tf3.Transformer.start(Transformer.java:78)

at com.sap.aii.mappingtool.tf3.AMappingProgram.execute(AMappingProgram.java:105)

at com.sap.aii.ibrun.server.mapping.JavaMapping.executeStep(JavaMapping.java:64)

at com.sap.aii.ibrun.server.mapping.Mapping.execute(Mapping.java:91)

at com.sap.aii.ibrun.server.mapping.MappingHandler.run(MappingHandler.java:90)

at com.sap.aii.ibrun.sbeans.mapping.MappingRequestHandler.handleMappingRequest(MappingRequestHandler.java:94)

at com.sap.aii.ibrun.sbeans.mapping.MappingRequestHandler.handleRequest(MappingRequestHandler.java:67)

at com.sap.aii.ibrun.sbeans.mapping.MappingServiceImpl.processFunction(MappingServiceImpl.java:79)

at com.sap.aii.ibrun.sbeans.mapping.MappingServiceObjectImpl0.processFunction(MappingServiceObjectImpl0.java:131)

at sun.reflect.GeneratedMethodAccessor216.invoke(Unknown Source)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)

at java.lang.reflect.Method.invoke(Method.java:324)

at com.sap.engine.services.ejb.session.stateless_sp5.ObjectStubProxyImpl.invoke(ObjectStubProxyImpl.java:187)

at $Proxy182.processFunction(Unknown Source)

at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)

at java.lang.reflect.Method.invoke(Method.java:324)

at com.sap.engine.services.rfcengine.RFCDefaultRequestHandler.handleRequest(RFCDefaultRequestHandler.java:100)

at com.sap.engine.services.rfcengine.RFCJCOServer.handleRequestInternal(RFCJCOServer.java:113)

at com.sap.engine.services.rfcengine.RFCJCOServer$ApplicationRunnable.run(RFCJCOServer.java:171)

at com.sap.engine.core.thread.impl3.ActionObject.run(ActionObject.java:37)

at java.security.AccessController.doPrivileged(Native Method)

at com.sap.engine.core.thread.impl3.SingleThread.execute(SingleThread.java:100)

at com.sap.engine.core.thread.impl3.SingleThread.run(SingleThread.java:170)

oracle(9i) -> xi -> sap

SELECT MANDT FROM TEMP1

-

---

result : MANDT(100)

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

<ns:MT_Businesstrip_Document_Req xmlns:ns="http://xi.ssc.co.kr/XI/PDS_Businesstrip_Document">

<row>

<MANDT>100</MANDT>

</row>

</ns:MT_Businesstrip_Document_Req>

[bhavesh_kantilal · Accepted solution]

Hi,

Which oracle driver is installed on your XI server?

There have been some with a conflict between classes12.zip and OJDBC.jar

Regards,

Bhavesh

[Former Member · Accepted solution]

Thank for your reply.

I have installed classes12.zip on XI server.

DO I have to install OJDBC.jar on my XI server?

Thank you.

[bhavesh_kantilal · Accepted solution]

Hi,

Suggest you take a look at these 2 notes on service market place,<b>867176.</b>

Also, another option is to turn on debuggging trace in JDBC adapter so that you can see the SQL query being executed and data being returned in the Adapter Montioring. For this , see note : 801367

Regards,

Bhavesh