- itsm - OTRS mailing lists

Our services dropdown doesn´t show anything
by Salvador Santander Gutiérrez 19 Sep '08

19 Sep '08

Hello, we have a problem with services. We've created both services and SLA, but when create a new ticket and introduce the type, user and queue any service appears. Do you know if we have to do more actions? Thanks very much.

1 0

Linking Customer User, Customer Company and Location
by Davide D'Onofrio 18 Sep '08

18 Sep '08

Hi all, I'm new to OTRS. I've just read OTRS and OTRS::ITSM available documentation but I couldn't find clear information about how to link customer users, customer company and customer location. I mean, I would like to reference this data in my tickets getting information about what company the customer user belongs to and what's the location affected by the incident. It would also be great if assets belonging to a specific company could be retrieved. Any clue? Thanks in advance David

1 0

Configitem Definition
by Raphael Matter 18 Sep '08

18 Sep '08

Hi, I've got a simple question: Is there any documentation about the format of configitem definitions? I wonder exactly: * Are there more datatypes than: date, customer, generalcatalog, text and textarea? * What kind of syntax and expressions can be used (like: countmin, countmax, searchable, maxlength...)? * Is it posible to use some kind of logic or conditions? E.g. I need to use different Sub-blocks, depending on a selected value. Some kind of reference or manual, which can answer my questions would be wonderul. Any help appreciated! thank you in advance best regards Raphael

1 0

Using Outlook-like signatures when responding to tickets
by robert_kollar＠inds.com 12 Sep '08

12 Sep '08

We have several individuals in our IT Department using OTRS. In addition to adding our names, is there a way add a title and phone extension? RK NOTICE: The information contained in this electronic mail message may be confidential, proprietary in nature and /or privileged . It is intended exclusively for the individual(s) or entity to which it is addressed. If you are not an intended recipient, you are hereby notified that any viewing, disclosure, reproduction, distribution or other use of this communication and any attachments is strictly prohibited. If you have received this communication in error, please notify the sender by reply transmission and delete the message without copying or disclosing it.

1 0

OTRS XML Error
by Madwin Cerezo 27 Aug '08

27 Aug '08

Hi there I have the following problem, when I try to access the "SysConfig" tab in the admin menu, it presents the following error Can't locate object method "new" via package "XML::Parser::Lite" at /usr/share/otrs//Kernel/System/XML.pm line 781. For help, please send mail to the webmaster ( <mailto:webmaster@localhost> webmaster@localhost), giving this error message and the time and date of the error. I'd appreciate the help you guys can provide me on this issue Best Regards Ing. Madwin Cerezo Junior IT Security Consultant IT Security Solutions, C.A Telf/Fax: +58 (212) 234 2444 Celular: +58 (416) 1746869

1 0

OTRS::ITSM Modifying ConfigItem fields
by Bertazzi Diego 26 Aug '08

26 Aug '08

Hi all! I did not find any documentation on how to modify the fields used by the "Config Item" classes definition. I would like to change the way a few fields are defined: for example I would like the "Vendor" field of the "Computer" class to be selected from a list of values and not a free-text field, the same for the "Model" field which should be a list dynamically composed depending on the value of the "Vendor" field. Anybody knows if this can be done ? It looks like the definition of all classes in the ConfigItem Management can be modified but I have no idea of which "Type" are acceptable by OTRS. I tried to use the GeneralCatalog classes (defining a new class and referencing it from the ConfigItem definition) but it is not satisfactory because it is too cumbersome. Thanks in advance to anyone willing to help. Cheers, Diego.- Diego Bertazzi Responsabile Esercizio e Operazioni IT Area Organizzazione e Sistemi Casino de la Vallee Via Italo Mus 11027 Saint Vincent (AO) Tel.: 0166-522637 Fax: 0166-522629 -------------------------------------------- INFORMATIVA SULLA PRIVACY Ai sensi del D.Lgs. 196/2003 si precisa che le informazioni contenute in questo messaggio e nei suoi eventuali allegati sono riservate e per uso esclusivo del destinatario. Nessuno, all'infuori dello stesso, pu� copiare o distribuire il messaggio, o parte di esso, a terzi. Chiunque riceva questo messaggio per errore � pregato di distruggerlo e di informare il mittente. PRIVACY NOTICE According to the D.Lgs. 196/2003 this document and its attachments are confidential and intended for the named addressee(s) only. If you are not the intended recipient of this message, any use or dissemination of this message is prohibited. If you have received this document by mistake, please notify the sender and destroy all physical and/or electronic copies. --------------------------------------------

