Search found 30 matches

by interploy
23 Feb 2016, 07:35
Forum: General
Topic: [SOLVED] Clarification on Switching Ticket Backend Docs
Replies: 5
Views: 1172

Re: [SOLVED] Clarification on Switching Ticket Backend Docs

Hello, I'm a newbie as well :) Even though the ticket is marked as SOLVED I am still confused.... :? We have around 100k tickets in our database but less than 6000 open tickets the rest are closed or archived. Should we use StaticDB or RuntimeDB? Thank you! Andrei Hi Andrei, To clarify, the documen...
by interploy
07 Nov 2014, 18:29
Forum: General
Topic: [SOLVED] Clarification on Switching Ticket Backend Docs
Replies: 5
Views: 1172

Re: Clarification on Switching Ticket Backends Documentation

crythias wrote:I could be wrong, but I would take it to mean open ever, or just *tickets*.
That's where I was leaning, but I wanted to make sure. I've lost count of the number of times I've bungled code because of an assumption. :lol:

Thanks for the input!
by interploy
07 Nov 2014, 18:11
Forum: Help
Topic: [SOLVED] Ticket Deleted After a Merge?
Replies: 4
Views: 1310

Re: [SOLVED] Ticket Deleted After a Merge?

crythias wrote:It is not likely that a ticket will be deleted without Generic Agent being used.
Sorry, I should have mentioned it before. We are using Generic Agensts on the junk queues to clear them out regularly.
by interploy
05 Nov 2014, 23:03
Forum: General
Topic: [SOLVED] Clarification on Switching Ticket Backend Docs
Replies: 5
Views: 1172

[SOLVED] Clarification on Switching Ticket Backend Docs

Hello, I just wanted to get some clarification on the performance tuning documentation about switching ticket index backends. Reference: http://otrs.github.io/doc/manual/admin/3.2/en/html/performance-tuning.html My OTRS database is getting fairly large (a sql dump file is 9.6GB). The ticket table is...
by interploy
28 Oct 2014, 22:45
Forum: Help
Topic: [SOLVED] Ticket Deleted After a Merge?
Replies: 4
Views: 1310

Re: Ticket Deleted After a Merge?

Okay, I will let the users know. Thank you for clarifying!
by interploy
28 Oct 2014, 18:32
Forum: Help
Topic: [SOLVED] Ticket Deleted After a Merge?
Replies: 4
Views: 1310

[SOLVED] Ticket Deleted After a Merge?

Hello, A user reported that a ticket was no longer displaying in OTRS. Here is what I found: 1. The provided ticket number was not in the ticket table. 2. The user said other tickets had been merged into it. I reviewed the ticket_history table and found entries for four other tickets had been merged...
by interploy
15 Jul 2014, 22:10
Forum: Help
Topic: Dynamic Fields Not Displaying for Some Statistics
Replies: 0
Views: 289

Dynamic Fields Not Displaying for Some Statistics

Hello, We have a few dynamic fields that we want to be able to include in statistics, but only one of them is displaying. I can't seem to figure out how to make the others display. I've cleared the cache and made sure all of the fields are ticket types as per the threads http://forums.otterhub.org/v...
by interploy
11 Sep 2013, 18:02
Forum: Help
Topic: [Closed] Preventing "Thanks" replies from reopening tickets.
Replies: 2
Views: 444

Re: Preventing "Thanks" replies from reopening tickets.

crythias wrote:Each queue followup on close
Possible: "Thanks" reopens
No/Reject: "Thanks" rejected
New ticket: "Thanks" creates a new ticket.
Thanks crythias! This tells me what I needed to know.
by interploy
11 Sep 2013, 00:10
Forum: Help
Topic: [Closed] Preventing "Thanks" replies from reopening tickets.
Replies: 2
Views: 444

[Closed] Preventing "Thanks" replies from reopening tickets.

Whenever a customer replies to a ticket, it reopens it. My agents are saying they like the feature when some new info comes in, but most of the time it's just customers saying thanks for fixing the problem and the agents then have to go back in and re-close the ticket. I haven't found much in the co...
by interploy
26 Apr 2013, 18:05
Forum: General
Topic: [Closed] Super Agents that can access locked tickets?
Replies: 8
Views: 1577

Re: [Closed] Super Agents that can access locked tickets?

