Hello Good People,
I didn't see anything on the Answers site, the old Laserfiche support site, nor the Microsoft Knowledge base for this error I am having. I first saw in in my event log. The content of the message appears to be a SQL query in the Laserfiche tables, but there is no distinct entry ID, TOC, etc.
An associate of mine cautioned me about searches that continue on indefinitely that need to be stopped manually. Could this be a reoccurring search that always fails? There were no Workflows that occurred at the time this error was created.
Any guidance is greatly appreciated. Here is the content of the event log error:
Date 6/2/2015 3:56:44 PM
Log Windows NT (Application)
Source LFS
Category (0)
Event 1074014018
Computer PALMLSF.palmbeach.local
Message
Database statement execution error encountered.
Session ID: ;
Dialog ID: 79968147;
Repository: 'Palm-Beach';
CLI routine: SearchExecuteThread;
Message: [Microsoft][SQL Native Client]Operation canceled;
SQL Statement: 'select distinct t.tocid, t.parentid from toc t join propval pv on pv.tocid = t.tocid join propdef pd on pv.prop_id = pd.prop_id where (t.toc_flags & 2048) = 0 and t.tocid <> 2 and exists(select * from propacl where propacl.prop_id = pv.prop_id and propacl.sid in (select sid from sess_sid where sess_id = :rsid2<int> ) and ace_type = 0 and mask & 1 = 1) and not exists(select * from propacl where propacl.prop_id = pv.prop_id and propacl.sid in (select sid from sess_sid where sess_id = :rsid3<int> ) and ace_type = 1 and mask & 1 = 1)and ((exists(select * from psetacl where psetacl.pset_id = t.pset_id and psetacl.sid in (select sid from sess_sid where sess_id = :rsid4<int> ) and ace_type = 0 and mask & 1 = 1) and not exists(select * from psetacl where psetacl.pset_id = t.pset_id and psetacl.sid in (select sid from sess_sid where sess_id = :rsid5<int> ) and ace_type = 1 and mask & 1 = 1)) or t.pset_id is null or t.pset_id not in (select pset_id from pset_props where prop_id = pv.prop_id)) and ((((pv.str_val like :str6<char[6]> ) and pd.prop_type in ('S','L'))))';
SQL variable: '';
SQL State: HY008.
Thank you in advance!