MII 12.1.5 problem: XML-Doc not initialized in second transaction call

[roger_zuehlsdorf]

(Sorry- I don't know why the lines are not seperated as in my input text...)

Hello!

We are migrating our projects from MII 12.5 to 12.1.5(Build 99).

Most of the problems we found last year during our 12.1 rampup tests are fixed now.

We are very happy about the improved expression parser- it now finds all syntax errors which are ignored in 12.0 (like missing parenthesis).

The new tracing options make is easy to remove such errors.

We found some small problems but this problem ist not easy to see and the result are some hundred wrong SAP postings:

In a called transaction we have a XML-Doc action block which manually configured fields.

Then we adds rows to this document using the ROW-action block.

Note: In the calling main transaction the option "reload transaction after each execution" is UNchecked (the default)

This works fine for the first call of this transaction.

The problems starts with the second call.

Some initalization for the XML-Doc ist not executed (see trace below)

VERY BAD: the ROW-actions to fill the document are executed WITHOUT errors!

Result: an EMPTY XML-Doc!

The solution is to check the option "reload transaction after each execution" in the Transaction call action.

In MII 12.0 the XML-Doc was initalized and filled correctly for both calling options.

Questions:

- Is this a bug or a known behaviour?

During the rampup test we found some problems with local variables and discussed this with SAP (Mr Schuette).

what I remeber: with the unchecked option the local transaction variables should keep the old values of the last call -

but XML-Docs should be initialzed always. The big problem is that the ROW action don't raise an error.

- Should the option "reload transaction after each execution" be checked as default?

- Are there performance differences for both options?

Best regards,

Roger Zuehlsdorf

-

---

Trace output:

==========================================================

FIRST CALL of Sub-Transaction

....

[DEBUG] [TESTSUB1] Loading action: Document_0, type: IlluminatorDocument

[DEBUG] [TESTSUB1] [Sequence]: Started sequence execution

[DEBUG] [TESTSUB1] [Document_0]: Started action execution

[DEBUG] [TESTSUB1] [Document_0]: Type: IlluminatorDocument, Description:

[DEBUG] [TESTSUB1] [Document_0]: [Initializing Action][Initializing Parameters: [Document_0.EndDate = Document_0.EndDate=[timestamp:2010-08-23T12:58:51]][Document_0.StartDate = Document_0.StartDate=[timestamp:2010-08-23T12:58:51]][Document_0.Output = Document_0.Output=[xml:<?xml version="1.0" encoding="UTF-8"?>

<Rowsets DateCreated="2010-08-23T16:09:59" EndDate="2010-08-23T12:58:51" StartDate="2010-08-23T12:58:51" Version="12.1.5 Build(99)">

<Rowset>

<Columns>

<Column Description="" MaxRange="1" MinRange="0" Name="TESTTEXT" SQLDataType="1" SourceColumn="TESTTEXT"/>

</Columns>

<Row>

<TESTTEXT>STRING</TESTTEXT>

</Row>

</Rowset>

</Rowsets>]][Document_0.ColumnSpecifications = Document_0.ColumnSpecifications=[xml:<?xml version="1.0" encoding="UTF-8"?>

<ColumnSpecifications>

<ContextItem>

<Name>TESTTEXT</Name>

<Description/>

<MinRange>0</MinRange>

<MaxRange>1</MaxRange>

<Value xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:type="string">STRING</Value>

<ReadOnly>false</ReadOnly>

</ContextItem>

</ColumnSpecifications>]]]

[DEBUG] [TESTSUB1] [Document_0]: Resolving Input Links

[DEBUG] [TESTSUB1] Action parameter creating time [ <1 ms]

[DEBUG] [TESTSUB1] Entering action 'Document_0' implementation.

[DEBUG] [TESTSUB1] Exiting action 'Document_0' implementation

[DEBUG] [TESTSUB1] [Document_0]: Resolving Output Links

[DEBUG] [TESTSUB1] [Document_0]: Finished[ <1 ms] Succeeded: true

-

---

• Add Row***

[DEBUG] [TESTSUB1] [Row_0]: Started action execution

[DEBUG] [TESTSUB1] [Row_0]: Type: IlluminatorRow, Description:

[DEBUG] [TESTSUB1] [Row_0]: [Initializing Action][Initializing Parameters: [Row_0.IlluminatorDocument = Row_0.IlluminatorDocument=[string:Document_0.Output]]]

[DEBUG] [TESTSUB1] [Row_0]: Resolving Input Links

[DEBUG] [TESTSUB1] [Row_0]: Link Stats: Row_0.TESTTEXT, Type [Assign], Time [ <1 ms], Expression: "xxxxxx xTHIS IS MY TEXT xxxxxxxxx "

[DEBUG] [TESTSUB1] Action parameter creating time [ <1 ms]

[DEBUG] [TESTSUB1] Entering action 'Row_0' implementation.

[DEBUG] [TESTSUB1] Exiting action 'Row_0' implementation

[DEBUG] [TESTSUB1] [Row_0]: Resolving Output Links

[DEBUG] [TESTSUB1] [Row_0]: Finished[ <1 ms] Succeeded: true

-

---

>>>> Result OK, Teststring is added to Document_0

[INFO] [TESTSUB1] [Tracer_0]Exit SUB: TESTTEXT in XML: <?xml version="1.0" encoding="UTF-8"?>

<Rowsets DateCreated="2010-08-23T16:14:15" EndDate="2010-08-23T12:58:51" StartDate="2010-08-23T12:58:51" Version="12.1.5 Build(99)">

<Rowset>

<Columns>

<Column Description="" MaxRange="1" MinRange="0" Name="TESTTEXT" SQLDataType="1" SourceColumn="TESTTEXT"/>

</Columns>

<Row>

<TESTTEXT>xxxxxx xTHIS IS MY TEXT xxxxxxxxx </TESTTEXT>

</Row>

</Rowset>

</Rowsets>

===============================================================================

SECOND CALL of Sub-Transaction => XML-Doc NOT initalized!?

....

[DEBUG] Entering action 'Transaction_Call_0' implementation.

[DEBUG] [TESTSUB1] [Sequence]: Started sequence execution

[DEBUG] [TESTSUB1] [Document_0]: Started action execution

[DEBUG] [TESTSUB1] [Document_0]: Type: IlluminatorDocument, Description:

[DEBUG] [TESTSUB1] [Document_0]: [Initializing Action][Initializing Parameters: ]

[DEBUG] [TESTSUB1] [Document_0]: Resolving Input Links

[DEBUG] [TESTSUB1] Action parameter creating time [ <1 ms]

[DEBUG] [TESTSUB1] Entering action 'Document_0' implementation.

[DEBUG] [TESTSUB1] Exiting action 'Document_0' implementation

[DEBUG] [TESTSUB1] [Document_0]: Resolving Output Links

[DEBUG] [TESTSUB1] [Document_0]: Finished[ <1 ms] Succeeded: true

-

---

• Add Row*** => NO error message!?

[DEBUG] [TESTSUB1] [Row_0]: Started action execution

[DEBUG] [TESTSUB1] [Row_0]: Type: IlluminatorRow, Description:

[DEBUG] [TESTSUB1] [Row_0]: [Initializing Action][Initializing Parameters: ]

[DEBUG] [TESTSUB1] [Row_0]: Resolving Input Links

[DEBUG] [TESTSUB1] [Row_0]: Link Stats: Row_0.TESTTEXT, Type [Assign], Time [ <1 ms], Expression: "xxxxxx xTHIS IS MY TEXT xxxxxxxxx "

[DEBUG] [TESTSUB1] Action parameter creating time [ <1 ms]

[DEBUG] [TESTSUB1] Entering action 'Row_0' implementation.

[DEBUG] [TESTSUB1] Exiting action 'Row_0' implementation

[DEBUG] [TESTSUB1] [Row_0]: Resolving Output Links

[DEBUG] [TESTSUB1] [Row_0]: Finished[ <1 ms] Succeeded: true

-

---

>>>> Result=> PROBLEM !??? Document_0 is empty:

[INFO] [TESTSUB1] [Tracer_0]Exit SUB: TESTTEXT in XML: <?xml version="1.0" encoding="UTF-8"?>

<Rowsets DateCreated="2010-08-23T16:14:15" EndDate="2010-08-23T12:58:51" StartDate="2010-08-23T12:58:51" Version="12.1.5 Build(99)">

<Rowset>

<Columns>

<Column Description="" MaxRange="1" MinRange="0" Name="TESTTEXT" SQLDataType="1" SourceColumn="TESTTEXT"/>

</Columns>

</Rowset>

</Rowsets>

===================================================================================

Edited by: Roger Zuehlsdorf on Aug 24, 2010 4:51 PM

[Former Member]

Hi.

It is very hard to read your description, but have a look at SP6 patch 2. This contains a fix for initialising of XML documents in transactions. I am not sure weather that is your problem but have a look.

BR

Poul.