Error "No Lock for lock found!" adding new ticket by phone

Moderator: crythias

Locked
sebamix
Znuny newbie
Posts: 2
Joined: 28 Oct 2013, 16:01
Znuny Version: 3.2.7

Error "No Lock for lock found!" adding new ticket by phone

Post by sebamix »

Hello everybody! I'm new on this community :)
We have an OTRS 3.2.7 installation on a Fedora machine and MySQL database.

We setted up the enviroment and everything was working fine, until I've restored a database backup. :(

I must admit that I've created the backup .sql file directly with the mysqldump command and not with the otrs "backup.pl" script.

Then we got the error "Need TicketID!" when saving a new ticket by phone (sorry, I have the system in Italian and I don't know how otrs calls this function).

Somewhere on internet I've found that this error can be caused by some installed package.
In fact the packet manager tells me that the "Support" module was in trouble so I've reinstalled it.

But now we got this error saving a new ticket by phone: "No Lock for lock found!".

I've checked the apache error log, finding something very long (I'll attach this below).

The most interesting part is this:

Code: Select all

 Message: Column 'ticket_lock_id' cannot be null, SQL: '
            INSERT INTO ticket (tn, title, create_time_unix, type_id, queue_id, ticket_lock_id,
                user_id, responsible_user_id, ticket_priority_id, ticket_state_id,
                escalation_time, escalation_update_time, escalation_response_time,
                escalation_solution_time, timeout, service_id, sla_id, until_time,
                valid_id, archive_flag, create_time, create_by, change_time, change_by)
            VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, 0, 0, 0, 0, 0, ?, ?, 0, ?, ?,
                
        '2013-10-28 14:54:11'
    , ?, 
        '2013-10-28 14:54:11'
    , ?)'
Google tells nothing about this error :(
https://www.google.it/search?q=otrs+Nee ... afe=active

Any idea?

Thanks :)

P.S. : Here is the Apache error log:

Code: Select all

