GenericAgent and PostMasterMailbox Error
Moderator: crythias
-
- Znuny expert
- Posts: 208
- Joined: 24 Jan 2012, 15:01
- Znuny Version: 4.0.13
- Real Name: Jörg Brümmer
- Company: Kreis Minden-Lübbecke
GenericAgent and PostMasterMailbox Error
I created some jobs which sort the Tickets, denpending on the Ticket-Types, in different Queues.
Since I updated to 3.1.1 the jobs don't run.
Message in the Log:
error
OTRS-otrs.PostMasterMailbox.pl-10Nachricht:
Message: Unknown column 'process_change' in 'field list', SQL: 'SELECT process_name, process_id, process_host, process_create, process_change FROM process_id WHERE process_name = ?'
and
error
OTRS-otrs.GenericAgent.pl-10
Message: Unknown column 'process_change' in 'field list', SQL: 'INSERT INTO process_id (process_name, process_id, process_host, process_create, process_change) VALUES (?, ?, ?, ?, ?)'
To test it I deleted all jobs in the GenericAgent and PistMaster-Filter. But the error isn't fixed. Every 10 minutes the same error.
Someone an idea?
Since I updated to 3.1.1 the jobs don't run.
Message in the Log:
error
OTRS-otrs.PostMasterMailbox.pl-10Nachricht:
Message: Unknown column 'process_change' in 'field list', SQL: 'SELECT process_name, process_id, process_host, process_create, process_change FROM process_id WHERE process_name = ?'
and
error
OTRS-otrs.GenericAgent.pl-10
Message: Unknown column 'process_change' in 'field list', SQL: 'INSERT INTO process_id (process_name, process_id, process_host, process_create, process_change) VALUES (?, ?, ?, ?, ?)'
To test it I deleted all jobs in the GenericAgent and PistMaster-Filter. But the error isn't fixed. Every 10 minutes the same error.
Someone an idea?
OTRS 5.0.18 auf Debian Linux | Apache2 | MySQL
-
- Znuny superhero
- Posts: 723
- Joined: 10 Oct 2007, 14:30
- Znuny Version: 3.0
- Location: Hamburg, Germany
Re: GenericAgent and PostMasterMailbox Error
It seems like you did not completely follow your UPGRADING file.
The given column 'process_change' does not exist in 3.0 and therefor it is required to run all .sql files.
The given column 'process_change' does not exist in 3.0 and therefor it is required to run all .sql files.
openSuSE on ESX
IT-Helpdesk: OTRS 3.0
Customer Service: OTRS 3.0 (upgraded from 2.3)
Customer Service (subsidiary): OTRS 3.0
+additional test and development systems
IT-Helpdesk: OTRS 3.0
Customer Service: OTRS 3.0 (upgraded from 2.3)
Customer Service (subsidiary): OTRS 3.0
+additional test and development systems
-
- Znuny expert
- Posts: 208
- Joined: 24 Jan 2012, 15:01
- Znuny Version: 4.0.13
- Real Name: Jörg Brümmer
- Company: Kreis Minden-Lübbecke
Re: GenericAgent and PostMasterMailbox Error
How can I fix it?
OTRS 5.0.18 auf Debian Linux | Apache2 | MySQL
-
- Znuny superhero
- Posts: 723
- Joined: 10 Oct 2007, 14:30
- Znuny Version: 3.0
- Location: Hamburg, Germany
Re: GenericAgent and PostMasterMailbox Error
Read the UPGRADING file carefully and watch
depending on your specific needs.therefor it is required to run all .sql files.
openSuSE on ESX
IT-Helpdesk: OTRS 3.0
Customer Service: OTRS 3.0 (upgraded from 2.3)
Customer Service (subsidiary): OTRS 3.0
+additional test and development systems
IT-Helpdesk: OTRS 3.0
Customer Service: OTRS 3.0 (upgraded from 2.3)
Customer Service (subsidiary): OTRS 3.0
+additional test and development systems
-
- Znuny expert
- Posts: 208
- Joined: 24 Jan 2012, 15:01
- Znuny Version: 4.0.13
- Real Name: Jörg Brümmer
- Company: Kreis Minden-Lübbecke
Re: GenericAgent and PostMasterMailbox Error
Can't find it.
I followed the instructions from this manual:
http://doc.otrs.org/3.1/en/html/upgrading.html
I followed the instructions from this manual:
http://doc.otrs.org/3.1/en/html/upgrading.html
OTRS 5.0.18 auf Debian Linux | Apache2 | MySQL
-
- Znuny superhero
- Posts: 723
- Joined: 10 Oct 2007, 14:30
- Znuny Version: 3.0
- Location: Hamburg, Germany
Re: GenericAgent and PostMasterMailbox Error
See part 9) of the manual. I am sure that the DB changes did not complete successfully.
openSuSE on ESX
IT-Helpdesk: OTRS 3.0
Customer Service: OTRS 3.0 (upgraded from 2.3)
Customer Service (subsidiary): OTRS 3.0
+additional test and development systems
IT-Helpdesk: OTRS 3.0
Customer Service: OTRS 3.0 (upgraded from 2.3)
Customer Service (subsidiary): OTRS 3.0
+additional test and development systems
-
- Znuny expert
- Posts: 208
- Joined: 24 Jan 2012, 15:01
- Znuny Version: 4.0.13
- Real Name: Jörg Brümmer
- Company: Kreis Minden-Lübbecke
Re: GenericAgent and PostMasterMailbox Error
Fixed. Execute the DBUpdate a second time and now it works. Thx.
OTRS 5.0.18 auf Debian Linux | Apache2 | MySQL
Re: GenericAgent and PostMasterMailbox Error
Got the same Errors.
Execute Update.pl again will not fix the problem.
Execute Update.pl again will not fix the problem.
OTRS 5.0.8
ITSM 5.0.14
CentOS 7
ITSM 5.0.14
CentOS 7
-
- Znuny superhero
- Posts: 723
- Joined: 10 Oct 2007, 14:30
- Znuny Version: 3.0
- Location: Hamburg, Germany
Re: GenericAgent and PostMasterMailbox Error
This is not about Update.pl!
openSuSE on ESX
IT-Helpdesk: OTRS 3.0
Customer Service: OTRS 3.0 (upgraded from 2.3)
Customer Service (subsidiary): OTRS 3.0
+additional test and development systems
IT-Helpdesk: OTRS 3.0
Customer Service: OTRS 3.0 (upgraded from 2.3)
Customer Service (subsidiary): OTRS 3.0
+additional test and development systems