Posting the data from SQL to SAP Business One UDO ...

Former Member · ‎10-15-2015

Hi Experts,

I am trying to post the data from SQL database to SAP Business One UDO table, while posting the data I got below error.

I was tried like as much as I known but I could not solve this issue please help me out.

Error Message:

Exception : com.sap.smb.sb... Exception : com.sap.smb.sbo.wrapper.com.ComFailException: Invoke of: GetDataInterfaceFromXMLString Source: SapBobsCom.GeneralService.88.0 Description: Unknown error -1005 !

My XML mapping:

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

<xsl:stylesheet xmlns:b1e="urn:com.sap.b1i.sim:b1event" xmlns:b1ie="urn:com.sap.b1i.sim:b1ievent" xmlns:b1im="urn:com.sap.b1i.sim:b1imessage" xmlns:bfa="urn:com.sap.b1i.bizprocessor:bizatoms" xmlns:jdbc="urn:com.sap.b1i.adapter:jdbcadapter" xmlns:rfc="urn:sap-com:document:sap:rfc:functions" xmlns:sim="urn:com.sap.b1i.sim:entity" xmlns:utils2="com.sap.b1i.bpc_tools.Utilities" xmlns:vpf="urn:com.sap.b1i.vplatform:entity" xmlns:xci="urn:com.sap.b1i.xcellerator:intdoc" xmlns:xsl="http://www.w3.org/1999/XSL/Transform" version="1.0" bfa:force="" vpf:force="" jdbc:force="" rfc:force="" b1ie:force="" b1e:force="" xci:force="" sim:force="" utils2:force="" b1im:force="">

<xsl:output method="xml" encoding="UTF-8" indent="yes"/>

<xsl:param name="atom"/>

<xsl:param name="sessionid"/>

<xsl:variable name="msg" select="/vpf:Msg/vpf:Body/vpf:Payload[./@Role='S']"/>

<xsl:variable name="vpSender" select="/vpf:Msg/vpf:Header/vpf:Sender/@Id"/>

<xsl:variable name="vpObject" select="/vpf:Msg/vpf:Header/vpf:Sender/@ObjId"/>

<xsl:variable name="vpReceiver" select="/vpf:Msg/vpf:Header/vpf:ReceiverList/vpf:Receiver[./@handover='P']/@Id"/>

<xsl:template match="/">

<xsl:copy-of select="/vpf:Msg/@*"/>

<xsl:copy-of select="/vpf:Msg/vpf:Header"/>

<Body>

<xsl:copy-of select="/vpf:Msg/vpf:Body/*"/>

<xsl:call-template name="transform"/>

</Payload>

</Body>

</Msg>

</xsl:template>

<xsl:template name="transform">

<b1im_multimsg xmlns="">

<xsl:for-each select="/vpf:Msg/vpf:Body/vpf:Payload[./@Role='C' and ./@id='atom1']/jdbc:ResultSet/jdbc:Row">

<b1im_msg>

<U_CardCode>

<xsl:value-of select="jdbc:CARDCODE/text()"/>

</U_CardCode>

<U_Consigne>

<xsl:value-of select="jdbc:CARDCODE/text()"/>

</U_Consigne>

<U_CardType>

<xsl:value-of select="jdbc:CARDTYPE/text()"/>

</U_CardType>

<U_ImpDoms>

<xsl:value-of select="jdbc:U_IMPDOMS/text()"/>

</U_ImpDoms>

<U_DocDate>

<xsl:value-of select="jdbc:DOCDATE/text()"/>

</U_DocDate>

<U_DocTime>

<xsl:value-of select="jdbc:DOCTIME/text()"/>

</U_DocTime>

<U_DocTime1>

<xsl:value-of select="jdbc:DOCTIME/text()"/>

</U_DocTime1>

<U_D2CARD>

<xsl:value-of select="jdbc:U_D2CARD/text()"/>

</U_D2CARD>

<U_D2ADDID>

<xsl:value-of select="jdbc:U_D2ADDID/text()"/>

</U_D2ADDID>

<CCO_TRNS_OUT_C1Collection>

<CCO_TRNS_OUT_C1>

