So we have this software that queries for content of Catalogue:
10:55:36,193 [ INFO] [rest.CatalogProvider:232] GET_CATALOG: {
Id: '*',
Title: '*',
Clip: '*',
IniDate: '*',
EndDate: '*',
DurMin: '*',
DurMax: '*',
Store: '*',
FilterConfig: '*',
FilterNoStore: '*',
InfoStore: '*',
Channel: '*',
Group: '*',
Type: '*',
Validated: '*',
SourceType: '*',
NumResults: '*',
StartIndex: '*',
Order: '*'
}
This terminates in error:
10:55:36,285 [ WARN] [util.JDBCExceptionReporter:233] SQL Error: 207, SQLState: S0001
10:55:36,285 [ERROR] [util.JDBCExceptionReporter:234] Invalid column name 'Locked'.
10:55:36,286 [ERROR] [service.CatalogService:434] getCatalog Exception could not execute query
However I am quite sure we do not have a column name Locked. Where is this 'locked' coming from?
The server is SQL Server 2008.
locked
is either referenced in the query being sent to SQL Server or referenced in a programmability object (e.g. trigger) being executed. Start with a trace of batch and rpc starting events to rule out the first case. The name suggests it may be used for concurrency - perhaps there's an ORM lay or similar injecting it.