[SOLVED] Error on database (generic_agent_jobs, gi_debugger_entry_content)

[elitt]

I first installed a new OTRS appliance v 4.0.3 on a virtual box hosted by a windows7 PC.
After a crash (apache server and postgreSQL server no more starting), I install a brand new OTRS appliance (v4.0.5 with PostgreSQL v8.4.21) on a virtual box hosted on the same Windows7 PC.

I tried to restore my data with some difficulties (see viewtopic.php?f=62&t=27378&p=112869#p112869), but I have now an OTRS application running.

Looking into the "Service center", I see the following error :

Code: Select all

Table Presence (generic_agent_jobs, gi_debugger_entry_content)
Tables found which are not present in the database.

Into the system logs, I find these errors :

Code: Select all

FEHLER:  Relation »gi_debugger_entry_content« existiert nicht
FEHLER:  Relation »generic_agent_jobs« existiert nicht

What do these errors mean ? How can I fix them ?

Thanks!

[elitt]

I just tried to add a GenericAgent Job to delete tickets in Junk queue (as described in http://blog.otrs.org/2011/08/04/otrs-ti ... nt-page-1/).
When I saved the form, I returned on the GenericAgent overview and nothing appears there... My job seems not to be created and my system log shouts many, many errors :

Code: Select all

Thu Feb 5 17:00:08 2015	error	OTRS-CGI-0	FEHLER: Relation »generic_agent_jobs« existiert nicht
Thu Feb 5 17:00:07 2015	notice	OTRS-CGI-0	New GenericAgent job 'Suppression' added (UserID=3).
Thu Feb 5 17:00:07 2015	error	OTRS-CGI-0	FEHLER: Relation »generic_agent_jobs« existiert nicht
Thu Feb 5 17:00:07 2015	error	OTRS-CGI-0	FEHLER: Relation »generic_agent_jobs« existiert nicht
Thu Feb 5 17:00:07 2015	error	OTRS-CGI-0	FEHLER: Relation »generic_agent_jobs« existiert nicht
Thu Feb 5 17:00:07 2015	error	OTRS-CGI-0	FEHLER: Relation »generic_agent_jobs« existiert nicht
Thu Feb 5 17:00:07 2015	error	OTRS-CGI-0	FEHLER: Relation »generic_agent_jobs« existiert nicht
Thu Feb 5 17:00:07 2015	error	OTRS-CGI-0	FEHLER: Relation »generic_agent_jobs« existiert nicht
Thu Feb 5 17:00:07 2015	error	OTRS-CGI-0	FEHLER: Relation »generic_agent_jobs« existiert nicht
...
...

But, according to the second line, it seems my GenericAgent Job is already created. Will it run or not ? That's the question...

How can I fix this ?

[crythias]

there is a relation that doesn't exist. I don't know what that is, but it seems to be related to Generic Agent, so delete/rebuild them?

[elitt]

Thank for your answer.

I continued to search around that issue.
I found a post about GRANT and resolution with GRANT usage ON SCHEMA public to user.

Nothing happend... So I searched back into the database and into my backup SQL file.
And I found some mistakes I had made before I restored the database.

So I had to re-create manually the two tables generic_agent_jobs and gi_debugger_entry_content. For this purpose, I used the /opt/otrs/script/database/otrs-schema-post.postgresql.sql file.