Parsing of stored procedure output fails after upgrading from BW versions before 5.7.0 to newer versions.
Article ID: KB0094565
Updated On:
| Products | Versions |
|---|---|
| TIBCO ActiveMatrix BusinessWorks | - |
| Not Applicable | - |
Description
Description:
The parsing of stored procedure output fails after upgrading from BW versions before 5.7.0 to newer versions.
Symptoms:
Error in Parse XML activity, which parses stored procedure output, after upgrading from older BW versions to versions post 5.7.0. With 5.6 the output is:
<?xml version="1.0" encoding="UTF-8"?>
<Resultsets>
<Update1>1</Update1>
<Update2>1</Update2>
<Update3>1</Update3>
<Update4>1</Update4>
<ResultSet1>
<Record1>
<StnSign> </StnSign>
<Nummer>040 966503</Nummer>
<Resultatkod>0</Resultatkod>
<Kabellangd>1796</Kabellangd>
<RevTid>2008-12-18 02:22:31</RevTid>
</Record1>
</ResultSet1>
<Update5>1</Update5>
<Update6>0</Update6>
</Resultsets>
With BW 5.7 the output is:
<?xml version="1.0" encoding="UTF-8"?>
<Resultsets>
<UpdateCount>1</UpdateCount>
<UpdateCount>1</UpdateCount>
<UpdateCount>1</UpdateCount>
<UpdateCount>1</UpdateCount>
<ResultSet1>
<Record1>
<StnSign> </StnSign>
<Nummer>040 966503</Nummer>
<Resultatkod>0</Resultatkod>
<Kabellangd>1796</Kabellangd>
<RevTid>2008-12-18 02:22:31</RevTid>
</Record1>
</ResultSet1>
<UpdateCount>1</UpdateCount>
<UpdateCount>0</UpdateCount>
</Resultsets>
Cause:
This is due to a change in the stored procedure resultset output 'update1' to 'updatecount'.
The parsing of stored procedure output fails after upgrading from BW versions before 5.7.0 to newer versions.
Symptoms:
Error in Parse XML activity, which parses stored procedure output, after upgrading from older BW versions to versions post 5.7.0. With 5.6 the output is:
<?xml version="1.0" encoding="UTF-8"?>
<Resultsets>
<Update1>1</Update1>
<Update2>1</Update2>
<Update3>1</Update3>
<Update4>1</Update4>
<ResultSet1>
<Record1>
<StnSign> </StnSign>
<Nummer>040 966503</Nummer>
<Resultatkod>0</Resultatkod>
<Kabellangd>1796</Kabellangd>
<RevTid>2008-12-18 02:22:31</RevTid>
</Record1>
</ResultSet1>
<Update5>1</Update5>
<Update6>0</Update6>
</Resultsets>
With BW 5.7 the output is:
<?xml version="1.0" encoding="UTF-8"?>
<Resultsets>
<UpdateCount>1</UpdateCount>
<UpdateCount>1</UpdateCount>
<UpdateCount>1</UpdateCount>
<UpdateCount>1</UpdateCount>
<ResultSet1>
<Record1>
<StnSign> </StnSign>
<Nummer>040 966503</Nummer>
<Resultatkod>0</Resultatkod>
<Kabellangd>1796</Kabellangd>
<RevTid>2008-12-18 02:22:31</RevTid>
</Record1>
</ResultSet1>
<UpdateCount>1</UpdateCount>
<UpdateCount>0</UpdateCount>
</Resultsets>
Cause:
This is due to a change in the stored procedure resultset output 'update1' to 'updatecount'.
Issue/Introduction
Parsing of stored procedure output fails after upgrading from BW versions before 5.7.0 to newer versions.
Resolution
Change the schema that parses the output
Feedback
Yes
No
Powered by