With editing you do not mean "editing articles"? That would be a different cup of tea and not possible. But making it possible to add a note on locked tickets (locked to other agents) is just some small code change; done that before. Also for closing (i.e. doing a state change) I see no problem at ...
by interploy
25 Apr 2013, 22:26
Forum: General
Topic: [Closed] Super Agents that can access locked tickets?
Replies: 8
Views: 1577

Re: Super Agents that can access locked tickets?

Sorry for the late reply... @crythias: Okay, thanks. I'm still not very familiar with what the Generic Agent's capabilities are so that's good to know. @ferrosti: The override would only be for supervisors; we wanted to keep locking as-is for everyone else. But, so long as they can reassign the tick...
by interploy
03 Apr 2013, 20:45
Forum: General
Topic: [Closed] Super Agents that can access locked tickets?
Replies: 8
Views: 1577

Re: Super Agents that can access locked tickets?

Fair enough. I'd still like to give supervisors more direct oversight though. I know I can change the ticket lock time per queue... Can the GenericAgent (or some other service) automatically set ticket watching and/or responsibility?
by interploy
02 Apr 2013, 23:13
Forum: General
Topic: [Closed] Super Agents that can access locked tickets?
Replies: 8
Views: 1577

[Closed] Super Agents that can access locked tickets?

Is there a way to create a super agent in OTRS that can access (edit/respond/close/etc) any ticket even if it's locked? It's something we'd like to have for one or two people (supervisors), but not everyone.

Thanks,
-interploy
by interploy
01 Apr 2013, 23:54
Forum: Help
Topic: [SOLVED] Cron jobs not running
Replies: 5
Views: 720

Re: Cron jobs not running

Optimally: remove .dist from all files (per INSTALL instructions). Secondarily, you can build crontab -e -u otrs yourself from copy/paste note that Cron.sh stop empties the cron, so... also, if you're lazy, you can just cat *.dist > mycrontab Cron.sh start otrs Ach, I completely missed that step in...
by interploy
01 Apr 2013, 22:33
Forum: Help
Topic: [SOLVED] Cron jobs not running
Replies: 5
Views: 720

Re: Cron jobs not running

If I copy the cron job info into /etc/crontab manually, (commands run as the otrs user of course), would that have any adverse effects on OTRS in terms of logging or other background processing?
by interploy
01 Apr 2013, 21:28
Forum: Help
Topic: [SOLVED] Cron jobs not running
Replies: 5
Views: 720

Re: Cron jobs not running

bin/Cron.sh restart otrs this concatenates all files on otrs/var/cron that do not have .dist appended to the filename. I haven't made any modifications to files in otrs/var/cron/ and it only has .dist files in it. Do I have to make copies of these files without the .dist and then rerun the Cron.sh ...
by interploy
01 Apr 2013, 21:00
Forum: Help
Topic: [SOLVED] Cron jobs not running
Replies: 5
Views: 720

[SOLVED] Cron jobs not running

Hi, I recently moved servers to CentOS 6.3 and updated to OTRS 3.2.3 and it's mostly good, but the cron jobs are not running. When I do the command bin/Cron.sh restart otrs (from the /opt/otrs dir), I get the output like it's working: /opt/otrs Cron.sh - start/stop OTRS cronjobs - <$Revision: 1.22 $...
by interploy
01 Apr 2013, 19:59
Forum: Help
Topic: [SOLVED] ERROR: relation "support_bench_test" does not exist
Replies: 5
Views: 1717

Re: ERROR: relation "support_bench_test" does not exist

After re-installing the Support package the support_bench_test table appeared in the db. I took the site down briefly to run the normal benchmark and everything is working as expected (and with good times too :) ). Thanks CSL and jojo!
by interploy
29 Mar 2013, 01:45
Forum: Help
Topic: [SOLVED] ERROR: relation "support_bench_test" does not exist
Replies: 5
Views: 1717

Re: ERROR: relation "support_bench_test" does not exist

I've finished the data migration and the new server seems pretty responsive so far. Though I won't be able to test this now, I'm still curious if there's a solution/explanation to this error.

Thanks!
-interploy
by interploy
28 Mar 2013, 00:09
Forum: Help
Topic: [SOLVED] ERROR: relation "support_bench_test" does not exist
Replies: 5
Views: 1717

Re: ERROR: relation "support_bench_test" does not exist