[Mon Oct 28 17:57:32 2013] HeaderMetaFAQSearch.pm: Subroutine new redefined at /opt/otrs//Kernel/Output/HTML/HeaderMetaFAQSearch.pm line 20.
[Mon Oct 28 17:57:32 2013] HeaderMetaFAQSearch.pm: Subroutine Run redefined at /opt/otrs//Kernel/Output/HTML/HeaderMetaFAQSearch.pm line 35.
[Mon Oct 28 17:57:32 2013] LayoutFAQ.pm: Subroutine GetFAQItemVotingRateColor redefined at /opt/otrs//Kernel/Output/HTML/LayoutFAQ.pm line 20.
[Mon Oct 28 17:57:32 2013] LayoutFAQ.pm: Subroutine FAQListShow redefined at /opt/otrs//Kernel/Output/HTML/LayoutFAQ.pm line 62.
[Mon Oct 28 17:57:32 2013] LayoutFAQ.pm: Subroutine FAQContentShow redefined at /opt/otrs//Kernel/Output/HTML/LayoutFAQ.pm line 370.
[Mon Oct 28 17:57:32 2013] LayoutFAQ.pm: Subroutine FAQPathShow redefined at /opt/otrs//Kernel/Output/HTML/LayoutFAQ.pm line 524.
[Mon Oct 28 17:57:32 2013] LayoutFAQ.pm: Subroutine FAQRatingStarsShow redefined at /opt/otrs//Kernel/Output/HTML/LayoutFAQ.pm line 597.
[Mon Oct 28 17:57:32 2013] LayoutFAQ.pm: Subroutine FAQShowLatestNewsBox redefined at /opt/otrs//Kernel/Output/HTML/LayoutFAQ.pm line 676.
[Mon Oct 28 17:57:32 2013] LayoutFAQ.pm: Subroutine FAQShowTop10 redefined at /opt/otrs//Kernel/Output/HTML/LayoutFAQ.pm line 854.
[Mon Oct 28 17:57:32 2013] LayoutFAQ.pm: Subroutine FAQShowQuickSearch redefined at /opt/otrs//Kernel/Output/HTML/LayoutFAQ.pm line 1006.
[Mon Oct 28 17:57:32 2013] LayoutImportExport.pm: Subroutine ImportExportFormInputCreate redefined at /opt/otrs//Kernel/Output/HTML/LayoutImportExport.pm line 31.
[Mon Oct 28 17:57:32 2013] LayoutImportExport.pm: Subroutine ImportExportFormDataGet redefined at /opt/otrs//Kernel/Output/HTML/LayoutImportExport.pm line 66.
[Mon Oct 28 17:57:32 2013] LayoutImportExport.pm: Subroutine _ImportExportLoadLayoutBackend redefined at /opt/otrs//Kernel/Output/HTML/LayoutImportExport.pm line 100.
[Mon Oct 28 17:57:32 2013] OutputFilterFAQ.pm: Subroutine new redefined at /opt/otrs//Kernel/Output/HTML/OutputFilterFAQ.pm line 20.
[Mon Oct 28 17:57:32 2013] OutputFilterFAQ.pm: Subroutine Run redefined at /opt/otrs//Kernel/Output/HTML/OutputFilterFAQ.pm line 35.
[Mon Oct 28 17:57:32 2013] ZZZAAuto.pm: Subroutine Load redefined at /opt/otrs/Kernel/Config/Files/ZZZAAuto.pm line 7.
[Mon Oct 28 17:57:32 2013] HeaderMetaFAQSearch.pm: Subroutine new redefined at /opt/otrs//Kernel/Output/HTML/HeaderMetaFAQSearch.pm line 20.
[Mon Oct 28 17:57:32 2013] HeaderMetaFAQSearch.pm: Subroutine Run redefined at /opt/otrs//Kernel/Output/HTML/HeaderMetaFAQSearch.pm line 35.
[Mon Oct 28 17:57:32 2013] LayoutFAQ.pm: Subroutine GetFAQItemVotingRateColor redefined at /opt/otrs//Kernel/Output/HTML/LayoutFAQ.pm line 20.
[Mon Oct 28 17:57:32 2013] LayoutFAQ.pm: Subroutine FAQListShow redefined at /opt/otrs//Kernel/Output/HTML/LayoutFAQ.pm line 62.
[Mon Oct 28 17:57:32 2013] LayoutFAQ.pm: Subroutine FAQContentShow redefined at /opt/otrs//Kernel/Output/HTML/LayoutFAQ.pm line 370.
[Mon Oct 28 17:57:32 2013] LayoutFAQ.pm: Subroutine FAQPathShow redefined at /opt/otrs//Kernel/Output/HTML/LayoutFAQ.pm line 524.
[Mon Oct 28 17:57:32 2013] LayoutFAQ.pm: Subroutine FAQRatingStarsShow redefined at /opt/otrs//Kernel/Output/HTML/LayoutFAQ.pm line 597.
[Mon Oct 28 17:57:32 2013] LayoutFAQ.pm: Subroutine FAQShowLatestNewsBox redefined at /opt/otrs//Kernel/Output/HTML/LayoutFAQ.pm line 676.
[Mon Oct 28 17:57:32 2013] LayoutFAQ.pm: Subroutine FAQShowTop10 redefined at /opt/otrs//Kernel/Output/HTML/LayoutFAQ.pm line 854.
[Mon Oct 28 17:57:32 2013] LayoutFAQ.pm: Subroutine FAQShowQuickSearch redefined at /opt/otrs//Kernel/Output/HTML/LayoutFAQ.pm line 1006.
[Mon Oct 28 17:57:32 2013] LayoutImportExport.pm: Subroutine ImportExportFormInputCreate redefined at /opt/otrs//Kernel/Output/HTML/LayoutImportExport.pm line 31.
[Mon Oct 28 17:57:32 2013] LayoutImportExport.pm: Subroutine ImportExportFormDataGet redefined at /opt/otrs//Kernel/Output/HTML/LayoutImportExport.pm line 66.
[Mon Oct 28 17:57:32 2013] LayoutImportExport.pm: Subroutine _ImportExportLoadLayoutBackend redefined at /opt/otrs//Kernel/Output/HTML/LayoutImportExport.pm line 100.
[Mon Oct 28 17:57:32 2013] OutputFilterFAQ.pm: Subroutine new redefined at /opt/otrs//Kernel/Output/HTML/OutputFilterFAQ.pm line 20.
[Mon Oct 28 17:57:32 2013] OutputFilterFAQ.pm: Subroutine Run redefined at /opt/otrs//Kernel/Output/HTML/OutputFilterFAQ.pm line 35.
[Mon Oct 28 17:57:32 2013] ZZZAAuto.pm: Subroutine Load redefined at /opt/otrs/Kernel/Config/Files/ZZZAAuto.pm line 7.
ERROR: OTRS-CGI-10 Perl: 5.16.3 OS: linux Time: Mon Oct 28 17:57:32 2013

 Message: No Lock for lock found!

 RemoteAddress: {REDACTED}
 RequestURI: /otrs/index.pl?Action=AgentTicketPhone

 Traceback (24704): 
   Module: Kernel::System::Lock::LockLookup (OTRS 3.2.7) Line: 203
   Module: Kernel::System::TicketSearch::TicketSearch (OTRS 3.2.7) Line: 625
   Module: Kernel::Output::HTML::ToolBarTicketLocked::Run (OTRS 3.2.7) Line: 41
   Module: Kernel::Output::HTML::Layout::Header (OTRS 3.2.7) Line: 1523
   Module: Kernel::Modules::AgentTicketPhone::Run (OTRS 3.2.7) Line: 206
   Module: Kernel::System::Web::InterfaceAgent::Run (OTRS 3.2.7) Line: 863
   Module: ModPerl::ROOT::ModPerl::Registry::opt_otrs_bin_cgi_2dbin_index_2epl::handler (unknown version) Line: 41
   Module: (eval) (v1.99) Line: 204
   Module: ModPerl::RegistryCooker::run (v1.99) Line: 204
   Module: ModPerl::RegistryCooker::default_handler (v1.99) Line: 170
   Module: ModPerl::Registry::handler (v1.99) Line: 31

