Unable to display tree view; Error when parsing an XML document (Premature end of file.) in message mapping sap pi

[Former Member]

Dear Experts,

After patch up gradation activity in PI we are getting the below error with MDM Material MATMAS05 to PI to SAP and recently we are encountering the same issue for MDM vendor CREMAS to SAP and to other Oracle DB systems.

In Message Mapping while testing ::

Unable to display tree view; Error when parsing an XML document (Premature end of file.)  (Please find the attached screen shot)

In Adapter Engine ::

Delivering the message to the application using connection JDBC_http://sap.com/xi/XI/System failed, due to: com.sap.engine.interfaces.messaging.api.exception.MessagingException: Error when attempting to get processing resources: com.sap.aii.af.lib.util.concurrent.ResourcePoolException: Unable to create new pooled resource: DriverManagerException: Cannot establish connection with the registered driver. oracle.jdbc.driver.OracleDriver returns: Listener refused the connection with the following error: ORA-12505, TNS:listener does not currently know of SID given in connect descriptor The Connection descriptor used by the client was: IP&port. : SQLException: Listener refused the connection with the following error: ORA-12505, TNS:listener does not currently know of SID given in connect descriptor The Connection descriptor used by the client was: IP&port .

Adapter Framework caught exception: Error when attempting to get processing resources: com.sap.aii.af.lib.util.concurrent.ResourcePoolException: Unable to create new pooled resource: DriverManagerException: Cannot establish connection with the registered driver. oracle.jdbc.driver.OracleDriver returns: Listener refused the connection with the following error: ORA-12505, TNS:listener does not currently know of SID given in connect descriptor The Connection descriptor used by the client was: IP&port . : SQLException: Listener refused the connection with the following error: ORA-12505, TNS:listener does not currently know of SID given in connect descriptor The Connection descriptor used by the client was: IP&port

MP: exception caught with cause com.sap.engine.interfaces.messaging.api.exception.MessagingException: Error when attempting to get processing resources: com.sap.aii.af.lib.util.concurrent.ResourcePoolException: Unable to create new pooled resource: DriverManagerException: Cannot establish connection with the registered driver. oracle.jdbc.driver.OracleDriver returns: Listener refused the connection with the following error: ORA-12505, TNS:listener does not currently know of SID given in connect descriptor The Connection descriptor used by the client was: IP&port . : SQLException: Listener refused the connection with the following error: ORA-12505, TNS:listener does not currently know of SID given in connect descriptor The Connection descriptor used by the client was: IP&port

JDBC Message processing failed, due to Error when attempting to get processing resources: com.sap.aii.af.lib.util.concurrent.ResourcePoolException: Unable to create new pooled resource: DriverManagerException: Cannot establish connection with the registered driver. oracle.jdbc.driver.OracleDriver returns: Listener refused the connection with the following error: ORA-12505, TNS:listener does not currently know of SID given in connect descriptor The Connection descriptor used by the client was: IP&port . : SQLException: Listener refused the connection with the following error: ORA-12505, TNS:listener does not currently know of SID given in connect descriptor The Connection descriptor used by the client was: IP&port

Please let us know the root cause and suggest the solution.

Thanks in Advance.

[manoj_khavatkopp]

 SQLException: Listener refused the connection with the following error: ORA-12505, TNS:listener does not currently know of SID given in connect descriptor The Connection descriptor used by the client was: IP&port

for this error chekc the SID which you have mentioned in your reciever JDBC communication channel Cross check the SID name with the third party database guys.

for the xml error in PI take the payload from message mapping after execution and check if its a valid xml or not.

.

[Former Member]

Hi Manoj,

As mentioned, after patch upgrade we are facing this issue. When testing at mapping itself is failing with simple test payload.

Thanks,

Vanitha P

[manoj_khavatkopp]

The error which you see in adapter engine is due to the connection parameters which you have mentioned in your receiver JDBC channel i.e IP/Server:Port:SID ...cross check these parameters with the third party. or in case if u have toad/squirrel tool try connecting with the database using these.

Can u execute the mapping with the payload even though you get the error  : Unable to display tree view; Error when parsing an XML document (Premature end of file.)  (Please find the attached screen shot) after executing just cling on src button on target side and see if u can see any output XML.

[Former Member]

HI Experts,

Anyone already faced such issue or aware of this, please advice. We are facing lot of issues regarding this.

please help.

thanks,

Vanitha p

[Former Member]

As the error itself is saying the  "premature end of file", could you please check for the XML tags properly... if possible ..pleas provide the payload .. I can may be try to make it correct and send it to you .

[Former Member]

Hi zeeshan,

We haven't done any changes in the environment and also we are getting the error while testing in Message Mapping. For MATMAS the payload is becoming empty from Request message mapping step for which screen shot is attached. Please find the Attached payloads for MDM to PI to SAP(matmas) and MDM to PI to Oracle DB(vendor) system.

Kindly help.

Thanks,

Vanitha.