And thanks in advance :) -interploy
by interploy
28 Mar 2013, 00:08
Forum: Help
Topic: [SOLVED] ERROR: relation "support_bench_test" does not exist
Replies: 5
Views: 1717

[SOLVED] ERROR: relation "support_bench_test" does not exist

Hi, I was looking at the Support Assessment area and saw the SQL benchmark tool. Having recently done (what I thought) was some optimizations to my PostgreSQL config, I ran the tests, and these were my results: Insert Time: 10000 10 s :-( Should not take more than 5's on an average system. Update Ti...
by interploy
27 Mar 2013, 19:31
Forum: Help
Topic: [SOLVED] Adding Dynamic Fields to Database Views
Replies: 7
Views: 2541

Re: [SOLVED] Adding Dynamic Fields to Database Views

Left join select? okay... :) Since there's only one value assigned per dynamic field (usually?) you probably could just join directly. I used separate selects so I would only get one row back for each ticket instead of two. I admit there's probably a less verbose way to do it, but this works for wh...
by interploy
20 Mar 2013, 00:23
Forum: Help
Topic: [SOLVED] Adding Dynamic Fields to Database Views
Replies: 7
Views: 2541

Re: [SOLVED] Adding Dynamic Fields to Database Views

For anyone interested, this is the new view I ended up creating: CREATE OR REPLACE VIEW helpdesk_view AS SELECT t.id, v.name AS validity, q.name AS queue_name, t.tn AS ticket_number, t.title, y.name AS type, u.login AS agent, p.name AS ticket_priority, s.name AS ticket_state, d1.value_int AS atypon_...
by interploy
19 Mar 2013, 18:37
Forum: Help
Topic: [SOLVED] Adding Dynamic Fields to Database Views
Replies: 7
Views: 2541

Re: Adding Dynamic Fields to Database Views

crythias wrote:I posted the relationship ... somewhere and forgot to bookmark it.
viewtopic.php?f=53&t=16009&p=77686#p77686
This is just what I was trying to figure out. Thank you so much! :D
by interploy
19 Mar 2013, 18:23
Forum: Help
Topic: Show both open and locked tickets in Queue view
Replies: 4
Views: 595

Re: Show both open and locked tickets in Queue view

Thanks, I'll try that.
by interploy
19 Mar 2013, 01:57
Forum: Help
Topic: Show both open and locked tickets in Queue view
Replies: 4
Views: 595

Re: Show both open and locked tickets in Queue view

Was there ever a resolution for this because I have a similar situation. We'd like to have all open tickets viewable, locked or unlocked, for a specific queue.

Thanks,
-inteprloy
by interploy
18 Mar 2013, 21:50
Forum: Help
Topic: [SOLVED] Adding Dynamic Fields to Database Views
Replies: 7
Views: 2541

Re: Adding Dynamic Fields to Database Views

No thoughts on this at all? Is it even feasible...? I'm in the process of upgrading to v3.2.3, though from my tests insofar it doesn't look like there's a direct relationship between the ticket table and the dynamic_fields table. If there is no direct connection, what might the repercussions be if I...
by interploy
26 Feb 2013, 21:18
Forum: Help
Topic: [SOLVED] Adding Dynamic Fields to Database Views
Replies: 7
Views: 2541

[SOLVED] Adding Dynamic Fields to Database Views

Hello, I've been tasked with creating a postgreSQL database view for an odbc connection to pull some basic ticket data. I've been able to setup most of the data, but two fields I need to include are dynamic fields. I found the the dynamic_field and dynamic_field_value tables, but I can't figure out ...
by interploy
24 Sep 2012, 23:04
Forum: Help
Topic: [SOLVED] "Environment not found" error
Replies: 2
Views: 409

Re: "Environment not found" error

Ach, of course... Not java, but I do have an instance of trac running on the same server and after checking trac does have that error message. I've updated the apache config to make sure it sees otrs separately from trac and it's working now. Thanks for your help!
by interploy
24 Sep 2012, 21:31
Forum: Help
Topic: [SOLVED] "Environment not found" error
Replies: 2
Views: 409

[SOLVED] "Environment not found" error

Hello, I'm attempting to install OTRS Help Desk v3.1.10 on an Ubuntu 10.04 server, but after installing I get the error "Environment not found" in the browser. That's it, no stacktrace or anything. I'm pretty well stumped on how to troubleshoot this. There's nothing in my apache log, I haven't had a...