ERROR: OTRS-CGI-10 Perl: 5.16.3 OS: linux Time: Mon Oct 28 17:57:32 2013

 Message: No Lock for lock found!

 RemoteAddress: {REDACTED}
 RequestURI: /otrs/index.pl?Action=AgentTicketPhone

 Traceback (24704): 
   Module: Kernel::System::Lock::LockLookup (OTRS 3.2.7) Line: 203
   Module: Kernel::System::TicketSearch::TicketSearch (OTRS 3.2.7) Line: 625
   Module: Kernel::Output::HTML::ToolBarTicketLocked::Run (OTRS 3.2.7) Line: 48
   Module: Kernel::Output::HTML::Layout::Header (OTRS 3.2.7) Line: 1523
   Module: Kernel::Modules::AgentTicketPhone::Run (OTRS 3.2.7) Line: 206
   Module: Kernel::System::Web::InterfaceAgent::Run (OTRS 3.2.7) Line: 863
   Module: ModPerl::ROOT::ModPerl::Registry::opt_otrs_bin_cgi_2dbin_index_2epl::handler (unknown version) Line: 41
   Module: (eval) (v1.99) Line: 204
   Module: ModPerl::RegistryCooker::run (v1.99) Line: 204
   Module: ModPerl::RegistryCooker::default_handler (v1.99) Line: 170
   Module: ModPerl::Registry::handler (v1.99) Line: 31

[Mon Oct 28 17:57:32 2013] -e: Use of uninitialized value $CountNew in subtraction (-) at /opt/otrs//Kernel/Output/HTML/ToolBarTicketLocked.pm line 59.
[Mon Oct 28 17:57:32 2013] -e: Use of uninitialized value $Count in subtraction (-) at /opt/otrs//Kernel/Output/HTML/ToolBarTicketLocked.pm line 59.
ERROR: OTRS-CGI-10 Perl: 5.16.3 OS: linux Time: Mon Oct 28 17:57:32 2013

 Message: No Lock for lock found!

 RemoteAddress: {REDACTED}
 RequestURI: /otrs/index.pl?Action=AgentTicketPhone

 Traceback (24704): 
   Module: Kernel::System::Lock::LockLookup (OTRS 3.2.7) Line: 203
   Module: Kernel::System::TicketSearch::TicketSearch (OTRS 3.2.7) Line: 625
   Module: Kernel::Output::HTML::ToolBarTicketLocked::Run (OTRS 3.2.7) Line: 60
   Module: Kernel::Output::HTML::Layout::Header (OTRS 3.2.7) Line: 1523
   Module: Kernel::Modules::AgentTicketPhone::Run (OTRS 3.2.7) Line: 206
   Module: Kernel::System::Web::InterfaceAgent::Run (OTRS 3.2.7) Line: 863
   Module: ModPerl::ROOT::ModPerl::Registry::opt_otrs_bin_cgi_2dbin_index_2epl::handler (unknown version) Line: 41
   Module: (eval) (v1.99) Line: 204
   Module: ModPerl::RegistryCooker::run (v1.99) Line: 204
   Module: ModPerl::RegistryCooker::default_handler (v1.99) Line: 170
   Module: ModPerl::Registry::handler (v1.99) Line: 31

