An error occurred while executing a save: Expression evaluation error: The save target must be a local variable that does not refresh on every evaluation or on an interval, a process variable, or a node input

title as above,

code as:

a!save(target:ri!userinputsheet.KONE_user_name,value:fv!item.KONE_user_name),
                a!save(target:ri!userinputsheet.FIRST_NAME,value:fv!item.FIRST_NAME),
                a!save(target:ri!userinputsheet.LAST_NAME,value:fv!item.LAST_NAME),
                a!save(target:ri!userinputsheet.Email,value:fv!item.Email),
                a!save(target:ri!userinputsheet.Role,value:fv!item.Role),
                a!save(target:ri!userinputsheet.Branch,value:fv!item.Branch),
                a!save(target:ri!userinputsheet.Region,value:fv!item.Region),
                a!save(target:ri!userinputsheet.Manager_role,value:fv!item.Manager_role),
                a!save(target:ri!userinputsheet.Telephone_number,value:fv!item.Telephone_number),
                a!save(target:ri!userinputsheet.CE_LEVEL,value:fv!item.CE_LEVEL),
                a!save(target:ri!userinputsheet.Active,value:fv!item.Active),
                a!save(target:ri!userinputsheet.Language,value:fv!item.Language),
                a!save(target:ri!userinputsheet.Exceptional_case_library_view_right,value:fv!item.Exceptional_case_library_view_right),
                a!save(target:ri!userinputsheet.updateTime,value:now()),
                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)
                  }
                )

what is the problem?

  Discussion posts and replies are publicly visible