1 0

Re: [itsm] R: OTRS:ITSM 1.2.1 on MSSQL
by Bertazzi Diego 26 Aug '08

26 Aug '08

Manuel, I've found the problem! The OTRS database had a wrong charset, different from the server's default. Thanks for your help! Diego Bertazzi Responsabile Esercizio e Operazioni IT Area Organizzazione e Sistemi Casino de la Vallee Via Italo Mus 11027 Saint Vincent (AO) Tel.: 0166-522637 Fax: 0166-522629 > -----Original Message----- > From: itsm-bounces(a)otrs.org [mailto:itsm-bounces@otrs.org] On Behalf Of > Manuel Hecht - OTRS AG > Sent: Tuesday, August 26, 2008 1:10 PM > To: 'OTRS::ITSM User questions and discussions' > Subject: Re: [itsm] R: OTRS:ITSM 1.2.1 on MSSQL > > Hi Diego > > Another possibility is a wrong charset of the otrs database tables on your MSSQL > server. > > > Best regards, > Manuel Hecht > > ((otrs)) :: OTRS AG :: Europaring 4 :: D - 94315 Straubing > Fon: +49 (0)9421 56818 0 :: Fax: +49 (0)9421 56818 18 > http://www.otrs.com/ :: Communication with success! > > > > > -----Ursprüngliche Nachricht----- > Von: itsm-bounces(a)otrs.org [mailto:itsm-bounces@otrs.org] Im Auftrag von > Manuel Hecht - OTRS AG > Gesendet: Dienstag, 26. August 2008 13:05 > An: 'OTRS::ITSM User questions and discussions' > Betreff: Re: [itsm] R: OTRS:ITSM 1.2.1 on MSSQL > > Hi Diego > > Hm. I think it's a charset problem! > > > Software error: > > Malformed UTF-8 character (fatal) at C:/OTRS/otrs/Kernel/cpan- > lib/XML/Parser/Lite.pm line 141. > > Perhaps, the downloaded package is damaged! > > Please download the packages from this FTP server and test it again: > > ftp://ftp.otrs.org/pub/otrs/itsm/packages12/ > > > Best regards, > Manuel Hecht > > ((otrs)) :: OTRS AG :: Europaring 4 :: D - 94315 Straubing > Fon: +49 (0)9421 56818 0 :: Fax: +49 (0)9421 56818 18 > http://www.otrs.com/ :: Communication with success! > > > > -----Ursprüngliche Nachricht----- > Von: itsm-bounces(a)otrs.org [mailto:itsm-bounces@otrs.org] Im Auftrag von > Bertazzi Diego > Gesendet: Dienstag, 26. August 2008 12:37 > An: OTRS::ITSM User questions and discussions > Betreff: [itsm] R: OTRS:ITSM 1.2.1 on MSSQL > > Manuel, > > Thank you for your reply. I don't think the problem is in the packages as I used > them on the MySQL installation without any problem. > Do you think it could be a localization problem ? I mean some national settings on > the MSSQL server ? > > Thanks. > Diego.- > > > -----Messaggio originale----- > Da: itsm-bounces(a)otrs.org [mailto:itsm-bounces@otrs.org] Per conto di Manuel > Hecht - OTRS AG > Inviato: martedì 26 agosto 2008 12.34 > A: 'OTRS::ITSM User questions and discussions' > Oggetto: Re: [itsm] OTRS:ITSM 1.2.1 on MSSQL > > Hi Diego > > We tested the installation of the ITSM 1.2.1 packages on MSSQL without any > problems. > > I think this is a setup or configuration problem. > > > Best regards, > Manuel Hecht > > ((otrs)) :: OTRS AG :: Europaring 4 :: D - 94315 Straubing > Fon: +49 (0)9421 56818 0 :: Fax: +49 (0)9421 56818 18 > http://www.otrs.com/ :: Communication with success! > > > > Von: itsm-bounces(a)otrs.org [mailto:itsm-bounces@otrs.org] Im Auftrag von > Bertazzi Diego > Gesendet: Freitag, 22. August 2008 11:41 > An: itsm(a)otrs.org > Betreff: [itsm] OTRS:ITSM 1.2.1 on MSSQL > > I'm trying to install OTRS:ITSM 1.2.1 on a Microsoft SQL Server 2005 (v > 9.00.3042). > I've executed the instructions as per FAQ #4200121 and it looks like OTRS > (v2.3.1) is working correctly. > After that I was following the installation instructions for the ITSM modules: tried > to add the first package (GeneralCatalog) but the browser returned the following > message: > Software error: > Malformed UTF-8 character (fatal) at C:/OTRS/otrs/Kernel/cpan- > lib/XML/Parser/Lite.pm line 141. > After that I am not able to open the PackageManager page anymore. If I drop and > recreate the package's SQL table I can open again the PackageManager page and > try to add again the package but the result is always the same (see message > above). > Before using the MSSQL backend I successfully installed and used the same > installation based on MySql so I think is a problem related to the way MSSQL > stores the package data. > Anyone can help me ? > Thanks in advance. > Diego.- > ________________________________________ > > -------------------------------------------- > INFORMATIVA SULLA PRIVACY > Ai sensi del D.Lgs. 196/2003 si precisa che le informazioni contenute in questo > messaggio e nei suoi eventuali allegati sono riservate e per uso esclusivo del > destinatario. Nessuno, all'infuori dello stesso, può copiare o distribuire il > messaggio, o parte di esso, a terzi. Chiunque riceva questo messaggio per errore è > pregato di distruggerlo e di informare il mittente. > > PRIVACY NOTICE > According to the D.Lgs. 196/2003 this document and its attachments are > confidential and intended for the named addressee(s) only. If you are not the > intended recipient of this message, any use or dissemination of this message is > prohibited. If you have received this document by mistake, please notify the > sender and destroy all physical and/or electronic copies. > -------------------------------------------- > > > _______________________________________________ > OTRS mailing list: itsm - Webpage: http://otrs.org/ > Archive: http://lists.otrs.org/pipermail/itsm > To unsubscribe: http://lists.otrs.org/mailman/listinfo/itsm > Support or consulting for your OTRS::ITSM system? > => http://www.otrs.com/ > > > > -------------------------------------------- > INFORMATIVA SULLA PRIVACY > Ai sensi del D.Lgs. 196/2003 si precisa che le informazioni contenute in questo > messaggio e nei suoi eventuali allegati sono riservate e per uso esclusivo del > destinatario. Nessuno, all'infuori dello stesso, può copiare o distribuire il > messaggio, o parte di esso, a terzi. Chiunque riceva questo messaggio per errore è > pregato di distruggerlo e di informare il mittente. > > PRIVACY NOTICE > According to the D.Lgs. 196/2003 this document and its attachments are > confidential and intended for the named addressee(s) only. If you are not the > intended recipient of this message, any use or dissemination of this message is > prohibited. If you have received this document by mistake, please notify the > sender and destroy all physical and/or electronic copies. > -------------------------------------------- > _______________________________________________ > OTRS mailing list: itsm - Webpage: http://otrs.org/ > Archive: http://lists.otrs.org/pipermail/itsm > To unsubscribe: http://lists.otrs.org/mailman/listinfo/itsm > Support or consulting for your OTRS::ITSM system? > => http://www.otrs.com/ > > > _______________________________________________ > OTRS mailing list: itsm - Webpage: http://otrs.org/ > Archive: http://lists.otrs.org/pipermail/itsm > To unsubscribe: http://lists.otrs.org/mailman/listinfo/itsm > Support or consulting for your OTRS::ITSM system? > => http://www.otrs.com/ > > > _______________________________________________ > OTRS mailing list: itsm - Webpage: http://otrs.org/ > Archive: http://lists.otrs.org/pipermail/itsm > To unsubscribe: http://lists.otrs.org/mailman/listinfo/itsm > Support or consulting for your OTRS::ITSM system? > => http://www.otrs.com/ -------------------------------------------- INFORMATIVA SULLA PRIVACY Ai sensi del D.Lgs. 196/2003 si precisa che le informazioni contenute in questo messaggio e nei suoi eventuali allegati sono riservate e per uso esclusivo del destinatario. Nessuno, all'infuori dello stesso, può copiare o distribuire il messaggio, o parte di esso, a terzi. Chiunque riceva questo messaggio per errore è pregato di distruggerlo e di informare il mittente. PRIVACY NOTICE According to the D.Lgs. 196/2003 this document and its attachments are confidential and intended for the named addressee(s) only. If you are not the intended recipient of this message, any use or dissemination of this message is prohibited. If you have received this document by mistake, please notify the sender and destroy all physical and/or electronic copies. --------------------------------------------

