• Sign In
  1. Messages

Error deleting sample set

Installation Forum (Inactive)

View Message

view list print
Error deleting sample set Olivier  2015-04-16 05:28
Status: Closed
 
Hi,

I have a sample set with ~70'000 samples registered. If I try to delete the set, I get following SQL error:

*****
ExecutingSelector; uncategorized SQLException for SQL []; SQL state [S1000]; error code [8632]; Internal error: An expression services limit has been reached. Please look for potentially complex expressions in your query, and try to simplify them.; nested exception is java.sql.SQLException: Internal error: An expression services limit has been reached. Please look for potentially complex expressions in your query, and try to simplify them.
*****

Once I reduce the data set to ~30'000 samples, the command is executed successfully. Are there any limitations/settings in the DB server that can cause this issue?

Thanks,
Olivier
 
 
Jon (LabKey DevOps) responded:  2015-04-16 12:16
Hi Olivier,

Just curious, what version of SQL are you running? So far, everything I've looked into has me thinking this is a limitation due to the sample size.

According to Microsoft (that's if you're using MS SQL - https://support.microsoft.com/en-us/kb/913050), they have an upper-limit of 65,535 records with a single expression query and the workaround according to them would be to reduce your data into smaller chunks. The behavior you described seems to support this article.

Regards,

Jon
 
Olivier responded:  2015-04-17 04:09
Hi Jon,

We are running MSSQL 2008, where similar limitations exist. Is there a workaround for labkey - specially for deleting large lists (i.e. via truncating the list before deleting it?)

Regards,
Olivier
 
Jon (LabKey DevOps) responded:  2015-04-17 10:55
Hi Oliver,

Yes, in 15.1 the truncation does exist there where we are able to work with deleting large lists. Since you're on the 14.3 version still, you're still somewhat limited unfortunately, sans the XML code I provided you here:

https://www.labkey.org/announcements/home/Developer/forum/thread.view?rowId=10636

Regards,

Jon