SQL Anywhere Error -131 Appears When Changing A User's Password

Problem: The error message com.sybase.scc.jmx.ManagedObjectGateway.err_invoke_op SQL Anywhere Error -131: Syntax error near 'BY' on line 1 appears when you attempt to change the password of another user.

This error message indicates that the change_password_dual_control option is enabled in the login policy for the selected user. This feature is not currently implemented in SAP Control Center.

Solution: Change the password using interactive SQL.

Note: Once the new dual part password is set, the user must connect to the IQ database outside of SAP Control Center and change his or her password before he or she can to log in to SAP Control Center. Failure to do this results in an error when logging in to SAP Control Center.