Service select is taking too long to populate

Hi experts, I've installed an OTRS v. 3.0 with itsMF on an IIS in Windows 2008 server and Microsoft Sql Server. I've also integrated it with Active Directory for Client and Agent single sign-on and group-role synchronization. When I'm going to create a new phone ticket, after selecting the ticket type, an Ajax call is being made to populate the Service, SLA and Owner fields. This call is taking too long to complete, more than 5 minutes. This is happening from a couple of days ago, and I can't find out what could have changed. I'm just testing now, so I have just some dozens of tickets. I know it would be much better to install it on linux+apache+mysql, but windows platform is a must at my job location. Has someone had any similar problem? Any ideas on what could be happening? Why is this Ajax call being made if Type and Service fields are not related? Thanks in advance for any help, Aldo. --- El presente correo electr?nico y cualquier posible archivo adjunto esta dirigido solamente al destinatario del mensaje y contiene informaci?n que puede ser confidencial. Si Ud. no es el destinatario por favor notifique al remitente respondiendo a este mensaje y elimine inmediatamente el correo electr?nico y los posibles archivos adjuntos de su sistema. Esta prohibida cualquier utilizaci?n, difusi?n y copia de este correo electr?nico por cualquier persona o entidad que no sean las especificas destinatarias del mensaje. MRREE no acepta ninguna responsabilidad con respecto a cualquier comunicaci?n que haya sido emitida incumpliendo nuestra Pol?tica de Seguridad de la Informaci?n y la Ley de Protecci?n de Datos y Acci?n de Habeas Data N? 18.331. ---

Hello Aldo,
I believe this behavior is also happening on linux machines so you're not
alone (but of course wait times are shorter on linux). In order to improve
performance, make sure Apache::DBI and mod_perl are enabled. Another issue
could be that your service catalogue has too many items, in this case you
could use an approach in which services are shown depending on the queue
selected, using the package published at
http://opar.perl-services.de/bin/index.cgi/package/R/RI/RICHIERI/QueueAndSer...
Leonardo Certuche
www.itconsultores.com.co
Medellín, Colombia
On 1 March 2012 13:13, Aldo Velazquez Alonso
Hi experts,
I’ve installed an OTRS v. 3.0 with itsMF on an IIS in Windows 2008 server and Microsoft Sql Server. I’ve also integrated it with Active Directory for Client and Agent single sign-on and group-role synchronization.
When I’m going to create a new phone ticket, after selecting the ticket type, an Ajax call is being made to populate the Service, SLA and Owner fields. This call is taking too long to complete, more than 5 minutes. This is happening from a couple of days ago, and I can’t find out what could have changed. I’m just testing now, so I have just some dozens of tickets.
I know it would be much better to install it on linux+apache+mysql, but windows platform is a must at my job location.
Has someone had any similar problem? Any ideas on what could be happening? Why is this Ajax call being made if Type and Service fields are not related?
Thanks in advance for any help,
Aldo.
--- El presente correo electrónico y cualquier posible archivo adjunto esta dirigido solamente al destinatario del mensaje y contiene información que puede ser confidencial. Si Ud. no es el destinatario por favor notifique al remitente respondiendo a este mensaje y elimine inmediatamente el correo electrónico y los posibles archivos adjuntos de su sistema. Esta prohibida cualquier utilización, difusión y copia de este correo electrónico por cualquier persona o entidad que no sean las especificas destinatarias del mensaje. MRREE no acepta ninguna responsabilidad con respecto a cualquier comunicación que haya sido emitida incumpliendo nuestra Política de Seguridad de la Información y la Ley de Protección de Datos y Acción de Habeas Data Nº 18.331. ---
--------------------------------------------------------------------- OTRS mailing list: itsm - Webpage: http://otrs.org/ Archive: http://lists.otrs.org/pipermail/itsm To unsubscribe: http://lists.otrs.org/mailman/listinfo/itsm

Thanks for your reply Leonardo,
I'm not using Apache but IIS, my service catalog has 10 services assigned by default to all clients (500+) but I've also tried to unassign the services but the times didn't improved. I'll try some things around services and if I can't make it work I'll try the queue approach.
Best regards,
Aldo.
From: itsm-bounces@otrs.org [mailto:itsm-bounces@otrs.org] On Behalf Of Leonardo Certuche
Sent: jueves, 01 de marzo de 2012 21:56
To: OTRS::ITSM User questions and discussions
Subject: Re: [itsm] Service select is taking too long to populate
Hello Aldo,
I believe this behavior is also happening on linux machines so you're not alone (but of course wait times are shorter on linux). In order to improve performance, make sure Apache::DBI and mod_perl are enabled. Another issue could be that your service catalogue has too many items, in this case you could use an approach in which services are shown depending on the queue selected, using the package published at http://opar.perl-services.de/bin/index.cgi/package/R/RI/RICHIERI/QueueAndSer...
Leonardo Certuche
www.itconsultores.com.cohttp://www.itconsultores.com.co
Medellín, Colombia
On 1 March 2012 13:13, Aldo Velazquez Alonso

