Category not set correctly when a service option element is created or editted

Document ID : KB000098052
Last Modified Date : 01/06/2018
Show Technical Document Details
Issue:
When a new service option element is created, the category, category_class and category_subclass fields in the MDB for that service option element are not populated correctly. You can see the problem if you follow these steps:

1. Create new Service Option Element (SOE)
2. Select the icon for the SOE.
3. Set the name of SOE
4. Add any other elements, such as forms, rate, text ect.
5. Set the Category, Category Class, Category Subclass for this SOE.
6. Save this SOE.

If you run the following query against the MDB, you can see that the category, category_class and category_subclass fields are correct for the first two lines, but n

SELECT item_id, service_option_id, status, item_text, item_type, category, category_class, category_subclass
 FROM usm_rate_definition
  WHERE status=1 and service_option_id = 7264

(7264 is the id of the newly created SOE).

The output is:

item_id service_option_id status item_text item_type category category_class category_subclass
45020 7264 1 Test 6 0 2 30 10
45021 7264 1  0 2 30 10
45022 7264 1 Form 14 -1 -1 -1
45023 7264 1 Rate 3 -1 -1 -1
45024 7264 1 Text 0 -1 -1 -1
45025 7264 1 Numeric 6 -1 -1 -1

Only the first two lines have the correct values in the category, category_class and category_subclass fields.

If I then edit the SOE, add or remove a new element and save it and then re-run the same SQL statement, the category, category_class and category_subclass fields are correct for all items:

item_id service_option_id status item_text item_type category category_class category_subclass
45038 7264 1 Text Again 0 2 30 10
45039 7264 1 Test 6 0 2 30 10
45040 7264 1  0 2 30 10
45041 7264 1 Form 14 2 30 10
45042 7264 1 Rate 3 2 30 10
45043 7264 1 Text 0 2 30 10
45044 7264 1 Numeric 6 2 30 10

A further problem is seen if the user edits the SOE, changes the category, category class and category subclass. When they save the change, only the name and icon rows are updated with the new values, all other rows contain the old values.

item_id service_option_id status item_text item_type category category_class category_subclass
45045 7264 1 Test 6 0 4 20 50
45046 7264 1  0 4 20 50
45047 7264 1 Form 14 2 30 10
45048 7264 1 Rate 3 2 30 10
45049 7264 1 Text 0 2 30 10
45050 7264 1 Numeric 6 2 30 10
45051 7264 1 Text Again 0 2 30 10
Resolution:
A workaround for this is to edit the service option element, make a small change and then save the change. This will reset the values in the category, category_class and category_subclass fields to their correct values.

A fix will be produced for this problem in the future.