Difference between revisions of "TW Bridge and SA users expired"
Jump to navigation
Jump to search
Line 1: | Line 1: | ||
== Overview == | == Overview == | ||
− | When you login to | + | When you login to System Administrator in TouchWorks EHR v10 or below, CMS Patient Merge or TouchWorks bridge in GE/IDX ConnectR you receive a message indicating that your user's pword will either expire in X days, or has expired.<BR><BR> |
− | + | Soon to expire dialog message:<BR> | |
− | Soon to expire:<BR> | + | ''-2147220384 WARNING: Your pword will expire in 4 days'' |
− | |||
− | Expired:<BR> | + | Expired dialog message:<BR> |
− | + | ''-2147220383 Your pword has Expired. Please Enter a New pword.'' | |
== Fix == | == Fix == | ||
Line 14: | Line 13: | ||
SET PasswordChangedDTTM = getdate() | SET PasswordChangedDTTM = getdate() | ||
,ChangePasswordDays = 999 | ,ChangePasswordDays = 999 | ||
− | WHERE AUserName = ' | + | WHERE AUserName = '<insert target username'</pre> |
− | This will reset the date when the | + | This will reset the date when the pword was changed to today, and extend it for 999 days. You could increase the ChangePasswordDays to 32,767, which is the maximum value allowed in that column (data type = smallint). |
Latest revision as of 11:50, 15 June 2012
Overview
When you login to System Administrator in TouchWorks EHR v10 or below, CMS Patient Merge or TouchWorks bridge in GE/IDX ConnectR you receive a message indicating that your user's pword will either expire in X days, or has expired.
Soon to expire dialog message:
-2147220384 WARNING: Your pword will expire in 4 days
Expired dialog message:
-2147220383 Your pword has Expired. Please Enter a New pword.
Fix
Run the following SQL in the master database on the clinical DB server:
UPDATE IDX_Login SET PasswordChangedDTTM = getdate() ,ChangePasswordDays = 999 WHERE AUserName = '<insert target username'
This will reset the date when the pword was changed to today, and extend it for 999 days. You could increase the ChangePasswordDays to 32,767, which is the maximum value allowed in that column (data type = smallint).