cancel
Showing results for 
Search instead for 
Did you mean: 

Sybase ASE - Update of Syslogins failed.

ps_vinay
Explorer
0 Kudos

Hello All,

Last few days we are observing the below msg in Sybase errorlog. User complained that the login gets disconnected and have to rerun the reports.

Update of Syslogins failed

Any workaround for this.


Thanks,

P S Vinay

Accepted Solutions (0)

Answers (3)

Answers (3)

Former Member
0 Kudos
jayrijnbergen
Active Participant
0 Kudos

Are there many new connections on this server?

Do you have enabled last login updates?

check current setting with:

exec sp_passwordpolicy 'list', 'enable last login updates'

If current value = 1 then setting is enabled

to disable this setting for overloaded server:

exec sp_passwordpolicy 'clear', 'enable last login updates'

Do you have any other process, e.g. a login trigger, which is trying to update something in syslogins?

ps_vinay
Explorer
0 Kudos

Any update on this?

Former Member
0 Kudos

Are there any deadlock messages in the errorlog associated with the master database?