ERROR: OTRS-CGI-10 Perl: 5.16.3 OS: linux Time: Mon Oct 28 17:57:47 2013

 Message: No Lock for unlock found!

 RemoteAddress: {REDACTED}
 RequestURI: /otrs/index.pl

 Traceback (22272): 
   Module: Kernel::System::Lock::LockLookup (OTRS 3.2.7) Line: 203
   Module: Kernel::System::Ticket::TicketCreate (OTRS 3.2.7) Line: 430
   Module: Kernel::Modules::AgentTicketPhone::Run (OTRS 3.2.7) Line: 1067
   Module: Kernel::System::Web::InterfaceAgent::Run (OTRS 3.2.7) Line: 863
   Module: ModPerl::ROOT::ModPerl::Registry::opt_otrs_bin_cgi_2dbin_index_2epl::handler (unknown version) Line: 41
   Module: (eval) (v1.99) Line: 204
   Module: ModPerl::RegistryCooker::run (v1.99) Line: 204
   Module: ModPerl::RegistryCooker::default_handler (v1.99) Line: 170
   Module: ModPerl::Registry::handler (v1.99) Line: 31

[Mon Oct 28 17:57:47 2013] -e: DBD::mysql::db do failed: Column 'ticket_lock_id' cannot be null at /opt/otrs//Kernel/System/DB.pm line 475.
ERROR: OTRS-CGI-10 Perl: 5.16.3 OS: linux Time: Mon Oct 28 17:57:47 2013

 Message: Column 'ticket_lock_id' cannot be null, SQL: '
            INSERT INTO ticket (tn, title, create_time_unix, type_id, queue_id, ticket_lock_id,
                user_id, responsible_user_id, ticket_priority_id, ticket_state_id,
                escalation_time, escalation_update_time, escalation_response_time,
                escalation_solution_time, timeout, service_id, sla_id, until_time,
                valid_id, archive_flag, create_time, create_by, change_time, change_by)
            VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, 0, 0, 0, 0, 0, ?, ?, 0, ?, ?,
                
        '2013-10-28 17:57:47'
    , ?, 
        '2013-10-28 17:57:47'
    , ?)'

 RemoteAddress: {REDACTED}
 RequestURI: /otrs/index.pl

 Traceback (22272): 
   Module: Kernel::System::Ticket::TicketCreate (OTRS 3.2.7) Line: 500
   Module: Kernel::Modules::AgentTicketPhone::Run (OTRS 3.2.7) Line: 1067
   Module: Kernel::System::Web::InterfaceAgent::Run (OTRS 3.2.7) Line: 863
   Module: ModPerl::ROOT::ModPerl::Registry::opt_otrs_bin_cgi_2dbin_index_2epl::handler (unknown version) Line: 41
   Module: (eval) (v1.99) Line: 204
   Module: ModPerl::RegistryCooker::run (v1.99) Line: 204
   Module: ModPerl::RegistryCooker::default_handler (v1.99) Line: 170
   Module: ModPerl::Registry::handler (v1.99) Line: 31

ERROR: OTRS-CGI-10 Perl: 5.16.3 OS: linux Time: Mon Oct 28 17:57:47 2013

 Message: Found no ArticleType(ID) for phone!

 RemoteAddress: {REDACTED}
 RequestURI: /otrs/index.pl

 Traceback (22272): 
   Module: Kernel::System::Ticket::Article::ArticleTypeLookup (OTRS 3.2.7) Line: 991
   Module: Kernel::System::Ticket::Article::ArticleCreate (OTRS 3.2.7) Line: 117
   Module: Kernel::Modules::AgentTicketPhone::Run (OTRS 3.2.7) Line: 1150
   Module: Kernel::System::Web::InterfaceAgent::Run (OTRS 3.2.7) Line: 863
   Module: ModPerl::ROOT::ModPerl::Registry::opt_otrs_bin_cgi_2dbin_index_2epl::handler (unknown version) Line: 41
   Module: (eval) (v1.99) Line: 204
   Module: ModPerl::RegistryCooker::run (v1.99) Line: 204
   Module: ModPerl::RegistryCooker::default_handler (v1.99) Line: 170
   Module: ModPerl::Registry::handler (v1.99) Line: 31

