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
Unexisting table: otrs.time_accounting_user_period
Moderator: crythias
-
- Znuny newbie
- Posts: 24
- Joined: 23 Jun 2016, 15:49
- Znuny Version: 4.0.1
-
- Znuny guru
- Posts: 5018
- Joined: 13 Mar 2011, 09:54
- Znuny Version: 6.0.x
- Real Name: Renée Bäcker
- Company: Perl-Services.de
- Contact:
Re: Unexisting table: otrs.time_accounting_user_period
That's a table that comes from the addon TimeAccounting. You should check if the installation of that addon is ok...
Perl / Znuny development: http://perl-services.de
Free Znuny add ons from the community: http://opar.perl-services.de
Commercial add ons: http://feature-addons.de
Free Znuny add ons from the community: http://opar.perl-services.de
Commercial add ons: http://feature-addons.de
-
- Znuny newbie
- Posts: 24
- Joined: 23 Jun 2016, 15:49
- Znuny Version: 4.0.1
Re: Unexisting table: otrs.time_accounting_user_period
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
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
-
- Moderator
- Posts: 10169
- Joined: 04 May 2010, 18:38
- Znuny Version: 5.0.x
- Location: SouthWest Florida, USA
- Contact:
Re: Unexisting table: otrs.time_accounting_user_period
It accumulates the agent-entered time spent per article of a given ticket.epferreira wrote:can you explain me what otrs.time_accounting is for?
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
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
-
- Znuny newbie
- Posts: 24
- Joined: 23 Jun 2016, 15:49
- Znuny Version: 4.0.1
Re: Unexisting table: otrs.time_accounting_user_period
I'm sorry I could not answer earlier.
Thank you for the hint
Thank you for the hint