Unexisting table: otrs.time_accounting_user_period

[epferreira]

Hello


I've created a GenericAgent Job through the web interface, that adds a note to the tickets when the solution time goes beyond what's defined by the SLA for a given Service.
The selected Event was - EscalationSolutionTimeStart.

No note was added. I've checked the SysLog and it's full of the following entry: Table 'otrs.time_accounting_user_period' doesn't exist, SQL: '

I have ITSM installed, so I can't understand why this issue.
Can anyone indicate me a possible direction to solve this issue?


Thank you

[reneeb]

That's a table that comes from the addon TimeAccounting. You should check if the installation of that addon is ok...

[epferreira]

We don't have that addon installed. I thought that (TimeAccounting) was a core feature of ITSM or even base OTRS, because the table otrs.time_accounting exists on our DB. Perhaps it was installed with other addons (?)

Here's a list of the modules we have installed:
Oficial
. ITSM 4.0.1
. ITSMChangeManagement 4.0.1
. ITSMConfigurationManagement
. ITSMCore 4.0.1
. ITSMIncidentProblemManagement 4.0.1
. ITSMServiceLevelManagement 4.0.1
. FAQ 4.0.1
. GeneralCatalog 4.0.1
. ImportExport 4.0.1
. Survey 4.0.1
3rd Party
. DynamicFieldITSMConfigItem 1.2.0
. ITSM-CIAttributeCollection 4.0.0

If in fact the table otrs.time_accounting_user_period solely belongs to the TimeAccounting addon, can you explain me what otrs.time_accounting is for?

Thank you

[crythias]

can you explain me what otrs.time_accounting is for?

It accumulates the agent-entered time spent per article of a given ticket.

[epferreira]

I'm sorry I could not answer earlier.

Thank you for the hint