ERROR: OTRS-CGI-10 Perl: 5.16.3 OS: linux Time: Mon Oct 28 17:57:47 2013

 Message: Found no SenderType(ID) for customer!

 RemoteAddress: {REDACTED}
 RequestURI: /otrs/index.pl

 Traceback (22272): 
   Module: Kernel::System::Ticket::Article::ArticleSenderTypeLookup (OTRS 3.2.7) Line: 913
   Module: Kernel::System::Ticket::Article::ArticleCreate (OTRS 3.2.7) Line: 120
   Module: Kernel::Modules::AgentTicketPhone::Run (OTRS 3.2.7) Line: 1150
   Module: Kernel::System::Web::InterfaceAgent::Run (OTRS 3.2.7) Line: 863
   Module: ModPerl::ROOT::ModPerl::Registry::opt_otrs_bin_cgi_2dbin_index_2epl::handler (unknown version) Line: 41
   Module: (eval) (v1.99) Line: 204
   Module: ModPerl::RegistryCooker::run (v1.99) Line: 204
   Module: ModPerl::RegistryCooker::default_handler (v1.99) Line: 170
   Module: ModPerl::Registry::handler (v1.99) Line: 31

ERROR: OTRS-CGI-10 Perl: 5.16.3 OS: linux Time: Mon Oct 28 17:57:47 2013

 Message: Need TicketID!

 RemoteAddress: {REDACTED}
 RequestURI: /otrs/index.pl

 Traceback (22272): 
   Module: Kernel::System::Ticket::Article::ArticleCreate (OTRS 3.2.7) Line: 127
   Module: Kernel::Modules::AgentTicketPhone::Run (OTRS 3.2.7) Line: 1150
   Module: Kernel::System::Web::InterfaceAgent::Run (OTRS 3.2.7) Line: 863
   Module: ModPerl::ROOT::ModPerl::Registry::opt_otrs_bin_cgi_2dbin_index_2epl::handler (unknown version) Line: 41
   Module: (eval) (v1.99) Line: 204
   Module: ModPerl::RegistryCooker::run (v1.99) Line: 204
   Module: ModPerl::RegistryCooker::default_handler (v1.99) Line: 170
   Module: ModPerl::Registry::handler (v1.99) Line: 31

ERROR: OTRS-CGI-10 Perl: 5.16.3 OS: linux Time: Mon Oct 28 17:57:47 2013

 Message: No Lock for lock found!

 RemoteAddress: {REDACTED}
 RequestURI: /otrs/index.pl

 Traceback (22272): 
   Module: Kernel::System::Lock::LockLookup (OTRS 3.2.7) Line: 203
   Module: Kernel::System::TicketSearch::TicketSearch (OTRS 3.2.7) Line: 625
   Module: Kernel::Output::HTML::ToolBarTicketLocked::Run (OTRS 3.2.7) Line: 41
   Module: Kernel::Output::HTML::Layout::Header (OTRS 3.2.7) Line: 1523
   Module: Kernel::Output::HTML::Layout::ErrorScreen (OTRS 3.2.7) Line: 1217
   Module: Kernel::Modules::AgentTicketPhone::Run (OTRS 3.2.7) Line: 1174
   Module: Kernel::System::Web::InterfaceAgent::Run (OTRS 3.2.7) Line: 863
   Module: ModPerl::ROOT::ModPerl::Registry::opt_otrs_bin_cgi_2dbin_index_2epl::handler (unknown version) Line: 41
   Module: (eval) (v1.99) Line: 204
   Module: ModPerl::RegistryCooker::run (v1.99) Line: 204
   Module: ModPerl::RegistryCooker::default_handler (v1.99) Line: 170
   Module: ModPerl::Registry::handler (v1.99) Line: 31

