VI Job to Update Auto-LogOff for users

SOLVED

We want to efficiently set all but a few users to have their AutoLogoff set to "Y" and have a 60 minute Inactivity Timer. So I'm trying to run a VI Job to update the SY_User table to update the following fields: AutoLogoff, InactivityTime and UserKey (just running replace with the existing UserKey) and I've gotten this error: "HS Record Invalid or Write Failed. Invalid User Logon."

I must be missing something here, unless this table isn't able to be updated in this way? Would it be more efficient to update the table directly via SQL?

  • +1
    verified answer

    It looks like the VI Import for SY_User expects both the UserKey and UserCode to be set.  You also need to make sure that if you opened your source file in Excel, it didn't strip out the leading zeros in the UserKey. 

    If your source file does have the leading zeros stripped out, you could use the following calculation to pad it appropriately.  Replace the "1" in between the brackets with the appropriate column number in your source file that holds the UserKey.

    PAD(IMP$[1], 10, "L", "0")