Hallo,
seit dem Update unserer Kix-Installation auf 17.14 erscheinen bei jeder Ticketsuche mehrere Fehlermeldungen im Log /opt/kix/var/log/kix.log:
[Tue Nov 16 09:19:56 2021][Error][Kernel::System::ITSMConfigItem::Version::VersionGet][407] ERROR: invalid input syntax for integer: "*foobar*", SQL: 'SELECT id, configitem_id, name, definition_id, depl_state_id, inci_state_id, create_time, create_by FROM configitem_version WHERE configitem_id = ? AND is_last_version = 1 LIMIT 1'
[Tue Nov 16 09:19:56 2021][Error][Kernel::System::ITSMConfigItem::Version::VersionGet][436] ERROR: invalid input syntax for integer: "*foobar*", SQL: 'SELECT id, configitem_id, name, definition_id, depl_state_id, inci_state_id, create_time, create_by FROM configitem_version WHERE configitem_id = ? ORDER BY id DESC LIMIT 1'
[Tue Nov 16 09:19:56 2021][Error][Kernel::System::ITSMConfigItem::Version::VersionGet][455] No such config item version!
[Tue Nov 16 09:19:56 2021][Error][Kernel::System::ITSMConfigItem::Version::VersionGet][407] ERROR: invalid input syntax for integer: "*foobar*", SQL: 'SELECT id, configitem_id, name, definition_id, depl_state_id, inci_state_id, create_time, create_by FROM configitem_version WHERE configitem_id = ? AND is_last_version = 1 LIMIT 1'
[Tue Nov 16 09:19:56 2021][Error][Kernel::System::ITSMConfigItem::Version::VersionGet][436] ERROR: invalid input syntax for integer: "*foobar*", SQL: 'SELECT id, configitem_id, name, definition_id, depl_state_id, inci_state_id, create_time, create_by FROM configitem_version WHERE configitem_id = ? ORDER BY id DESC LIMIT 1'
[Tue Nov 16 09:19:56 2021][Error][Kernel::System::ITSMConfigItem::Version::VersionGet][455] No such config item version!
In diesem Fall habe ich lediglich in der Suchleiste oben in der Agentenansicht nach "foobar" gesucht. Die Suche scheint trotz diesen Fehlers zu funktionieren.