B1if SQL to SAP doc

[Former Member]

Hi!

I create the package in B1if from SQL to SAP Document.

In case SQL call value and put value to SAP, It's ok

In case SQL select with no data, Atom continue to transfer data to SAP and B1i monitoring shows the error :

com.sap.b1i.xcellerator.XcelleratorException: XCE001 Nested exception: com.sap.b1i.bizprocessor.BizProcException: BPE001 Nested exception: com.sap.b1i.utilities.UtilException: UTE001 Nested exception: com.sap.engine.lib.xml.util.NestedException: Variable '$DocDate' has not been bound to a value

How can I set up SQL to document and only catch value in SQL. If SQL can't see any value It will not show the message?

Thanks

Hong Bich

[Former Member]

Hi Gordon!

Please see the link:

https://imo.im/fd/B/hSCDHt2DGA/Atom.txt

Thanks

Hong Bich

[Former Member]

Under:

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

You need find a way to add a logical condition to skip the code after it if the selection is null.

[Former Member]

Hi Gordon!

I Try to make condition for this case but nothing happen.  I don't have experience about XML.

Please help  me!

<xsl:template name="transform">

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

                              <xsl:variable name="DocDate">

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

                              </xsl:variable>

                              <xsl:if test="$DocDate=null">

                                        20120101

                              </xsl:if>

                              <xsl:variable name="FromWarehouse">

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

                              </xsl:variable>

                              <xsl:variable name="DocEntry">

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

                              </xsl:variable>

                    </xsl:for-each>

Thanks so much

Hong Bich

[Former Member]

Hi Hong Bich,

What Atom had been setup?

Thanks,

Gordon