Hello, There's a bundle package for windows that includes apache and mysql. Have you tried if this package performs better than your approach? It's still windows! El mar 2, 2012 6:20 a.m., "Aldo Velazquez Alonso" < aldo.velazquez@mrree.gub.uy> escribió:
Thanks for your reply Leonardo,
I’m not using Apache but IIS, my service catalog has 10 services assigned by default to all clients (500+) but I’ve also tried to unassign the services but the times didn’t improved. I’ll try some things around services and if I can’t make it work I’ll try the queue approach.
Best regards,
Aldo.
*From:* itsm-bounces@otrs.org [mailto:itsm-bounces@otrs.org] *On Behalf Of *Leonardo Certuche *Sent:* jueves, 01 de marzo de 2012 21:56 *To:* OTRS::ITSM User questions and discussions *Subject:* Re: [itsm] Service select is taking too long to populate
Hello Aldo,
I believe this behavior is also happening on linux machines so you're not alone (but of course wait times are shorter on linux). In order to improve performance, make sure Apache::DBI and mod_perl are enabled. Another issue could be that your service catalogue has too many items, in this case you could use an approach in which services are shown depending on the queue selected, using the package published at http://opar.perl-services.de/bin/index.cgi/package/R/RI/RICHIERI/QueueAndSer...
Leonardo Certuche www.itconsultores.com.co Medellín, Colombia
On 1 March 2012 13:13, Aldo Velazquez Alonso
wrote: Hi experts,
I’ve installed an OTRS v. 3.0 with itsMF on an IIS in Windows 2008 server and Microsoft Sql Server. I’ve also integrated it with Active Directory for Client and Agent single sign-on and group-role synchronization.
When I’m going to create a new phone ticket, after selecting the ticket type, an Ajax call is being made to populate the Service, SLA and Owner fields. This call is taking too long to complete, more than 5 minutes. This is happening from a couple of days ago, and I can’t find out what could have changed. I’m just testing now, so I have just some dozens of tickets.
I know it would be much better to install it on linux+apache+mysql, but windows platform is a must at my job location.
Has someone had any similar problem? Any ideas on what could be happening? Why is this Ajax call being made if Type and Service fields are not related?
Thanks in advance for any help,
Aldo.
--- El presente correo electrónico y cualquier posible archivo adjunto esta dirigido solamente al destinatario del mensaje y contiene información que puede ser confidencial. Si Ud. no es el destinatario por favor notifique al remitente respondiendo a este mensaje y elimine inmediatamente el correo electrónico y los posibles archivos adjuntos de su sistema. Esta prohibida cualquier utilización, difusión y copia de este correo electrónico por cualquier persona o entidad que no sean las especificas destinatarias del mensaje. MRREE no acepta ninguna responsabilidad con respecto a cualquier comunicación que haya sido emitida incumpliendo nuestra Política de Seguridad de la Información y la Ley de Protección de Datos y Acción de Habeas Data Nº 18.331. ---
--------------------------------------------------------------------- OTRS mailing list: itsm - Webpage: http://otrs.org/ Archive: http://lists.otrs.org/pipermail/itsm To unsubscribe: http://lists.otrs.org/mailman/listinfo/itsm
--- El presente correo electrónico y cualquier posible archivo adjunto esta dirigido solamente al destinatario del mensaje y contiene información que puede ser confidencial. Si Ud. no es el destinatario por favor notifique al remitente respondiendo a este mensaje y elimine inmediatamente el correo electrónico y los posibles archivos adjuntos de su sistema. Esta prohibida cualquier utilización, difusión y copia de este correo electrónico por cualquier persona o entidad que no sean las especificas destinatarias del mensaje. MRREE no acepta ninguna responsabilidad con respecto a cualquier comunicación que haya sido emitida incumpliendo nuestra Política de Seguridad de la Información y la Ley de Protección de Datos y Acción de Habeas Data Nº 18.331. ---
--------------------------------------------------------------------- OTRS mailing list: itsm - Webpage: http://otrs.org/ Archive: http://lists.otrs.org/pipermail/itsm To unsubscribe: http://lists.otrs.org/mailman/listinfo/itsm

