Updating the security.properties file

[CR #337866] If auditing is enabled, you must update the security.properties file after performing the upgrade so users can log in to Enterprise Portal.

Workaround: Follow these steps:

StepsUpdating the security.properties file

  1. Go to %EAServer%\java\classes\com\sybase\ep\security and open the security.properties file with a text editor.

  2. Locate the line:

    INSERT Audit(recordType, subjectID, timeStamp, auditData) VALUES (?,?,?,?)
    
  3. Change it to:

    INSERT Audit(recordID, timeStamp, auditData) VALUES ({1}, {2}, {3})