Error while setting a default Data Partition ?Data partition default "0" for attribute priority is incorrect value type string; expecting type integer?

Document ID : KB000029751
Last Modified Date : 14/02/2018
Show Technical Document Details

Setting priority=‘None’ as the default constraint type on the Change Request table, results in the below error in the stdlog:

 “Data partition default "0" for attribute priority is incorrect value type string; expecting type integer

 1.png

2.png

Solution:

Use value of 6 (or any value greater than 5 for that matter) for Priority, it will get internally mapped to the “0” enum value and as a result it will display ‘None’ as the selected value on the Priority dropdown.

We came up with the solution of setting the default data partition to ‘priority=6’ as opposed to ‘priority=0’ by enabling bop_logging on the domsrvr and looked at the values that are being passed from domsvr to the webengine for various partitions.

Below is an excerpt from the bop_logging logs that were captured:

Setting priority=6 as the default Data Partition:

For priority 6, the enum value of 0 is being used and that patches the “None” priority from the Priority (pri) table: 

01/12 23:04:15.140 (+0.002) Imported Msg [User ServiceDesk; Session 176439499]

To: SREL:PAT:MTH:

BPMessage[ 454623232.2800.33 ]

{

                method = set_val

                arg 0 = (integer)0

                reply object = XjIAAA (refcounted 5 refs)  [P_Dob chg:400002]

                reply method = dp_default_done

}

 01/12 23:04:15.805 (+0.000) Imported Msg [User superuser/ServiceDesk; Session 176439499]

To: @|domsrvr|DBAAAA

BPMessage

{

                method = dob_by_key

                arg 0 = (string)enum

                arg 1 = (integer)1

                arg 2 = (integer)0

                reply object = PlIAAA (refcounted 2 refs)  [SRef_Holder]

                reply method = mlist_key_ret

}

                method = got_dob_vals

                 arg 142 = (string)priority.persistent_id

                arg 143 = (integer)0

                arg 144 = (string)pri:505

                arg 145 = (string)priority.sym

                arg 146 = (integer)0

               arg 147 = (string)None