Skip to main content
September 2, 2021
Question

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

  • September 2, 2021
  • 8 replies
  • 0 views
Could not display interface. Please check definition and inputs.

Interface Definition: Expression evaluation error: An error occurred while executing a smart service: An error occurred while trying to write to the data store [KONE_User_Development_Database]. No values have been written. Details: could not insert: [USERROLEDT2804] (APNX-1-4208-004)

I make a interface for new user to register, but once new user finish his information fill in and hit submit, the first time is good, all data inserted to back end without problem. However,if he click twice in submit button, always jump out report error as above.

    8 replies

    September 2, 2021

    I doubt it might be the name column is unique but that person click twice though auto increment a new userId as primary key but the name is replicated so which not allowed.

    stefanhelzle0001
    Brainy
    September 2, 2021

    OK. Then you might want to prevent the user from clicking twice. Not sure about the exact use case. When I do things like this, I modify the state of the UI in a way the user can not enter the same data multiple times.

    September 2, 2021

    Thank you sir, I am new to appian not go that far yet, are there other refer to document i can see such process or UI interface?