Hi Aldo, IIS will work, but you'll have to set it up with some kind of CGI accelleration. Then it will be performing quite well, as good as Apache + mod_perl as far as I am concerned. See this article on our wiki: http://wiki.otterhub.org/index.php?title=Installation_on_Win2008_with_Micros... Hope this helps! -- Mike On 2-3-2012 14:36, Leonardo Certuche wrote:
Hello, There's a bundle package for windows that includes apache and mysql. Have you tried if this package performs better than your approach? It's still windows!
El mar 2, 2012 6:20 a.m., "Aldo Velazquez Alonso"
mailto:aldo.velazquez@mrree.gub.uy> escribió: Thanks for your reply Leonardo,
I'm not using Apache but IIS, my service catalog has 10 services assigned by default to all clients (500+) but I've also tried to unassign the services but the times didn't improved. I'll try some things around services and if I can't make it work I'll try the queue approach.
Best regards,
Aldo.
*From:*itsm-bounces@otrs.org mailto:itsm-bounces@otrs.org [mailto:itsm-bounces@otrs.org mailto:itsm-bounces@otrs.org] *On Behalf Of *Leonardo Certuche *Sent:* jueves, 01 de marzo de 2012 21:56 *To:* OTRS::ITSM User questions and discussions *Subject:* Re: [itsm] Service select is taking too long to populate
Hello Aldo,
I believe this behavior is also happening on linux machines so you're not alone (but of course wait times are shorter on linux). In order to improve performance, make sure Apache::DBI and mod_perl are enabled. Another issue could be that your service catalogue has too many items, in this case you could use an approach in which services are shown depending on the queue selected, using the package published at http://opar.perl-services.de/bin/index.cgi/package/R/RI/RICHIERI/QueueAndSer...
Leonardo Certuche www.itconsultores.com.co http://www.itconsultores.com.co Medellín, Colombia
On 1 March 2012 13:13, Aldo Velazquez Alonso
mailto:aldo.velazquez@mrree.gub.uy> wrote: Hi experts,
I've installed an OTRS v. 3.0 with itsMF on an IIS in Windows 2008 server and Microsoft Sql Server. I've also integrated it with Active Directory for Client and Agent single sign-on and group-role synchronization.
When I'm going to create a new phone ticket, after selecting the ticket type, an Ajax call is being made to populate the Service, SLA and Owner fields. This call is taking too long to complete, more than 5 minutes. This is happening from a couple of days ago, and I can't find out what could have changed. I'm just testing now, so I have just some dozens of tickets.
I know it would be much better to install it on linux+apache+mysql, but windows platform is a must at my job location.
Has someone had any similar problem? Any ideas on what could be happening? Why is this Ajax call being made if Type and Service fields are not related?
Thanks in advance for any help,
Aldo.
--- El presente correo electrónico y cualquier posible archivo adjunto esta dirigido solamente al destinatario del mensaje y contiene información que puede ser confidencial. Si Ud. no es el destinatario por favor notifique al remitente respondiendo a este mensaje y elimine inmediatamente el correo electrónico y los posibles archivos adjuntos de su sistema. Esta prohibida cualquier utilización, difusión y copia de este correo electrónico por cualquier persona o entidad que no sean las especificas destinatarias del mensaje. MRREE no acepta ninguna responsabilidad con respecto a cualquier comunicación que haya sido emitida incumpliendo nuestra Política de Seguridad de la Información y la Ley de Protección de Datos y Acción de Habeas Data Nº 18.331. ---
--------------------------------------------------------------------- OTRS mailing list: itsm - Webpage: http://otrs.org/ Archive: http://lists.otrs.org/pipermail/itsm To unsubscribe: http://lists.otrs.org/mailman/listinfo/itsm
--- El presente correo electrónico y cualquier posible archivo adjunto esta dirigido solamente al destinatario del mensaje y contiene información que puede ser confidencial. Si Ud. no es el destinatario por favor notifique al remitente respondiendo a este mensaje y elimine inmediatamente el correo electrónico y los posibles archivos adjuntos de su sistema. Esta prohibida cualquier utilización, difusión y copia de este correo electrónico por cualquier persona o entidad que no sean las especificas destinatarias del mensaje. MRREE no acepta ninguna responsabilidad con respecto a cualquier comunicación que haya sido emitida incumpliendo nuestra Política de Seguridad de la Información y la Ley de Protección de Datos y Acción de Habeas Data Nº 18.331. ---
--------------------------------------------------------------------- OTRS mailing list: itsm - Webpage: http://otrs.org/ Archive: http://lists.otrs.org/pipermail/itsm To unsubscribe: http://lists.otrs.org/mailman/listinfo/itsm
--------------------------------------------------------------------- OTRS mailing list: itsm - Webpage: http://otrs.org/ Archive: http://lists.otrs.org/pipermail/itsm To unsubscribe: http://lists.otrs.org/mailman/listinfo/itsm

Yes, it's working fine in almost all functionalities, but when creating a phone ticket it takes several minutes for service population and when opening the search it takes too long too. The rest is working fine, even when modifying a ticket the service field population works fast.
From: itsm-bounces@otrs.org [mailto:itsm-bounces@otrs.org] On Behalf Of Michiel Beijen
Sent: viernes, 02 de marzo de 2012 11:16
To: OTRS:@
Subject: Re: [itsm] Service select is taking too long to populate
Hi Aldo,
IIS will work, but you'll have to set it up with some kind of CGI accelleration. Then it will be performing quite well, as good as Apache + mod_perl as far as I am concerned.
See this article on our wiki:
http://wiki.otterhub.org/index.php?title=Installation_on_Win2008_with_Micros...
Hope this helps!
--
Mike
On 2-3-2012 14:36, Leonardo Certuche wrote:
Hello,
There's a bundle package for windows that includes apache and mysql. Have you tried if this package performs better than your approach? It's still windows!
El mar 2, 2012 6:20 a.m., "Aldo Velazquez Alonso"
participants (3)
-
Aldo Velazquez Alonso
-
Leonardo Certuche
-
Michiel Beijen