Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

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

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=&apos;S&apos;]"/>

    <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=&apos;P&apos;]/@Id"/>

    <xsl:template match="/">

        <Msg xmlns="urn:com.sap.b1i.vplatform:entity">

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

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

            <Body>

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

                <Payload Role="R" id="{$atom}">

                    <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=&apos;C&apos; and ./@id=&apos;atom1&apos;]/jdbc:ResultSet/jdbc:Row">

                <b1im_msg>

                    <BS ServiceCode="Outgoing">

                        <InsertOrUpdate>

                            <Outgoing>

                                <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=&apos;C&apos; and ./@id=&apos;atom2&apos;]/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
Not what you were looking for? View more on this topic or Ask a question