No values have been written. Details: could not insert: [USERROLEDT2804] (APNX-1-4208-004)

Question

a!localVariables(
 local!rule:rule!KONE_Development_userinputsheet_Rule(),
 local!allRole:rule!KONE_Development_ROLE(),
 local!allLanguage:rule!KONE_Development_LANGUAGE(),
 local!allBranch:rule!KONE_Development_BRANCH(),
 local!allRegion:rule!KONE_Development_REGION(),
 local!noFiltersApplied: all(fn!isnull, {ri!userinputsheet.KONE_user_name}),
 local!searchValue,
 a!sectionLayout(
 label:"Update Info",
 contents: {
 a!columnsLayout(
 columns: {
 a!columnLayout(
 contents: {
 a!textField(
 label: "Username",
 value: local!searchValue,
 saveInto: {local!searchValue
 },
 refreshAfter: "KEYPRESS"
 ),
 a!buttonLayout(
 primaryButtons: {
 a!buttonWidget(
 label: "SEARCH",
 saveInto: {
 local!searchValue,
 },
 disabled: local!noFiltersApplied
 )
 }
 ),
 a!gridLayout(
 label: "Editable Grid",
 labelPosition: "ABOVE",
 headerCells: {
 a!gridLayoutHeaderCell(
 label: "Username"
 ),
 a!gridLayoutHeaderCell(
 label: "First Name"
 ),
 a!gridLayoutHeaderCell(
 label: "Last Name"
 ),
 a!gridLayoutHeaderCell(
 label: "Email"
 ),
 a!gridLayoutHeaderCell(
 label: "Role"
 ),
 a!gridLayoutHeaderCell(
 label: "Branch"
 ),
 a!gridLayoutHeaderCell(
 label: "Region"
 ),
 a!gridLayoutHeaderCell(
 label: "Manager_role"
 ),
 a!gridLayoutHeaderCell(
 label: "Language"
 ),
 a!gridLayoutHeaderCell(
 label: "CE_LEVEL"
 ),
 a!gridLayoutHeaderCell(
 label: "Telephone Number"
 ),
 a!gridLayoutHeaderCell(
 label: "Exceptional Case Library View Right"
 ),
 a!gridLayoutHeaderCell(
 label: "Update"
 ),
 a!gridLayoutHeaderCell(
 label: "Delete"
 ),
 a!gridLayoutHeaderCell(
 label: "Restart"
 )
 },
 columnConfigs: {
 a!gridLayoutColumnConfig(
 width: "DISTRIBUTE"
 ),
 a!gridLayoutColumnConfig(
 width: "DISTRIBUTE"
 ),
 a!gridLayoutColumnConfig(
 width: "DISTRIBUTE"
 ),
 a!gridLayoutColumnConfig(
 width: "DISTRIBUTE"
 ),
 a!gridLayoutColumnConfig(
 width: "DISTRIBUTE"
 ),
 a!gridLayoutColumnConfig(
 width: "DISTRIBUTE"
 ),
 a!gridLayoutColumnConfig(
 width: "DISTRIBUTE"
 ),
 a!gridLayoutColumnConfig(
 width: "DISTRIBUTE"
 ),
 a!gridLayoutColumnConfig(
 width: "DISTRIBUTE"
 ),
 a!gridLayoutColumnConfig(
 width: "DISTRIBUTE"
 ),
 a!gridLayoutColumnConfig(
 width: "DISTRIBUTE"
 ),
 a!gridLayoutColumnConfig(
 width: "DISTRIBUTE"
 ),
 a!gridLayoutColumnConfig(
 width: "DISTRIBUTE"
 ),
 a!gridLayoutColumnConfig(
 width: "DISTRIBUTE"
 ),
 a!gridLayoutColumnConfig(
 width: "DISTRIBUTE"
 )
 },
 rows: {
 a!forEach(
 items: local!rule,
 expression:a!gridRowLayout(
 contents: {
 a!textField(
 label: "Username",
 labelPosition: "ABOVE",
 value:if(local!searchValue=fv!item.KONE_user_name,local!searchValue,fv!item.KONE_user_name),
 saveInto: {
 fv!item.KONE_user_name,
 a!save(target:ri!userinputsheet.KONE_user_name,value:save!value),
 a!save(target:ri!userrole.NAME,value:save!value),
 a!save(target:ri!userrole.USER_ID,value:a!localVariables(local!value:fv!item.KONE_user_name,
 a!forEach(
 items:rule!KONE_Development_Username_UserId(),
 expression: if(local!value=fv!item.username,fv!item.userid,{}),
 ),
 )),
 },
 refreshAfter: "UNFOCUS",
 readOnly: true,
 validations: {}
 ),
 a!textField(
 label: "First Name",
 labelPosition: "ABOVE",
 value:fv!item.FIRST_NAME,
 saveInto: {fv!item.FIRST_NAME,
 a!save(target:ri!userinputsheet.FIRST_NAME,value:save!value)},
 refreshAfter: "UNFOCUS",
 validations: {}
 ),
 a!textField(
 label: "Last Name",
 labelPosition: "ABOVE",
 value:fv!item.LAST_NAME,
 saveInto: {fv!item.FIRST_NAME,
 a!save(target:ri!userinputsheet.LAST_NAME,value:save!value),
 },
 refreshAfter: "UNFOCUS",
 validations: {}
 ),
 a!textField(
 label: "Email",
 labelPosition: "ABOVE",
 value:fv!item.Email,
 saveInto: { 
 fv!item.Email,
 a!save(target:ri!userinputsheet.Email,
 value:save!value),
 a!save(target:ri!userrole.EMAIL,value:save!value)},
 refreshAfter: "UNFOCUS",
 validations: {}
 ),
 a!dropdownField(
 label: "Role",
 labelPosition: "ABOVE",
 choiceLabels:reject(fn!isnull,local!allRole),
 choiceValues:reject(fn!isnull,local!allRole),
 value:if(isnull(fv!item.Role),"null",fv!item.Role),
 saveInto:{
 fv!item.Role,
 a!save(target:ri!userinputsheet.Role,value:save!value),
 a!save(
 target:ri!userrole.ROLE_ID,
 value: a!forEach
 (items:rule!KONE_Development_Role_RoleId(),
 expression:if(fv!item.Role=ri!userinputsheet.Role,fv!item.Role_Id,{}) 
 )),
 a!save(
 target:ri!userrole.ROLE,
 value: save!value),
 a!save(target:ri!userrole.PHASE_ID,
 value:a!forEach
 (items:rule!KONE_Development_Role_RoleId(),
 expression:if(fv!item.Role=ri!userinputsheet.Role,fv!item.Role_Id,{}) 
 ))
 },
 validations: {}
 ),
 a!dropdownField(
 label: "Branch",
 labelPosition: "ABOVE",
 choiceLabels:reject(fn!isnull,local!allBranch),
 choiceValues:reject(fn!isnull,local!allBranch),
 value:if(isnull(fv!item.Branch),"null",fv!item.Branch),
 saveInto:{
 fv!item.Branch,
 a!save(target:ri!userinputsheet.Branch,value:save!value),
 a!save(target:ri!userrole.BRANCH,value:save!value),
 a!save(target:ri!userrole.BRANCH_ID,
 value:a!forEach
 (items:rule!KONE_Development_Branch_BranchId(),
 expression:if(fv!item.Branch=ri!userinputsheet.Branch,fv!item.Branch_Id,{}) 
 ))
 },
 refreshAfter: "UNFOCUS",
 validations: {}
 ),
 a!dropdownField(
 label: "Region",
 labelPosition: "ABOVE",
 choiceLabels:reject(fn!isnull,local!allRegion),
 choiceValues:reject(fn!isnull,local!allRegion),
 value:fv!item.Region,
 saveInto:{
 fv!item.Region,
 a!save(target:ri!userinputsheet.Region,value:save!value),
 a!save(target:ri!userrole.REGION,value:save!value),
 a!save(target:ri!userrole.REGION_ID,
 value:a!forEach
 (items:rule!KONE_Development_Region_RegionId(),
 expression:if(fv!item.Region=ri!userinputsheet.Region,fv!item.Region_Id,{}) 
 ))
 },
 refreshAfter: "UNFOCUS",
 validations: {}
 ),
 a!dropdownField(
 label: "Manager_role",
 labelPosition: "ABOVE",
 choiceLabels:reject(fn!isnull,local!allRole),
 choiceValues:reject(fn!isnull,local!allRole),
 value:if(isnull(fv!item.Manager_role),"null",fv!item.Manager_role),
 saveInto:{
 fv!item.Manager_role,
 a!save(target:ri!userinputsheet.Manager_role,value:save!value)
 },
 refreshAfter: "UNFOCUS",
 validations: {}
 ),
 a!dropdownField(
 label: "Language",
 labelPosition: "ABOVE",
 choiceLabels:reject(fn!isnull,local!allLanguage),
 choiceValues:reject(fn!isnull,local!allLanguage),
 value:if(isnull(ri!userinputsheet.Language),"null",ri!userinputsheet.Language),
 saveInto:{
 fv!item.Language,
 a!save(target:ri!userinputsheet.Language,value:save!value),
 a!save(target:ri!userrole.LANG_ID,
 value:a!forEach
 (items:rule!KONE_Development_Language_LanguageId(),
 expression:if(fv!item.Language=ri!userinputsheet.Language,fv!item.Language_Id,{}) 
 ))
 },
 refreshAfter: "UNFOCUS",
 validations: {}
 ),
 a!textField(
 label: "CE_LEVEL",
 labelPosition: "ABOVE",
 value:fv!item.CE_LEVEL,
 saveInto: {
 fv!item.CE_LEVEL,
 a!save(target:ri!userinputsheet.CE_LEVEL,value:save!value),
 a!save(target:ri!userrole.LEVEL,value:save!value)
 },
 refreshAfter: "UNFOCUS",
 validations: {}
 ),
 a!textField(
 label: "Telephone Number",
 labelPosition: "ABOVE",
 value:fv!item.Telephone_number,
 saveInto: {
 fv!item.Telephone_number,
 a!save(target:ri!userinputsheet.Telephone_number,value:save!value),
 a!save(target:ri!userrole.TELEPHONE_NUMBER,value:save!value)
 },
 refreshAfter: "UNFOCUS",
 validations: {}
 ),
 a!textField(
 label: "Exceptional Case Library View Right",
 labelPosition: "ABOVE",
 value:fv!item.Exceptional_case_library_view_right,
 saveInto: {
 fv!item.Exceptional_case_library_view_right,
 a!save(target:ri!userinputsheet.Exceptional_case_library_view_right,value:save!value),
 a!save(target:ri!userrole.IS_EXCEPTION,value:0),
 a!save(target:ri!userrole.ACTIVE,value:1),
 a!save(target:ri!userinputsheet.updateTime,value:now()),
 },
 refreshAfter: "UNFOCUS",
 validations: {}
 ),
 a!richTextDisplayField(
 label:"Update",
 labelPosition:"ABOVE",
 value:{
 a!richTextIcon(
 icon:"check",
 link:a!dynamicLink(
 saveInto:{
 a!writeToMultipleDataStoreEntities(
 valuesToStore: {
 a!entityData(entity: cons!KONE_Development_userinputsheet_Constant, data: ri!userinputsheet),
 a!entityData(entity: cons!KONE_Development_userrole_Constant, data: ri!userrole)
 }
 ),
 }
 ),
 linkStyle:"STANDALONE",
 color:"POSITIVE"
 )
 }
 ),
 a!richTextDisplayField(
 label:"Delete",
 labelPosition:"ABOVE",
 value:{
 a!richTextIcon(
 icon:"arrow-down",
 link:a!dynamicLink(
 saveInto:{a!save(target:ri!userrole.ACTIVE,value:0),
 a!writeToMultipleDataStoreEntities(
 valuesToStore: {
 a!entityData(entity: cons!KONE_Development_userinputsheet_Constant, data: ri!userinputsheet),
 a!entityData(entity: cons!KONE_Development_userrole_Constant, data: ri!userrole)
 },
 ),
 }
 ),
 linkStyle:"STANDALONE",
 color:"NEGATIVE"
 )
 }
 ),
 a!richTextDisplayField(
 label:"Restart",
 labelPosition:"ABOVE",
 value:{
 a!richTextIcon(
 icon:"arrow-up",
 link:a!dynamicLink(
 saveInto:{a!save(target:ri!userrole.ACTIVE,value:1),
 a!writeToMultipleDataStoreEntities(
 valuesToStore: {
 a!entityData(entity: cons!KONE_Development_userinputsheet_Constant, data: ri!userinputsheet),
 a!entityData(entity: cons!KONE_Development_userrole_Constant, data: ri!userrole)
 },
 ),
 }
 ),
 linkStyle:"STANDALONE",
 color:"POSITIVE",
 )
 }
 ),
 }
 )
 )
 },
 ),
 }
 )
 }
 )
 }
 )
)
 
 Sorry i pose this problem again, this time the situation is a little bit different, i wish to update it. The primary key as ri!userinputsheet.USER_ID, another unique column as ri!userinputsheet.username. I a!writeToDataEntity again, then it got error report, Theoretically I write into with primary key and username is not change because it is read only, it should have achieve update function already, then how it can't be ?