Running SQLs to Create Groups, Queues: Problem

samwaithaka · Post by **samwaithaka** » 30 Jul 2016, 12:33

Hi,

I ran insert SQLs on Postgresql to create groups and queues. However, I'm not able to see these groups and queues on the dashboard. Why is this? Or what other tables are updated when new group or queue is added normally?
Please help.

jojo · Post by **jojo** » 30 Jul 2016, 13:06

Never do manual inserts on the database! You (most likely)will break dependencies.

Neverless, there is a cache, wich need to be deletednow

smile31 · Post by **smile31** » 31 Jul 2016, 01:04

hi,
I have acreated A1 thet A2 then T1, when i deploy the process juste the first activity is created, so i guess the transition dosn't work:
he are some screenshot: https://drive.google.com/file/d/0B5ilC2 ... sp=sharing

Thank you for your help if you have an idea why the transition doesn't work..

samwaithaka · Post by **samwaithaka** » 01 Aug 2016, 08:03

jojo wrote:Never do manual inserts on the database! You (most likely)will break dependencies.

Neverless, there is a cache, wich need to be deletednow

Thanks. I deleted cache. Thanks for the advise too. Was careful to analyze dependencies first but I suppose OTRS API would help with over 120 groups, queues etc...to add?

jojo · Post by **jojo** » 01 Aug 2016, 08:23

yes there are scripts in the Console.pl

Znuny Open Source Ticketsystem

Running SQLs to Create Groups, Queues: Problem

Running SQLs to Create Groups, Queues: Problem

Re: Running SQLs to Create Groups, Queues: Problem

transition doesn't work

Re: Running SQLs to Create Groups, Queues: Problem

Re: Running SQLs to Create Groups, Queues: Problem