Log Name: Laserfiche-ContentRepository-Service/Admin
Source: Laserfiche-ContentRepository-Service
Date: 8/4/2021 8:33:03 AM
Event ID: 150
Task Category: None
Level: Error
Keywords:
User: ServiceAccountName
Computer: ServerName
Description:
An error occurred when executing an SQL query, retrieving the results of a query, or otherwise communicating with the database server. Session ID=1099; Dialog ID=775259; Repository="AMCOM-COMMAND-GROUP"; Function=Search::ParseAndExecute; Message="[Microsoft][ODBC Driver 11 for SQL Server][SQL Server]Invalid object name '#tmpsearchvolid'."; Statement="INSERT INTO #tempresult (tocid, rsid, hitcount, parentid, etype, acl_tocid, vol_id, path) SELECT tocid, :rsid<int>, :hitcount<int>, parentid, etype, acl_tocid, vol_id, '' FROM ( SELECT toc.name displayname, toc.* FROM toc ) toc WHERE tocid = :tocid<int> AND tocid <> 2 AND del_tocid = 0 AND (etype <> -2 OR vol_id NOT IN (SELECT vol_id FROM #tmpsearchvolid))"; SQL Variable=""; SQL State="42S02".
Event Xml:
<Event xmlns="http://schemas.microsoft.com/win/2004/08/events/event">
<System>
<Provider Name="Laserfiche-ContentRepository-Service" Guid="{82FC23FE-4B0A-435C-82E6-01C7077098AF}" />
<EventID>150</EventID>
<Version>0</Version>
<Level>2</Level>
<Task>0</Task>
<Opcode>0</Opcode>
<Keywords>0x4000000000000000</Keywords>
<TimeCreated SystemTime="2021-08-04T13:33:03.271348500Z" />
<EventRecordID>611811</EventRecordID>
<Correlation ActivityID="{5F9D7A07-219A-41C1-858B-5CFCF23F8698}" />
<Execution ProcessID="2840" ThreadID="4660" />
<Channel>Laserfiche-ContentRepository-Service/Admin</Channel>
<Computer>ServerName</Computer>
<Security UserID="S-1-5-21-3822721094-983390456-1902330015-16993477" />
</System>
<EventData>
<Data Name="sessionID">1099</Data>
<Data Name="dialogID">775259</Data>
<Data Name="repository">AMCOM-COMMAND-GROUP</Data>
<Data Name="func">Search::ParseAndExecute</Data>
<Data Name="message">[Microsoft][ODBC Driver 11 for SQL Server][SQL Server]Invalid object name '#tmpsearchvolid'.</Data>
<Data Name="stmt">INSERT INTO #tempresult (tocid, rsid, hitcount, parentid, etype, acl_tocid, vol_id, path) SELECT tocid, :rsid<int>, :hitcount<int>, parentid, etype, acl_tocid, vol_id, '' FROM ( SELECT toc.name displayname, toc.* FROM toc ) toc WHERE tocid = :tocid<int> AND tocid <> 2 AND del_tocid = 0 AND (etype <> -2 OR vol_id NOT IN (SELECT vol_id FROM #tmpsearchvolid))</Data>
<Data Name="sqlvar">
</Data>
<Data Name="sqlstate">42S02</Data>
</EventData>
</Event>