Follow

SPT DELETE failed with the following command

 

Title:

 SPT DELETE failed with the following command

 

Affected Users:

LimsPlus Administrators

LimsPlus users

 

Fielded Statements:

Why can't I change my password?

SPT Insert Error. Insert into auditsessions (limslogin, logintime, limsworkstation, limsfullname) when trying to login to LIMS-plus after the application was re-installed.

 

Description:

The message will usually appear after a reinstallation or update/upgrade of LimsPlus application.

(this message was generated when trying to change the password for a Staff member)

SPT DELETE failed with the following command:
Delete from PasswrdHist where rep_id = 'ZC78612U0KQY0Y' And pswhist_id not in ('ZCSD62S60NUONU')   

Line 1: 1526

Line 2: Connectivity error: [Microsoft] [ODBC SQL Server Driver] [SQL Server] Cannot insert the value NULL into

column 'rec_primkey', table 'sqllims.dbo.audittrail'; column does not allow nulls. INSERT fails.

Line 3: [Microsoft] [ODBC SQL Server Driver] [SQL Server] Cannot insert the value NULL into column 'rec_primkey',

table 'sqllims.dbo.audittrail'; column does not allow nulls. INSERT fails.

Line 4: 23000

Line 5: 515

Line 6: 1

Line 7:

sptdelete_10302009.jpg 

 

 

Resolution:

Depending on the number of clients used within an agency, the SPID spawned by a SQL server may be larger than the default 5 digits.  Changing the value for the SPID field in the auditsessions table from 5 to 7 should correct the situation.

 

auditsessions_10302009.jpg

 

 

 

NOTE: In order to make the changes to the Auditsessions table you will need to have either your Database Administrator make the necessary change or have an account that permits you access to the SQL server.  Please note that it is best to perform these tasks when a full backup of the database has been made and that all users are logged off and are out of the LimsPlus application.

 

Article ID : JTKB258

 

Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request

0 Comments

Please sign in to leave a comment.
Powered by Zendesk