Problems with XML-Joiner after updating to 12.0.7

[matthias_prller]

Hello,

After updating to MII 12.0 SP7 (from SP6) I get error messages with an XML Joiner.

I just want to be sure that I didn't do a mistake:

I have two XML-variables (local)

<?xml version="1.0" encoding="UTF-8"?>
<Rowsets DateCreated="2009-04-29T21:15:30" EndDate="2009-04-29T23:14:51" StartDate="2009-04-29T22:14:51" Version="12.0.7 Build(13)">
    <Rowset>
        <Columns>
            <Column Description="PROD_ZEIT" MaxRange="1" MinRange="0" Name="PROD_ZEIT" SQLDataType="2" SourceColumn="PROD_ZEIT"/>
            <Column Description="DATUM" MaxRange="1" MinRange="0" Name="DATUM" SQLDataType="91" SourceColumn="DATUM"/>
        </Columns>
        <Row>
            <PROD_ZEIT>63.71</PROD_ZEIT>
            <DATUM>2009-04-28T02:00:00</DATUM>
        </Row>
        <Row>
            <PROD_ZEIT>65.85</PROD_ZEIT>
            <DATUM>2009-04-27T02:00:00</DATUM>
        </Row>
        <Row>
            <PROD_ZEIT>58.98</PROD_ZEIT>
            <DATUM>2009-04-24T02:00:00</DATUM>
        </Row>
        <Row>
            <PROD_ZEIT>58.13</PROD_ZEIT>
            <DATUM>2009-04-23T02:00:00</DATUM>
        </Row>
   ...(I cut some lines)...
    </Rowset>
    <Messages>
        <Message>Query Derived from cache....</Message>
    </Messages>
</Rowsets>

and the second xml-document-variable:

<?xml version="1.0" encoding="UTF-8"?>
<Rowsets DateCreated="2009-04-29T21:15:30" EndDate="2009-04-29T23:14:51" StartDate="2009-04-29T22:14:51" Version="12.0.7 Build(13)">
    <Rowset>
        <Columns>
            <Column Description="MNZ" MaxRange="1" MinRange="0" Name="MNZ" SQLDataType="2" SourceColumn="MNZ"/>
            <Column Description="PERIODE" MaxRange="1" MinRange="0" Name="PERIODE" SQLDataType="91" SourceColumn="PERIODE"/>
        </Columns>
        <Row>
            <MNZ>78.1235</MNZ>
            <PERIODE>2009-04-28T02:00:00</PERIODE>
        </Row>
        <Row>
            <MNZ>54.598</MNZ>
            <PERIODE>2009-04-27T02:00:00</PERIODE>
        </Row>
        <Row>
            <MNZ>38.296666666667</MNZ>
            <PERIODE>2009-04-24T02:00:00</PERIODE>
        </Row>
        <Row>
            <MNZ>61.784566666667</MNZ>
            <PERIODE>2009-04-23T02:00:00</PERIODE>
        </Row>
...(I cut some lines)...
    </Rowset>
    <Messages>
        <Message>Query Derived from cache....</Message>
    </Messages>
</Rowsets>

I join the fields "PERIODE" with "DATUM" and get always the error

[ERROR]: Joiner: null

what is the mistake?

Thanks for your help.

Regards

Matthias

[Former Member]

I just checked your given XMLs in joiner and it is working fine. Try to save the joiner result via XML Saver action and debug it.

Make sure you are saving the joiner result with Link type "Assign XML".

[matthias_prller]

Thank you for your help. I was not sure if I made something wrong or the joiner doesn't work correctly.

I don't do anything in this "just testing transaction" than joining this two xmls with a joiner.

I asked SAP for help and the are looking at this issue currently.

Regards Matthias

[Former Member]

It's certainly possible that it is an "optimization" introduced in 12.0.7 that broke certain scenarios. Do you have a support ticket in?

[matthias_prller]

Yes, SAP is already investigating this problem.

Perhaps it has something to do with problems we had when we updated to 12.0.7 from 12.0.6. The installation broke and we got a new patch and a lot of assistance from SAP for the SP7.

(On another machine the update was quite easy - but there we have the same problems with the joiner)

Thanks for your help but I think only the SAP support can help me in this case.

Regards,

Matthias

[matthias_prller]

Hello again,

for those who have similar problems:

SAP has released a new update for this problem:

Patch-3 for xMII 12.0 SP07,

SAP Note 1339450 (which is currently only availible intern)

Regards,

Matthias