ERROR: OTRS-CGI-10 Perl: 5.16.3 OS: linux Time: Mon Oct 28 17:57:47 2013

 Message: No Lock for lock found!

 RemoteAddress: {REDACTED}
 RequestURI: /otrs/index.pl

 Traceback (22272): 
   Module: Kernel::System::Lock::LockLookup (OTRS 3.2.7) Line: 203
   Module: Kernel::System::TicketSearch::TicketSearch (OTRS 3.2.7) Line: 625
   Module: Kernel::Output::HTML::ToolBarTicketLocked::Run (OTRS 3.2.7) Line: 48
   Module: Kernel::Output::HTML::Layout::Header (OTRS 3.2.7) Line: 1523
   Module: Kernel::Output::HTML::Layout::ErrorScreen (OTRS 3.2.7) Line: 1217
   Module: Kernel::Modules::AgentTicketPhone::Run (OTRS 3.2.7) Line: 1174
   Module: Kernel::System::Web::InterfaceAgent::Run (OTRS 3.2.7) Line: 863
   Module: ModPerl::ROOT::ModPerl::Registry::opt_otrs_bin_cgi_2dbin_index_2epl::handler (unknown version) Line: 41
   Module: (eval) (v1.99) Line: 204
   Module: ModPerl::RegistryCooker::run (v1.99) Line: 204
   Module: ModPerl::RegistryCooker::default_handler (v1.99) Line: 170
   Module: ModPerl::Registry::handler (v1.99) Line: 31

[Mon Oct 28 17:57:47 2013] -e: Use of uninitialized value $CountNew in subtraction (-) at /opt/otrs//Kernel/Output/HTML/ToolBarTicketLocked.pm line 59.
[Mon Oct 28 17:57:47 2013] -e: Use of uninitialized value $Count in subtraction (-) at /opt/otrs//Kernel/Output/HTML/ToolBarTicketLocked.pm line 59.
ERROR: OTRS-CGI-10 Perl: 5.16.3 OS: linux Time: Mon Oct 28 17:57:47 2013

 Message: No Lock for lock found!

 RemoteAddress: {REDACTED}
 RequestURI: /otrs/index.pl

 Traceback (22272): 
   Module: Kernel::System::Lock::LockLookup (OTRS 3.2.7) Line: 203
   Module: Kernel::System::TicketSearch::TicketSearch (OTRS 3.2.7) Line: 625
   Module: Kernel::Output::HTML::ToolBarTicketLocked::Run (OTRS 3.2.7) Line: 60
   Module: Kernel::Output::HTML::Layout::Header (OTRS 3.2.7) Line: 1523
   Module: Kernel::Output::HTML::Layout::ErrorScreen (OTRS 3.2.7) Line: 1217
   Module: Kernel::Modules::AgentTicketPhone::Run (OTRS 3.2.7) Line: 1174
   Module: Kernel::System::Web::InterfaceAgent::Run (OTRS 3.2.7) Line: 863
   Module: ModPerl::ROOT::ModPerl::Registry::opt_otrs_bin_cgi_2dbin_index_2epl::handler (unknown version) Line: 41
   Module: (eval) (v1.99) Line: 204
   Module: ModPerl::RegistryCooker::run (v1.99) Line: 204
   Module: ModPerl::RegistryCooker::default_handler (v1.99) Line: 170
   Module: ModPerl::Registry::handler (v1.99) Line: 31
sebamix
Znuny newbie
Posts: 2
Joined: 28 Oct 2013, 16:01
Znuny Version: 3.2.7

Re: Error "No Lock for lock found!" adding new ticket by pho

Post by sebamix »

By the way (I was forgetting).
I've tryed deleting the database and running the installer.pl script again and I was able to add tickets with a "fresh" installation.
The problem seems to occour only if I restore the database (with mysql or restore.pl script).

Thanks
Sebastiano
crythias
Moderator
Posts: 10170
Joined: 04 May 2010, 18:38
Znuny Version: 5.0.x
Location: SouthWest Florida, USA
Contact:

Re: Error "No Lock for lock found!" adding new ticket by pho

Post by crythias »

>> Column 'ticket_lock_id' cannot be null
Summary: There is a configuration change made (likely by hand for translation purposes) that has changed the label for "lock" or "unlock" (as an example) and, via SysConfig, was not also changed to reflect the translation.

Longer answer: Let's say, somehow, that "lock" now says "foo" and "unlock" says "bar". In sysconfig, for defaults that explicitly look for the english "lock" or "unlock", there is no longer a database "id"/index that is associated with "lock" and therefore this error will show up.

Fix: Mass search/replace SysConfig to match or change the label back. (Translate via custom translation, if necessary/appropriate).
OTRS 6.0.x (private/testing/public) on Linux with MySQL database.
Please edit your signature to include your OTRS version, Operating System, and database type.
Click Subscribe Topic below to get notifications. Consider amending your topic title to include [SOLVED] if it is so.
Need help? Before you ask
Locked