2 1

Re: [itsm] R: OTRS:ITSM 1.2.1 on MSSQL
by Bertazzi Diego 26 Aug '08

26 Aug '08

Manuel, Do you have a charset which you suggest as the correct one ? Currently our test MSSQL Server is set for Latin1_General_CI_AS collation and it is a localized (italian) version (but I don't think this should be a problem). Thanks. Diego Bertazzi Responsabile Esercizio e Operazioni IT Area Organizzazione e Sistemi Casino de la Vallee Via Italo Mus 11027 Saint Vincent (AO) Tel.: 0166-522637 Fax: 0166-522629 > -----Original Message----- > From: itsm-bounces(a)otrs.org [mailto:itsm-bounces@otrs.org] On Behalf Of > Manuel Hecht - OTRS AG > Sent: Tuesday, August 26, 2008 1:10 PM > To: 'OTRS::ITSM User questions and discussions' > Subject: Re: [itsm] R: OTRS:ITSM 1.2.1 on MSSQL > > Hi Diego > > Another possibility is a wrong charset of the otrs database tables on your MSSQL > server. > > > Best regards, > Manuel Hecht > > ((otrs)) :: OTRS AG :: Europaring 4 :: D - 94315 Straubing > Fon: +49 (0)9421 56818 0 :: Fax: +49 (0)9421 56818 18 > http://www.otrs.com/ :: Communication with success! > > > > > -----Ursprüngliche Nachricht----- > Von: itsm-bounces(a)otrs.org [mailto:itsm-bounces@otrs.org] Im Auftrag von > Manuel Hecht - OTRS AG > Gesendet: Dienstag, 26. August 2008 13:05 > An: 'OTRS::ITSM User questions and discussions' > Betreff: Re: [itsm] R: OTRS:ITSM 1.2.1 on MSSQL > > Hi Diego > > Hm. I think it's a charset problem! > > > Software error: > > Malformed UTF-8 character (fatal) at C:/OTRS/otrs/Kernel/cpan- > lib/XML/Parser/Lite.pm line 141. > > Perhaps, the downloaded package is damaged! > > Please download the packages from this FTP server and test it again: > > ftp://ftp.otrs.org/pub/otrs/itsm/packages12/ > > > Best regards, > Manuel Hecht > > ((otrs)) :: OTRS AG :: Europaring 4 :: D - 94315 Straubing > Fon: +49 (0)9421 56818 0 :: Fax: +49 (0)9421 56818 18 > http://www.otrs.com/ :: Communication with success! > > > > -----Ursprüngliche Nachricht----- > Von: itsm-bounces(a)otrs.org [mailto:itsm-bounces@otrs.org] Im Auftrag von > Bertazzi Diego > Gesendet: Dienstag, 26. August 2008 12:37 > An: OTRS::ITSM User questions and discussions > Betreff: [itsm] R: OTRS:ITSM 1.2.1 on MSSQL > > Manuel, > > Thank you for your reply. I don't think the problem is in the packages as I used > them on the MySQL installation without any problem. > Do you think it could be a localization problem ? I mean some national settings on > the MSSQL server ? > > Thanks. > Diego.- > > > -----Messaggio originale----- > Da: itsm-bounces(a)otrs.org [mailto:itsm-bounces@otrs.org] Per conto di Manuel > Hecht - OTRS AG > Inviato: martedì 26 agosto 2008 12.34 > A: 'OTRS::ITSM User questions and discussions' > Oggetto: Re: [itsm] OTRS:ITSM 1.2.1 on MSSQL > > Hi Diego > > We tested the installation of the ITSM 1.2.1 packages on MSSQL without any > problems. > > I think this is a setup or configuration problem. > > > Best regards, > Manuel Hecht > > ((otrs)) :: OTRS AG :: Europaring 4 :: D - 94315 Straubing > Fon: +49 (0)9421 56818 0 :: Fax: +49 (0)9421 56818 18 > http://www.otrs.com/ :: Communication with success! > > > > Von: itsm-bounces(a)otrs.org [mailto:itsm-bounces@otrs.org] Im Auftrag von > Bertazzi Diego > Gesendet: Freitag, 22. August 2008 11:41 > An: itsm(a)otrs.org > Betreff: [itsm] OTRS:ITSM 1.2.1 on MSSQL > > I'm trying to install OTRS:ITSM 1.2.1 on a Microsoft SQL Server 2005 (v > 9.00.3042). > I've executed the instructions as per FAQ #4200121 and it looks like OTRS > (v2.3.1) is working correctly. > After that I was following the installation instructions for the ITSM modules: tried > to add the first package (GeneralCatalog) but the browser returned the following > message: > Software error: > Malformed UTF-8 character (fatal) at C:/OTRS/otrs/Kernel/cpan- > lib/XML/Parser/Lite.pm line 141. > After that I am not able to open the PackageManager page anymore. If I drop and > recreate the package's SQL table I can open again the PackageManager page and > try to add again the package but the result is always the same (see message > above). > Before using the MSSQL backend I successfully installed and used the same > installation based on MySql so I think is a problem related to the way MSSQL > stores the package data. > Anyone can help me ? > Thanks in advance. > Diego.- > ________________________________________ > > -------------------------------------------- > INFORMATIVA SULLA PRIVACY > Ai sensi del D.Lgs. 196/2003 si precisa che le informazioni contenute in questo > messaggio e nei suoi eventuali allegati sono riservate e per uso esclusivo del > destinatario. Nessuno, all'infuori dello stesso, può copiare o distribuire il > messaggio, o parte di esso, a terzi. Chiunque riceva questo messaggio per errore è > pregato di distruggerlo e di informare il mittente. > > PRIVACY NOTICE > According to the D.Lgs. 196/2003 this document and its attachments are > confidential and intended for the named addressee(s) only. If you are not the > intended recipient of this message, any use or dissemination of this message is > prohibited. If you have received this document by mistake, please notify the > sender and destroy all physical and/or electronic copies. > -------------------------------------------- > > > _______________________________________________ > OTRS mailing list: itsm - Webpage: http://otrs.org/ > Archive: http://lists.otrs.org/pipermail/itsm > To unsubscribe: http://lists.otrs.org/mailman/listinfo/itsm > Support or consulting for your OTRS::ITSM system? > => http://www.otrs.com/ > > > > -------------------------------------------- > INFORMATIVA SULLA PRIVACY > Ai sensi del D.Lgs. 196/2003 si precisa che le informazioni contenute in questo > messaggio e nei suoi eventuali allegati sono riservate e per uso esclusivo del > destinatario. Nessuno, all'infuori dello stesso, può copiare o distribuire il > messaggio, o parte di esso, a terzi. Chiunque riceva questo messaggio per errore è > pregato di distruggerlo e di informare il mittente. > > PRIVACY NOTICE > According to the D.Lgs. 196/2003 this document and its attachments are > confidential and intended for the named addressee(s) only. If you are not the > intended recipient of this message, any use or dissemination of this message is > prohibited. If you have received this document by mistake, please notify the > sender and destroy all physical and/or electronic copies. > -------------------------------------------- > _______________________________________________ > OTRS mailing list: itsm - Webpage: http://otrs.org/ > Archive: http://lists.otrs.org/pipermail/itsm > To unsubscribe: http://lists.otrs.org/mailman/listinfo/itsm > Support or consulting for your OTRS::ITSM system? > => http://www.otrs.com/ > > > _______________________________________________ > OTRS mailing list: itsm - Webpage: http://otrs.org/ > Archive: http://lists.otrs.org/pipermail/itsm > To unsubscribe: http://lists.otrs.org/mailman/listinfo/itsm > Support or consulting for your OTRS::ITSM system? > => http://www.otrs.com/ > > > _______________________________________________ > OTRS mailing list: itsm - Webpage: http://otrs.org/ > Archive: http://lists.otrs.org/pipermail/itsm > To unsubscribe: http://lists.otrs.org/mailman/listinfo/itsm > Support or consulting for your OTRS::ITSM system? > => http://www.otrs.com/ -------------------------------------------- INFORMATIVA SULLA PRIVACY Ai sensi del D.Lgs. 196/2003 si precisa che le informazioni contenute in questo messaggio e nei suoi eventuali allegati sono riservate e per uso esclusivo del destinatario. Nessuno, all'infuori dello stesso, può copiare o distribuire il messaggio, o parte di esso, a terzi. Chiunque riceva questo messaggio per errore è pregato di distruggerlo e di informare il mittente. PRIVACY NOTICE According to the D.Lgs. 196/2003 this document and its attachments are confidential and intended for the named addressee(s) only. If you are not the intended recipient of this message, any use or dissemination of this message is prohibited. If you have received this document by mistake, please notify the sender and destroy all physical and/or electronic copies. --------------------------------------------

1 0

Re: [itsm] R: OTRS:ITSM 1.2.1 on MSSQL
by Manuel Hecht - OTRS AG 26 Aug '08

26 Aug '08

Hi Diego Another possibility is a wrong charset of the otrs database tables on your MSSQL server. Best regards, Manuel Hecht ((otrs)) :: OTRS AG :: Europaring 4 :: D - 94315 Straubing Fon: +49 (0)9421 56818 0 :: Fax: +49 (0)9421 56818 18 http://www.otrs.com/ :: Communication with success! -----Ursprüngliche Nachricht----- Von: itsm-bounces(a)otrs.org [mailto:itsm-bounces@otrs.org] Im Auftrag von Manuel Hecht - OTRS AG Gesendet: Dienstag, 26. August 2008 13:05 An: 'OTRS::ITSM User questions and discussions' Betreff: Re: [itsm] R: OTRS:ITSM 1.2.1 on MSSQL Hi Diego Hm. I think it's a charset problem! > Software error: > Malformed UTF-8 character (fatal) at C:/OTRS/otrs/Kernel/cpan-lib/XML/Parser/Lite.pm line 141. Perhaps, the downloaded package is damaged! Please download the packages from this FTP server and test it again: ftp://ftp.otrs.org/pub/otrs/itsm/packages12/ Best regards, Manuel Hecht ((otrs)) :: OTRS AG :: Europaring 4 :: D - 94315 Straubing Fon: +49 (0)9421 56818 0 :: Fax: +49 (0)9421 56818 18 http://www.otrs.com/ :: Communication with success! -----Ursprüngliche Nachricht----- Von: itsm-bounces(a)otrs.org [mailto:itsm-bounces@otrs.org] Im Auftrag von Bertazzi Diego Gesendet: Dienstag, 26. August 2008 12:37 An: OTRS::ITSM User questions and discussions Betreff: [itsm] R: OTRS:ITSM 1.2.1 on MSSQL Manuel, Thank you for your reply. I don't think the problem is in the packages as I used them on the MySQL installation without any problem. Do you think it could be a localization problem ? I mean some national settings on the MSSQL server ? Thanks. Diego.- -----Messaggio originale----- Da: itsm-bounces(a)otrs.org [mailto:itsm-bounces@otrs.org] Per conto di Manuel Hecht - OTRS AG Inviato: martedì 26 agosto 2008 12.34 A: 'OTRS::ITSM User questions and discussions' Oggetto: Re: [itsm] OTRS:ITSM 1.2.1 on MSSQL Hi Diego We tested the installation of the ITSM 1.2.1 packages on MSSQL without any problems. I think this is a setup or configuration problem. Best regards, Manuel Hecht ((otrs)) :: OTRS AG :: Europaring 4 :: D - 94315 Straubing Fon: +49 (0)9421 56818 0 :: Fax: +49 (0)9421 56818 18 http://www.otrs.com/ :: Communication with success! Von: itsm-bounces(a)otrs.org [mailto:itsm-bounces@otrs.org] Im Auftrag von Bertazzi Diego Gesendet: Freitag, 22. August 2008 11:41 An: itsm(a)otrs.org Betreff: [itsm] OTRS:ITSM 1.2.1 on MSSQL I'm trying to install OTRS:ITSM 1.2.1 on a Microsoft SQL Server 2005 (v 9.00.3042). I've executed the instructions as per FAQ #4200121 and it looks like OTRS (v2.3.1) is working correctly. After that I was following the installation instructions for the ITSM modules: tried to add the first package (GeneralCatalog) but the browser returned the following message: Software error: Malformed UTF-8 character (fatal) at C:/OTRS/otrs/Kernel/cpan-lib/XML/Parser/Lite.pm line 141. After that I am not able to open the PackageManager page anymore. If I drop and recreate the package's SQL table I can open again the PackageManager page and try to add again the package but the result is always the same (see message above). Before using the MSSQL backend I successfully installed and used the same installation based on MySql so I think is a problem related to the way MSSQL stores the package data. Anyone can help me ? Thanks in advance. Diego.- ________________________________________ -------------------------------------------- INFORMATIVA SULLA PRIVACY Ai sensi del D.Lgs. 196/2003 si precisa che le informazioni contenute in questo messaggio e nei suoi eventuali allegati sono riservate e per uso esclusivo del destinatario. Nessuno, all'infuori dello stesso, può copiare o distribuire il messaggio, o parte di esso, a terzi. Chiunque riceva questo messaggio per errore è pregato di distruggerlo e di informare il mittente. PRIVACY NOTICE According to the D.Lgs. 196/2003 this document and its attachments are confidential and intended for the named addressee(s) only. If you are not the intended recipient of this message, any use or dissemination of this message is prohibited. If you have received this document by mistake, please notify the sender and destroy all physical and/or electronic copies. -------------------------------------------- _______________________________________________ OTRS mailing list: itsm - Webpage: http://otrs.org/ Archive: http://lists.otrs.org/pipermail/itsm To unsubscribe: http://lists.otrs.org/mailman/listinfo/itsm Support or consulting for your OTRS::ITSM system? => http://www.otrs.com/ -------------------------------------------- INFORMATIVA SULLA PRIVACY Ai sensi del D.Lgs. 196/2003 si precisa che le informazioni contenute in questo messaggio e nei suoi eventuali allegati sono riservate e per uso esclusivo del destinatario. Nessuno, all'infuori dello stesso, può copiare o distribuire il messaggio, o parte di esso, a terzi. Chiunque riceva questo messaggio per errore è pregato di distruggerlo e di informare il mittente. PRIVACY NOTICE According to the D.Lgs. 196/2003 this document and its attachments are confidential and intended for the named addressee(s) only. If you are not the intended recipient of this message, any use or dissemination of this message is prohibited. If you have received this document by mistake, please notify the sender and destroy all physical and/or electronic copies. -------------------------------------------- _______________________________________________ OTRS mailing list: itsm - Webpage: http://otrs.org/ Archive: http://lists.otrs.org/pipermail/itsm To unsubscribe: http://lists.otrs.org/mailman/listinfo/itsm Support or consulting for your OTRS::ITSM system? => http://www.otrs.com/ _______________________________________________ OTRS mailing list: itsm - Webpage: http://otrs.org/ Archive: http://lists.otrs.org/pipermail/itsm To unsubscribe: http://lists.otrs.org/mailman/listinfo/itsm Support or consulting for your OTRS::ITSM system? => http://www.otrs.com/

1 0

Re: [itsm] R: OTRS:ITSM 1.2.1 on MSSQL
by Bertazzi Diego 26 Aug '08

26 Aug '08

Manuel, The exact same package was used on MySQL! Which character set (collation) did you use on your MSSQL test installation ? Thanks. Diego Bertazzi Responsabile Esercizio e Operazioni IT Area Organizzazione e Sistemi Casino de la Vallee Via Italo Mus 11027 Saint Vincent (AO) Tel.: 0166-522637 Fax: 0166-522629 > -----Original Message----- > From: itsm-bounces(a)otrs.org [mailto:itsm-bounces@otrs.org] On Behalf Of > Manuel Hecht - OTRS AG > Sent: Tuesday, August 26, 2008 1:05 PM > To: 'OTRS::ITSM User questions and discussions' > Subject: Re: [itsm] R: OTRS:ITSM 1.2.1 on MSSQL > > Hi Diego > > Hm. I think it's a charset problem! > > > Software error: > > Malformed UTF-8 character (fatal) at C:/OTRS/otrs/Kernel/cpan- > lib/XML/Parser/Lite.pm line 141. > > Perhaps, the downloaded package is damaged! > > Please download the packages from this FTP server and test it again: > > ftp://ftp.otrs.org/pub/otrs/itsm/packages12/ > > > Best regards, > Manuel Hecht > > ((otrs)) :: OTRS AG :: Europaring 4 :: D - 94315 Straubing > Fon: +49 (0)9421 56818 0 :: Fax: +49 (0)9421 56818 18 > http://www.otrs.com/ :: Communication with success! > > > > -----Ursprüngliche Nachricht----- > Von: itsm-bounces(a)otrs.org [mailto:itsm-bounces@otrs.org] Im Auftrag von > Bertazzi Diego > Gesendet: Dienstag, 26. August 2008 12:37 > An: OTRS::ITSM User questions and discussions > Betreff: [itsm] R: OTRS:ITSM 1.2.1 on MSSQL > > Manuel, > > Thank you for your reply. I don't think the problem is in the packages as I used > them on the MySQL installation without any problem. > Do you think it could be a localization problem ? I mean some national settings on > the MSSQL server ? > > Thanks. > Diego.- > > > -----Messaggio originale----- > Da: itsm-bounces(a)otrs.org [mailto:itsm-bounces@otrs.org] Per conto di Manuel > Hecht - OTRS AG > Inviato: martedì 26 agosto 2008 12.34 > A: 'OTRS::ITSM User questions and discussions' > Oggetto: Re: [itsm] OTRS:ITSM 1.2.1 on MSSQL > > Hi Diego > > We tested the installation of the ITSM 1.2.1 packages on MSSQL without any > problems. > > I think this is a setup or configuration problem. > > > Best regards, > Manuel Hecht > > ((otrs)) :: OTRS AG :: Europaring 4 :: D - 94315 Straubing > Fon: +49 (0)9421 56818 0 :: Fax: +49 (0)9421 56818 18 > http://www.otrs.com/ :: Communication with success! > > > > Von: itsm-bounces(a)otrs.org [mailto:itsm-bounces@otrs.org] Im Auftrag von > Bertazzi Diego > Gesendet: Freitag, 22. August 2008 11:41 > An: itsm(a)otrs.org > Betreff: [itsm] OTRS:ITSM 1.2.1 on MSSQL > > I'm trying to install OTRS:ITSM 1.2.1 on a Microsoft SQL Server 2005 (v > 9.00.3042). > I've executed the instructions as per FAQ #4200121 and it looks like OTRS > (v2.3.1) is working correctly. > After that I was following the installation instructions for the ITSM modules: tried > to add the first package (GeneralCatalog) but the browser returned the following > message: > Software error: > Malformed UTF-8 character (fatal) at C:/OTRS/otrs/Kernel/cpan- > lib/XML/Parser/Lite.pm line 141. > After that I am not able to open the PackageManager page anymore. If I drop and > recreate the package's SQL table I can open again the PackageManager page and > try to add again the package but the result is always the same (see message > above). > Before using the MSSQL backend I successfully installed and used the same > installation based on MySql so I think is a problem related to the way MSSQL > stores the package data. > Anyone can help me ? > Thanks in advance. > Diego.- > ________________________________________ > > -------------------------------------------- > INFORMATIVA SULLA PRIVACY > Ai sensi del D.Lgs. 196/2003 si precisa che le informazioni contenute in questo > messaggio e nei suoi eventuali allegati sono riservate e per uso esclusivo del > destinatario. Nessuno, all'infuori dello stesso, può copiare o distribuire il > messaggio, o parte di esso, a terzi. Chiunque riceva questo messaggio per errore è > pregato di distruggerlo e di informare il mittente. > > PRIVACY NOTICE > According to the D.Lgs. 196/2003 this document and its attachments are > confidential and intended for the named addressee(s) only. If you are not the > intended recipient of this message, any use or dissemination of this message is > prohibited. If you have received this document by mistake, please notify the > sender and destroy all physical and/or electronic copies. > -------------------------------------------- > > > _______________________________________________ > OTRS mailing list: itsm - Webpage: http://otrs.org/ > Archive: http://lists.otrs.org/pipermail/itsm > To unsubscribe: http://lists.otrs.org/mailman/listinfo/itsm > Support or consulting for your OTRS::ITSM system? > => http://www.otrs.com/ > > > > -------------------------------------------- > INFORMATIVA SULLA PRIVACY > Ai sensi del D.Lgs. 196/2003 si precisa che le informazioni contenute in questo > messaggio e nei suoi eventuali allegati sono riservate e per uso esclusivo del > destinatario. Nessuno, all'infuori dello stesso, può copiare o distribuire il > messaggio, o parte di esso, a terzi. Chiunque riceva questo messaggio per errore è > pregato di distruggerlo e di informare il mittente. > > PRIVACY NOTICE > According to the D.Lgs. 196/2003 this document and its attachments are > confidential and intended for the named addressee(s) only. If you are not the > intended recipient of this message, any use or dissemination of this message is > prohibited. If you have received this document by mistake, please notify the > sender and destroy all physical and/or electronic copies. > -------------------------------------------- > _______________________________________________ > OTRS mailing list: itsm - Webpage: http://otrs.org/ > Archive: http://lists.otrs.org/pipermail/itsm > To unsubscribe: http://lists.otrs.org/mailman/listinfo/itsm > Support or consulting for your OTRS::ITSM system? > => http://www.otrs.com/ > > > _______________________________________________ > OTRS mailing list: itsm - Webpage: http://otrs.org/ > Archive: http://lists.otrs.org/pipermail/itsm > To unsubscribe: http://lists.otrs.org/mailman/listinfo/itsm > Support or consulting for your OTRS::ITSM system? > => http://www.otrs.com/ -------------------------------------------- INFORMATIVA SULLA PRIVACY Ai sensi del D.Lgs. 196/2003 si precisa che le informazioni contenute in questo messaggio e nei suoi eventuali allegati sono riservate e per uso esclusivo del destinatario. Nessuno, all'infuori dello stesso, può copiare o distribuire il messaggio, o parte di esso, a terzi. Chiunque riceva questo messaggio per errore è pregato di distruggerlo e di informare il mittente. PRIVACY NOTICE According to the D.Lgs. 196/2003 this document and its attachments are confidential and intended for the named addressee(s) only. If you are not the intended recipient of this message, any use or dissemination of this message is prohibited. If you have received this document by mistake, please notify the sender and destroy all physical and/or electronic copies. --------------------------------------------

1 0