The first thing I tried was upgrading the client to v.11 and the error continued.
We are getting null values in a variable/column where null values aren't allowed.
Log Name: Laserfiche-ContentRepository-Service/Admin
Source: Laserfiche-ContentRepository-Service
Date: 11/4/2022 12:37:35 PM
Event ID: 150
Task Category: None
Level: Error
Keywords:
User: domain\user
Computer: lfappserver.example.com
Description:
An error occurred when executing an SQL query, retrieving the results of a query, or otherwise communicating with the database server. Session ID=452; Dialog ID=53099; Repository="RepoName"; Function=SysAnnCreate; Message="[Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Cannot insert the value NULL into column 'private', table 'LF_McAllen.dbo.ann'; column does not allow nulls. INSERT fails."; Statement="{call create_ann(:pageid<bigint,in>, :itemid<short,in>, :anntype<short,in>, :anncreator<raw[85],in>, :anncreated<timestamp,in>, :annlastmod<timestamp,in>, :annvisibility<int,in>, :anncomment<char[200],in>, :protect<short,in>, :ann_access<short,in>, :ann_reason_id<int,in>, :pos1<int,in>, :pos2<int,in>, :pos3<int,in>, :pos4<int,in>, :rotation<short,in>, :direction<short,in>, :color1<int,in>, :color2<int,in>, :color3<int,in>, :thickness<short,in>, :opacity<short,in>, :style1<short,in>, :style2<short,in>, :style3<short,in>, :stampid<int,in>, :attachstoreid<int,in>, :mime<char[127],in>, :filename<char[259],in>, :anntext<varchar_long,in>, :anntextsize<int,in>, :data1<char[600],in>, :annid<int,out>)}"; SQL Variable=""; SQL State="23000".
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="2022-11-04T17:37:35.210555900Z" />
<EventRecordID>188</EventRecordID>
<Correlation />
<Execution ProcessID="6468" ThreadID="3368" />
<Channel>Laserfiche-ContentRepository-Service/Admin</Channel>
<Computer>lfappserver.example.com</Computer>
<Security UserID="S-1-5-21-2538293913-1371282071-302991336-3607" />
</System>
<EventData>
<Data Name="sessionID">452</Data>
<Data Name="dialogID">53099</Data>
<Data Name="repository">RepoName</Data>
<Data Name="func">SysAnnCreate</Data>
<Data Name="message">[Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Cannot insert the value NULL into column 'private', table 'LF_McAllen.dbo.ann'; column does not allow nulls. INSERT fails.</Data>
<Data Name="stmt">{call create_ann(:pageid<bigint,in>, :itemid<short,in>, :anntype<short,in>, :anncreator<raw[85],in>, :anncreated<timestamp,in>, :annlastmod<timestamp,in>, :annvisibility<int,in>, :anncomment<char[200],in>, :protect<short,in>, :ann_access<short,in>, :ann_reason_id<int,in>, :pos1<int,in>, :pos2<int,in>, :pos3<int,in>, :pos4<int,in>, :rotation<short,in>, :direction<short,in>, :color1<int,in>, :color2<int,in>, :color3<int,in>, :thickness<short,in>, :opacity<short,in>, :style1<short,in>, :style2<short,in>, :style3<short,in>, :stampid<int,in>, :attachstoreid<int,in>, :mime<char[127],in>, :filename<char[259],in>, :anntext<varchar_long,in>, :anntextsize<int,in>, :data1<char[600],in>, :annid<int,out>)}</Data>
<Data Name="sqlvar">
</Data>
<Data Name="sqlstate">23000</Data>
</EventData>
</Event>