Parents Reply Children
  • I wasn't accomplish exact what you mean, i didn't use a!refreshVariable in this interface, plus i don't think i recall this interface from others or vice versa.

  • How many dependents does this interface have? And where are you calling it? Directly in a process model?

  • a!localVariables(   
      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!valid:false(),
      local!Language,
      local!noFiltersApplied: any(fn!isnull, {ri!userinputsheet.kone_user_name, ri!userinputsheet.FIRST_NAME, 
      ri!userinputsheet.LAST_NAME,ri!userinputsheet.Email,
      ri!userinputsheet.Role,
      }),
      a!formLayout(
        label:"Registration Info",
        contents: {
          a!textField(
            label: "Username(please fill lower case or it will transfer to lower)",
            value: {ri!userinputsheet.kone_user_name},
            saveInto: {
              a!save(target:ri!userinputsheet.Active,value:1),
              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()),
              a!save(target:ri!userinputsheet.kone_user_name,
              value:trim(lower(save!value))),
              a!save(target:ri!userrole.NAME,
                     value:trim(lower(save!value))),
              a!save(target:local!valid,
              value:if(isnull(ri!userinputsheet.kone_user_name),false(),
              if(a!queryEntity(
                entity:cons!KONE_Development_userrole_Constant,
                fetchTotalCount:true,
                query:a!query(
                  filter:a!queryFilter(
                    field:"NAME",operator:"=",
                    value:ri!userinputsheet.kone_user_name
                  ),
                  pagingInfo:a!pagingInfo(
                    startIndex: 1,
                    batchSize: 50
                  )
                )
              ).totalCount>0,true(),false()
              )
              )
              )
             },
            required:true,
             validations:if(local!valid=true(),"username already exists",null)
            
          ),
          a!textField(
            label: "FirstName",
            value: {ri!userinputsheet.FIRST_NAME},
            saveInto: {ri!userinputsheet.FIRST_NAME},
            required:true
          ),
          a!textField(
            label: "LastName",
            value: {ri!userinputsheet.LAST_NAME},
            saveInto: {ri!userinputsheet.LAST_NAME},
            required:true
          ),
          a!textField(
            label: "Email",
            value: {ri!userinputsheet.Email},
            saveInto: {
              a!save(target:ri!userinputsheet.Email,
                     value:save!value),
              a!save(target:ri!userrole.EMAIL,value:save!value)
            },
            required:true,
            validations:if(find("@",ri!userinputsheet.Email),if(find(".com",ri!userinputsheet.Email),null,"not contain correction .com"),if(find(".com",ri!userinputsheet.Email),"not contain @","not contain @ and .com"))
          ),
          a!dropdownField(
            label:"Role",
            placeholder:"---please fill your Role---",
            choiceLabels:reject(fn!isnull,local!allRole),
            choiceValues:reject(fn!isnull,local!allRole),
            value:ri!userinputsheet.Role,
            saveInto:{
            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,{})        
            ))
            },
            required:true
          ),
          a!dropdownField(
            label:"Branch",
            placeholder:"---please fill your Branch---",
            choiceLabels:reject(fn!isnull,local!allBranch),
            choiceValues:reject(fn!isnull,local!allBranch),
            value:ri!userinputsheet.Branch,
            saveInto:{
            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,{})        
            ))
            }
          ),
          a!dropdownField(
            label:"Region",
            placeholder:"---please fill your Region---",
            choiceLabels:reject(fn!isnull,local!allRegion),
            choiceValues:reject(fn!isnull,local!allRegion),
            value:ri!userinputsheet.Region,
            saveInto:{
            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,{})        
            ))
            }
          ),
          a!dropdownField(
            label:"Manager_Role",
            placeholder:"---please fill your Manager_Role---",
            choiceLabels:reject(fn!isnull,local!allRole),
            choiceValues:reject(fn!isnull,local!allRole),
            value:ri!userinputsheet.Manager_role,
            saveInto:{
              a!save(target:ri!userinputsheet.Manager_role,value:save!value)
            }
          ),
          a!dropdownField(
            label:"Language",
            labelPosition: "ABOVE",
            placeholder:"Chinese",
            choiceLabels:{reject(fn!isnull,local!allLanguage)},
            choiceValues:reject(fn!isnull,local!allLanguage),
            value:ri!userinputsheet.Language,
            saveInto:{
            a!save(target:local!Language,value:save!value),
            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,2)        
            ))
            }
          ),
          a!textField(
            label: "CELevel",
            value: {ri!userinputsheet.CE_LEVEL},
            saveInto: {
              a!save(target:ri!userinputsheet.CE_LEVEL,value:save!value),
              a!save(target:ri!userrole.LEVEL,value:save!value)
            }
          ),
          a!textField(
            label: "Telephone Number",
            value: {ri!userinputsheet.Telephone_number},
            saveInto: {
              a!save(target:ri!userinputsheet.Telephone_number,value:save!value),
              a!save(target:ri!userrole.TELEPHONE_NUMBER,value:save!value)
            },
            validations: 
            if( len(ri!userinputsheet.Telephone_number) <> 11, "phone number should be 11 digits", null )
          ),
          a!textField(
            label: "Exceptional Case Library View Right",
            value: {ri!userinputsheet.Exceptional_case_library_view_right},
            saveInto: {
              a!save(target:ri!userinputsheet.Exceptional_case_library_view_right,value:save!value)
            },
            refreshAfter: "KEYPRESS"
          ),
          a!richTextDisplayField(
            labelPosition: "COLLAPSED",
            value: {
              a!richTextItem(
                text:"username already exists or incorrect fill such as leave the necessary field blank or wrong form"
              )
            },
            showWhen:local!valid=true()
          )    
          },
          buttons:a!buttonLayout(
            primaryButtons:{
              a!buttonWidget(
                label: "Submit",
                saveInto:{
                  if(isnull(ri!userinputsheet.Language),
                  a!save(
                    target:ri!userinputsheet.Language,
                    value:"Chinese"
                  ),{}),
                  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)
                   }
                  ),
                  a!save(ri!userinputsheet,null())
                },
                submit: true,
                style: "PRIMARY",
                disabled: or(local!valid=true(),local!noFiltersApplied)
              ),
              a!buttonWidget(
              label:"Clear",
              saveInto: {a!save(ri!userinputsheet, null())},  
              submit:false,
              style:"PRIMARY"
              )
            }
          )
        )
      )
    

    errors occur after line:507. 

  • I only have one interface, and i don't think this interface have any dependents