<xsl:for-each select="/vpf:Msg/vpf:Body/vpf:Payload[./@Role='C' and ./@id='atom2']/jdbc:ResultSet/jdbc:Row">

<U_DODocNum>

<xsl:value-of select="jdbc:STDOCNUM/text()"/>

</U_DODocNum>

<U_DODocEn>

<xsl:value-of select="jdbc:STDOCENTRY/text()"/>

</U_DODocEn>

<U_DoLineID>

<xsl:value-of select="jdbc:STLINENUM/text()"/>

</U_DoLineID>

<U_Batchno>

<xsl:value-of select="jdbc:BATCHNUM/text()"/>

</U_Batchno>

<U_ItemCode>

<xsl:value-of select="jdbc:ITEMCODE/text()"/>

</U_ItemCode>

<U_ItemName>

<xsl:value-of select="jdbc:DESCRIPTION/text()"/>

</U_ItemName>

<U_OutQty>

<xsl:value-of select="jdbc:SYSTEMBATQTY/text()"/>

</U_OutQty>

<U_UsedQty>

<xsl:value-of select="jdbc:SYSTEMBATQTY/text()"/>

</U_UsedQty>

<U_IEIDoNo>

<xsl:value-of select="jdbc:INCDOCENTRY/text()"/>

</U_IEIDoNo>

<U_IEILinNo>

<xsl:value-of select="jdbc:INCLINEID/text()"/>

</U_IEILinNo>

<U_RG23DNo>

<xsl:value-of select="jdbc:INCEXCISENO/text()"/>

</U_RG23DNo>

<U_Itmsgrp>

<xsl:value-of select="jdbc:ITMSGRPCOD/text()"/>

</U_Itmsgrp>

<U_GrpName>

<xsl:value-of select="jdbc:ITMGRPNAME/text()"/>

</U_GrpName>

<U_IEIOrQty>

<xsl:value-of select="jdbc:U_BATQTY/text()"/>

</U_IEIOrQty>

<U_IEIAvQty>

<xsl:value-of select="jdbc:AVLQTY/text()"/>

</U_IEIAvQty>

<U_BaseType>

<xsl:value-of select="jdbc:STOBJECT/text()"/>

</U_BaseType>

<U_AssValue>

<xsl:value-of select="jdbc:ASSVALUE/text()"/>

</U_AssValue>

<U_BED>

<xsl:value-of select="jdbc:U_BCD/text()"/>

</U_BED>

<U_EC>

<xsl:value-of select="jdbc:U_BCESS/text()"/>

</U_EC>

<U_SEC>

<xsl:value-of select="jdbc:U_BHCESS/text()"/>

</U_SEC>

<U_BCD>

<xsl:value-of select="jdbc:U_BCD/text()"/>

</U_BCD>

<U_CVD>

<xsl:value-of select="jdbc:U_CVD/text()"/>

</U_CVD>

<U_AD>

<xsl:value-of select="jdbc:U_ADDDUTY/text()"/>

</U_AD>

<U_TotalED>

<xsl:value-of select="jdbc:U_TOTALED/text()"/>

</U_TotalED>

<U_EDPUnit>

<xsl:value-of select="jdbc:U_EDPUNIT/text()"/>

</U_EDPUnit>

</xsl:for-each>

</CCO_TRNS_OUT_C1>

</CCO_TRNS_OUT_C1Collection>

</Outgoing>

</InsertOrUpdate>

</BS>

</b1im_msg>

</xsl:for-each>

</b1im_multimsg>

</xsl:template>

</xsl:stylesheet>

Former Member · ‎10-20-2015

Hi Karthick

Have you seen this blog entry:

https://scn.sap.com/blogs/bagoftricks/2014/10/02/unknown-error--1005-when-importing-udt-information-...

Kind regards,
Radek

Former Member · ‎10-20-2015

Its urgent can anyone help me to out.

Thanks

Karthick

Posting the data from SQL to SAP Business One UDO table through B1IF

Accepted Solutions (0)

Answers (2)

Answers (2)

Re: SAP Standard Table - PO Number, Invoice Number...

Re: Is it possible to group all open items into a ...

Re: KSV5, Sender Tracking Factor come from where?

Avoid new deliveries for a purchase order

7KE1 Plan / Costs / Revenues