GenericAgent and PostMasterMailbox Error

Moderator: crythias

Post Reply
TheDude
OTRS superhero
Posts: 208
Joined: 24 Jan 2012, 15:01
OTRS Version?: 4.0.13
Real Name: Jörg Brümmer
Company: Kreis Minden-Lübbecke

GenericAgent and PostMasterMailbox Error

Post by TheDude »

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?
OTRS 5.0.18 auf Debian Linux | Apache2 | MySQL

ferrosti
OTRS ninja
Posts: 723
Joined: 10 Oct 2007, 14:30
OTRS Version?: 3.0
Location: Hamburg, Germany

Re: GenericAgent and PostMasterMailbox Error

Post by ferrosti »

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.
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

TheDude
OTRS superhero
Posts: 208
Joined: 24 Jan 2012, 15:01
OTRS Version?: 4.0.13
Real Name: Jörg Brümmer
Company: Kreis Minden-Lübbecke

Re: GenericAgent and PostMasterMailbox Error

Post by TheDude »

How can I fix it?
OTRS 5.0.18 auf Debian Linux | Apache2 | MySQL

ferrosti
OTRS ninja
Posts: 723
Joined: 10 Oct 2007, 14:30
OTRS Version?: 3.0
Location: Hamburg, Germany

Re: GenericAgent and PostMasterMailbox Error

Post by ferrosti »

Read the UPGRADING file carefully and watch
therefor it is required to run all .sql files.
depending on your specific needs.
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

TheDude
OTRS superhero
Posts: 208
Joined: 24 Jan 2012, 15:01
OTRS Version?: 4.0.13
Real Name: Jörg Brümmer
Company: Kreis Minden-Lübbecke

Re: GenericAgent and PostMasterMailbox Error

Post by TheDude »

Can't find it.

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

ferrosti
OTRS ninja
Posts: 723
Joined: 10 Oct 2007, 14:30
OTRS Version?: 3.0
Location: Hamburg, Germany

Re: GenericAgent and PostMasterMailbox Error

Post by ferrosti »

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

TheDude
OTRS superhero
Posts: 208
Joined: 24 Jan 2012, 15:01
OTRS Version?: 4.0.13
Real Name: Jörg Brümmer
Company: Kreis Minden-Lübbecke

Re: GenericAgent and PostMasterMailbox Error

Post by TheDude »

Fixed. Execute the DBUpdate a second time and now it works. Thx.
OTRS 5.0.18 auf Debian Linux | Apache2 | MySQL

Calsonic
OTRS newbie
Posts: 44
Joined: 07 Nov 2011, 15:00
OTRS Version?: 5.0.8

Re: GenericAgent and PostMasterMailbox Error

Post by Calsonic »

Got the same Errors.

Execute Update.pl again will not fix the problem.
OTRS 5.0.8
ITSM 5.0.14

CentOS 7

ferrosti
OTRS ninja
Posts: 723
Joined: 10 Oct 2007, 14:30
OTRS Version?: 3.0
Location: Hamburg, Germany

Re: GenericAgent and PostMasterMailbox Error

Post by ferrosti »

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

Post Reply