In Catalog SoapResponsBody output of the method "getFormRateItemValues" inverts line numbers after upgrading to RU12

Products

• CA Service Management - Service Desk Manager

Issue/Introduction

Issue:

The SoapResponsBody output of the method "getFormRateItemValues" changed from 17.3RU5 to 17.3RU12

Steps:

-> The order of columns and lines in the table „swe1_table“ (swe1_table-swe_name1—3), is stored in a reversed order in the SoapResponesBody, (1st line highest number; last line = 1). So its not possible to use an Array fort he number of lines in the XML.

-> Syntax: <table-ID>-<field(column)-ID>--<row-ID>
the row-ID is NOT the line number in the table.

->  Untill RU5 the line number of the SoapResponseBody fields has been the same as in the form.

Table lines in the form:

Field numbers in XML (SoapResponseBody with the method „getFormRateItemValues“

<form xsi:type="ns1:FormElement">

<ID xsi:type="soapenc:string">swe1_table</ID>

<label xsi:type="soapenc:string">Softwareeinheiten/Release</label>TC-59891 

<labelValue xsi:nil="true" xsi:type="soapenc:string"/>

<type xsi:type="xsd:int">21</type>

<value xsi:nil="true" xsi:type="soapenc:string"/>

</form>

<form xsi:type="ns1:FormElement">

<ID xsi:type="soapenc:string">swe1_table-swe_name1--3</ID> ß 1. Line in the table

<label xsi:type="soapenc:string">Softwareeinheit</label>

<labelValue xsi:nil="true" xsi:type="soapenc:string"/>

<type xsi:type="xsd:int">0</type>

<value xsi:type="soapenc:string">Systemnahe Software BayLfSt-Wiki_1.2.0</value> ß 1. Line in the table

</form>

<form xsi:type="ns1:FormElement">

<ID xsi:type="soapenc:string">swe1_table-swe_version1--3</ID>

<label xsi:type="soapenc:string">aktuelle Version</label>

<labelValue xsi:nil="true" xsi:type="soapenc:string"/>

<type xsi:type="xsd:int">0</type>

<value xsi:type="soapenc:string">1.2.0</value>

</form>

Environment

Release : 17.3

Component : Catalog - Accounting

Resolution

This is resolved by SE via defect DE64676 and the fix is included in 17.3 RU 16. Post applying path please run the below query in the database.
      
      MSSQL:
      if not exists (select * from usm_configuration where group_name = 'userdefaults' and name = 'skiptableroworder')
        begin
        insert into usm_configuration values ('userdefaults','skiptableroworder','INSTALLED_DEFAULT', 3, 0,  'true',  0,  '111,114', 'USV', NULL, NULL);
      end
      
      If you want to revert your changes, please run the below:
      
       if exists (select * from usm_configuration where group_name = 'userdefaults' and name = 'skiptableroworder')
    begin
        delete from usm_configuration where group_name = 'userdefaults' and name = 'skiptableroworder'
    end
    
    Oracle:
     select count(*) into cnt from mdbadmin.usm_configuration where group_name = 'userdefaults' and name = 'skiptableroworder';
        if cnt = 0 then
        insert into mdbadmin.usm_configuration values('userdefaults','skiptableroworder','INSTALLED_DEFAULT', 3,  0,  'true',  0,  '111,114', 'USV', NULL, NULL);
        end if;
    end;
      
      select count(*) into cnt from mdbadmin.usm_configuration where group_name = 'userdefaults' and name = 'skiptableroworder';
        if cnt > 0 then
        delete from mdbadmin.usm_configuration where group_name = 'userdefaults' and name = 'skiptableroworder';
        end if;
        end;